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;
温馨提示:答案为网友推荐,仅供参考