DB_51Aspx/mysql.sql

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

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

DROP DATABASE IF EXISTS jspNltCJ;

CREATE DATABASE jspNltCJ default character set utf8mb4 collate utf8mb4_general_ci;

USE jspNltCJ;

DROP TABLE IF EXISTS `yuangongxinxi`;

CREATE TABLE `yuangongxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`yuangonggonghao` varchar(200)  UNIQUE   COMMENT '员工工号',
	`yuangongxingming` varchar(200)    COMMENT '员工姓名',
	`mima` varchar(200)    COMMENT '密码',
	`xingbie` varchar(200)    COMMENT '性别',
	`bumen` varchar(200)    COMMENT '部门',
	`gangwei` varchar(200)    COMMENT '岗位',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`shenfenzheng` varchar(200)    COMMENT '身份证',
	`zhaopian` varchar(200)    COMMENT '照片',
	`jiatingzhuzhi` varchar(200)    COMMENT '家庭住址',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工信息';

DROP TABLE IF EXISTS `qiandaopingtai`;

CREATE TABLE `qiandaopingtai` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`biaoti` varchar(200)    COMMENT '标题',
	`xiangqing` longtext    COMMENT '详情',
	`tupian` varchar(200)    COMMENT '图片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到平台';

DROP TABLE IF EXISTS `qiandaoxinxi`;

CREATE TABLE `qiandaoxinxi` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`qiandaoleixing` varchar(200)    COMMENT '签到类型',
	`qiandaoshijian` datetime    COMMENT '签到时间',
	`yuangonggonghao` varchar(200)    COMMENT '员工工号',
	`yuangongxingming` varchar(200)    COMMENT '员工姓名',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到信息';

DROP TABLE IF EXISTS `qingjiapingtai`;

CREATE TABLE `qingjiapingtai` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
	`biaoti` varchar(200)    COMMENT '标题',
	`neirong` longtext    COMMENT '内容',
	`tupian` varchar(200)    COMMENT '图片',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='请假平台';

DROP TABLE IF EXISTS `bangongshebei`;