schema.sql.php

<?php
$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_domain` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `is_default` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否是默认域名',
    `is_https` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否启用HTTPS',
    `expire` INT NOT NULL DEFAULT 0 COMMENT '默认缓存时间',
    `domain` VARCHAR(64) NOT NULL COMMENT '域名',
    `theme` VARCHAR(32) NOT NULL DEFAULT 'default' COMMENT '模板目录',
    `tpl` VARCHAR(64) NULL COMMENT '主页模板',
	`title` VARCHAR(128) NULL COMMENT '网站标题',
	`name` VARCHAR(32) NULL COMMENT '网站名称',
	`keywords` VARCHAR(256) NULL COMMENT '网站关键词',
	`description` VARCHAR(512) NULL COMMENT '网站描述',
	`offline` TINYINT NOT NULL DEFAULT 1 COMMENT '网站离线',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `UDX_DOMAIN` (`domain` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='站点域名配置'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_model` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `refid` VARCHAR(16) NOT NULL COMMENT '模型标识',
    `name` VARCHAR(32) NOT NULL COMMENT '模型名称',
    `hidden` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '不可编辑',
    `creatable` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否可以创建页面',
    `flags` VARCHAR(128) NULL COMMENT '自定义标志',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `UDX_REFID` (`refid` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='模型'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_channel_model` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `page_id` INT UNSIGNED NOT NULL COMMENT '栏目ID',
    `model` INT NOT NULL COMMENT '模型ID',
    `enabled` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否启用',
    `url_pattern` TEXT NULL COMMENT 'URL生成规则',
    `template_file` VARCHAR(128) NULL COMMENT '页面模板文件',
    `template_file2` VARCHAR(128) NULL COMMENT '页面模板文件2(用于分页)',
    PRIMARY KEY (`id`),
    INDEX `IDX_PAGE_ID` (`page_id` ASC),
    INDEX `IDX_MODEL` (`model` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='栏目里可以发放的模型配置'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_model_field` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `model` INT NOT NULL COMMENT '模型编号',
    `label` VARCHAR(32) NOT NULL COMMENT '名称',
    `name` VARCHAR(16) NOT NULL COMMENT '字段名',
    `field` VARCHAR(128) NOT NULL COMMENT '类型',
    `layout` VARCHAR(128) NULL COMMENT '布局',
    `fieldCfg` TEXT NULL COMMENT '字段配置',
    `dataSource` VARCHAR(128) NULL COMMENT '数据源',
    `dsCfg` TEXT NULL COMMENT '数据源配置',
    `note` VARCHAR(64) NULL COMMENT '提示',
    `index` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否索引',
    `unique` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否是唯一索引',
    `required` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否必须提供',
    `type` VARCHAR(8) NOT NULL DEFAULT 'varchar' COMMENT '类型',
    `length` SMALLINT UNSIGNED NOT NULL DEFAULT 128 COMMENT '长度',
    `default` VARCHAR(128) NULL COMMENT '默认值',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `UDX_M_NAME` (`model` ASC , `name` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='模型字段'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_router` (
    `id` INT UNSIGNED NOT NULL COMMENT '页面编号',
    `route` CHAR(32) NOT NULL COMMENT 'URL的MD5',
    PRIMARY KEY (`id`),
    UNIQUE INDEX `UDX_ROUTE` (`route` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='CMS路由表'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_page` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `create_time` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
    `create_uid` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建用户',
    `model` INT NOT NULL COMMENT '模型',
    `status` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0草稿1发布2删除',
    `origin_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '放入回收站之前的状态',
    `noindex` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '阻止被索引',
    `ver` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '当前版本',
    `expire` INT NOT NULL DEFAULT 0 COMMENT '-1不缓存0系统配置，其它值为自定义缓存',
    `path` VARCHAR(64) NOT NULL COMMENT '路径',
    `url` VARCHAR(256) NULL COMMENT 'URL',
    PRIMARY KEY (`id`),
    INDEX `IDX_MODEL` (`model` ASC),
    INDEX `IDEX_CREATETIME` (`create_time` ASC),
    INDEX `UDX_PATH` (`path` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='cms页面'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_page_field` (
    `page_id` INT UNSIGNED NOT NULL COMMENT '页面编号',
    `update_time` INT UNSIGNED NOT NULL COMMENT '修改时间',
    `update_uid` INT UNSIGNED NOT NULL COMMENT '作者',
    `channel` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '栏目',
    `model` INT NOT NULL COMMENT '模型',
    `status` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0草稿1发布2删除',
    `path` VARCHAR(64) NOT NULL COMMENT '虚拟路径',
    `title` VARCHAR(96) NULL COMMENT '标题',
    `title2` VARCHAR(64) NULL COMMENT '短标题',
    `template_file` VARCHAR(128) NULL COMMENT '模板文件',
    `content_file` VARCHAR(128) NULL COMMENT '内容文件地址',
    `author` VARCHAR(32) NULL COMMENT '作者',
    `source` VARCHAR(32) NULL COMMENT '来源',
    `tags` VARCHAR(128) NULL COMMENT '标签,逗号分隔',
    `flags` VARCHAR(128) NULL COMMENT '标志,逗号分隔',
    `keywords` VARCHAR(128) NULL COMMENT '关键词',
    `description` VARCHAR(256) NULL COMMENT '描述',
    `image` VARCHAR(512) NULL COMMENT '插图',
    `image1` VARCHAR(512) NULL COMMENT '插图1',
    `image2` VARCHAR(512) NULL COMMENT '插图2',
    `related_pages` TEXT NULL COMMENT '相关页面',
    `publisher` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布人',
    `publish_time` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布时间',
    `view` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '浏览次数',
    `cmts` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论次数',
    `dig` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '顶次数',
    `dig1` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '踩次数',
    PRIMARY KEY (`page_id`),
    INDEX `IDX_TIME` (`update_time` ASC),
    INDEX `IDX_PUB_TIME` (`publish_time` ASC),
    INDEX `IDX_MODEL` (`model` ASC,`status` ASC),
    INDEX `IDX_CH_MODEL` (`channel` ASC,`model` ASC,`status` ASC),
    INDEX `IDX_PATH_M` (`path` ASC,`model` ASC, `status` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='cms页面字段'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_page_tag` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `page_id` INT UNSIGNED NOT NULL COMMENT '页面编号',
    `tag` VARCHAR(16) NOT NULL COMMENT '标签',
    PRIMARY KEY (`id`),
    INDEX `IDX_PAGEID` (`page_id` ASC),
    INDEX `IDX_TAG` (`tag` ASC )
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='标签页，发布时同步'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_page_flag` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `page_id` INT UNSIGNED NOT NULL,
    `flag` VARCHAR(16) NOT NULL,
    PRIMARY KEY (`id`),
    INDEX `IDX_SMF` (`flag` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='页面标志，发布时同步过来'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_page_rev` (
    `page_id` INT UNSIGNED NOT NULL COMMENT '页面编号',
    `ver` INT UNSIGNED NOT NULL COMMENT '版本号',
    `update_time` INT UNSIGNED NOT NULL DEFAULT 0,
    `update_uid` INT UNSIGNED NOT NULL,
    `channel` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '栏目',
    `model` INT NOT NULL COMMENT '模型',
    `path` VARCHAR(64) NOT NULL COMMENT '虚拟路径',
    `title` VARCHAR(96) NULL COMMENT '标题',
    `title2` VARCHAR(64) NULL COMMENT '短标题',
    `template_file` VARCHAR(128) NULL COMMENT '模板文件',
    `content_file` VARCHAR(128) NULL COMMENT '内容文件地址',
    `author` VARCHAR(32) NULL COMMENT '作者',
    `source` VARCHAR(32) NULL COMMENT '来源',
    `tags` VARCHAR(128) NULL COMMENT '标签,逗号分隔',
    `flags` VARCHAR(128) NULL COMMENT '标志,逗号分隔',
    `keywords` VARCHAR(128) NULL COMMENT '关键词',
    `description` VARCHAR(256) NULL COMMENT '描述',
    `image` VARCHAR(512) NULL COMMENT '插图',
    `related_pages` TEXT NULL COMMENT '相关页面',
    `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态,0草稿，1：待审核，2：未通过，3：通过(已发布)',
    `ip` VARCHAR(64) NOT NULL COMMENT '操作时使用的IP地址', 
    `data_file` VARCHAR(128) NULL COMMENT '数据文件',
    `publisher` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布人',
    `publish_time` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布时间',
    `msg` TEXT NULL COMMENT '审核不通行原因',
    PRIMARY KEY (`page_id` , `ver`),
    INDEX IDX_CH_CM (`channel`,`model`)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='页面版本'";

$tables['1.0.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_channel` (
    `page_id` INT UNSIGNED NOT NULL COMMENT '页面ID',
    `display_sort` SMALLINT UNSIGNED NOT NULL DEFAULT 999 COMMENT '显示排序',
    `store_path` VARCHAR(15) NOT NULL COMMENT '页面文件存储路径',
    PRIMARY KEY (`page_id`)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='栏目'";

$tables['1.0.0'][] = "INSERT INTO `{prefix}cms_model` (`id`,`refid`,`name`,`flags`,`hidden`,`creatable`) VALUES (2,'dynamic','动态模板页',null,1,1), (1,'catagory','栏目',null,1,1),(3,'static','静态模板页',null,1,1), (4,'article','普通文章','头条,推荐,特荐,置顶,跳转',0,1)";

//添加区块功能
$tables['1.1.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_block` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `page` VARCHAR(16) NOT NULL COMMENT '区块所在页面',
    `name` VARCHAR(32) NOT NULL COMMENT '区块名称',
    `create_time` INT UNSIGNED NOT NULL DEFAULT 0,
    `create_uid` INT UNSIGNED NOT NULL DEFAULT 0,
    `update_time` INT UNSIGNED NOT NULL DEFAULT 0,
    `update_uid` INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `UDX_PN` (`name` ASC , `page` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='页面区块'";

$tables['1.1.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_block_item` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `block_id` INT UNSIGNED NOT NULL COMMENT '所在区块',
    `pn` VARCHAR(49) NOT NULL COMMENT '区块名称',
    `title` VARCHAR(64) NULL COMMENT '标题',
    `title2` VARCHAR(64) NULL COMMENT '副标题',
    `url` VARCHAR(256) NULL COMMENT '链接地址',
    `image` VARCHAR(256) NULL COMMENT '图片1',
    `image1` VARCHAR(256) NULL COMMENT '图片2',
    `image2` VARCHAR(256) NULL COMMENT '图片3',
    `sort` SMALLINT UNSIGNED NOT NULL DEFAULT 999 COMMENT '排序',
    `page_id` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT '绑定的页面',
    `num` INT NOT NULL DEFAULT 0 COMMENT '任意数1',
    `num1` INT NOT NULL DEFAULT 0 COMMENT '任意数2',
    `num2` INT NOT NULL DEFAULT 0 COMMENT '任意数3',
    `desc` VARCHAR(256) NULL COMMENT '说明',
    `create_time` INT UNSIGNED NOT NULL DEFAULT 0,
    `create_uid` INT UNSIGNED NOT NULL DEFAULT 0,
    `update_time` INT UNSIGNED NOT NULL DEFAULT 0,
    `update_uid` INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (`id`),
    INDEX `FK_BLOCKID` (`block_id` ASC),
    INDEX `UDX_PN` (`pn` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='区块内容'";

$tables ['1.2.0'] [] = "CREATE TABLE `{prefix}cms_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `create_time` int(10) unsigned NOT NULL,
  `create_uid` int(10) unsigned NOT NULL,
  `update_time` int(10) unsigned NOT NULL,
  `update_uid` int(10) unsigned NOT NULL,
  `sort` int(10) unsigned NOT NULL DEFAULT 1,
  `tag` varchar(16) NOT NULL COMMENT '标签',
  `title` varchar(1024) NOT NULL COMMENT '标题',
  `url` varchar(1024) NOT NULL COMMENT 'url',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UDX_TAG` (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET={encoding} COMMENT='内链标签库'";

$tables['1.2.1'][] = "ALTER TABLE {prefix}`cms_block` 
ADD COLUMN `pn` VARCHAR(49) NULL COMMENT '区块引用ID' AFTER `name`";

$tables['1.2.1'][] = "UPDATE {prefix}`cms_block` SET `pn` = CONCAT(`page`,':',`name`)";

$tables['1.3.0'][] = "CREATE TABLE IF NOT EXISTS `{prefix}cms_cache` (
    `page_id` INT UNSIGNED NOT NULL COMMENT '页面ID',
    `cid` CHAR(32) NOT NULL COMMENT '缓存KEY',
    UNIQUE INDEX `UDX_PID_CID` (`page_id` ASC , `cid` ASC)
)  ENGINE=INNODB DEFAULT CHARACTER SET={encoding} COMMENT='缓存表'";