BESCMS/dayrui/App/Cms/Config/SysTable.php

<?php
/**
 * 本文件是框架系统文件，二次开发时不可以修改本文件
 **/

/**
 * 系统模块表（规范化 Schema：fields / indexes / comment）
 * Module 安装时走 Table::create_table → 驱动 createTable
 */

return [

    '_draft' => [
        'comment' => '内容草稿表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',
            'cid' => 'int(10) unsigned NOT NULL COMMENT \'内容id\'',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
            'content' => 'mediumtext NOT NULL COMMENT \'具体内容\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'录入时间\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `cid` (`cid`)',
            'KEY `catid` (`catid`)',
            'KEY `inputtime` (`inputtime`)',
        ],
    ],

    '_verify' => [
        'comment' => '内容审核表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'vid' => 'tinyint(2) NOT NULL COMMENT \'审核id号\'',
            'isnew' => 'tinyint(1) unsigned NOT NULL COMMENT \'0修改1新增2删除\'',
            'islock' => 'tinyint(1) unsigned NOT NULL COMMENT \'是否锁定\'',
            'author' => 'varchar(50) NOT NULL COMMENT \'作者\'',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
            'status' => 'tinyint(2) NOT NULL COMMENT \'审核状态\'',
            'content' => 'mediumtext NOT NULL COMMENT \'具体内容\'',
            'backuid' => 'mediumint(8) unsigned NOT NULL COMMENT \'操作人uid\'',
            'backinfo' => 'text NOT NULL COMMENT \'操作退回信息\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'录入时间\'',
        ],
        'indexes' => [
            'UNIQUE KEY `id` (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `vid` (`vid`)',
            'KEY `catid` (`catid`)',
            'KEY `status` (`status`)',
            'KEY `inputtime` (`inputtime`)',
            'KEY `backuid` (`backuid`)',
        ],
    ],

    '_hits' => [
        'comment' => '时段点击量统计',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL COMMENT \'文章id\'',
            'hits' => 'int(10) unsigned NOT NULL COMMENT \'总点击数\'',
            'day_hits' => 'int(10) unsigned NOT NULL COMMENT \'本日点击\'',
            'week_hits' => 'int(10) unsigned NOT NULL COMMENT \'本周点击\'',
            'month_hits' => 'int(10) unsigned NOT NULL COMMENT \'本月点击\'',
            'year_hits' => 'int(10) unsigned NOT NULL COMMENT \'年点击量\'',
            'day_time' => 'int(10) unsigned NOT NULL COMMENT \'本日\'',
            'week_time' => 'int(10) unsigned NOT NULL COMMENT \'本周\'',
            'month_time' => 'int(10) unsigned NOT NULL COMMENT \'本月\'',
            'year_time' => 'int(10) unsigned NOT NULL COMMENT \'年\'',
        ],
        'indexes' => [
            'UNIQUE KEY `id` (`id`)',
            'KEY `day_hits` (`day_hits`)',
            'KEY `week_hits` (`week_hits`)',
            'KEY `month_hits` (`month_hits`)',
            'KEY `year_hits` (`year_hits`)',
        ],
    ],

    '_index' => [
        'comment' => '内容索引表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
            'status' => 'tinyint(2) NOT NULL COMMENT \'审核状态\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'录入时间\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `catid` (`catid`)',
            'KEY `status` (`status`)',
            'KEY `inputtime` (`inputtime`)',
        ],
    ],

    '_category' => [
        'comment' => '栏目表',
        'fields' => [
            'id' => 'mediumint(8) unsigned NOT NULL AUTO_INCREMENT',
            'pid' => 'mediumint(8) unsigned NOT NULL DEFAULT \'0\' COMMENT \'上级id\'',
            'pids' => 'varchar(255) NOT NULL COMMENT \'所有上级id\'',
            'name' => 'varchar(255) NOT NULL COMMENT \'栏目名称\'',
            'dirname' => 'varchar(255) NOT NULL COMMENT \'栏目目录\'',
            'pdirname' => 'varchar(255) NOT NULL COMMENT \'上级目录\'',
            'child' => 'tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'是否有下级\'',
            'disabled' => 'tinyint(1) unsigned NOT NULL DEFAULT \'0\' COMMENT \'是否禁用\'',
            'ismain' => 'tinyint(1) unsigned NOT NULL DEFAULT \'1\' COMMENT \'是否主栏目\'',
            'childids' => 'text NOT NULL COMMENT \'下级所有id\'',
            'thumb' => 'varchar(255) NOT NULL COMMENT \'栏目图片\'',
            'show' => 'tinyint(1) unsigned NOT NULL DEFAULT \'1\' COMMENT \'是否显示\'',
            'setting' => 'mediumtext NOT NULL COMMENT \'属性配置\'',
            'displayorder' => 'mediumint(8) NOT NULL DEFAULT \'0\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `show` (`show`)',
            'KEY `disabled` (`disabled`)',
            'KEY `ismain` (`ismain`)',
            'KEY `module` (`pid`,`displayorder`,`id`)',
        ],
    ],

    '_category_data' => [
        'comment' => '栏目模型表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'int(3) unsigned NOT NULL COMMENT \'栏目id\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `catid` (`catid`)',
        ],
    ],

    '_flag' => [
        'comment' => '标记表',
        'fields' => [
            'flag' => 'tinyint(2) unsigned NOT NULL DEFAULT \'1\' COMMENT \'文档标记id\'',
            'id' => 'int(10) unsigned NOT NULL COMMENT \'文档内容id\'',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
        ],
        'indexes' => [
            'KEY `flag` (`flag`,`id`,`uid`)',
            'KEY `catid` (`catid`)',
        ],
    ],

    '_search' => [
        'comment' => '搜索表',
        'fields' => [
            'id' => 'varchar(32) NOT NULL',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
            'params' => 'text NOT NULL COMMENT \'参数数组\'',
            'keyword' => 'varchar(255) NOT NULL COMMENT \'关键字\'',
            'contentid' => 'int(10) unsigned NOT NULL COMMENT \'字段改成了结果数量值\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'搜索时间\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'UNIQUE KEY `id` (`id`)',
            'KEY `catid` (`catid`)',
            'KEY `keyword` (`keyword`)',
            'KEY `inputtime` (`inputtime`)',
        ],
    ],

    '_recycle' => [
        'comment' => '内容回收站表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',
            'cid' => 'int(10) unsigned NOT NULL COMMENT \'内容id\'',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'tinyint(3) unsigned NOT NULL COMMENT \'栏目id\'',
            'content' => 'mediumtext NOT NULL COMMENT \'具体内容\'',
            'result' => 'text NOT NULL COMMENT \'删除理由\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'录入时间\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `cid` (`cid`)',
            'KEY `catid` (`catid`)',
            'KEY `inputtime` (`inputtime`)',
        ],
    ],

    '_time' => [
        'comment' => '内容定时发布表',
        'fields' => [
            'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',
            'uid' => 'mediumint(8) unsigned NOT NULL COMMENT \'作者uid\'',
            'catid' => 'mediumint(8) unsigned NOT NULL COMMENT \'栏目id\'',
            'content' => 'mediumtext NOT NULL COMMENT \'具体内容\'',
            'result' => 'text NOT NULL COMMENT \'处理结果\'',
            'error' => 'tinyint(1) unsigned NOT NULL COMMENT \'是否错误\'',
            'posttime' => 'int(10) unsigned NOT NULL COMMENT \'定时发布时间\'',
            'inputtime' => 'int(10) unsigned NOT NULL COMMENT \'录入时间\'',
        ],
        'indexes' => [
            'PRIMARY KEY (`id`)',
            'KEY `uid` (`uid`)',
            'KEY `catid` (`catid`)',
            'KEY `error` (`error`)',
            'KEY `posttime` (`posttime`)',
            'KEY `inputtime` (`inputtime`)',
        ],
    ],

];