DB_51Aspx/ssmgxhqxxglxthsg4289b4.sql

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

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

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE IF NOT EXISTS `ssmgxhqxxglxthsg4289b4` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ssmgxhqxxglxthsg4289b4`;

CREATE TABLE IF NOT EXISTS `allusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT '普通管理员',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

/*!40000 ALTER TABLE `allusers` DISABLE KEYS */;
REPLACE INTO `allusers` (`id`, `username`, `pwd`, `cx`, `addtime`) VALUES
	(2, 'hsg', 'hsg', '超级管理员', '2019-02-20 07:46:56');
/*!40000 ALTER TABLE `allusers` ENABLE KEYS */;

CREATE TABLE IF NOT EXISTS `banjixinxi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banji` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

/*!40000 ALTER TABLE `banjixinxi` DISABLE KEYS */;
REPLACE INTO `banjixinxi` (`id`, `banji`, `addtime`) VALUES
	(2, 'B03', '2019-03-05 00:44:53'),
	(3, 'D02', '2019-03-05 00:44:53'),
	(4, 'C02', '2019-03-05 00:44:53'),
	(5, 'A02', '2019-03-05 00:44:53'),
	(6, 'D01', '2019-03-05 00:44:53');
/*!40000 ALTER TABLE `banjixinxi` ENABLE KEYS */;

CREATE TABLE IF NOT EXISTS `gongyubaoxiu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gonghao` varchar(50) DEFAULT NULL,
  `xingming` varchar(50) DEFAULT NULL,
  `gongyuhao` varchar(50) DEFAULT NULL,
  `riqi` date DEFAULT NULL,
  `fujian` varchar(50) DEFAULT NULL,
  `guzhangmiaoshu` varchar(500) DEFAULT NULL,
  `issh` varchar(10) DEFAULT '否',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;

/*!40000 ALTER TABLE `gongyubaoxiu` DISABLE KEYS */;
REPLACE INTO `gongyubaoxiu` (`id`, `gonghao`, `xingming`, `gongyuhao`, `riqi`, `fujian`, `guzhangmiaoshu`, `issh`, `addtime`) VALUES
	(8, '555', '王老师', 'G01001', '2019-03-05', '', 'wfwe', '是', '2019-03-05 01:59:44');
/*!40000 ALTER TABLE `gongyubaoxiu` ENABLE KEYS */;

CREATE TABLE IF NOT EXISTS `gongyudiaohuan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gonghao` varchar(50) DEFAULT NULL,