CREATE TABLE IF NOT EXISTS userinfo
(
user_idchar(10) PRIMARY KEY,
user_name varchar(20) NOT NULL,
user_sex char(2) NOT NULL
CHECK(user_sex LIKE ‘男’OR user_sex LIKE ‘女’),
user_telephone char(11) NOT NULL
CHECK(LEN(user_telephone)=11),
user_address varchar(40) NULL,
)character set = utf8
CREATE TABLE `colleague` (`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`idnetify_card` varchar(18) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`department` varchar(30) DEFAULT NULL,
`work_time` datetime DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`login_count` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)