图片 在这 http://pan.baidu.com/s/1qY1o7U0，，
- CREATE TABLE `diary` (
- `username` CHAR(20) NOT NULL COLLATE 'gbk_chinese_ci',
- `dat` CHAR(20) NOT NULL COLLATE 'gbk_chinese_ci',
- `mood` CHAR(10) NOT NULL COLLATE 'gbk_chinese_ci',
- `weather` CHAR(10) NOT NULL COLLATE 'gbk_chinese_ci',
- `title` TEXT NOT NULL COLLATE 'gbk_chinese_ci',
- `mtext` TEXT NOT NULL COLLATE 'gbk_chinese_ci',
- PRIMARY KEY (`username`, `dat`)
- )
- COLLATE='utf8_icelandic_ci'
- ENGINE=InnoDB
- ;
- CREATE TABLE `question` (
- `id` INT(11) NOT NULL,
- `question` CHAR(20) NULL DEFAULT NULL COLLATE 'gbk_chinese_ci',
- PRIMARY KEY (`id`)
- )
- COLLATE='utf8_icelandic_ci'
- ENGINE=InnoDB
- ;
- CREATE TABLE `user` (
- `username` CHAR(20) NOT NULL COLLATE 'utf8_icelandic_ci',
- `pwd` CHAR(20) NULL DEFAULT NULL COLLATE 'utf8_icelandic_ci',
- `nickname` CHAR(20) NULL DEFAULT NULL COLLATE 'utf8_icelandic_ci',
- `email` CHAR(20) NULL DEFAULT NULL COLLATE 'utf8_icelandic_ci',
- `question` CHAR(20) NULL DEFAULT NULL COLLATE 'utf8_icelandic_ci',
- `choiceQueAnswer` CHAR(10) NULL DEFAULT NULL COLLATE 'utf8_icelandic_ci',
- `enterSign` INT(11) NULL DEFAULT NULL,
- PRIMARY KEY (`username`)
- )
- COLLATE='utf8_icelandic_ci'
- ENGINE=InnoDB
- ;
|
