-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: ityks
-- ------------------------------------------------------
-- Server version	5.7.16-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `questionnaire_answer`
--

DROP TABLE IF EXISTS `questionnaire_answer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questionnaire_answer` (
  `answer_id` varchar(64) NOT NULL,
  `answer_value` int(11) NOT NULL COMMENT '没选择一个结果自加一次',
  `answer_type` varchar(10) NOT NULL COMMENT 'type 有文字(value= text )，图片(value= img)两种类型。',
  `answer_destype` varchar(255) NOT NULL COMMENT '增加文件类型，这个是文件名',
  `answer_text` varchar(255) NOT NULL COMMENT 'answer 描述文字，如果type是图片类型的话，那么就是文件路径，如果是文字，那么正常。',
  `question_id` varchar(64) NOT NULL,
  `answer_creat` datetime NOT NULL,
  PRIMARY KEY (`answer_id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `question_id` FOREIGN KEY (`question_id`) REFERENCES `questionnaire_question` (`question_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questionnaire_answer`
--

LOCK TABLES `questionnaire_answer` WRITE;
/*!40000 ALTER TABLE `questionnaire_answer` DISABLE KEYS */;
INSERT INTO `questionnaire_answer` VALUES ('03a2173c-7a3e-498f-be34-359ae4a6ce4c',0,'n','网络','#','8d02c51f-2b1f-4c64-8e73-b98f6a0a7a10','2017-01-17 13:21:00'),('05949029-0d05-452f-9ae9-3996b7b5bbfd',0,'n','产业、服务业工人','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('0a844d09-dc26-4726-a8aa-c218be49a4e9',0,'n','不足每周1天','#','9fb31499-2b58-440d-9fd6-885d3c8504fe','2016-06-25 15:35:19'),('0dbbc10e-dc0b-4e59-9598-53841500b71e',0,'n','25~35岁（含35岁）','#','44b593ce-edff-4b85-9b60-6cecaa927c1e','2016-06-25 15:47:19'),('0feaf1a2-31c3-4b28-927e-af4b57df43c9',1,'n','Jubeat','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('12808b1f-40d5-40d4-9492-76ecbbce9452',1,'y','黑紫相间红边框(点击下载附件)','upload/file/b795bcd9-d1bb-405a-a4d0-4ec8a02c5a13.jpg','4820d0ea-8ecc-49e0-863b-f292fd22c556','2016-06-25 16:30:22'),('1bbd1a58-6380-42c8-b1cb-46ad90fe568e',1,'n','高中在读','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('1dab4267-37f6-4820-bf03-e23f9eccf607',1,'n','天天爱消除','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('24bebd34-a5e9-4adb-9a8e-8dca04f2f0ba',0,'n','IDOLISH 7','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('26acd3d7-ab5c-4d19-86a7-02eacf90dc59',0,'y','黑白主题绿色边框(点击下载附件)','upload/file/f492619b-7bcf-444a-a722-ec13f52bc876.jpg','4820d0ea-8ecc-49e0-863b-f292fd22c556','2016-06-25 16:30:22'),('2c672faf-734e-4a69-abc1-31a41f538c0b',0,'n','硕士及以上在读','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('2d00ec1b-da79-4573-b402-e5bc68da3619',0,'n','项目类','#','b76aaf9a-c2f8-4621-856d-ec0d82579139','2017-01-17 13:20:09'),('310f63f2-3fb1-49d8-a4dd-73eaeec623f9',1,'n','项目类','#','85c7a48b-9a10-4029-a51e-60dd5577bf86','2017-01-17 11:37:00'),('3fccc26c-d267-4c27-8a96-a11ab79146d8',0,'n','崩坏学院2','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('4bd0025a-0bd8-476b-bb39-c17497b53aac',0,'n','喜妃传','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('4d386126-23b9-482a-ba5d-df74aa865607',0,'n','大专','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('4e73861e-595e-4cae-85a5-a62aafae4bbd',0,'n','企业公司一般职员','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('50f34146-3670-4a50-b00a-b2497939c608',1,'n','12~18岁（含18岁）','#','44b593ce-edff-4b85-9b60-6cecaa927c1e','2016-06-25 15:47:19'),('51ae7c91-c9d9-47a4-a7a3-dbe8869a8854',0,'n','本科在读','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('53927769-702c-40b7-9752-3eec4ee50d48',0,'n','小学在读','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('5852abbc-35db-46e8-98a7-888bf1dfd95e',0,'n','党政、事业单位、公务员','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('5d88d9cd-3d29-4428-ae71-fb1d61433123',0,'n','书店','#','8d02c51f-2b1f-4c64-8e73-b98f6a0a7a10','2017-01-17 13:21:00'),('5dce8b1b-3f7a-4809-9752-aecddc5188b7',0,'n','实例类','#','b76aaf9a-c2f8-4621-856d-ec0d82579139','2017-01-17 13:20:09'),('62cfdf33-a7e6-4e96-a2d3-26f8c409a5d3',0,'n','无业人士、退休','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('6631b990-6c85-4548-a9c3-4edb321af32f',0,'n','小学及以下','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('6d4d1850-54cc-4285-ba92-feeedc28cb7e',0,'n','偶像梦祭祀','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('70b82afc-26d0-4522-874f-c70ed2b3f8d0',0,'n','保卫萝卜2','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('73446a52-b260-474b-88fd-03746a0e166e',0,'n','经验技巧类','#','b76aaf9a-c2f8-4621-856d-ec0d82579139','2017-01-17 13:20:09'),('7463b78e-998e-489e-a40b-dd7a3f36d5e1',0,'n','3小时以上','#','74a9a1b2-db75-49e3-ac7e-1aab575f0f47','2016-06-25 15:37:05'),('7ab0db20-5968-4578-b610-527e15663760',0,'n','务农人员','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('7ef7cd66-3e8d-4022-8d6c-d5974407611e',0,'n','基础类','#','85c7a48b-9a10-4029-a51e-60dd5577bf86','2017-01-17 11:37:00'),('7fc929ce-5fd9-447a-8141-519d4f1c4067',0,'n','其他','#','b76aaf9a-c2f8-4621-856d-ec0d82579139','2017-01-17 13:20:09'),('7ff3c5a9-0bde-4d6b-b3f1-20e18f73f83c',1,'n','是','#','584db07b-ec0d-49b6-8101-927954f63315','2016-06-25 15:45:28'),('80796a32-1740-4b77-9fe0-b0173c630f37',0,'n','Fate Grand Order','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('80bf4ab8-8b8c-4f8c-9177-fc0402c8b6a0',0,'n','糖果传奇','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('864b96fa-2314-4c91-937d-0c7815d80d70',0,'n','每周4~6天','#','9fb31499-2b58-440d-9fd6-885d3c8504fe','2016-06-25 15:35:19'),('89e020f7-6657-408c-8cec-e4443bfdd54f',0,'n','初中在读','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('8c91a1bd-b090-4468-b9d4-4df2653f589f',0,'n','奇迹暖暖','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('8e2c7d6b-1e7f-4925-9650-4a927515c7b8',1,'n','2小时~3小时（含2小时）','#','74a9a1b2-db75-49e3-ac7e-1aab575f0f47','2016-06-25 15:37:05'),('93040a2a-22ba-4146-a127-1db6c49df150',0,'y','红绿主题黑色边框(点击下载附件)','upload/file/38fe5a06-4b76-44cd-b029-d771bf24dc90.jpg','4820d0ea-8ecc-49e0-863b-f292fd22c556','2016-06-25 16:30:22'),('977f46c0-2316-4636-85ff-33052f289f77',1,'n','男','#','a44d437e-0744-4aab-bf99-6e8e3770f494','2016-06-25 15:45:48'),('99dc6622-72a1-4139-843f-43031c215f4f',0,'n','18~25岁（含25岁）','#','44b593ce-edff-4b85-9b60-6cecaa927c1e','2016-06-25 15:47:19'),('9a9069c0-5b30-4e40-8fe0-c553f89c4f37',0,'n','1小时~2小时（含2小时）','#','74a9a1b2-db75-49e3-ac7e-1aab575f0f47','2016-06-25 15:37:05'),('9db510f8-6c5b-45e3-8df4-93f4333f1b03',0,'n','35岁以上','#','44b593ce-edff-4b85-9b60-6cecaa927c1e','2016-06-25 15:47:19'),('a83b081f-d124-46da-8fc7-08632e044831',0,'n','硕士及以上','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('acb0080d-80de-416c-b8e3-9fcb23c9a821',0,'n','战舰少女','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('aed34123-6065-4fed-a02c-54abaf05cdbc',1,'n','天天酷跑','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('b1c93464-012f-46aa-8506-f64e16c37df9',1,'n','高中','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('b557bc53-38ad-4c2d-bac2-4361d9d7828e',0,'n','Love Live！学员偶像祭','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('b6703bec-a3e6-4f6c-8162-8184e470dd59',0,'n','每周1天','#','9fb31499-2b58-440d-9fd6-885d3c8504fe','2016-06-25 15:35:19'),('b9372c32-4276-4a69-a54c-5ae05d5cd4dd',0,'n','自由职业者、个体经营者','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16'),('bf5db675-a70e-49f2-a450-25faa04d9674',0,'n','否','#','584db07b-ec0d-49b6-8101-927954f63315','2016-06-25 15:45:28'),('c2ff954c-49de-4ad4-a4c6-69faafb8ef1b',0,'n','30分钟以内','#','74a9a1b2-db75-49e3-ac7e-1aab575f0f47','2016-06-25 15:37:05'),('c3454969-70a8-4e4e-8403-0959fe91aa6c',0,'n','开心消消乐','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('c3bfd025-7151-4ce6-bb5b-64431e2b4732',0,'n','偶像大师','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('d21c7008-4d45-4269-94ad-dba79750b23f',0,'n','仙剑奇侠传 官方手游','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('d5c07c54-3c81-4a7a-9a2f-e7229440fe21',0,'n','暖暖环游世界','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('d6b5ca73-196e-4126-b1bc-ff741569f075',0,'n','乖离性百万亚瑟王','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('e594f3f8-ee24-448f-9de2-012ab54ff432',0,'n','刀剑乱舞','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('e805b833-66ba-4cff-a361-e6eb1083b43b',0,'n','梦幻cast','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('e891a5fb-0979-4cc4-b7ae-98e6d6012f40',0,'n','基础类','#','b76aaf9a-c2f8-4621-856d-ec0d82579139','2017-01-17 13:20:09'),('ea76b729-9e3a-4fcb-983f-b854e3d7882e',1,'n','每天都玩','#','9fb31499-2b58-440d-9fd6-885d3c8504fe','2016-06-25 15:35:19'),('ebe56078-0b3e-47bb-8d0b-a797be910933',0,'n','初中','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('edb2d670-6cc0-42b5-985f-9521e05a0e3d',1,'n','梦100','#','987a90af-e07c-4e67-9f4e-4f3335495b23','2016-06-25 15:43:26'),('eed55c40-634e-451d-9edc-1174565ed096',0,'n','30分钟~1小时（含1小时）','#','74a9a1b2-db75-49e3-ac7e-1aab575f0f47','2016-06-25 15:37:05'),('f1b4ed20-3544-4e1e-b1e1-8d1abb43ea29',0,'n','女','#','a44d437e-0744-4aab-bf99-6e8e3770f494','2016-06-25 15:45:48'),('f20e647d-9ad0-4024-84b4-bf8990f04599',0,'n','每周2~3天','#','9fb31499-2b58-440d-9fd6-885d3c8504fe','2016-06-25 15:35:19'),('f9f47dd6-5bb6-4719-862b-882cf2151cdc',1,'n','实例类','#','85c7a48b-9a10-4029-a51e-60dd5577bf86','2017-01-17 11:37:00'),('f9f70afc-6a70-448a-9c92-4178f51edcdc',0,'n','本科','#','333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','2016-06-25 15:48:23'),('facdc877-410a-47f3-8a79-6e36778cbdb0',0,'n','企业公司管理者','#','30bdc659-e4cf-4745-94d9-8c55adc5017e','2016-06-25 15:51:16');
/*!40000 ALTER TABLE `questionnaire_answer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questionnaire_main`
--

DROP TABLE IF EXISTS `questionnaire_main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questionnaire_main` (
  `main_id` varchar(64) NOT NULL,
  `main_title` varchar(255) NOT NULL,
  `main_creat` datetime NOT NULL,
  `main_isuse` char(1) NOT NULL COMMENT 'main_isuse 该字段判断是否是当前发布的问卷调查',
  `main_endtime` date NOT NULL,
  `main_creatuser` varchar(20) DEFAULT NULL COMMENT '创建人',
  `main_creatdep` int(20) unsigned zerofill DEFAULT '00000000000000000000' COMMENT '创建部门',
  PRIMARY KEY (`main_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questionnaire_main`
--

LOCK TABLES `questionnaire_main` WRITE;
/*!40000 ALTER TABLE `questionnaire_main` DISABLE KEYS */;
INSERT INTO `questionnaire_main` VALUES ('b7bf4380-fb54-4f9b-afe2-be6b936e0f34','《Java 核心技术》样式意见征求','2016-06-25 16:28:10','y','2017-06-30','明日',00000000000000000001),('b866ea1c-3d0c-4f42-9880-05dfcc5aa640','第一期有奖问卷调查','2017-01-17 13:14:09','y','2018-01-01','明日科技',00000000000000000000),('d8dbfd3a-ffc0-47be-9c7d-a145346b58d2','关于您喜欢什么类型的计算机图书的问卷','2017-01-17 11:31:36','y','2018-01-31','明日科技',00000000000000000001),('dc499fc4-ac43-4ab1-8023-a52897b662b3','《偶像进行曲》IOS公测用户调研（无附件模板）','2016-06-25 15:33:43','y','2017-06-30','明日',00000000000000000001);
/*!40000 ALTER TABLE `questionnaire_main` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questionnaire_main_user`
--

DROP TABLE IF EXISTS `questionnaire_main_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questionnaire_main_user` (
  `user_id` varchar(64) NOT NULL,
  `main_id` varchar(64) NOT NULL,
  PRIMARY KEY (`user_id`,`main_id`),
  KEY `main_user_id` (`main_id`),
  CONSTRAINT `main_user_id` FOREIGN KEY (`main_id`) REFERENCES `questionnaire_main` (`main_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questionnaire_main_user`
--

LOCK TABLES `questionnaire_main_user` WRITE;
/*!40000 ALTER TABLE `questionnaire_main_user` DISABLE KEYS */;
INSERT INTO `questionnaire_main_user` VALUES ('mr','b7bf4380-fb54-4f9b-afe2-be6b936e0f34'),('mr','d8dbfd3a-ffc0-47be-9c7d-a145346b58d2'),('mr','dc499fc4-ac43-4ab1-8023-a52897b662b3');
/*!40000 ALTER TABLE `questionnaire_main_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questionnaire_msg`
--

DROP TABLE IF EXISTS `questionnaire_msg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questionnaire_msg` (
  `msg_id` varchar(64) NOT NULL,
  `msg_text` varchar(255) DEFAULT NULL,
  `main_id` varchar(64) NOT NULL,
  `msg_creatuser` varchar(20) DEFAULT NULL,
  `msg_creattime` datetime DEFAULT NULL,
  PRIMARY KEY (`msg_id`),
  KEY `msg_mainId` (`main_id`),
  CONSTRAINT `msg_mainId` FOREIGN KEY (`main_id`) REFERENCES `questionnaire_main` (`main_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questionnaire_msg`
--

LOCK TABLES `questionnaire_msg` WRITE;
/*!40000 ALTER TABLE `questionnaire_msg` DISABLE KEYS */;
INSERT INTO `questionnaire_msg` VALUES ('e1817edb-61b9-49b8-9c2f-cbaf130a455b','','b7bf4380-fb54-4f9b-afe2-be6b936e0f34',NULL,NULL),('ee0e6d7f-9435-464e-8369-4f0946b82fc9','','dc499fc4-ac43-4ab1-8023-a52897b662b3',NULL,NULL);
/*!40000 ALTER TABLE `questionnaire_msg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `questionnaire_question`
--

DROP TABLE IF EXISTS `questionnaire_question`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `questionnaire_question` (
  `question_id` varchar(64) NOT NULL,
  `question_title` varchar(255) NOT NULL,
  `question_creat` datetime NOT NULL,
  `question_destype` varchar(10) NOT NULL COMMENT 'destype 图片 img 文字 text',
  `question_type` varchar(10) NOT NULL COMMENT 'type 单选 radio 多攒 check',
  `main_id` varchar(64) NOT NULL,
  PRIMARY KEY (`question_id`),
  KEY `main_id` (`main_id`),
  CONSTRAINT `main_id` FOREIGN KEY (`main_id`) REFERENCES `questionnaire_main` (`main_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `questionnaire_question`
--

LOCK TABLES `questionnaire_question` WRITE;
/*!40000 ALTER TABLE `questionnaire_question` DISABLE KEYS */;
INSERT INTO `questionnaire_question` VALUES ('30bdc659-e4cf-4745-94d9-8c55adc5017e','请问您的职业是？','2016-06-25 15:51:16','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('333fb4bd-2f7b-4e9d-aeb4-c3bf751b150c','请问您的学历是？','2016-06-25 15:48:23','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('44b593ce-edff-4b85-9b60-6cecaa927c1e','请问您的年龄是？','2016-06-25 15:47:19','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('4820d0ea-8ecc-49e0-863b-f292fd22c556','您认为下列样式哪个比较吸引你？','2016-06-25 16:30:22','file','radio','b7bf4380-fb54-4f9b-afe2-be6b936e0f34'),('584db07b-ec0d-49b6-8101-927954f63315','您之前玩过《ICHU》日服么？','2016-06-25 15:45:28','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('74a9a1b2-db75-49e3-ac7e-1aab575f0f47','请问您最近3个月平均每天累计玩移动游戏的时间是多久呢？','2016-06-25 15:37:05','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('85c7a48b-9a10-4029-a51e-60dd5577bf86','关于您喜欢什么类型的计算机图书？','2017-01-17 11:37:00','file','check','d8dbfd3a-ffc0-47be-9c7d-a145346b58d2'),('8d02c51f-2b1f-4c64-8e73-b98f6a0a7a10','您喜欢通过哪种途径选购图书？','2017-01-17 13:21:00','file','check','b866ea1c-3d0c-4f42-9880-05dfcc5aa640'),('987a90af-e07c-4e67-9f4e-4f3335495b23','请告诉我们你您还玩过以下哪些游戏？','2016-06-25 15:43:26','file','check','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('9fb31499-2b58-440d-9fd6-885d3c8504fe','请问您最近3个月玩移动游戏的平率是怎样的呢？*','2016-06-25 15:35:19','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('a44d437e-0744-4aab-bf99-6e8e3770f494','您的性别是？','2016-06-25 15:45:48','file','radio','dc499fc4-ac43-4ab1-8023-a52897b662b3'),('b76aaf9a-c2f8-4621-856d-ec0d82579139','您喜欢哪种类型的计算机图书？','2017-01-17 13:20:09','file','check','b866ea1c-3d0c-4f42-9880-05dfcc5aa640');
/*!40000 ALTER TABLE `questionnaire_question` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_login`
--

DROP TABLE IF EXISTS `sys_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_login` (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(64) NOT NULL,
  `email` varchar(45) DEFAULT NULL,
  `wxname` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`login_id`),
  UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='登录信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_login`
--

LOCK TABLES `sys_login` WRITE;
/*!40000 ALTER TABLE `sys_login` DISABLE KEYS */;
INSERT INTO `sys_login` VALUES (28,'mr','fdb390e945559e74475ed8c8bbb48ca5','mingrisoft@mingrisoft.com','明日科技'),(29,'admin2','21232f297a57a5a743894a0e4a801fc3','mingrisoft@mingrisoft.com','明日科技'),(30,'admin3','21232f297a57a5a743894a0e4a801fc3','mingrisoft@mingrisoft.com','明日科技'),(31,'admin4','21232f297a57a5a743894a0e4a801fc3','mingrisoft@mingrisoft.com','明日科技'),(33,'admin6','21232f297a57a5a743894a0e4a801fc3','mingrisoft@mingrisoft.com','明日科技'),(35,'sssxxx','dad3a37aa9d50688b5157698acfd7aee','mingrisoft@mingrisoft.com','明日科技'),(38,'mingrisoft','6af49e0c6392610ce195e40b2dc0b4b3','mingrisoft@mingrisoft.com','明日科技'),(39,'admin0431','21232f297a57a5a743894a0e4a801fc3','mingrisoft@mingrisoft.com','明日'),(41,'mrsoft2','e10adc3949ba59abbe56e057f20f883e','mingrisoft@mingrisoft.com','明日科技'),(42,'mrsoft1','fdb390e945559e74475ed8c8bbb48ca5','mingrisoft@mingrisoft.com','明日科技');
/*!40000 ALTER TABLE `sys_login` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_login_role`
--

DROP TABLE IF EXISTS `sys_login_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_login_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `login_id` (`login_id`),
  CONSTRAINT `login_id` FOREIGN KEY (`login_id`) REFERENCES `sys_login` (`login_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='用户较色对照表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_login_role`
--

LOCK TABLES `sys_login_role` WRITE;
/*!40000 ALTER TABLE `sys_login_role` DISABLE KEYS */;
INSERT INTO `sys_login_role` VALUES (7,28,1,'mr'),(8,29,3,'admin2'),(9,30,3,'admin3'),(10,31,3,'admin4'),(12,33,3,'admin6'),(14,35,3,'sssxxx'),(17,38,1,'mingrisoft'),(18,39,2,'admin0431'),(20,41,1,'mrsoft2'),(21,42,3,'mrsoft1');
/*!40000 ALTER TABLE `sys_login_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_permission`
--

DROP TABLE IF EXISTS `sys_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_permission` (
  `permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_name` varchar(20) NOT NULL,
  `permission_menu_name` varchar(20) NOT NULL,
  `permission_menu_pid` int(11) DEFAULT NULL,
  PRIMARY KEY (`permission_id`),
  UNIQUE KEY `permission_name_UNIQUE` (`permission_name`),
  UNIQUE KEY `permission_menu_name_UNIQUE` (`permission_menu_name`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='权限';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_permission`
--

LOCK TABLES `sys_permission` WRITE;
/*!40000 ALTER TABLE `sys_permission` DISABLE KEYS */;
INSERT INTO `sys_permission` VALUES (8,'wjdc','问卷调查',0),(9,'wjdcxinjian','新建问卷',8),(10,'wjdchakan','查看问卷结果',8),(11,'wjdcshanchu','删除问卷',8),(12,'wjdcbianji','编辑问卷',8),(13,'wjdcfabu','发布问卷',8),(14,'wjdcfuzhi','复制问卷',8),(15,'wjdcchakan','查看结果',8),(20,'wjdcDH','导航菜单',8),(21,'sfqxDH','身份权限设置',0),(22,'jssz','角色设置',0),(23,'jsszDH','角色导航',22),(24,'jsszDEL','删除用户',22),(25,'jsszXGQX','修改权限',22),(26,'wjdcsousuo','问卷搜索',8),(27,'wjdcME','我的问卷',0),(28,'wjdctoupiao','问卷投票',8),(29,'quanxian','权限设置',NULL);
/*!40000 ALTER TABLE `sys_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) NOT NULL,
  `role_des` varchar(20) NOT NULL,
  `role_pid` int(11) NOT NULL,
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `role_des_UNIQUE` (`role_des`),
  UNIQUE KEY `role_name_UNIQUE` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'admin','管理员',0),(2,'guest','嘉宾',0),(3,'vip','会员',0),(4,'test01','测试角色',0),(5,'test0233','测试角色02',0),(6,'qicaoren','起草人',0),(7,'role','权限分配',-1);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_permission`
--

DROP TABLE IF EXISTS `sys_role_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `role_name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8 COMMENT='角色，权限对照表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_permission`
--

LOCK TABLES `sys_role_permission` WRITE;
/*!40000 ALTER TABLE `sys_role_permission` DISABLE KEYS */;
INSERT INTO `sys_role_permission` VALUES (82,2,15,'guest'),(91,5,8,'test02'),(92,5,9,'test02'),(93,5,10,'test02'),(94,5,11,'test02'),(95,5,12,'test02'),(96,5,13,'test02'),(97,5,14,'test02'),(98,5,15,'test02'),(99,4,8,'test01'),(100,4,14,'test01'),(213,6,8,'qicaoren'),(214,6,9,'qicaoren'),(215,6,10,'qicaoren'),(216,6,11,'qicaoren'),(217,6,12,'qicaoren'),(218,6,13,'qicaoren'),(219,6,14,'qicaoren'),(220,6,15,'qicaoren'),(221,6,20,'qicaoren'),(222,6,26,'qicaoren'),(223,6,27,'qicaoren'),(224,3,8,'vip'),(225,3,15,'vip'),(226,3,28,'vip'),(244,1,9,'admin'),(245,1,10,'admin'),(246,1,11,'admin'),(247,1,12,'admin'),(248,1,13,'admin'),(249,1,14,'admin'),(250,1,15,'admin'),(251,1,20,'admin'),(252,1,26,'admin'),(253,1,28,'admin'),(254,1,21,'admin'),(255,1,22,'admin'),(256,1,23,'admin'),(257,1,24,'admin'),(258,1,25,'admin'),(259,1,27,'admin'),(260,1,29,'admin');
/*!40000 ALTER TABLE `sys_role_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_userinfo`
--

DROP TABLE IF EXISTS `sys_userinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_userinfo` (
  `sys_userid` varchar(64) NOT NULL,
  `sys_username` varchar(64) DEFAULT NULL,
  `sys_sex` char(2) DEFAULT NULL,
  `sys_age` int(11) DEFAULT NULL,
  `sys_language` varchar(64) DEFAULT NULL,
  `sys_profession` varchar(64) DEFAULT NULL,
  `sys_name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`sys_userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_userinfo`
--

LOCK TABLES `sys_userinfo` WRITE;
/*!40000 ALTER TABLE `sys_userinfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_userinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_login`
--

DROP TABLE IF EXISTS `user_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_login` (
  `id` varchar(64) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `role` char(1) NOT NULL COMMENT '身份标记 0 普通用户 1 系统管理员',
  `infoname` varchar(6) DEFAULT NULL COMMENT '真是姓名',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `sex` char(1) DEFAULT NULL COMMENT '性别 0 女 1 男',
  `tell` varchar(20) DEFAULT NULL,
  `sfzh` varchar(18) DEFAULT NULL COMMENT '身份证号码',
  `address` varchar(70) DEFAULT NULL COMMENT '家庭住址',
  `creat_date` date DEFAULT NULL COMMENT '创建时间',
  `update_date` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户登录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_login`
--

LOCK TABLES `user_login` WRITE;
/*!40000 ALTER TABLE `user_login` DISABLE KEYS */;
INSERT INTO `user_login` VALUES ('bccc0cd5e87e4df6840f5475233f21e5','mr','mrsoft','1','明日科技',12,'1','84978981','220105100000000000','长春市经济技术开发区','2016-03-23','2016-03-23');
/*!40000 ALTER TABLE `user_login` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `work_day`
--

DROP TABLE IF EXISTS `work_day`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `work_day` (
  `work_id` varchar(64) NOT NULL,
  `work_title` varchar(255) NOT NULL,
  `work_start` date NOT NULL,
  `work_end` date NOT NULL,
  `work_color` varchar(255) NOT NULL,
  `work_scope` varchar(4) NOT NULL,
  PRIMARY KEY (`work_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `work_day`
--

LOCK TABLES `work_day` WRITE;
/*!40000 ALTER TABLE `work_day` DISABLE KEYS */;
/*!40000 ALTER TABLE `work_day` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-01-17 14:26:26