xdcjing/xdcjing_db.sql

-- MySQL dump 10.13  Distrib 5.7.19, for macos10.12 (x86_64)
--
-- Host: localhost    Database: xdcjing_db
-- ------------------------------------------------------
-- Server version	5.7.19

/*!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 `auth_group`
--

DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group`
--

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

--
-- Table structure for table `auth_group_permissions`
--

DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  KEY `auth_group__permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id` (`permission_id`),
  CONSTRAINT `auth_group__permission_id_1f49ccbbdc69d2fc_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permission_group_id_689710a9a73b7457_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_group_permissions`
--

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

--
-- Table structure for table `auth_permission`
--

DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
  CONSTRAINT `auth__content_type_id_508cf46651277a81_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_permission`
--

LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add permission',2,'add_permission'),(5,'Can change permission',2,'change_permission'),(6,'Can delete permission',2,'delete_permission'),(7,'Can add group',3,'add_group'),(8,'Can change group',3,'change_group'),(9,'Can delete group',3,'delete_group'),(10,'Can add user',4,'add_user'),(11,'Can change user',4,'change_user'),(12,'Can delete user',4,'delete_user'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add users',7,'add_users'),(20,'Can change users',7,'change_users'),(21,'Can delete users',7,'delete_users'),(22,'Can add reader',8,'add_reader'),(23,'Can change reader',8,'change_reader'),(24,'Can delete reader',8,'delete_reader'),(25,'Can add article',9,'add_article'),(26,'Can change article',9,'change_article'),(27,'Can delete article',9,'delete_article'),(28,'Can add banner',10,'add_banner'),(29,'Can change banner',10,'change_banner'),(30,'Can delete banner',10,'delete_banner'),(31,'Can add news',11,'add_news'),(32,'Can change news',11,'change_news'),(33,'Can delete news',11,'delete_news'),(34,'Can add reply',12,'add_reply'),(35,'Can change reply',12,'change_reply'),(36,'Can delete reply',12,'delete_reply');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auth_user`
--

DROP TABLE IF EXISTS `auth_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(30) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(254) DEFAULT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user`
--

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

--
-- Table structure for table `auth_user_groups`
--

DROP TABLE IF EXISTS `auth_user_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_33ac548dcf5f8e37_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_33ac548dcf5f8e37_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_4b5ed4ffdb8fd9b0_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user_groups`
--

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

--
-- Table structure for table `auth_user_user_permissions`
--

DROP TABLE IF EXISTS `auth_user_user_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`permission_id`),
  KEY `auth_user_u_permission_id_384b62483d7071f0_fk_auth_permission_id` (`permission_id`),
  CONSTRAINT `auth_user_u_permission_id_384b62483d7071f0_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissi_user_id_7f0938558328534a_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auth_user_user_permissions`
--

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

--
-- Table structure for table `content_manage_article`
--

DROP TABLE IF EXISTS `content_manage_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_manage_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) DEFAULT NULL,
  `img_url` varchar(500) DEFAULT NULL,
  `content` longtext,
  `type` smallint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `content_manage_article`
--

LOCK TABLES `content_manage_article` WRITE;
/*!40000 ALTER TABLE `content_manage_article` DISABLE KEYS */;
INSERT INTO `content_manage_article` VALUES (1,NULL,NULL,'<pre class=\"ql-syntax\" spellcheck=\"false\">现在财经主编致辞！\n</pre>',1),(2,'编委成员名单',NULL,'<ul><li>编委成员列表</li></ul><p><br></p><p class=\"ql-align-right\">衬里 不知道是谁 你知道吗 哈哈 。 我也不知道</p><p><br></p><p>那你地方十大城市的 地方地方给 。 电饭锅</p>',2),(3,' 投稿指南q',NULL,'<p>投稿指南qeq dfvsdfvrvewrver ergerge</p><p class=\"ql-align-center\">dfvdvfdfbdf sfgbsdfb</p>',3),(4,'选题指南',NULL,'<p>选题指南</p>',4),(5,NULL,NULL,'<p><span style=\"color: green;\">你不是这样的你知道吗</span></p><p>你都烦你</p>',0),(6,'年度指南',NULL,'<p>年度指南</p>',5);
/*!40000 ALTER TABLE `content_manage_article` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `content_manage_banner`
--

DROP TABLE IF EXISTS `content_manage_banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_manage_banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL,
  `img_url` varchar(500) DEFAULT NULL,
  `display_title` varchar(128) NOT NULL,
  `article_url` varchar(200) DEFAULT NULL,
  `article_title` varchar(128) NOT NULL,
  `author` varchar(32) DEFAULT NULL,
  `content` longtext,
  `create_time` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `content_manage_banner`
--

LOCK TABLES `content_manage_banner` WRITE;
/*!40000 ALTER TABLE `content_manage_banner` DISABLE KEYS */;
INSERT INTO `content_manage_banner` VALUES (8,3,'http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511160691.png','qwer','wer','qwer','qwer','<p>qwer阿嘎而过</p>','2017-11-17'),(9,2,'http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511160653.png','dfg','dfg','dfg','dfg','<p>dfg</p>','2017-11-20'),(10,1,'http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511164584.png','标题1','去玩儿','圈儿','圈儿 ','<p><br></p><p><img src=\"http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511163538.png\"></p>','2017-11-20'),(11,4,'http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511164527.png','123132','123','123','123123','<p><br></p><p><img src=\"http://tederen.oss-cn-shanghai.aliyuncs.com/xdcjing/1511164152.png\"></p>','2017-11-20');
/*!40000 ALTER TABLE `content_manage_banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `content_manage_news`
--

DROP TABLE IF EXISTS `content_manage_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_manage_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `img_url` varchar(500) DEFAULT NULL,
  `author` varchar(32) DEFAULT NULL,
  `content` longtext,
  `create_time` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `content_manage_news`
--

LOCK TABLES `content_manage_news` WRITE;
/*!40000 ALTER TABLE `content_manage_news` DISABLE KEYS */;
INSERT INTO `content_manage_news` VALUES (6,'动态1',NULL,'author1','<p>动态1</p>','2017-11-20'),(7,'动态2',NULL,'author2','<p>动态2</p>','2017-11-20');
/*!40000 ALTER TABLE `content_manage_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_admin_log`
--

DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `djang_content_type_id_697914295151027a_fk_django_content_type_id` (`content_type_id`),
  KEY `django_admin_log_user_id_52fdd58701c5f563_fk_auth_user_id` (`user_id`),
  CONSTRAINT `djang_content_type_id_697914295151027a_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_52fdd58701c5f563_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_admin_log`
--

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

--
-- Table structure for table `django_content_type`
--

DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_45f3b1d93ec8c61c_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_content_type`
--

LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(9,'content_manage','article'),(10,'content_manage','banner'),(11,'content_manage','news'),(6,'sessions','session'),(8,'users','reader'),(12,'users','reply'),(7,'users','users');
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_migrations`
--

DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_migrations`
--

LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2017-11-16 07:36:09.242970'),(2,'auth','0001_initial','2017-11-16 07:36:10.840553'),(3,'admin','0001_initial','2017-11-16 07:36:11.349527'),(4,'contenttypes','0002_remove_content_type_name','2017-11-16 07:36:11.624761'),(5,'auth','0002_alter_permission_name_max_length','2017-11-16 07:36:11.811673'),(6,'auth','0003_alter_user_email_max_length','2017-11-16 07:36:11.970218'),(7,'auth','0004_alter_user_username_opts','2017-11-16 07:36:12.004303'),(8,'auth','0005_alter_user_last_login_null','2017-11-16 07:36:12.118244'),(9,'auth','0006_require_contenttypes_0002','2017-11-16 07:36:12.120829'),(10,'sessions','0001_initial','2017-11-16 07:36:12.382079'),(11,'users','0001_initial','2017-11-16 07:36:12.500994'),(12,'users','0002_users_real_name','2017-11-16 07:36:12.781213'),(13,'users','0003_auto_20171116_0630','2017-11-16 07:36:14.120786'),(14,'users','0004_auto_20171116_0702','2017-11-16 07:36:14.487133'),(15,'users','0005_auto_20171116_0733','2017-11-16 07:36:14.604348'),(16,'users','0006_auto_20171116_0917','2017-11-16 09:17:11.003372'),(17,'content_manage','0001_initial','2017-11-16 10:20:02.468007'),(18,'users','0007_auto_20171116_1019','2017-11-16 10:20:02.480845'),(19,'content_manage','0002_auto_20171116_1047','2017-11-16 10:47:33.056994'),(20,'content_manage','0003_auto_20171116_1139','2017-11-16 11:40:07.117119'),(21,'content_manage','0004_auto_20171116_1253','2017-11-16 12:53:40.170944'),(22,'content_manage','0005_banner','2017-11-17 02:32:23.884475'),(23,'users','0008_auto_20171117_0232','2017-11-17 02:32:24.603995'),(24,'content_manage','0006_news','2017-11-17 03:33:58.510359'),(25,'users','0009_auto_20171117_0828','2017-11-17 08:28:20.463893'),(26,'users','0010_auto_20171117_0831','2017-11-17 08:31:26.534645'),(27,'content_manage','0007_auto_20171117_1117','2017-11-17 11:17:10.297705'),(28,'content_manage','0008_auto_20171120_0146','2017-11-20 01:46:11.697740'),(29,'users','0011_auto_20171120_0814','2017-11-20 08:15:03.925797'),(30,'users','0012_remove_reader_fb_id','2017-11-20 08:59:27.877032');
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `django_session`
--

DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_de54fa62` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `django_session`
--

LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
INSERT INTO `django_session` VALUES ('09xwv8z66a3nljhub9dv4fvi9vlnrb03','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 04:37:50.099927'),('499i3fj93hxsbpkya8rzsu528y1mxaju','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 06:40:13.317221'),('5gjyw2byvgj513gnk77u5m7tgsise8jg','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 06:26:34.130527'),('5omzh1028st9llbeqapx9vlximlnqe1e','YzM1Y2IwMDVhMTczYTBjNDE3ZDdjMjYxNWU4ZjVhOWJmYWY1MWUwMzp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjowLCJ1aWQiOjksInJlYWxuYW1lIjpudWxsfX0=','2017-11-20 14:08:51.320312'),('60zort1zhas7ezv566hay3kz0wo1cwaa','YzM1Y2IwMDVhMTczYTBjNDE3ZDdjMjYxNWU4ZjVhOWJmYWY1MWUwMzp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjowLCJ1aWQiOjksInJlYWxuYW1lIjpudWxsfX0=','2017-11-17 13:54:37.103806'),('84nql97zeck4tfv3qtget2q6bnbln0dh','ZTVlYzdjZDUxZGI5NzRkM2RkYTIyOTIzZDYwNWE3NGZmZWVkZTgyMTp7InVzZXIiOnsidXNlcm5hbWUiOiJ0ZXN0NCIsInN0YXR1cyI6MSwicGVybWlzc2lvbiI6MSwidWlkIjoxMCwicmVhbG5hbWUiOm51bGx9fQ==','2017-11-17 14:14:46.327861'),('fgvn6hqdno7k2dgwzmlmbokyh0kmdoyp','YTk5ZGZkZGIxNjhjMTc4M2Q2MjQ4M2JjOGE4ZjNkY2U3MzE5Njc3YTp7InVzZXIiOnsidXNlcm5hbWUiOiJcdTZkNGJcdThiZDUxIiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoyLCJ1aWQiOjExLCJyZWFsbmFtZSI6bnVsbH19','2017-11-20 08:58:51.479830'),('jiu8ayygnq6kpc4zxhydwm5wd606a2t8','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 07:43:19.241970'),('kvrpv4vr7l2zzzzt3pztal3xgjpzjuy8','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 06:39:07.001343'),('mwwgi0cwati7o347fjp08sciq750vzgk','YTk5ZGZkZGIxNjhjMTc4M2Q2MjQ4M2JjOGE4ZjNkY2U3MzE5Njc3YTp7InVzZXIiOnsidXNlcm5hbWUiOiJcdTZkNGJcdThiZDUxIiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoyLCJ1aWQiOjExLCJyZWFsbmFtZSI6bnVsbH19','2017-11-20 14:46:46.032802'),('o7nihy1dlbvy1fzn8zcekyx1g7jy5wz7','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 07:14:29.630193'),('r795mjd4jld7kp5723wzjuuhslwc1ofw','ZmU0ZjJiYmIxZTM5YWE0ZmE0YTA5YTI1NWI2MGQ4Zjk0MGZmYzhmODp7InVzZXIiOnsidXNlcm5hbWUiOiJUb20yIiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjMsInJlYWxuYW1lIjpudWxsfX0=','2017-11-16 10:08:27.799721'),('vrnaygr43sn6ioavhschg3r18vkjnsvw','NzUwZTI1MzhhZTc3NDc1YzYxOTQ4ZDhkMTJjMDc2YWEzODFjZTE4MTp7InVzZXIiOnsidXNlcm5hbWUiOiJUb255Iiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjEsInJlYWxuYW1lIjoiXHU2NzRlXHU2NjUzXHU1MzRlIn19','2017-11-17 06:26:05.897339'),('y22a7kx6ux6cff1wohtizinudk3cm7nq','ZmU0ZjJiYmIxZTM5YWE0ZmE0YTA5YTI1NWI2MGQ4Zjk0MGZmYzhmODp7InVzZXIiOnsidXNlcm5hbWUiOiJUb20yIiwic3RhdHVzIjoxLCJwZXJtaXNzaW9uIjoxLCJ1aWQiOjMsInJlYWxuYW1lIjpudWxsfX0=','2017-11-16 09:17:42.386191');
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_reader`
--

DROP TABLE IF EXISTS `users_reader`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_reader` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `readername` varchar(32) DEFAULT NULL,
  `create_time` date DEFAULT NULL,
  `question` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_reader`
--

LOCK TABLES `users_reader` WRITE;
/*!40000 ALTER TABLE `users_reader` DISABLE KEYS */;
INSERT INTO `users_reader` VALUES (1,'hahaha',NULL,'为什么下雨');
/*!40000 ALTER TABLE `users_reader` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_reply`
--

DROP TABLE IF EXISTS `users_reply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fb_content` longtext,
  `fb_id_id` int(11),
  `u_id_id` int(11),
  PRIMARY KEY (`id`),
  KEY `users_reply_fe932a18` (`fb_id_id`),
  KEY `users_reply_1ce89169` (`u_id_id`),
  CONSTRAINT `users_reply_fb_id_id_39a673f1c307e7d3_fk_users_reader_id` FOREIGN KEY (`fb_id_id`) REFERENCES `users_reader` (`id`),
  CONSTRAINT `users_reply_u_id_id_5939940f99e49777_fk_users_users_id` FOREIGN KEY (`u_id_id`) REFERENCES `users_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_reply`
--

LOCK TABLES `users_reply` WRITE;
/*!40000 ALTER TABLE `users_reply` DISABLE KEYS */;
INSERT INTO `users_reply` VALUES (2,'wwwwwwwss',1,9),(3,'wwwwwwwss',1,3),(4,'wwwwwwwss',1,3);
/*!40000 ALTER TABLE `users_reply` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_users`
--

DROP TABLE IF EXISTS `users_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(128) NOT NULL,
  `status` int(11),
  `permission` int(11),
  `signup_time` date NOT NULL,
  `real_name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_users`
--

LOCK TABLES `users_users` WRITE;
/*!40000 ALTER TABLE `users_users` DISABLE KEYS */;
INSERT INTO `users_users` VALUES (3,'Tom2','pbkdf2_sha256$20000$TYf434zIJeXQ$0yUUy8G92ybd4T20JrSX1e7j+j/jbh8orx9V34XDu3A=',0,1,'2017-11-16',NULL),(4,'123','pbkdf2_sha256$20000$TrinQ3r5UCK7$S9JEPEnuE1wutv7Ia1SxzDmfAWUA+2MiLZa1uYIzgDM=',1,1,'2017-11-17',NULL),(9,'Tony','pbkdf2_sha256$20000$4iTT0Xyn0RWL$ur/WwPOlo+jAddR9cDTVdMscvaHF9MBNmVfX4Nw/yeE=',1,0,'2017-11-17',NULL),(10,'test4','pbkdf2_sha256$20000$EG8aQLNTtncy$x1t1YqdzzAeDYKOOnuDPvN7EbuLJALFy3VM3N15Tc0g=',1,0,'2017-11-17',NULL),(11,'测试1','pbkdf2_sha256$20000$j7C8qpfapD7h$bfFXIo/j7jCUQopeQIhz/EvzH/F31YTYXoFJsc1jUK8=',1,2,'2017-11-20',NULL);
/*!40000 ALTER TABLE `users_users` 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 2018-01-15 17:18:50