/*
Navicat MySQL Data Transfer
Source Server : 1
Source Server Version : 50554
Source Host : localhost:3306
Source Database : sushedb
Target Server Type : MYSQL
Target Server Version : 50554
File Encoding : 65001
Date: 2021-01-06 21:05:59
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `dtproperties`
-- ----------------------------
DROP TABLE IF EXISTS `dtproperties`;
CREATE TABLE `dtproperties` (
`id` int(11) NOT NULL,
`objectid` int(11) DEFAULT NULL,
`property` varchar(64) NOT NULL,
`value` varchar(255) DEFAULT NULL,
`uvalue` varchar(255) DEFAULT NULL,
`lvalue` longblob,
`version` int(11) NOT NULL,
PRIMARY KEY (`id`,`property`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dtproperties
-- ----------------------------
-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`userId` int(11) NOT NULL,
`userName` varchar(50) DEFAULT NULL,
`userPw` varchar(50) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', '1', '1');
-- ----------------------------
-- Table structure for `z_dayi`
-- ----------------------------
DROP TABLE IF EXISTS `z_dayi`;
CREATE TABLE `z_dayi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stu_id` int(11) DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`question` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`answer` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`flag` int(11) DEFAULT NULL,
`riqi` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_dayi
-- ----------------------------
INSERT INTO `z_dayi` VALUES ('1', '2', '张三', 'A102宿舍报修', '宿舍床报修', '', '1', '2021-01-04 23:26:06');
INSERT INTO `z_dayi` VALUES ('3', '2', '张三', 'A103宿舍报修', '电灯报修', '', '1', '2021-01-04 23:26:06');
INSERT INTO `z_dayi` VALUES ('4', '2', '张三', 'A104宿舍报修', '电脑报修', '', '1', '2021-01-04 23:26:06');
INSERT INTO `z_dayi` VALUES ('5', '2', '张三', 'A105宿舍报修', '空调报修', '', '1', '2021-01-04 23:26:06');
-- ----------------------------
-- Table structure for `z_guangbo`
-- ----------------------------
DROP TABLE IF EXISTS `z_guangbo`;
CREATE TABLE `z_guangbo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
`shijian` varchar(255) DEFAULT NULL,
`con` varchar(3000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_guangbo
-- ----------------------------
INSERT INTO `z_guangbo` VALUES ('2', '冬季注意防火', '2021-01-04 23:26:06', ' 使用劣质电器和大功率电器(包括劣质应急灯、充电器、电吹风、取暖器等)。学生基本没有经济收入，又缺乏社会经验，往往会购买价低劣质的电器在宿舍使用；还有的学生在宿舍使用大功率电器，使电线超负荷，因此很容易造成短路引起火情。');
INSERT INTO `z_guangbo` VALUES ('4', '冬季作息时间调整', '2021-01-04 23:26:06', '冬季作息时间调整冬季作息时间调整冬季作息时间调整冬季作息时间调整冬季作息时间调整');
-- ----------------------------
-- Table structure for `z_kaoqin`
-- ----------------------------
DROP TABLE IF EXISTS `z_kaoqin`;
CREATE TABLE `z_kaoqin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`xuehao` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
`shijian` varchar(50) DEFAULT NULL,
`zhuangkuang` varchar(500) DEFAULT NULL,
`con` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_kaoqin
-- ----------------------------
INSERT INTO `z_kaoqin` VALUES ('6', '2018001', '2021-01-05', '晚归', '无故12点晚归');
INSERT INTO `z_kaoqin` VALUES ('8', '2018002', '2021-01-05', '早离', '早上4点离开');
-- ----------------------------
-- Table structure for `z_shiwu`
-- ----------------------------
DROP TABLE IF EXISTS `z_shiwu`;
CREATE TABLE `z_shiwu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
`shijian` varchar(255) DEFAULT NULL,
`con` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_shiwu
-- ----------------------------
INSERT INTO `z_shiwu` VALUES ('1', '身份证招领', '2021-01-05', '拾主：张小锋,联系电话：13698549672');
INSERT INTO `z_shiwu` VALUES ('3', '证件招领', '2021-01-05', '请和李伟联系，联系电话：13698549672');
-- ----------------------------
-- Table structure for `z_shuidian`
-- ----------------------------
DROP TABLE IF EXISTS `z_shuidian`;
CREATE TABLE `z_shuidian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shushe` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
`jinge` varchar(255) DEFAULT NULL,
`shijian` varchar(255) DEFAULT NULL,
`con` varchar(2550) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_shuidian
-- ----------------------------
INSERT INTO `z_shuidian` VALUES ('2', 'A102宿舍', '120元', '2021-01-05', '无');
INSERT INTO `z_shuidian` VALUES ('3', 'A103宿舍', '210元', '2021-01-05', '无');
-- ----------------------------
-- Table structure for `z_stu`
-- ----------------------------
DROP TABLE IF EXISTS `z_stu`;
CREATE TABLE `z_stu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(16) CHARACTER SET utf8 NOT NULL,
`password` varchar(32) NOT NULL,
`xuehao` varchar(50) DEFAULT NULL,
`realname` varchar(50) DEFAULT NULL,
`sushe` varchar(50) DEFAULT NULL,
`diaohuan` varchar(255) DEFAULT '否',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_stu
-- ----------------------------
INSERT INTO `z_stu` VALUES ('2', '1', '1', '2018001', '张哲', 'A102宿舍', '是');
INSERT INTO `z_stu` VALUES ('4', '2', '2', '2018002', '李哲', 'A102宿舍', '否');
INSERT INTO `z_stu` VALUES ('5', '333', '333', '333', '333333刘', '', '否');
INSERT INTO `z_stu` VALUES ('7', '33', '33', '33', '3333', '', '否');
-- ----------------------------
-- Table structure for `z_sushe`
-- ----------------------------
DROP TABLE IF EXISTS `z_sushe`;
CREATE TABLE `z_sushe` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bh` text CHARACTER SET utf8,
`name` varchar(255) DEFAULT NULL,
`renshu` varchar(255) DEFAULT NULL,
`weizhi` varchar(255) DEFAULT NULL,
`con` varchar(2550) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_sushe
-- ----------------------------
INSERT INTO `z_sushe` VALUES ('3', 'A102', 'A102宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('5', 'A103', 'A103宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('6', 'A104', 'A104宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('7', 'A105', 'A105宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('8', 'A106', 'A106宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('9', 'A107', 'A107宿舍', '8', '东区', '无');
INSERT INTO `z_sushe` VALUES ('10', 'A108', 'A108宿舍', '8', '东区', '无');
-- ----------------------------
-- Table structure for `z_weisheng`
-- ----------------------------
DROP TABLE IF EXISTS `z_weisheng`;
CREATE TABLE `z_weisheng` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shushe` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
`dnegji` varchar(255) DEFAULT NULL,
`shijian` varchar(255) DEFAULT NULL,
`con` varchar(2550) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of z_weisheng
-- ----------------------------
INSERT INTO `z_weisheng` VALUES ('4', 'A102宿舍', 'A级', '2021-01-05', '很干净');
INSERT INTO `z_weisheng` VALUES ('5', 'A103宿舍', 'B级', '2021-01-05', '一般');
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ