8月18日(周六)成都源创会火热报名中,四位一线行业大牛与你面对面,探讨区块链技术热潮下的冷思考。
Watch Star Fork

sid_jiang / easycmsJavaLGPL-3.0

加入码云
与超过 300 万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
jQuery,jqGrid,jsp,servlet ,guice, mybatis,thymeleaf , 5张表,最简约但不简单的Java cms系统 http://www.j4cms.com
一键复制 编辑 原始数据 按行查看 历史
easycms.sql 8.54 KB jiang 提交于 2018-04-26 08:44 . 1修改类名,2增加通用方法
/*
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 */;

评论 ( 0 )

你可以在登录后,发表评论