/*
Navicat MySQL Data Transfer
Source Server : MySQL
Source Server Version : 50550
Source Host : localhost:3307
Source Database : hrms
Target Server Type : MYSQL
Target Server Version : 50550
File Encoding : 65001
Date: 2018-02-07 02:02:02
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` varchar(255) NOT NULL,
`username` varchar(32) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`photo` varchar(255) DEFAULT NULL,
`regtime` datetime DEFAULT NULL,
`jd` int(11) DEFAULT '1',
`active` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('0300f06e-103b-4ff4-9efe-95c0c0820b24', 'admin', '4297F44B13955235245B2497399D7A93', '91f2c08c-d518-43bc-8587-7f7b6f11152a.jpeg', '2018-01-25 15:05:52', '1', '1');
INSERT INTO `admin` VALUES ('21b4259d-1615-464f-ad9f-25e4d00503a5', 'zy', '099EBEA48EA9666A7DA2177267983138', '9718677d-e703-4ddb-9f1e-60e82c512ae8.gif', '2018-01-25 00:06:04', '1', '0');
INSERT INTO `admin` VALUES ('38861009-b213-4d78-a9a1-0e4fd812db00', 'gdf', 'B5525D41964463B5D6A1F23A99C0C897', '2af0cfa8-eb6a-49d5-86a4-b155962efeb7.gif', '2018-01-25 00:36:24', '1', '0');
INSERT INTO `admin` VALUES ('55b84bf5-ec35-4680-a1cb-426f57966cc3', 'dsfsf', 'DCB64C94E1B81CD1CD3EB4A73AD27D99', '513be7d3-20b7-4c98-8c1e-af0d7a17b6a4.jpg', '2018-01-25 00:17:42', '1', '0');
INSERT INTO `admin` VALUES ('8094b99d-86c9-4272-a92f-44a11e560928', '123', 'CF8EFF55DE3795250547D03E2173CBE3', 'a5aed01c-bc73-4951-8837-c482492ed9ec.jpg', '2018-01-25 00:33:56', '1', '0');
INSERT INTO `admin` VALUES ('87560941-09d2-4445-8a16-28667f596946', 'zyy', 'E10ADC3949BA59ABBE56E057F20F883E', 'b19b8d46-4013-408c-a18e-82f3ed353c3e.jpg', '2018-01-21 16:22:21', '1', '1');
INSERT INTO `admin` VALUES ('98b5b576-bd01-4091-8447-555b01dd69f5', '0124', 'FF3F8C1844C38479B09245CC4AB42DCD', 'dc4f04c9-73c4-4b3a-bf07-00d3e24b490b.gif', '2018-01-25 00:32:54', '1', '0');
INSERT INTO `admin` VALUES ('a7ca999b-dce5-41c4-a1b9-748a8831f695', '0124', 'FF3F8C1844C38479B09245CC4AB42DCD', 'a91a4c0b-0945-4ede-b996-bc526cf4e242.gif', '2018-01-25 00:32:12', '1', '0');
INSERT INTO `admin` VALUES ('b3a6f41c-dcef-4686-ab37-0854c0d4f306', 'dsfsf', 'DCB64C94E1B81CD1CD3EB4A73AD27D99', 'bc696183-d89b-4e8f-a2ce-3bdc1f01923f.jpg', '2018-01-25 00:16:47', '1', '0');
INSERT INTO `admin` VALUES ('d0e4f334-05d8-4c42-82da-d1a5dd549199', 'zy', 'E10ADC3949BA59ABBE56E057F20F883E', 'fefff4db-8b7e-42fd-9fff-bbf1e841c1ab.jpg', '2018-01-18 17:49:44', '1', '1');
INSERT INTO `admin` VALUES ('d3ab1790-9367-4988-a429-05c5895f76d6', '123', '0B695362A1326B9CFDBB163E1763151B', '02b02286-c2c0-43ab-80c6-345d364d1a29.gif', '2018-01-25 00:33:14', '1', '0');
INSERT INTO `admin` VALUES ('de6caa54-19ef-4146-a699-38c397ff673e', '123', '0B695362A1326B9CFDBB163E1763151B', '65cd9ae3-b05d-41c3-9161-892e51c31789.gif', '2018-01-25 00:33:35', '1', '0');
-- ----------------------------
-- Table structure for award
-- ----------------------------
DROP TABLE IF EXISTS `award`;
CREATE TABLE `award` (
`a_id` varchar(255) NOT NULL,
`emp_id` varchar(255) NOT NULL,
`emp_eid` varchar(11) DEFAULT NULL,
`emp_name` varchar(32) NOT NULL,
`emp_depid` int(16) NOT NULL,
`a_title` varchar(128) DEFAULT NULL,
`a_type` int(11) DEFAULT NULL,
`a_money` double(11,0) DEFAULT NULL,
`a_regtime` datetime DEFAULT NULL,
`a_active` int(11) DEFAULT NULL,
PRIMARY KEY (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of award
-- ----------------------------
INSERT INTO `award` VALUES ('06d17059-9b3c-4c57-a8bd-1fd473ef2156', '201810221', null, '更新测试2', '2', '雪天铲雪', '0', '101', '2018-01-26 10:35:23', '1');
INSERT INTO `award` VALUES ('1', '1', null, '张三', '5', '迟到', '1', '-200', '2018-01-16 11:32:48', '1');
INSERT INTO `award` VALUES ('2', '2', null, '李四', '4', '扶老奶奶', '0', '200', '2018-01-09 11:35:34', '1');
INSERT INTO `award` VALUES ('62e1a1aa-237e-471d-9514-4a6bd4738fa7', '6138d82b-a156-45f9-96d4-a36b98160e44', null, 'zyy', '4', '打架闹事', '1', '-500', '2018-01-19 16:21:23', '1');
INSERT INTO `award` VALUES ('8310464e-c469-4bb5-bb7d-6ebd389417ed', '8d676fc8-5cbd-4f46-b8e3-d2d5af4fc3d9', null, '赵雨旸', '2', '忘了写模块', '0', '-50', '2018-01-25 01:35:17', '1');
INSERT INTO `award` VALUES ('bcb34dd5-9fc6-474d-a7da-47a0a913e20e', '331c23ed-82e8-4d44-8482-1e00e1a2a311', null, '更新测试', '3', '扶老奶奶过马路', '0', '150', '2018-01-25 15:11:06', '1');
INSERT INTO `award` VALUES ('c4647d58-1d5e-4d17-b338-1fe976cd02c7', '6138d82b-a156-45f9-96d4-a36b98160e44', null, 'zyy', '4', '吃饭太少', '1', '-200', '2018-01-19 14:55:45', '0');
-- ----------------------------
-- Table structure for daily
-- ----------------------------
DROP TABLE IF EXISTS `daily`;
CREATE TABLE `daily` (
`id` varchar(255) NOT NULL,
`emp_id` varchar(128) NOT NULL,
`emp_name` varchar(32) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`content` text,
`regtime` datetime NOT NULL,
`active` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of daily
-- ----------------------------
INSERT INTO `daily` VALUES ('0c4290f4-e5ce-4e44-9a85-b12234dc1e49', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '这次还是测试返回弹窗', '测试测试', '2018-01-25 00:48:35', '1');
INSERT INTO `daily` VALUES ('2b000a94-8429-418c-a608-ea7d7c1f3bfc', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '测试测试', '和第三件看电视呢就爱看的比较阿克苏的数据库回到家扩散到卡死接口的s', '2018-01-22 18:34:03', '0');
INSERT INTO `daily` VALUES ('4380d509-045b-40a0-831f-03e6c3ab79c1', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '测试', '这也是一次测试，用于测试彻底删除功能', '2018-01-23 08:38:50', '1');
INSERT INTO `daily` VALUES ('438de1ef-8e26-4e90-9b0d-711ae0cbce64', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', 'this is a message', 'hello,every,this is a things', '2018-01-23 08:50:15', '0');
INSERT INTO `daily` VALUES ('4bb78378-2b75-43e2-89cb-b60db192cc42', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '测试', '123456', '2018-01-25 15:14:50', '1');
INSERT INTO `daily` VALUES ('511024a9-ca45-4a05-80bc-b885cdd82025', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '我好饿', '我好饿，我好饿啊！！！！好饿啊！！！！', '2018-01-23 18:24:34', '1');
INSERT INTO `daily` VALUES ('5ed0ca19-8111-4c10-8119-69c0e2779007', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '今晚下了大雪', '武汉，2018.1.25 凌晨 0.46分，没见到雪。标题党', '2018-01-25 00:46:16', '1');
INSERT INTO `daily` VALUES ('7d375a0f-2376-45a0-af4b-1457a624dc1d', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '当升科技大三', '发你空间的年份数据库', '2018-01-22 18:19:38', '0');
INSERT INTO `daily` VALUES ('7dd05524-39e6-4940-a4db-c36d82c29050', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '测试返回值', '测试返回谭弹框', '2018-01-25 00:47:34', '1');
INSERT INTO `daily` VALUES ('8560f846-43c6-48e0-a8b5-5b014a9380b9', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '好饿', '饺子，包子，吃的，喝的，米饭，面条，牛肉，羊肉，鸡肉，烧肉，烤肉，啤酒，肉串，蘑菇，香菇。土豆，。。', '2018-01-23 18:25:20', '1');
INSERT INTO `daily` VALUES ('ab09efdf-20aa-4de9-b0c9-689bf6b48524', '52090cd0-2382-4dcd-b435-f21b0ad2818f', 'zy', '长篇小说', '因此优秀的长篇小说常常被称为“时代的百科全书。”长篇小说的特点：1．广泛地反映社会生活。2．多方面地描写人物性格。发�
