-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: 192.168.4.39    Database: mall
-- ------------------------------------------------------
-- Server version	5.6.26-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 `album`
--

DROP TABLE IF EXISTS `album`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `album` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_title` varchar(10) NOT NULL COMMENT '主标题',
  `half_title` varchar(30) NOT NULL COMMENT '副标题',
  `image` varchar(100) NOT NULL COMMENT '图片',
  `url` varchar(500) NOT NULL COMMENT 'url链接',
  `sort` int(10) unsigned NOT NULL COMMENT '排序',
  `hide` tinyint(1) unsigned NOT NULL COMMENT '是否隐藏',
  `deleted` tinyint(1) NOT NULL COMMENT '是否删除',
  `created_time` datetime NOT NULL COMMENT '创建时间s',
  `defaulted` bit(1) NOT NULL DEFAULT b'0',
  `template_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='专辑';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `album`
--

/*!40000 ALTER TABLE `album` DISABLE KEYS */;
INSERT INTO `album` VALUES (3,'涨姿势|送礼清单','礼来了，TA还会远么？','FvP7U3-s8vArQr72ELACuuSvIiQK','http://activity.xyqb.com/activity/594c89d14bd5be4aea76978e',9,1,0,'2017-06-26 14:59:21','\0','精选专辑-- 秋季养生帖'),(4,'这些理由，供你换新机','万事俱备，只欠一个理由。','Fnv0aI-uSiFKqJQsqRmjS2Kh53r_','http://activity.xyqb.com/activity/594cd16e4bd5be4aea7697d4',8,0,0,'2017-06-26 15:04:14','\0','精选专辑-- 秋季养生帖'),(5,'上得厅堂，下得厨房','生活不只有诗和远方，还有人间烟火~','Fo81Lg2_Oh8wm5Kc0XGpI_PKPmux','http://activity.xyqb.com/activity/58e743a7d01c4b689466d782',6,1,0,'2017-06-26 15:04:48','\0','精选专辑-- 秋季养生帖'),(6,'烈焰红唇，百变女神','不是谁都可以做一只狐狸精','FvhKbncjhccVkzf1eJ_-QZeVPBm1','http://activity.xyqb.com/activity/5900797db20aa04301fbd6d5',5,1,0,'2017-06-26 15:05:18','\0','精选专辑-- 秋季养生帖'),(7,'辨货识型男','变帅不过如此','Fk91OkupZ-LeI5rtMM0KYpVn1oUj','http://activity.xyqb.com/activity/594cd11c4bd5be4aea7697cb',4,1,0,'2017-06-26 15:05:50','\0','精选专辑-- 秋季养生帖'),(8,'减的你心，美的我心','每一个故事里 都有一个胖子，希望不是你','FrOrH-80GhBIdZCso7bdSaMkJ1SX','http://activity.xyqb.com/activity/594c821c4bd5be4aea769781',3,1,0,'2017-06-26 15:06:29','\0','精选专辑-- 秋季养生帖'),(9,'毕业游 带你走','毕业旅行，这些必备你带上了吗？','FjBmnC4-cJ8h2Kbz93b_JxjaRUHx','https://activity.xyqb.com/activity/5966e16eb406a12b1b7c2b88',10,1,0,'2017-07-13 11:14:35','\0','精选专辑-- 秋季养生帖'),(11,'闻香识女/男神','酷热炎夏，穿香是一种美德。','FmYIjxawoS39o6L_tleMsdnl2Yg_','https://activity.xyqb.com/activity/596c305fb406a12b1b7c2bb5',7,1,0,'2017-07-17 11:44:36','\0','精选专辑-- 秋季养生帖'),(13,'我们白着呢','和夏日骄阳谈场恋爱吧','FgpQG_oFhOlRT2YfSXDkEW511ONt','https://activity.xyqb.com/activity/596f2e7660c849736369e958',11,1,0,'2017-07-19 18:45:19','\0','精选专辑-- 秋季养生帖'),(15,'世界那么大阴天再去看','有了它，宅在家也不怕闷啦！','Fn9VM29S1SFfKSZKsfyubHmpiv2N','https://activity.xyqb.com/activity/5975bd4760c849736369e997',12,1,0,'2017-07-24 17:39:21','\0','精选专辑-- 秋季养生帖'),(17,'我有美食，你有故事','不念过去，不畏将来','FpQ5wCA7s4LwdTWdJW045XaHAi-V','https://activity.xyqb.com/activity/59780e1860c849736369e9be',13,0,0,'2017-07-27 10:24:52','\0','精选专辑-- 秋季养生帖'),(19,'小家电 大用途','懒乃是科技进步的重要动力','FspoTGYNfSAdZ0o-jkmAPGp6nG0_','https://activity.xyqb.com/activity/597b1bd7b406a12b1b7c2c2e',14,0,0,'2017-07-28 19:18:46','\0','精选专辑-- 秋季养生帖'),(21,'hey 一起运动呗','装备都给你选好了 赶紧行动起来！','FufUX1g2mpurwM2UjbKJ6Myur0AS','https://activity.xyqb.com/activity/5983ef265d158d18498d65cb',16,0,0,'2017-08-04 14:28:21','\0','精选专辑-- 秋季养生帖'),(23,'戏已落幕，人生继续','从这里，开始后半生的蜕变！','Fsc9FtYXPXE46OMrEOvJR5Ns5I_V','https://activity.xyqb.com/activity/5987fc9f808ad24d984a5e34',15,1,0,'2017-08-07 14:08:18','\0','精选专辑-- 秋季养生帖'),(25,'男生送礼清单','开不了口的时候礼物会说话','FpUNhvuAzVtMOr22U6QVY5BExCFU','https://activity.xyqb.com/activity/598bc45d195c4f0486d7b3be',17,1,0,'2017-08-10 11:22:59','\0','精选专辑-- 秋季养生帖'),(27,'女生送礼清单','他收到礼物的样子 真可爱','Fpz1TMltOd-XVKDW2imxkl8medCn','https://activity.xyqb.com/activity/5991157c195c4f0486d7b408',18,1,0,'2017-08-14 11:18:33','\0','精选专辑-- 秋季养生帖'),(29,'浓妆艳抹 不如伪素颜','就想每天还你一点点','FopMDzog6BZ2nD1hHW5pK4HqEhFj','https://activity.xyqb.com/activity/59940e4d8074f7047f357a2f',20,0,0,'2017-08-17 11:04:56','\0','精选专辑-- 秋季养生帖'),(31,'秋季出游 随行必备','如画江山，一路与你箱伴而行','FoAvPdFS5aktCrcHtnJiAKY5YAwt','https://activity.xyqb.com/activity/599a5c6d195c4f0486d7b5c8',19,1,0,'2017-08-21 14:50:02','\0','精选专辑-- 秋季养生帖'),(33,'租房生活不将就','简单四招，打造租房也该有的幸福感','Fgsut9V77x1IBxHpsOwx5xgOzVUY','https://activity.xyqb.com/activity/599c051b195c4f0486d7b6ed',21,0,0,'2017-08-24 10:11:41','\0','精选专辑-- 秋季养生帖'),(35,'好厨艺 show出来','做饭小能手 这些必须有~！','Fvhb94F14myiOt4sqCkYf5Ojg3hP','https://activity.xyqb.com/activity/599e9777195c4f0486d7b944',22,0,0,'2017-08-24 17:12:29','\0','精选专辑-- 秋季养生帖'),(37,'一起拍照吧！','你说你不美？不！你只是少了它！','FlIdCMTkcGz8YO89Aoz-7kLO9vQ8','https://activity.xyqb.com/activity/59a68db7f70cff7a37fed836',23,0,0,'2017-08-31 10:27:24','\0','精选专辑-- 秋季养生帖'),(39,'我想和你谈场恋爱','哎呀，好撩人啊~','FsCCLO1ngIvl6amwaUWgrP2TOEBg','https://activity.xyqb.com/activity/59accebd8d846538e5939084',24,0,0,'2017-09-04 14:09:31','\0','精选专辑-- 秋季养生帖'),(41,'教师节快乐','师恩难忘，礼重情深','FrZDc2Oa8XCS7f8p2yGcbokL1m1e','https://activity.xyqb.com/activity/59b210c6f70cff7a37fedad6',25,1,0,'2017-09-08 15:18:17','\0','精选专辑-- 秋季养生帖'),(43,'全民一起来健身','能看懂的，妥妥的老司机！','FhhNrdUAGZ2mtdJVV3Uv38hl-lxh','https://activity.xyqb.com/activity/59b89fddf70cff7a37fedb9a',26,0,0,'2017-09-14 10:22:59','\0','精选专辑-- 秋季养生帖'),(45,'TA比Siri更懂你','用最懂你的方式，探索属于自己的激情','FtDlv_JNUGhMWLrKJZEU1sad2sgJ','https://activity.xyqb.com/activity/59c085e6184d885c4b5928b1',27,0,0,'2017-09-19 11:17:28','\0','精选专辑-- 秋季养生帖'),(47,'秋日护肤水当当','做自己的完美情人','Fg6G_Dwcunqd53I1GcGe-j9lhvMB','https://activity.xyqb.com/activity/59c32232c0883151901ecdb0',29,0,0,'2017-09-21 11:00:24','\0','精选专辑-- 秋季养生帖'),(49,'谁的玩物最值钱','一起来了解12星座的怪癖吧','FgmxX-Utvb_6W_ZcAT_Kxva0Fmfa','https://activity.xyqb.com/activity/59a3cf34195c4f0486d7ba24',28,0,0,'2017-09-21 11:17:02','\0','精选专辑-- 秋季养生帖'),(51,'实用篇|秋季养生秘籍','身体不好怎么相约一起运动~','FgCYvJdBBps8OlQMY8Cyq6mP8Qbm','https://activity.xyqb.com/activity/59cc923c80cd600c425831c4',30,0,0,'2017-09-28 14:22:34','','精选专辑-- 秋季养生帖');
/*!40000 ALTER TABLE `album` ENABLE KEYS */;
/*!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-10-20 21:01:23
