DB_51Aspx/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

DROP DATABASE IF EXISTS jspnxRul;

CREATE DATABASE jspnxRul default character set utf8mb4 collate utf8mb4_general_ci;

USE jspnxRul;

DROP TABLE IF EXISTS `yonghu`;

CREATE TABLE `yonghu` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`yonghuming` varchar(200)  UNIQUE   COMMENT '用户名',
	`mima` varchar(200)    COMMENT '密码',
	`xingming` varchar(200)    COMMENT '姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`dianziyouxiang` varchar(200)    COMMENT '电子邮箱',
	`shenfenzhenghao` varchar(200)    COMMENT '身份证号',
	`youzhengbianhao` int    COMMENT '邮政编号',
	`shouhuodizhi` varchar(200)    COMMENT '收货地址',
	`gerenzhaopian` varchar(200)    COMMENT '个人照片',
	`money` float   default '0' COMMENT '余额',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,shenfenzhenghao,youzhengbianhao,shouhuodizhi,gerenzhaopian,money) VALUES('用户1','123456','姓名1','男','020-89819991','773890001@qq.com','440300199101010001',1,'收货地址1','yonghu_gerenzhaopian1',1);
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,shenfenzhenghao,youzhengbianhao,shouhuodizhi,gerenzhaopian,money) VALUES('用户2','123456','姓名2','男','020-89819992','773890002@qq.com','440300199202020002',2,'收货地址2','yonghu_gerenzhaopian2',2);
INSERT INTO yonghu(yonghuming,mima,xingming,xingbie,lianxidianhua,dianziyouxiang,shenfenzhenghao,youzhengbianhao,shouhuodizhi,gerenzhaopian,money) VALUES('用户3','123456','姓名3','男','020-89819993','773890003@qq.com','440300199303030003',3,'收货地址3','yonghu_gerenzhaopian3',3);


DROP TABLE IF EXISTS `yuangong`;

CREATE TABLE `yuangong` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`yuangongzhanghao` varchar(200)  UNIQUE   COMMENT '员工账号',
	`mima` varchar(200)    COMMENT '密码',
	`yuangongxingming` varchar(200)    COMMENT '员工姓名',
	`xingbie` varchar(200)    COMMENT '性别',
	`nianling` int    COMMENT '年龄',
	`bumen` varchar(200)    COMMENT '部门',
	`zhiwei` varchar(200)    COMMENT '职位',
	`shoujihaoma` varchar(200)    COMMENT '手机号码',
	`youxianghaoma` varchar(200)    COMMENT '邮箱号码',
	`shenfenzhenghao` varchar(200)    COMMENT '身份证号',
	`yuangongzhaopian` varchar(200)    COMMENT '员工照片',
	`money` float   default '0' COMMENT '余额',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工';

INSERT INTO yuangong(yuangongzhanghao,mima,yuangongxingming,xingbie,nianling,bumen,zhiwei,shoujihaoma,youxianghaoma,shenfenzhenghao,yuangongzhaopian,money) VALUES('员工1','123456','员工姓名1','男',1,'部门1','文员','020-89819991','773890001@qq.com','440300199101010001','yuangong_yuangongzhaopian1',1);
INSERT INTO yuangong(yuangongzhanghao,mima,yuangongxingming,xingbie,nianling,bumen,zhiwei,shoujihaoma,youxianghaoma,shenfenzhenghao,yuangongzhaopian,money) VALUES('员工2','123456','员工姓名2','男',2,'部门2','文员','020-89819992','773890002@qq.com','440300199202020002','yuangong_yuangongzhaopian2',2);
INSERT INTO yuangong(yuangongzhanghao,mima,yuangongxingming,xingbie,nianling,bumen,zhiwei,shoujihaoma,youxianghaoma,shenfenzhenghao,yuangongzhaopian,money) VALUES('员工3','123456','员工姓名3','男',3,'部门3','文员','020-89819993','773890003@qq.com','440300199303030003','yuangong_yuangongzhaopian3',3);


DROP TABLE IF EXISTS `jishuzhuanjia`;

CREATE TABLE `jishuzhuanjia` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,