jspyuangong.sql

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

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50067
Source Host           : localhost:3306
Source Database       : jspyuangong

Target Server Type    : MYSQL
Target Server Version : 50067
File Encoding         : 65001

Date: 2020-08-10 13:00:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for checkwa
-- ----------------------------
DROP TABLE IF EXISTS `checkwa`;
CREATE TABLE `checkwa` (
  `cid` int(11) NOT NULL auto_increment,
  `staff` varchar(40) default NULL COMMENT '员工',
  `datea` varchar(40) default NULL COMMENT '日期',
  `statea` varchar(40) default NULL COMMENT '状态',
  PRIMARY KEY  (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of checkwa
-- ----------------------------
INSERT INTO `checkwa` VALUES ('1', '123', '2020-08-12', '正常');
INSERT INTO `checkwa` VALUES ('2', 'admin', '2020-08-04', '正常');
INSERT INTO `checkwa` VALUES ('4', '333', '2020-08-10', '迟到');

-- ----------------------------
-- Table structure for staff
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `sid` int(11) NOT NULL auto_increment,
  `username` varchar(40) default NULL COMMENT '用户名',
  `passworda` varchar(40) default NULL COMMENT '密码',
  `fullname` varchar(40) default NULL COMMENT '姓名',
  `power` varchar(40) default NULL COMMENT '权限',
  `contactn` varchar(40) default NULL COMMENT '联系电话',
  `Gender` varchar(40) default NULL COMMENT '性别',
  PRIMARY KEY  (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of staff
-- ----------------------------
INSERT INTO `staff` VALUES ('1', '123', '123', '123', '员工', '1231231231', '男');
INSERT INTO `staff` VALUES ('2', 'admin', 'admin', 'admin', '管理员', '12312312', '男');
INSERT INTO `staff` VALUES ('3', 'superadmin', 'superadmin', 'superadmin', '超级管理员', '13123131', '男');
INSERT INTO `staff` VALUES ('4', '333', '333', '333', '员工', '123123123', '男');
INSERT INTO `staff` VALUES ('5', '666', '666', '666', '', '12313333121233', '女');
INSERT INTO `staff` VALUES ('6', '777', '777', '777', '员工', '12312312312', '男');