代码拉取完成，页面将自动刷新
同步操作将从 rinuo/tp5问卷调查系统 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
-- MySQL dump 10.13 Distrib 5.5.53, for Win32 (AMD64)
--
-- Host: localhost Database: diaocha
-- ------------------------------------------------------
-- Server version 5.5.53
/*!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 `ym_admin`
--
DROP TABLE IF EXISTS `ym_admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_admin` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`password` char(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_admin`
--
LOCK TABLES `ym_admin` WRITE;
/*!40000 ALTER TABLE `ym_admin` DISABLE KEYS */;
INSERT INTO `ym_admin` VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3'),(5,'admin2','e10adc3949ba59abbe56e057f20f883e'),(6,'admin3','c33367701511b4f6020ec61ded352059'),(8,'gmy','c9312104bb5d9f669cab14ba7317a734'),(9,'guo','e2ac255ade95b9268571eb5baf345974'),(10,'管理一','e10adc3949ba59abbe56e057f20f883e'),(11,'gmt','3cb8eb17ba602a2951b9d2c11f1de623');
/*!40000 ALTER TABLE `ym_admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_answer`
--
DROP TABLE IF EXISTS `ym_answer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_answer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cate` int(11) NOT NULL DEFAULT '0' COMMENT '所属问题',
`title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '问题名称',
`type` int(1) NOT NULL DEFAULT '0' COMMENT '问题类型',
`time` int(10) DEFAULT NULL COMMENT '提交时间',
`answerid` int(11) DEFAULT '0' COMMENT '所属问题id',
`answer1` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案1',
`answer2` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案2',
`answer3` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案3',
`answer4` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案4',
`answer5` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案5',
`answer6` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '问题答案6',
`member` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案2',
`name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '填写人姓名',
`serialnumber` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '学号',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_answer`
--
LOCK TABLES `ym_answer` WRITE;
/*!40000 ALTER TABLE `ym_answer` DISABLE KEYS */;
/*!40000 ALTER TABLE `ym_answer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_article`
--
DROP TABLE IF EXISTS `ym_article`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_article` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL COMMENT '标题',
`username` varchar(150) NOT NULL DEFAULT '' COMMENT '所属用户',
`desc` varchar(255) DEFAULT '' COMMENT '描述',
`pic` varchar(100) NOT NULL COMMENT '缩略图',
`content` text NOT NULL COMMENT '内容',
`click` mediumint(9) NOT NULL DEFAULT '0' COMMENT '点击量',
`cateid` mediumint(9) NOT NULL,
`time` int(10) NOT NULL COMMENT '发布时间',
`close` mediumint(9) NOT NULL DEFAULT '0' COMMENT '打开关闭',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_article`
--
LOCK TABLES `ym_article` WRITE;
/*!40000 ALTER TABLE `ym_article` DISABLE KEYS */;
INSERT INTO `ym_article` VALUES (48,'国庆去哪里玩','','大家国庆节去过哪些地方','','',267,80,1475655497,0),(49,'国庆去哪里玩','','大家国庆节去过哪些地方','','',229,80,1475656743,1),(50,'你喜欢的景点','','列举几个可以多选哦','','',207,81,1475659291,0),(52,'多个复选题目','','','','',183,83,1475704560,1),(57,'多个单选题目','','','','',53,84,1475915664,0),(58,'国庆去哪里玩','','大家国庆节去过哪些地方','','',18,80,1476065467,0);
/*!40000 ALTER TABLE `ym_article` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_article_contens`
--
DROP TABLE IF EXISTS `ym_article_contens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_article_contens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cate` int(11) NOT NULL DEFAULT '0' COMMENT '所属问题',
`title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '问题名称',
`type` int(1) DEFAULT '0' COMMENT '问题类型',
`number` int(1) DEFAULT '0',
`contens` text CHARACTER SET utf8,
`answer1` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案1',
`answer2` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案2',
`answer6` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案6',
`answer3` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案3',
`answer4` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案4',
`answer5` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案5',
`close` smallint(6) DEFAULT '0' COMMENT '无',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_article_contens`
--
LOCK TABLES `ym_article_contens` WRITE;
/*!40000 ALTER TABLE `ym_article_contens` DISABLE KEYS */;
INSERT INTO `ym_article_contens` VALUES (88,48,'我去了很多地方',0,0,NULL,'1个','2个','','3个以上','','',0),(89,48,'为什么喜欢旅游',1,0,NULL,'锻炼身体','扩展视野','','结交朋友','','',0),(90,48,'作业写了吗',0,0,NULL,'写好了','写了大部分','','写了一点点','没有写','',0),(91,49,'我去了很多地方',0,0,NULL,'1个','2个','','3个以上','','',0),(92,49,'为什么喜欢旅游',1,0,NULL,'锻炼身体','扩展视野','','结交朋友','','',0),(93,49,'作业写了吗',1,0,NULL,'写好了','写了大部分','','写了一点点','没有写','',0),(94,50,'国内的景点',1,0,NULL,'九寨沟','泰山','','华山','桂林','长城',0),(95,50,'国外的景点',1,0,NULL,'伦敦桥','自由女神','','日本樱花','马来西亚','',0),(96,51,'地方规定是的方法反反复复凤飞飞反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复',1,0,NULL,'发货的 和嘎嘎嘎嘎嘎嘎灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌 ','个呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵好回家','几个','价格高','感觉','公积金就急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急',0),(97,52,'1',1,0,NULL,'1','1','','','','',0),(98,52,'2',1,0,NULL,'2','2','','','','',0),(99,52,'3',1,0,NULL,'3','3','','','','',0),(100,53,'1',0,0,NULL,'11','11','1','11','11','11',0),(101,53,'22',0,0,NULL,'2','2','2','222','22','22',0),(102,53,'3',0,0,NULL,'33','3','33','33','33','3',0),(103,54,'二',0,0,NULL,' 人',' 二','太阳','突然','让他','有人',0),(104,54,'让他也',0,0,NULL,'让他也','太阳','r6567','UI哦','够一u欧赔 ','UI欧',0),(105,55,'二',0,0,NULL,' 人',' 二','太阳','突然','让他','有人',0),(106,55,'让他也',0,0,NULL,'让他也','太阳','r6567','UI哦','够一u欧赔 ','UI欧',0),(107,56,'二',0,0,NULL,' 人',' 二','太阳','突然','让他','有人',0),(108,56,'让他也',0,0,NULL,'让他也','太阳','r6567','UI哦','够一u欧赔 ','UI欧',0),(109,57,'1',0,0,NULL,'11','11','1','11','11','11',0),(110,57,'22',0,0,NULL,'2','2','2','222','22','22',0),(111,57,'3',0,0,NULL,'33','3','33','33','33','3',0),(112,58,'我去了很多地方',0,0,NULL,'1个','2个','','3个以上','','',0),(113,58,'为什么喜欢旅游',2,0,NULL,'锻炼身体','扩展视野','','结交朋友','','',0),(114,58,'作业写了吗',1,0,NULL,'写好了','写了大部分','','写了一点点','没有写','',0),(115,59,'标题',0,0,NULL,'说的','','','','','',0),(116,60,'标题',0,0,NULL,'说的','','','','','',0),(117,63,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','6以上','3次','4次','5次',0),(118,64,'你旅游平均大概几天',1,0,NULL,'1天内','2天','6天以上','3天','4天','5天',0),(119,65,'你旅游平均大概几天',1,0,NULL,'1天内','2天','6天以上','3天','4天','5天',0),(120,66,'你旅游平均大概几天',1,0,NULL,'1天内','2天','6天以上','3天','4天','5天',0),(121,66,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','拉萨','桂林','香港','澳门',0),(122,66,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','6以上','3次','4次','5次',0),(123,67,'你旅游平均大概几天',1,0,NULL,'1天内','2天','6天以上','3天','4天','5天',0),(124,67,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','拉萨','桂林','香港','澳门',0),(125,67,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','6以上','3次','4次','5次',0),(126,68,'888888888',1,0,NULL,'8','8','6天以上','8','8','8',0),(127,68,'8888',2,0,NULL,'8','8','8','8','8','8',0),(128,68,'8888888888888',0,0,NULL,'8','8','8','8','8','8',0);
/*!40000 ALTER TABLE `ym_article_contens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_article_limit`
--
DROP TABLE IF EXISTS `ym_article_limit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_article_limit` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`articleid` varchar(255) DEFAULT '' COMMENT '所属问卷',
`limit` text COMMENT '允许的用户记录',
`title` varchar(30) NOT NULL COMMENT '标题',
`username` varchar(150) NOT NULL DEFAULT '' COMMENT '所属用户',
`pic` varchar(100) NOT NULL COMMENT '缩略图',
`click` mediumint(9) NOT NULL DEFAULT '0' COMMENT '点击量',
`cateid` mediumint(9) NOT NULL,
`time` int(10) NOT NULL COMMENT '发布时间',
`close` mediumint(9) NOT NULL DEFAULT '0' COMMENT '打开关闭',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_article_limit`
--
LOCK TABLES `ym_article_limit` WRITE;
/*!40000 ALTER TABLE `ym_article_limit` DISABLE KEYS */;
INSERT INTO `ym_article_limit` VALUES (4,'67','50,49,48,47,46,45,44,43,6,','','','',0,0,1476331566,0),(5,'64','','','','',0,0,1476332535,0);
/*!40000 ALTER TABLE `ym_article_limit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_cate`
--
DROP TABLE IF EXISTS `ym_cate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_cate` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`catename` varchar(30) DEFAULT '' COMMENT '栏目名称',
`username` varchar(150) DEFAULT '' COMMENT '所属管理员',
`desc` text COMMENT '栏目描述',
`type` tinyint(1) DEFAULT '0' COMMENT '栏目类型0：列表 1：留言',
`title` varchar(255) DEFAULT '' COMMENT '问卷模板标题',
`time` int(10) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=164 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_cate`
--
LOCK TABLES `ym_cate` WRITE;
/*!40000 ALTER TABLE `ym_cate` DISABLE KEYS */;
INSERT INTO `ym_cate` VALUES (80,'国庆去哪里玩','admin','大家国庆节去过哪些地方',0,NULL,0),(81,'你喜欢的景点','admin','列举几个可以多选哦',0,NULL,0),(83,'多个复选题目','admin','',0,NULL,0),(84,'多个单选题目','admin','',0,'miaoshu',1586683233);
/*!40000 ALTER TABLE `ym_cate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_cate_contens`
--
DROP TABLE IF EXISTS `ym_cate_contens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_cate_contens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cate` int(11) NOT NULL DEFAULT '0' COMMENT '所属问题',
`title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '问题名称',
`type` int(1) NOT NULL DEFAULT '0' COMMENT '问题类型',
`number` int(1) NOT NULL DEFAULT '0' COMMENT '问题序号',
`contens` text CHARACTER SET utf8,
`answer1` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '问题答案1',
`answer2` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案2',
`answer3` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案3',
`answer4` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案4',
`answer5` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案5',
`answer6` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案6',
`Copy_of_answer2` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '问题答案2',
`time` int(10) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=gbk;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_cate_contens`
--
LOCK TABLES `ym_cate_contens` WRITE;
/*!40000 ALTER TABLE `ym_cate_contens` DISABLE KEYS */;
INSERT INTO `ym_cate_contens` VALUES (94,80,'我去了很多地方',0,0,NULL,'1个','2个','3个以上','','','','',0),(95,80,'为什么喜欢旅游',2,0,NULL,'锻炼身体','扩展视野','结交朋友','','','','',0),(96,80,'作业写了吗',1,0,NULL,'写好了','写了大部分','写了一点点','没有写','','','',0),(97,81,'国内的景点',1,0,NULL,'九寨沟','泰山','华山','桂林','长城','','',0),(98,81,'国外的景点',1,0,NULL,'伦敦桥','自由女神','日本樱花','马来西亚','','','',0),(99,82,'地方规定是的方法反反复复凤飞飞反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复反复',1,0,NULL,'发货的 和嘎嘎嘎嘎嘎嘎灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌灌 ','个呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵呵好回家','价格高','感觉','公积金就急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急','几个','',0),(123,0,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(124,0,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(125,141,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(126,142,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(127,143,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(128,144,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(129,145,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(130,146,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(131,147,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(132,148,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(133,149,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(134,150,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(135,151,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(136,152,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(137,153,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(138,154,'你想要去以下哪些地方旅行',2,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',1476258816),(139,155,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(140,156,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(141,156,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(142,156,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(143,157,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(144,157,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(145,157,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(146,158,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(147,158,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(148,158,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(149,159,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(150,159,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(151,159,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(152,160,'您一年大概参加旅游几次',0,0,NULL,'1次','2次','3次','4次','5次','6以上','',0),(153,160,'你想要去以下哪些地方旅行',1,0,NULL,'北京','九寨沟','桂林','香港','澳门','拉萨','',0),(154,160,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0),(162,163,'你旅游平均大概几天',1,0,NULL,'1天内','2天','3天','4天','5天','6天以上','',0);
/*!40000 ALTER TABLE `ym_cate_contens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_guest`
--
DROP TABLE IF EXISTS `ym_guest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_guest` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`nickname` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
`homepage` varchar(150) NOT NULL,
`content` text NOT NULL,
`face` varchar(150) NOT NULL,
`level` tinyint(1) NOT NULL DEFAULT '1',
`artid` mediumint(9) NOT NULL DEFAULT '0',
`pid` mediumint(9) NOT NULL DEFAULT '0',
`time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_guest`
--
LOCK TABLES `ym_guest` WRITE;
/*!40000 ALTER TABLE `ym_guest` DISABLE KEYS */;
INSERT INTO `ym_guest` VALUES (1,'fsadf','dfasdf@qq.com','www.122.com','sdfsdf','',1,0,0,1469539481),(2,'fsadf2','dfasd2f@qq.com','www.12222.com','sdfsdf2','',1,0,0,1469539687),(3,'童攀','tongpan@qq.com','www.12222.com','童攀童攀童攀童攀童攀童攀童攀童攀','',1,0,0,1469539721),(4,'童年','tongnian@qq.com','www.12222.com','童年童年童年童年童年童年童年童年童年童年童年童年童年','',1,0,0,1469539739),(5,'天天','tongnian@qq.com','www.12222.com','天天天天天天天天天天天天天天天天天天天天','',1,0,0,1469539760),(6,'dfsd','dfasdf@qq.com','www.12222.com','fasdfsdfsdf','',1,0,0,1469542092),(7,'dfsd','dfasdf@qq.com','www.12222.com','sdfasdfsdf','',1,0,0,1469542468);
/*!40000 ALTER TABLE `ym_guest` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_link`
--
DROP TABLE IF EXISTS `ym_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_link` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL COMMENT '链接标题',
`desc` varchar(255) NOT NULL COMMENT '链接描述',
`url` varchar(60) NOT NULL COMMENT '链接地址',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_link`
--
LOCK TABLES `ym_link` WRITE;
/*!40000 ALTER TABLE `ym_link` DISABLE KEYS */;
INSERT INTO `ym_link` VALUES (1,'百度1','百度百度百度百度百度','http://www.baidu.com'),(2,'title','desc','url'),(4,'asdf','asdf','asdf'),(5,'11','3','2'),(6,'sdfsadf','asdf','sdfasdf'),(8,'sdfsd','asdfsdf','sadfsadf');
/*!40000 ALTER TABLE `ym_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ym_member`
--
DROP TABLE IF EXISTS `ym_member`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ym_member` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL COMMENT '姓名',
`username` varchar(50) DEFAULT NULL COMMENT '所属管理员ID',
`province` varchar(30) NOT NULL DEFAULT '' COMMENT '省',
`city` varchar(50) DEFAULT NULL COMMENT '市',
`area` varchar(150) NOT NULL DEFAULT '' COMMENT '县/区',
`school` varchar(30) NOT NULL DEFAULT '' COMMENT '学校',
`grade` varchar(50) NOT NULL DEFAULT '' COMMENT '年级',
`class` varchar(22) DEFAULT NULL COMMENT '班级',
`serialnumber` int(11) DEFAULT NULL COMMENT '学号',
`telephone` bigint(13) DEFAULT NULL COMMENT '电话',
`type` int(11) DEFAULT NULL COMMENT '类型（老师/家长/学生）',
`level` int(11) DEFAULT NULL COMMENT '级别（小/初/高）',
`number` int(11) NOT NULL DEFAULT '0' COMMENT '编号',
`pic` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
`timee` mediumint(9) DEFAULT NULL COMMENT '添加时间',
`time` int(11) DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ym_member`
--
LOCK TABLES `ym_member` WRITE;
/*!40000 ALTER TABLE `ym_member` DISABLE KEYS */;
INSERT INTO `ym_member` VALUES (6,'张三','guo','山东','淄博市','张店区','传媒大学','一年级','五班',55,55,5,5,5,'/static/uploads/20160927/c0381420b9281694ba3eb14f97d62f78.PNG',5,1469271904),(43,'测试123','admin','湖南省','三省市','张庄区','实现高中','高一','三班',100200,12501254122,3,3,2001,'',NULL,NULL),(44,'李三儿','admin','四川省','成都市','海淀区','第二实小','三年级','五班',100895,18210784566,1,2,1201201,'',NULL,NULL),(46,'张昊','admin','山东','淄博市','学生','张三','初一','二班',1821078740,18210782222,2,1,22,'',NULL,NULL),(47,'测试123','admin','湖南省','三省市','张庄区','实现高中','高一','三班',100200,12501254122,3,3,2001,'',NULL,NULL),(48,'李三儿','admin','四川省','成都市','海淀区','第二实小','三年级','五班',100895,18210784566,1,2,1201201,'',NULL,NULL),(49,'张三','admin','湖北','阳江市','张店区','传媒大学','一年级','五班',55,18536552366,1,2,5,'',NULL,NULL),(50,'张昊','admin','山东','淄博市','学生','张三','初一','二班',1821078740,18210782222,2,1,22,'',NULL,NULL),(51,'测试123','admin','湖南省','三省市','张庄区','实现高中','高一','三班',100200,12501254122,3,3,2001,'',NULL,NULL),(52,'李三儿','admin','四川省','成都市','海淀区','第二实小','三年级','五班',100895,18210784566,1,2,1201201,'',NULL,NULL),(53,'张三','admin','湖北','阳江市','张店区','传媒大学','一年级','五班',55,18536552366,1,2,5,'',NULL,NULL),(54,'张昊','admin','山东','淄博市','学生','张三','初一','二班',1821078740,18210782222,2,1,22,'',NULL,NULL);
/*!40000 ALTER TABLE `ym_member` 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 2020-04-12 17:59:32
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
