CREATE DATABASE  IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `test`;
-- MySQL dump 10.13  Distrib 5.6.17, for Win64 (x86_64)
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	5.6.21-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 `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_permissions_5f412f9a` (`group_id`),
  KEY `auth_group_permissions_83d7f98b` (`permission_id`),
  CONSTRAINT `group_id_refs_id_f4b32aac` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `permission_id_refs_id_6ba0f519` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`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(50) NOT 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`),
  KEY `auth_permission_37ef4eb4` (`content_type_id`),
  CONSTRAINT `content_type_id_refs_id_d043b34a` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 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');
/*!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 NOT 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(75) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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 */;
INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$12000$ntRbjxEyujWF$mBOguvfuMXuaSycDn3TVxTXkFbHzKv5cv7BFbqrlUMg=','2014-12-10 08:20:56',1,'xiao','','','xiao@xiaohello.cn',1,1,'2014-10-26 10:41:53');
/*!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_6340c63c` (`user_id`),
  KEY `auth_user_groups_5f412f9a` (`group_id`),
  CONSTRAINT `group_id_refs_id_274b862c` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `user_id_refs_id_40c41112` 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_user_permissions_6340c63c` (`user_id`),
  KEY `auth_user_user_permissions_83d7f98b` (`permission_id`),
  CONSTRAINT `permission_id_refs_id_35d9ac25` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `user_id_refs_id_4dc23c39` 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 `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 NOT NULL,
  `user_id` int(11) NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_6340c63c` (`user_id`),
  KEY `django_admin_log_37ef4eb4` (`content_type_id`),
  CONSTRAINT `content_type_id_refs_id_93d2d1f8` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `user_id_refs_id_c0d12874` 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,
  `name` varchar(100) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_label` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=7 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,'log entry','admin','logentry'),(2,'permission','auth','permission'),(3,'group','auth','group'),(4,'user','auth','user'),(5,'content type','contenttypes','contenttype'),(6,'session','sessions','session');
/*!40000 ALTER TABLE `django_content_type` 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 NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_b7b81f0c` (`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 ('0isdcysrvcjwoik8nnm6i92yc83ek80o','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 07:53:45'),('35vseebf92qzg9i96vucmhz4xwzn9d2k','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 05:04:04'),('40qeyifk12lpl87x2ha31zcxdg9jth5c','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 11:26:44'),('4q4vab9tsreonflc11hxf7ya7s932lcb','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-09 11:53:02'),('4rrbv6fr54hciil5x79e0wo1wxzjiyjo','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-17 06:27:51'),('5s6kcizw5yx2dzia1katsvia5kk2y9ne','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-02 07:08:22'),('5vqukerxmi15d93fgoqpjt4jwf885fsc','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 11:58:10'),('69bj66gqysqzif5y9aun48wsp4mr12m4','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:23'),('6tggs1bwsbwg5pt88v33lnoe62pexa7a','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-11 08:17:55'),('8pjkokl3ka4j9f3hkkiu3c5uvwv9xl2q','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:28'),('8s0vbw51gpzgkc0vhgwcag0b87p27lw0','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-11-28 12:04:07'),('95h1onmjig9mmec2abfscy3o3pnj0mmm','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-03 11:33:35'),('98bbpe9u59nx1yccxit012er9tqeba4d','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-11-28 12:03:22'),('9c7vwsqjhzoytpy2cfaksw2br1ng57pi','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-09 11:57:52'),('9skgi5zvzhlpko2nvv4u0900a0k0ht7z','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 09:45:25'),('a1wmxijqm4enn735uwi1ufvzitmm6fib','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 12:02:22'),('cg1bkzet4xdhda7s0uajayn7frfbwryl','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-10 08:01:49'),('d24fsifop2c9gezylea01zrggxpnqwid','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-11 08:43:10'),('d2k8vuktrwbsd07vtlsyq88kff53cteo','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:53'),('d5mmm3gskeszn85eh5fu82qwvidgx12v','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 12:58:36'),('dd4fdkdrrna1fykeu0w9o0row2bi7dmd','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 10:22:05'),('dsgfh3r9ystj594picymrx7m6zmfyj23','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 10:35:29'),('ehgf9jt69lrji6yv40x6moylrlsyx9ha','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:28'),('f2cokzl85kk8hyyyehopo1obnipb3gsb','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 07:55:14'),('f3n7loi8pi5zx3pipcfhljatv3i23swo','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-11-10 10:49:44'),('fcb9fivyslh7ye9ta9ravc6hkvcnmwsq','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-23 01:40:42'),('fs6ppd3f3dgpigen0a9u8git4f1kv2d6','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-01 05:19:50'),('fxnyjrxx9vuhh9g06tpup7pu8gaj5s2x','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-10 05:57:35'),('gomka8lwcr7au3yjkibz6ea4vt2c3y75','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-07 06:43:06'),('h8f9ujiprob48g72g3h293qxjbfaci24','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:51'),('hh71zt5kp9nezzr72y03ny3bbd4gqz0a','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-10 07:33:42'),('jv2o247oux7h33h55fmrpivtl0b3dz0z','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-10 07:56:47'),('kuy2wipv5lsibrguo3vxgkgrxj3ota9p','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 08:04:25'),('l1szyqok6h0x1f5v9uxy2nmnmnpzbh0s','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 10:30:18'),('lfyxcs61okazwp84qly4xa6rb83485gc','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-24 09:16:41'),('mepbbd1cv3ssu05ursaqxr6uhf3kfd98','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-10 07:53:42'),('mw9vfgc0bls0wnwtgn6gpbdu6wnau6z2','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-24 06:06:57'),('n9kg0cpqgsigmy322kofs4grltgsdhun','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 12:52:54'),('oadi33ibf65a168yqg5v09q8xf9fgjh4','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 12:13:19'),('pmtcudw8166hngj66f9g99worg8w9tz3','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-01 05:42:16'),('py4r3ues7u9pmickkegax0aef7dkzjql','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 07:54:48'),('qf698pk8f4ycreshch4n43o7n5jggdxa','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:52'),('qjcymikm3adpogk3uuqj354a56h79l1t','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-10 07:31:27'),('s49971v4fih60sjbize424dci4regtm9','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-12-12 07:41:47'),('teos2ciku6plubko32hk12g5d9nlbo8y','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:45'),('u2dbbltsyo4tk4q4hq7qoaaob78zcnbu','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-28 11:55:37'),('u6hnsrnrzwdqrqibh44f1k3ja7qf5d2u','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-11-28 12:03:50'),('vhrhwjy340w1h2u20nxe95uhqaq1m3gr','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-12 11:11:40'),('wr0hmy2p6q7x6lstr9avdsdv8jw5gebg','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-09 13:26:21'),('wyuuc1wr2hkk5f8gpav31nvcmn76rno8','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-09 11:53:01'),('y4bpgphrcdpt06t0713ayjswq7gc8v0c','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 08:08:48'),('ylkhozd805lvq4apqdocmmmojkcuj0qk','MTJjNzJjZGJlZDkzNWNkMGVkNzRlMzM0OTI4NGQ5YzZhMDY4YzQ0Nzp7Il9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6MX0=','2014-12-08 10:19:20'),('zw04zzsab5l1iwjf4ubo5jo3flgev78m','ZjQ2YzRkN2EyZmFjNGIwZmY3NjA1MWM2YTJhZDI2YzQwZDZhMmJhNjp7fQ==','2014-11-09 11:51:33');
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wxxiaohello_blog`
--

DROP TABLE IF EXISTS `wxxiaohello_blog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wxxiaohello_blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` char(45) DEFAULT NULL,
  `content` text,
  `summary` text,
  `time` date DEFAULT NULL,
  `classify_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `release` int(11) DEFAULT '0',
  `type` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `classify` (`classify_id`),
  KEY `time` (`time`),
  CONSTRAINT `classify_blog` FOREIGN KEY (`classify_id`) REFERENCES `wxxiaohello_classify` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wxxiaohello_blog`
--

LOCK TABLES `wxxiaohello_blog` WRITE;
/*!40000 ALTER TABLE `wxxiaohello_blog` DISABLE KEYS */;
INSERT INTO `wxxiaohello_blog` VALUES (33,'测试文章系列1','<p>这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1<br/></p><p><img src=\"http://uploadwxxiaohello-xiaohellostorage.stor.sinaapp.com/ueditor/php/upload/image/20141124/1416819999215483.png\" alt=\"1416819999215483.png\" width=\"200\" height=\"200\" border=\"0\" vspace=\"0\" title=\"1416819999215483.png\" style=\"width: 200px; height: 200px;\"/>frgtgtrgtrg</p><p>uouoiyi</p>','这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1这是一个测试文章测试文章系列1','2014-11-08',6,NULL,1,1),(34,'22222稿草稿草稿草稿22222稿草稿草稿草稿22222稿草稿草稿草稿','<p>222222222222222222222222222222</p><p>o9o9879</p>','2222222222222','2014-11-14',6,NULL,1,0),(37,'ttttt22222稿草稿草稿草稿22222稿草稿草稿草稿22222稿草稿草稿草稿','<p>zidong zidongdflafhdlajfl发的发大水范德萨发大水发大幅度</p><p><em><strong>发大水范德萨发大水</strong></em></p><p><em><strong>发大水范德萨发大水</strong></em></p><p><img src=\"http://uploadwxxiaohello-xiaohellostorage.stor.sinaapp.com/ueditor/php/upload/image/20141125/1416901746746784.png\" alt=\"1416901746746784.png\"/><em><strong><br/></strong></em></p><p>范德萨发大水范德萨发的萨芬哈哈哈和护发素个梵蒂冈的广泛的广泛的过分过分审稿费</p>','zidong zidongdflafhdlajfl发的发大水范德萨发大水发大幅度发大水范德萨发大水发大水范德萨发大水范德萨发大水范德萨发的萨芬哈哈哈和护发素个梵蒂冈的广泛的广泛的过分过分审稿费','2014-10-14',1,1,1,1),(39,'草稿草稿草稿草稿草稿草稿草稿草稿草稿22222稿草稿草稿草稿','<p><br/></p><h1 class=\"ue_t\" label=\"Title center\" name=\"tc\" style=\"border-bottom-color:#cccccc;border-bottom-width:2px;border-bottom-style:solid;padding:0px 4px 0px 0px;text-align:center;margin:0px 0px 20px;\"><span style=\"color:#c0504d;\">[键入文档标题]</span></h1><p style=\"text-align:center;\"><strong class=\"ue_t\">[键入文档副标题]</strong></p><h3><span class=\"ue_t\" style=\"font-family:幼圆\">[标题 1]</span></h3><p class=\"ue_t\" style=\"text-indent:2em;\">对于“插入”选项卡上的库，在设计时都充分考虑了其中的项与文档整体外观的协调性。 您可以使用这些库来插入表格、页眉、页脚、列表、封面以及其他文档构建基块。 您创建的图片、图表或关系图也将与当前的文档外观协调一致。</p><h3><span class=\"ue_t\" style=\"font-family:幼圆\">[标题 2]</span></h3><p class=\"ue_t\" style=\"text-indent:2em;\">在“开始”选项卡上，通过从快速样式库中为所选文本选择一种外观，您可以方便地更改文档中所选文本的格式。 您还可以使用“开始”选项卡上的其他控件来直接设置文本格式。大多数控件都允许您选择是使用当前主题外观，还是使用某种直接指定的格式。</p><h3><span class=\"ue_t\" style=\"font-family:幼圆\">[标题 3]</span></h3><p class=\"ue_t\">对于“插入”选项卡上的库，在设计时都充分考虑了其中的项与文档整体外观的协调性。 您可以使用这些库来插入表格、页眉、页脚、列表、封面以及其他文档构建基块。 您创建的图片、图表或关系图也将与当前的文档外观协调一致。</p><pre class=\"brush:java;toolbar:false\">package&nbsp;snooway.ajax;\n\nimport&nbsp;java.util.List;\nimport&nbsp;java.util.Map;\n\nimport&nbsp;com.opensymphony.xwork2.ActionContext;\nimport&nbsp;com.opensymphony.xwork2.ActionSupport;\n\nimport&nbsp;nlp.whu.utils.db.QueryHelper;\nimport&nbsp;security.model.EventNews;\nimport&nbsp;security.model.Follow;\nimport&nbsp;security.model.FollowNews;\nimport&nbsp;security.model.User;\n\npublic&nbsp;class&nbsp;FollowAjaxAction&nbsp;&nbsp;extends&nbsp;AjaxActionBase&nbsp;{\n	int&nbsp;pageId;\n	String&nbsp;type;\n	List&lt;FollowNews&gt;&nbsp;eventNewsList;\n	public&nbsp;String&nbsp;execute()&nbsp;throws&nbsp;Exception&nbsp;{\n		System.out.print(&quot;follw&nbsp;a&nbsp;&quot;);\n		if(type==null){\n			String&nbsp;sql&nbsp;=&nbsp;&quot;select&nbsp;wdyq_eventnews_all.*&nbsp;from&nbsp;wdyq_eventnews_all,&nbsp;follow&nbsp;where&nbsp;follow.userId&nbsp;=&nbsp;?&nbsp;&nbsp;and&nbsp;wdyq_eventnews_all.pageId&nbsp;=&nbsp;follow.pageId&nbsp;order&nbsp;by&nbsp;wdyq_eventnews_all.pageId&nbsp;desc&quot;;\n			eventNewsList&nbsp;=&nbsp;QueryHelper.query(FollowNews.class,&nbsp;sql,&nbsp;getUserId());\n			net.sf.json.JSONArray&nbsp;jsonArray&nbsp;=&nbsp;net.sf.json.JSONArray.fromObject(eventNewsList);\n			writeSuccess(jsonArray);\n		//	return&nbsp;super.execute();\n			\n		}else&nbsp;if&nbsp;(type.equals(&quot;follow&quot;)){\n			String&nbsp;sql&nbsp;=&quot;insert&nbsp;into&nbsp;follow(userid,pageid)values(?,?)&quot;;\n			QueryHelper.update(sql,&nbsp;getUserId(),pageId);\n			writeSuccess(&quot;0&quot;);\n			\n		}else&nbsp;if(type.equals(&quot;cancel&quot;)){\n			String&nbsp;sql&nbsp;=&nbsp;&quot;delete&nbsp;from&nbsp;follow&nbsp;where&nbsp;userId&nbsp;=&nbsp;?&nbsp;and&nbsp;pageId&nbsp;=&nbsp;?&quot;;\n			QueryHelper.update(sql,&nbsp;getUserId(),pageId);\n			writeSuccess(&quot;0&quot;);\n		}else{\n			String&nbsp;sql&nbsp;=&nbsp;&quot;select&nbsp;wdyq_eventnews_all.*&nbsp;from&nbsp;wdyq_eventnews_all,&nbsp;follow&nbsp;where&nbsp;follow.userId&nbsp;=&nbsp;?&nbsp;&nbsp;and&nbsp;wdyq_eventnews_all.pageId&nbsp;=&nbsp;follow.pageId&nbsp;order&nbsp;by&nbsp;wdyq_eventnews_all.pageId&nbsp;desc&quot;;\n			eventNewsList&nbsp;=&nbsp;QueryHelper.query(FollowNews.class,&nbsp;sql,&nbsp;getUserId());\n			return&nbsp;super.execute();\n		}\n		\n		return&nbsp;null;\n	}\n\n	public&nbsp;int&nbsp;getPageId()&nbsp;{\n		return&nbsp;pageId;\n	}\n	public&nbsp;void&nbsp;setPageId(int&nbsp;pageId)&nbsp;{\n		this.pageId&nbsp;=&nbsp;pageId;\n	}\n	public&nbsp;String&nbsp;getType()&nbsp;{\n		return&nbsp;type;\n	}\n	public&nbsp;void&nbsp;setType(String&nbsp;type)&nbsp;{\n		this.type&nbsp;=&nbsp;type;\n	}\n\n	public&nbsp;int&nbsp;getUserId(){\n		Map&nbsp;session&nbsp;=&nbsp;(Map)&nbsp;ActionContext.getContext().get(&quot;session&quot;);\n		User&nbsp;user&nbsp;=&nbsp;(User)&nbsp;session.get(&quot;userEntity&quot;);\n		String&nbsp;roletype&nbsp;=&nbsp;user.getRoletype(&nbsp;);\n		return&nbsp;user.getId();\n&nbsp;	}\n\n}</pre><p><br/></p>','草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿草稿','2014-11-14',1,1,1,0),(47,'自动摘要','<p>自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要</p>','自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘','2014-09-25',4,1,1,1),(48,'测试测试hello测试测试hello测试测试hello','<p>测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello</p>','测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hello测试测试hel','2014-11-28',1,1,1,1);
/*!40000 ALTER TABLE `wxxiaohello_blog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wxxiaohello_blog_tag`
--

DROP TABLE IF EXISTS `wxxiaohello_blog_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wxxiaohello_blog_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) DEFAULT NULL,
  `tag_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id_idx` (`blog_id`),
  KEY `tag_id_idx` (`tag_id`),
  CONSTRAINT `blog_id` FOREIGN KEY (`blog_id`) REFERENCES `wxxiaohello_blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tag_id` FOREIGN KEY (`tag_id`) REFERENCES `wxxiaohello_tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wxxiaohello_blog_tag`
--

LOCK TABLES `wxxiaohello_blog_tag` WRITE;
/*!40000 ALTER TABLE `wxxiaohello_blog_tag` DISABLE KEYS */;
INSERT INTO `wxxiaohello_blog_tag` VALUES (22,37,16),(23,34,11),(24,34,12),(25,33,8),(26,33,9),(27,33,10),(30,39,18),(31,39,17),(32,37,18),(42,47,26),(43,48,8),(44,48,1);
/*!40000 ALTER TABLE `wxxiaohello_blog_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wxxiaohello_classify`
--

DROP TABLE IF EXISTS `wxxiaohello_classify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wxxiaohello_classify` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Content` varchar(45) 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 `wxxiaohello_classify`
--

LOCK TABLES `wxxiaohello_classify` WRITE;
/*!40000 ALTER TABLE `wxxiaohello_classify` DISABLE KEYS */;
INSERT INTO `wxxiaohello_classify` VALUES (1,'默认'),(4,'测试'),(6,'测试2');
/*!40000 ALTER TABLE `wxxiaohello_classify` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wxxiaohello_comment`
--

DROP TABLE IF EXISTS `wxxiaohello_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wxxiaohello_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `message` text,
  `blog_id` int(11) DEFAULT NULL,
  `time` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wxxiaohello_comment`
--

LOCK TABLES `wxxiaohello_comment` WRITE;
/*!40000 ALTER TABLE `wxxiaohello_comment` DISABLE KEYS */;
INSERT INTO `wxxiaohello_comment` VALUES (17,'fdsfads','','fdsafdasfdsfdsa',39,'2014-11-28'),(18,'222222','','测试哈拉的反垄断送免费陆地上发的身份上房顶上南方的律师费马鼎盛',47,'2014-11-28'),(19,'自动摘要','','自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要自动摘要',47,'2014-11-28'),(20,'Hello','http://www.baidu.com','hello test hello test hahah',48,'2014-12-03');
/*!40000 ALTER TABLE `wxxiaohello_comment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `wxxiaohello_filing`
--

DROP TABLE IF EXISTS `wxxiaohello_filing`;
/*!50001 DROP VIEW IF EXISTS `wxxiaohello_filing`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `wxxiaohello_filing` (
  `id` tinyint NOT NULL,
  `month` tinyint NOT NULL,
  `count` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `wxxiaohello_tag`
--

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

--
-- Dumping data for table `wxxiaohello_tag`
--

LOCK TABLES `wxxiaohello_tag` WRITE;
/*!40000 ALTER TABLE `wxxiaohello_tag` DISABLE KEYS */;
INSERT INTO `wxxiaohello_tag` VALUES (4,''),(27,'1111'),(19,'22'),(11,'2222'),(12,'233'),(13,'333'),(20,'43'),(15,'4444'),(7,'45'),(21,'fdsfsd'),(25,'gfdgdf'),(22,'gg'),(24,'gs'),(1,'hello'),(5,'helloWord'),(14,'rewrew'),(23,'rr'),(9,'test'),(16,'tttt'),(2,'y游戏'),(3,'你好呀'),(6,'可怜'),(8,'测试'),(10,'系列'),(26,'自动摘要'),(18,'草稿'),(17,'草稿草稿');
/*!40000 ALTER TABLE `wxxiaohello_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `wxxiaohello_filing`
--

/*!50001 DROP TABLE IF EXISTS `wxxiaohello_filing`*/;
/*!50001 DROP VIEW IF EXISTS `wxxiaohello_filing`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `wxxiaohello_filing` AS select `wxxiaohello_blog`.`id` AS `id`,date_format(`wxxiaohello_blog`.`time`,'%Y-%m') AS `month`,count(`wxxiaohello_blog`.`id`) AS `count` from `wxxiaohello_blog` group by `month` order by `month` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!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 2014-12-11 11:33:04