67,513
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) DEFAULT NULL,
`password` varchar(200) DEFAULT NULL,
`role` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `t_user`(`id`,`username`,`password`,`role`) values (1,'admin','admin','1');
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`descp` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `t_role`(`id`,`name`) values (1,'管理员');
DROP TABLE IF EXISTS `t_operator`;
CREATE TABLE `t_operator` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`age` varchar(200) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`tel` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`user` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_commodity`;
CREATE TABLE `t_commodity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`createDate` varchar(200) DEFAULT NULL,
`zhiliang` varchar(200) DEFAULT NULL,
`pinzhong` varchar(200) DEFAULT NULL,
`descp` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_warehouse`;
CREATE TABLE `t_warehouse` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`no` varchar(200) DEFAULT NULL,
`name` varchar(200) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`capacity` varchar(200) DEFAULT NULL,
`descp` varchar(200) DEFAULT NULL,
`max` int(11) DEFAULT NULL,
`min` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_supplier`;
CREATE TABLE `t_supplier` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL,
`incharge` varchar(200) DEFAULT NULL,
`tel` varchar(200) DEFAULT NULL,
`descp` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_business`;
CREATE TABLE `t_business` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`warehouse` int(11) DEFAULT NULL,
`commodity` int(11) DEFAULT NULL,
`supplier` int(11) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `t_search`;
CREATE TABLE `t_search` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kind` varchar(200) DEFAULT NULL,
`opraTime` varchar(200) DEFAULT NULL,
`move` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;