-- ----------------------------- -- 导出时间 `2016-12-13 22:26:46` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_advert` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_advert`; CREATE TABLE `dp_cms_advert` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `typeid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类id', `tagname` varchar(30) NOT NULL DEFAULT '' COMMENT '广告位标识', `ad_type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '广告类型', `timeset` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '时间限制:0-永不过期,1-在设内时间内有效', `start_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间', `end_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间', `name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告位名称', `content` text NOT NULL COMMENT '广告内容', `expcontent` text NOT NULL COMMENT '过期显示内容', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告表'; -- ----------------------------- -- 表数据 `dp_cms_advert` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_advert_type` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_advert_type`; CREATE TABLE `dp_cms_advert_type` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告分类表'; -- ----------------------------- -- 表数据 `dp_cms_advert_type` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_column` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_column`; CREATE TABLE `dp_cms_column` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id', `name` varchar(32) NOT NULL DEFAULT '' COMMENT '栏目名称', `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文档模型id', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接', `target` varchar(16) NOT NULL DEFAULT '_self' COMMENT '链接打开方式', `content` text NOT NULL COMMENT '内容', `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '字体图标', `index_template` varchar(32) NOT NULL DEFAULT '' COMMENT '封面模板', `list_template` varchar(32) NOT NULL DEFAULT '' COMMENT '列表页模板', `detail_template` varchar(32) NOT NULL DEFAULT '' COMMENT '详情页模板', `post_auth` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '投稿权限', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', `hide` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏', `rank_auth` int(11) NOT NULL DEFAULT '0' COMMENT '浏览权限，-1待审核，0为开放浏览，大于0则为对应的用户角色id', `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '栏目属性：0-最终列表栏目，1-外部链接，2-频道封面', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='栏目表'; -- ----------------------------- -- 表数据 `dp_cms_column` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_document` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_document`; CREATE TABLE `dp_cms_document` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `cid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '栏目id', `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文档模型ID', `title` varchar(256) NOT NULL DEFAULT '' COMMENT '标题', `shorttitle` varchar(32) NOT NULL DEFAULT '' COMMENT '简略标题', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID', `flag` set('j','p','b','s','a','f','c','h') DEFAULT NULL COMMENT '自定义属性', `view` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读量', `comment` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论数', `good` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数', `bad` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '踩数', `mark` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收藏数量', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', `trash` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '回收站', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档基础表'; -- ----------------------------- -- 表数据 `dp_cms_document` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_field` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_field`; CREATE TABLE `dp_cms_field` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '字段名称', `name` varchar(32) NOT NULL, `title` varchar(32) NOT NULL DEFAULT '' COMMENT '字段标题', `type` varchar(32) NOT NULL DEFAULT '' COMMENT '字段类型', `define` varchar(128) NOT NULL DEFAULT '' COMMENT '字段定义', `value` text NULL COMMENT '默认值', `options` text NULL COMMENT '额外选项', `tips` varchar(256) NOT NULL DEFAULT '' COMMENT '提示说明', `fixed` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否为固定字段', `show` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示', `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '所属文档模型id', `ajax_url` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框ajax地址', `next_items` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框的下级下拉框名，多个以逗号隔开', `param` varchar(32) NOT NULL DEFAULT '' COMMENT '联动下拉框请求参数名', `format` varchar(32) NOT NULL DEFAULT '' COMMENT '格式，用于格式文本', `table` varchar(32) NOT NULL DEFAULT '' COMMENT '表名，只用于快速联动类型', `level` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '联动级别，只用于快速联动类型', `key` varchar(32) NOT NULL DEFAULT '' COMMENT '键字段，只用于快速联动类型', `option` varchar(32) NOT NULL DEFAULT '' COMMENT '值字段，只用于快速联动类型', `pid` varchar(32) NOT NULL DEFAULT '' COMMENT '父级id字段，只用于快速联动类型', `ak` varchar(32) NOT NULL DEFAULT '' COMMENT '百度地图appkey', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='文档字段表'; -- ----------------------------- -- 表数据 `dp_cms_field` -- ----------------------------- INSERT INTO `dp_cms_field` VALUES ('1', 'id', 'ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', 'ID', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480562978', '1480562978', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('2', 'cid', '栏目', 'select', 'int(11) UNSIGNED NOT NULL', '0', '', '请选择所属栏目', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480562978', '1480562978', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('3', 'uid', '用户ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563110', '1480563110', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('4', 'model', '模型ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563110', '1480563110', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('5', 'title', '标题', 'text', 'varchar(128) NOT NULL', '', '', '文档标题', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480575844', '1480576134', '1', '1'); INSERT INTO `dp_cms_field` VALUES ('6', 'shorttitle', '简略标题', 'text', 'varchar(32) NOT NULL', '', '', '简略标题', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480575844', '1480576134', '1', '1'); INSERT INTO `dp_cms_field` VALUES ('7', 'flag', '自定义属性', 'checkbox', 'set(\'j\',\'p\',\'b\',\'s\',\'a\',\'f\',\'h\',\'c\') NULL DEFAULT NULL', '', 'j:跳转\r\np:图片\r\nb:加粗\r\ns:滚动\r\na:特荐\r\nf:幻灯\r\nh:头条\r\nc:推荐', '自定义属性', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480671258', '1480671258', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('8', 'view', '阅读量', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480563149', '1480563149', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('9', 'comment', '评论数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563189', '1480563189', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('10', 'good', '点赞数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563279', '1480563279', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('11', 'bad', '踩数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563330', '1480563330', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('12', 'mark', '收藏数量', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563372', '1480563372', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('13', 'create_time', '创建时间', 'datetime', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563406', '1480563406', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('14', 'update_time', '更新时间', 'datetime', 'int(11) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563432', '1480563432', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('15', 'sort', '排序', 'text', 'int(11) NOT NULL', '100', '', '', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480563510', '1480563510', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('16', 'status', '状态', 'radio', 'tinyint(2) UNSIGNED NOT NULL', '1', '0:禁用\r\n1:启用', '', '0', '1', '0', '', '', '', '', '', '0', '', '', '', '', '1480563576', '1480563576', '100', '1'); INSERT INTO `dp_cms_field` VALUES ('17', 'trash', '回收站', 'text', 'tinyint(2) UNSIGNED NOT NULL', '0', '', '', '0', '0', '0', '', '', '', '', '', '0', '', '', '', '', '1480563576', '1480563576', '100', '1'); -- ----------------------------- -- 表结构 `dp_cms_link` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_link`; CREATE TABLE `dp_cms_link` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型：1-文字链接，2-图片链接', `title` varchar(128) NOT NULL DEFAULT '' COMMENT '链接标题', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址', `logo` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '链接LOGO', `contact` varchar(255) NOT NULL DEFAULT '' COMMENT '联系方式', `sort` int(11) NOT NULL DEFAULT '100', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='有钱链接表'; -- ----------------------------- -- 表数据 `dp_cms_link` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_menu` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_menu`; CREATE TABLE `dp_cms_menu` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `nid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '导航id', `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id', `column` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '栏目id', `page` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '单页id', `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '类型：0-栏目链接，1-单页链接，2-自定义链接', `title` varchar(128) NOT NULL DEFAULT '' COMMENT '菜单标题', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接', `css` varchar(64) NOT NULL DEFAULT '' COMMENT 'css类', `rel` varchar(64) NOT NULL DEFAULT '' COMMENT '链接关系网', `target` varchar(16) NOT NULL DEFAULT '' COMMENT '打开方式', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='菜单表'; -- ----------------------------- -- 表数据 `dp_cms_menu` -- ----------------------------- INSERT INTO `dp_cms_menu` VALUES ('1', '1', '0', '0', '0', '2', '首页', 'cms/index/index', '', '', '_self', '1492345605', '1492345605', '100', '1'); INSERT INTO `dp_cms_menu` VALUES ('2', '2', '0', '0', '0', '2', '关于我们', 'http://www.dolphinphp.com', '', '', '_self', '1492346763', '1492346763', '100', '1'); INSERT INTO `dp_cms_menu` VALUES ('3', '3', '0', '0', '0', '2', '开发文档', 'http://www.kancloud.cn/ming5112/dolphinphp', '', '', '_self', '1492346812', '1492346812', '100', '1'); INSERT INTO `dp_cms_menu` VALUES ('4', '3', '0', '0', '0', '2', '开发者社区', 'http://bbs.dolphinphp.com/', '', '', '_self', '1492346832', '1492346832', '100', '1'); INSERT INTO `dp_cms_menu` VALUES ('5', '1', '0', '0', '0', '2', '二级菜单', 'http://www.dolphinphp.com', '', '', '_self', '1492347372', '1492347510', '100', '1'); INSERT INTO `dp_cms_menu` VALUES ('6', '1', '5', '0', '0', '2', '子菜单', 'http://www.dolphinphp.com', '', '', '_self', '1492347388', '1492347520', '100', '1'); -- ----------------------------- -- 表结构 `dp_cms_model` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_model`; CREATE TABLE `dp_cms_model` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '' COMMENT '模型名称', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模型标题', `table` varchar(64) NOT NULL DEFAULT '' COMMENT '附加表名称', `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '模型类别：0-系统模型，1-普通模型，2-独立模型', `icon` varchar(64) NOT NULL, `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序', `system` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否系统模型', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='内容模型表'; -- ----------------------------- -- 表结构 `dp_cms_nav` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_nav`; CREATE TABLE `dp_cms_nav` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `tag` varchar(32) NOT NULL DEFAULT '' COMMENT '导航标识', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '菜单标题', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='导航表'; -- ----------------------------- -- 表数据 `dp_cms_nav` -- ----------------------------- INSERT INTO `dp_cms_nav` VALUES ('1', 'main_nav', '顶部导航', '1492345083', '1492345083', '1'); INSERT INTO `dp_cms_nav` VALUES ('2', 'about_nav', '底部关于', '1492346685', '1492346685', '1'); INSERT INTO `dp_cms_nav` VALUES ('3', 'support_nav', '服务与支持', '1492346715', '1492346715', '1'); -- ----------------------------- -- 表结构 `dp_cms_page` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_page`; CREATE TABLE `dp_cms_page` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(64) NOT NULL DEFAULT '' COMMENT '单页标题', `content` mediumtext NOT NULL COMMENT '单页内容', `keywords` varchar(32) NOT NULL DEFAULT '' COMMENT '关键词', `description` varchar(250) NOT NULL DEFAULT '' COMMENT '页面描述', `template` varchar(32) NOT NULL DEFAULT '' COMMENT '模板文件', `cover` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '单页封面', `view` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读量', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='单页表'; -- ----------------------------- -- 表数据 `dp_cms_page` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_slider` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_slider`; CREATE TABLE `dp_cms_slider` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(32) NOT NULL DEFAULT '' COMMENT '标题', `cover` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '封面id', `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='滚动图片表'; -- ----------------------------- -- 表数据 `dp_cms_slider` -- ----------------------------- -- ----------------------------- -- 表结构 `dp_cms_support` -- ----------------------------- DROP TABLE IF EXISTS `dp_cms_support`; CREATE TABLE `dp_cms_support` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL DEFAULT '' COMMENT '客服名称', `qq` varchar(16) NOT NULL DEFAULT '' COMMENT 'QQ', `msn` varchar(100) NOT NULL DEFAULT '' COMMENT 'msn', `taobao` varchar(100) NOT NULL DEFAULT '' COMMENT 'taobao', `alibaba` varchar(100) NOT NULL DEFAULT '' COMMENT 'alibaba', `skype` varchar(100) NOT NULL DEFAULT '' COMMENT 'skype', `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态', `sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='客服表'; -- ----------------------------- -- 表数据 `dp_cms_support` -- -----------------------------