#培训类型
DROP TABLE IF EXISTS `traintype`;
CREATE TABLE `traintype`
(
`traintype_id` INT NOT NULL AUTO_INCREMENT,
`name` CHAR(50) NOT NULL DEFAULT '',
PRIMARY KEY (`traintype_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
#用户表
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int NOT NULL auto_increment COMMENT '编号',
`name` varchar(255) default NULL COMMENT '用户名',
`password` varchar(255) default NULL COMMENT '密码',
`authority` enum('admin','normal') default NULL COMMENT '权限',
`update` int(11) default NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;