ZmuRwizu

1DROP TABLE IF EXISTS `test_int`;
2
3CREATE TABLE `test_int` (
4  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
5  `user_id` int(11) UNSIGNED NOT NULL,
6  `uname` char(50) NOT NULL DEFAULT 'student',
7  `email` char(50),
8  `sex` enum('M','F'),
9  `id_FK` int(11) UNSIGNED NOT NULL DEFAULT '0',
10  PRIMARY KEY(`id`, `user_id`),
11  UNIQUE INDEX `idx_email`(`email`),
12  INDEX `index0`(`id`),
13  CONSTRAINT `Ref_01` FOREIGN KEY (`id_FK`)
14    REFERENCES `bbs_user`(`id`)
15    ON DELETE NO ACTION
16    ON UPDATE NO ACTION
17)
18ENGINE=INNODB
19CHARACTER SET utf8 ;