yii1.1mysql操作_Yii系列总结：[1]Yii DAO数据库操作

数据库代码：

/*

Navicat MySQL Data Transfer

Source Server         : lonxom

Source Server Version : 50524

Source Host           : localhost:3306

Source Database       : test

Target Server Type    : MYSQL

Target Server Version : 50524

File Encoding         : 65001

Date: 2013-10-12 00:03:03

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `city`

-- ----------------------------

DROP TABLE IF EXISTS `city`;

CREATE TABLE `city` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '城市名',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='城市表';

-- ----------------------------

-- Records of city

-- ----------------------------

INSERT INTO `city` VALUES ('1', '北京');

INSERT INTO `city` VALUES ('2', '上海');

INSERT INTO `city` VALUES ('3', '广州');

INSERT INTO `city` VALUES ('4', '武汉');

INSERT INTO `city` VALUES ('5', '天津');

-- ----------------------------

-- Table structure for `user`

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`username` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '用户名',

`city_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市',

`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',

`update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户表';

-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('2', '菩提', '2', '0', '0');

INSERT INTO `user` VALUES ('3', '天师', '5', '0', '0');

INSERT INTO `user` VALUES ('5', '久1', '3', '0', '0');

INSERT INTO `user` VALUES ('6', '久2', '4', '0', '0');

INSERT INTO `user` VALUES ('7', '久3', '1', '0', '0');

INSERT INTO `user` VALUES ('8', '久4', '4', '0', '0');

INSERT INTO `user` VALUES ('9', '久5', '5', '0', '0');

INSERT INTO `user` VALUES ('10', '久6', '1', '0', '0');

INSERT INTO `user` VALUES ('11', '久7', '3', '0', '0');

INSERT INTO `user` VALUES ('12', '久8', '3', '0', '0');

INSERT INTO `user` VALUES ('13', '久9', '1', '0', '0');

INSERT INTO `user` VALUES ('14', '帅帅', '1', '1381395175', '1381395175');

INSERT INTO `user` VALUES ('15', '小猪猪', '1', '1381396237', '1381463258');

INSERT INTO `user` VALUES ('16', '阿浩', '2', '1381396559', '1381396559');

INSERT INTO `user` VALUES ('17', '鹏鹏', '1', '1381398344', '1381398344');

INSERT INTO `user` VALUES ('18', '方方', '5', '1381398969', '1381398969');

INSERT INTO `user` VALUES ('19', '官人', '1', '1381456860', '1381456860');

INSERT INTO `user` VALUES ('20', '谢平', '4', '1381461563', '1381461563');

INSERT INTO `user` VALUES ('21', '元方', '2', '1381463288', '1381463288');

INSERT INTO `user` VALUES ('22', '康师傅', '1', '1381500128', '1381500128');

-- ----------------------------

-- Table structure for `user_info`

-- ----------------------------

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户表id',

`info` text CHARACTER SET utf8 COMMENT '用户简介',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='用户信息表';

-- ----------------------------

-- Records of user_info

-- ----------------------------

INSERT INTO `user_info` VALUES ('1', '15', '我是一个好人');