easycms
/
easycms.sql

/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.6.24-log : Database - easycms
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 `cfg` */

CREATE TABLE `cfg` (
  `c` int(11) DEFAULT NULL,
  `c1` varchar(100)  DEFAULT NULL,
  `c2` varchar(100)  DEFAULT NULL,
  `c3` varchar(100)  DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  KEY `c` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `cfg` */

insert  into `cfg`(`c`,`c1`,`c2`,`c3`,`seq`) values (1,'c2','文本-100-2','50',2),(1,'c1','文本-100-1','50',1),(1,'c16','文本-n*-16','n',16),(1,'c4','文本-100-4','50',4),(1,'c5','文本-200-5','100',5),(1,'c6','文本-200-6','100',6),(1,'c7','文本-200-7','100',7),(1,'c8','文本-200-8','100',8),(1,'c9','文本-500-9','250',9),(1,'c10','文本-500-10','250',10),(1,'c11','文本-500-11','250',11),(1,'c12','文本-500-12','250',12),(1,'c13','文本-2000-13','1000',13),(1,'c14','文本-2000-14','1000',14),(1,'c15','文本-n*-15','n',15),(1,'c3','文本-100-3','50',3),(2,'data_1','表1',NULL,1),(3,'text','文本',NULL,1),(3,'number','数字',NULL,2),(3,'textarea','文本域',NULL,3),(3,'date','日期',NULL,4),(3,'editor','富文本',NULL,6),(3,'combo','下拉列表',NULL,5);

/*Table structure for table `field` */

CREATE TABLE `field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `subject_id` bigint(20) NOT NULL COMMENT '模型id',
  `name` varchar(200) NOT NULL COMMENT '名称',
  `type` varchar(10) NOT NULL COMMENT '类型',
  `seq` int(11) DEFAULT '0' COMMENT '序号',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `width` int(11) DEFAULT NULL COMMENT '列表显示时宽带',
  `allow_blank` char(1) DEFAULT NULL COMMENT '允许为空',
  `list_show` char(1) DEFAULT NULL COMMENT '列表显示',
  `sql` varchar(500) DEFAULT NULL COMMENT '下拉对应sql',
  `status` int(11) DEFAULT '0' COMMENT '状态',
  `mapping_data` varchar(20) NOT NULL COMMENT '映射字段',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=268 DEFAULT CHARSET=utf8;

/*Data for the table `field` */

insert  into `field`(`id`,`subject_id`,`name`,`type`,`seq`,`remark`,`width`,`allow_blank`,`list_show`,`sql`,`status`,`mapping_data`) values (1,1,'标题','text',1,'标题',200,'0','1',NULL,1,'c1'),(2,1,'内容','editor',5,'',200,'1','0',NULL,1,'c15'),(3,2,'标题','text',1,'标题',200,'0','1',NULL,1,'c1'),(4,2,'内容','editor',5,'',200,'1','0',NULL,1,'c15'),(5,3,'标题','text',1,'标题',200,'0','1',NULL,1,'c1'),(6,3,'内容','editor',5,'',200,'1','0',NULL,1,'c15'),(80,44,'名称','text',1,'标题',200,'0','1',NULL,0,'c1'),(81,44,'介绍1','text',2,'',200,'1','1',NULL,0,'c5'),(100,44,'图片','text',7,'',100,'0','1','',0,'c7'),(262,46,'名称','text',1,'标题',200,'0','1',NULL,0,'c1'),(263,46,'介绍1','text',2,'',200,'1','1',NULL,0,'c5'),(264,46,'图片','text',7,'',100,'0','1','',0,'c7'),(265,47,'名称','text',1,'标题',200,'0','1',NULL,0,'c1'),(266,47,'介绍1','text',2,'',200,'1','1',NULL,0,'c5'),(267,47,'图片','text',7,'',100,'0','1','',0,'c7');

/*Table structure for table `combo` */

CREATE TABLE `combo` (
  `type` int(11) NOT NULL COMMENT '类型',
  `value` varchar(20) NOT NULL COMMENT '值',
  `num` int(11) DEFAULT NULL COMMENT '序号'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `combo` */

insert  into `combo`(`type`,`value`,`num`) values (1,'输入值',2),(1,'花生棒',1),(2,'手机',1),(2,'电脑',2),(1,'花生壳',3);

/*Table structure for table `data_0` */

CREATE TABLE `data_0` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `c1` varchar(100) DEFAULT NULL,
  `c2` varchar(100) DEFAULT NULL,
  `c3` varchar(100) DEFAULT NULL,
  `c4` varchar(100) DEFAULT NULL,
  `c5` varchar(200) DEFAULT NULL,
  `c6` varchar(200) DEFAULT NULL,
  `c7` varchar(200) DEFAULT NULL,
  `c8` varchar(200) DEFAULT NULL,
  `c9` varchar(500) DEFAULT NULL,
  `c10` varchar(500) DEFAULT NULL,
  `c11` varchar(500) DEFAULT NULL,
  `c12` varchar(500) DEFAULT NULL,
  `c13` text,
  `c14` text,
  `c15` longtext,
  `c16` longtext,
  `subject_id` bigint(20) NOT NULL COMMENT '对应模型id',
  `state` int(11) DEFAULT NULL COMMENT '状态，1已发布，0未发布',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人，账号',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `data_0` */

insert  into `data_0`(`id`,`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`,`subject_id`,`state`,`create_time`,`create_by`,`update_time`,`update_by`) values (7,'Macbook, Laptop','290.00','390.00','充足','Apple Macbook Retina 23’’','Duis autem vel eum iriure dolor in hendrerit in vu','assets/images/wk-deal-img.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'44',1,'2017-07-30 18:36:45','admin',NULL,NULL);

/*Table structure for table `data_1` */

CREATE TABLE `data_1` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `c1` varchar(100) DEFAULT NULL,
  `c2` varchar(100) DEFAULT NULL,
  `c3` varchar(100) DEFAULT NULL,
  `c4` varchar(100) DEFAULT NULL,
  `c5` varchar(200) DEFAULT NULL,
  `c6` varchar(200) DEFAULT NULL,
  `c7` varchar(200) DEFAULT NULL,
  `c8` varchar(200) DEFAULT NULL,
  `c9` varchar(500) DEFAULT NULL,
  `c10` varchar(500) DEFAULT NULL,
  `c11` varchar(500) DEFAULT NULL,
  `c12` varchar(500) DEFAULT NULL,
  `c13` text,
  `c14` text,
  `c15` longtext,
  `c16` longtext,
  `subject_id` bigint(20) NOT NULL COMMENT '对应模型id',
  `state` int(11) DEFAULT NULL COMMENT '状态，1已发布，0未发布',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(20) DEFAULT NULL COMMENT '创建人，账号',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(20) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=utf8;

/*Data for the table `data_1` */

insert  into `data_1`(`id`,`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`,`subject_id`,`state`,`create_time`,`create_by`,`update_time`,`update_by`) values (276,'蛋糕6',NULL,NULL,NULL,'美味',NULL,'images/6.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47',1,'2018-04-19 18:50:31','admin','2018-04-19 18:54:26','admin'),(274,'蛋糕4',NULL,NULL,NULL,'脆',NULL,'images/4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'47',1,'2018-04-19 18:48:22','admin','2018-04-19 18:54:39','admin'),(275,'蛋糕5',NULL,NULL,NULL,'香甜',NULL,'images/5.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46',1,'2018-04-19 18:48:39','admin','2018-04-19 18:54:33','admin'),(273,'蛋糕3',NULL,NULL,NULL,'快来买',NULL,'images/3.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'46',1,'2018-04-19 18:48:08','admin','2018-04-19 18:54:53','admin'),(271,'蛋糕1',NULL,NULL,NULL,'美味',NULL,'images/1.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'44',1,'2018-04-19 18:42:01','admin','2018-04-19 18:52:25','admin'),(272,'蛋糕2',NULL,NULL,NULL,'甜',NULL,'images/2.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'44',1,'2018-04-19 18:47:48','admin','2018-04-19 18:52:36','admin');

/*Table structure for table `subject` */

CREATE TABLE `subject` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `table_name` varchar(50) DEFAULT NULL,
  `remark` varchar(400) DEFAULT NULL,
  `leaf` bit(1) DEFAULT NULL,
  `seq` int(11) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `nav` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

/*Data for the table `subject` */

insert  into `subject`(`id`,`name`,`table_name`,`remark`,`leaf`,`seq`,`parent_id`,`nav`) values (1,'咖啡站','data_1','咖啡站栏目配置','\0',10,0,NULL),(2,'52en.me','data_1','我爱英语','\0',20,0,NULL),(3,'首页','data_1','','\0',10,2,NULL),(36,'首页','data_1','','\0',30,1,NULL),(44,'Meun3','data_1','','\0',5,36,NULL),(46,'Meun2','data_1','','\0',5,36,NULL),(47,'Meun1','data_1','','\0',5,36,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;