56,677
社区成员
发帖
与我相关
我的任务
分享
create table dic_sex ( sex int primary key);
insert into dic_sex values (1),(2);
create table dic_degree( degree int primary key);
insert into dic_degree values (1),(2),(3),(4);
CREATE TABLE `testuser` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(12) NOT NULL default '',
`real_name` varchar(12) NOT NULL default '',
`password` varchar(8) NOT NULL default '',
`sex` int references dic_sex(sex),
`degree` int references dic_degree(degree),
`birthday` datetime default NULL,
PRIMARY KEY (`user_id`)
)
CREATE TABLE `testuser` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(12) NOT NULL default '',
`real_name` varchar(12) NOT NULL default '',
`password` varchar(8) NOT NULL default '',
`sex` enum('0','1') NOT NULL default '0',
`degree` enum('1','2','3','4') NOT NULL default '1',
`birthday` datetime default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;