/*
MySQL Backup
Source Server Version: 5.7.17
Source Database: jijincms
Date: 2020-01-15 09:36:31
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `db_access`
-- ----------------------------
DROP TABLE IF EXISTS `db_access`;
CREATE TABLE `db_access` (
`role_id` smallint(6) unsigned NOT NULL,
`node_id` smallint(6) unsigned NOT NULL,
`level` tinyint(1) NOT NULL,
`module` varchar(50) DEFAULT NULL,
KEY `groupId` (`role_id`),
KEY `nodeId` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_ad`
-- ----------------------------
DROP TABLE IF EXISTS `db_ad`;
CREATE TABLE `db_ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adid` int(11) NOT NULL,
`pubid` bigint(15) NOT NULL,
`status` tinyint(4) NOT NULL,
`name` varchar(50) NOT NULL,
`intro` varchar(255) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`thumb` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`sort` int(11) NOT NULL DEFAULT '0',
`adcode` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_ad_cat`
-- ----------------------------
DROP TABLE IF EXISTS `db_ad_cat`;
CREATE TABLE `db_ad_cat` (
`adid` int(11) NOT NULL AUTO_INCREMENT,
`pubid` bigint(15) NOT NULL,
`name` varchar(50) NOT NULL,
`intro` varchar(255) DEFAULT NULL,
`type` varchar(50) NOT NULL,
`thumb` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`sort` int(11) NOT NULL,
`adcode` text,
PRIMARY KEY (`adid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_cat`
-- ----------------------------
DROP TABLE IF EXISTS `db_cat`;
CREATE TABLE `db_cat` (
`catid` smallint(11) NOT NULL AUTO_INCREMENT,
`modelid` int(11) NOT NULL,
`lang` varchar(10) DEFAULT '' COMMENT '语言',
`pubid` bigint(15) NOT NULL,
`classpath` varchar(255) NOT NULL DEFAULT '',
`table_name` varchar(100) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`infonum` int(11) NOT NULL COMMENT '信息条数',
`lencord` smallint(5) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`sort` smallint(6) unsigned NOT NULL,
`pid` smallint(6) unsigned NOT NULL,
`level` tinyint(1) unsigned NOT NULL,
`is_last` tinyint(1) NOT NULL DEFAULT '0',
`parent_catids` text COMMENT '所有父级栏目',
`son_catids` text COMMENT '所有子级栏目',
`listtemp` int(10) unsigned NOT NULL DEFAULT '0',
`viewtemp` int(10) unsigned NOT NULL DEFAULT '0',
`thumb` varchar(255) NOT NULL DEFAULT '',
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`keywords` varchar(255) NOT NULL DEFAULT '',
`description` text,
`is_page` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_show` tinyint(1) NOT NULL DEFAULT '0',
`list_type` varchar(20) DEFAULT NULL,
`view_type` varchar(20) DEFAULT NULL,
`listorder` varchar(255) DEFAULT NULL,
`reorder` varchar(255) DEFAULT NULL,
`member_group_id` varchar(255) DEFAULT NULL,
`test22` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`catid`),
KEY `level` (`level`),
KEY `pid` (`pid`),
KEY `status` (`status`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_cat_data`
-- ----------------------------
DROP TABLE IF EXISTS `db_cat_data`;
CREATE TABLE `db_cat_data` (
`catid` smallint(11) NOT NULL,
PRIMARY KEY (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_cat_field`
-- ----------------------------
DROP TABLE IF EXISTS `db_cat_field`;
CREATE TABLE `db_cat_field` (
`field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`field` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名',
`name` varchar(30) NOT NULL DEFAULT '' COMMENT '别名',
`fieldtype` varchar(30) NOT NULL COMMENT '字段类型',
`fieldlen` varchar(20) NOT NULL COMMENT '长度',
`formtype` varchar(20) NOT NULL DEFAULT '' COMMENT '字段类型',
`tips` text COMMENT '字段提示',
`pattern` varchar(255) NOT NULL DEFAULT '' COMMENT '数据校验正则',
`errortips` varchar(255) DEFAULT '' COMMENT '数据校验未通过的提示信息',
`savefun` varchar(255) DEFAULT NULL,
`issystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否主表',
`isunique` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '值唯一',
`sort` mediumint(8) unsigned NOT NULL DEFAULT '0',
`formwidth` smallint(4) DEFAULT NULL COMMENT '元素宽度',
`formheight` smallint(4) DEFAULT NULL COMMENT '元素高度',
`imgwidth` smallint(4) DEFAULT '0',
`imgheight` smallint(4) DEFAULT '0',
`defaultval` text COMMENT '默认值',
`htmlcode` longtext COMMENT 'html代码',
PRIMARY KEY (`field_id`),
KEY `field` (`field`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='模型字段列表';
-- ----------------------------
-- Table structure for `db_cms_news`
-- ----------------------------
DROP TABLE IF EXISTS `db_cms_news`;
CREATE TABLE `db_cms_news` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
`checked` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`thumb` varchar(255) NOT NULL DEFAULT '',
`linkurl` varchar(255) NOT NULL DEFAULT '',
`newstime` int(11) unsigned NOT NULL DEFAULT '0',
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`keywords` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
`sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
`userid` int(11) unsigned NOT NULL DEFAULT '0',
`username` char(20) NOT NULL DEFAULT '',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`editortime` int(10) unsigned NOT NULL DEFAULT '0',
`is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
`is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
`views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
`goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
`favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
`comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
`viewtemp` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `checked` (`checked`),
KEY `catid` (`catid`),
KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=9394 DEFAULT CHARSET=utf8 COMMENT='新闻数据表';
-- ----------------------------
-- Table structure for `db_cms_news_data`
-- ----------------------------
DROP TABLE IF EXISTS `db_cms_news_data`;
CREATE TABLE `db_cms_news_data` (
`id` mediumint(8) unsigned NOT NULL,
`newstext` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='新闻数据表-副表';
-- ----------------------------
-- Table structure for `db_cms_product`
-- ----------------------------
DROP TABLE IF EXISTS `db_cms_product`;
CREATE TABLE `db_cms_product` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
`checked` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`thumb` varchar(255) NOT NULL DEFAULT '',
`linkurl` varchar(255) NOT NULL DEFAULT '',
`newstime` int(11) unsigned NOT NULL DEFAULT '0',
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`keywords` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
`sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
`userid` int(11) unsigned NOT NULL DEFAULT '0',
`username` char(20) NOT NULL DEFAULT '',
`addtime` int(10) unsigned NOT NULL DEFAULT '0',
`editortime` int(10) unsigned NOT NULL DEFAULT '0',
`is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
`is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
`views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
`goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
`favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
`comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
`viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
`price` int(11) NOT NULL DEFAULT '0',
`morepic` text,
`type_no` varchar(50) NOT NULL DEFAULT '',
`pro_group` varchar(50) NOT NULL DEFAULT '',
`price2` int(11) unsigned NOT NULL DEFAULT '0',
`sales` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `checked` (`checked`),
KEY `catid` (`catid`),
KEY `sort` (`sort`)
) ENGINE=InnoDB AUTO_INCREMENT=641 DEFAULT CHARSET=utf8 COMMENT='产品数据表';
-- ----------------------------
-- Table structure for `db_cms_product_data`
-- ----------------------------
DROP TABLE IF EXISTS `db_cms_product_data`;
CREATE TABLE `db_cms_product_data` (
`id` mediumint(8) unsigned NOT NULL,
`newstext` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品数据表-副表';
-- ----------------------------
-- Table structure for `db_feedback`
-- ----------------------------
DROP TABLE IF EXISTS `db_feedback`;
CREATE TABLE `db_feedback` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addtime` int(11) NOT NULL,
`member_id` int(11) DEFAULT '0',
`is_read` tinyint(4) NOT NULL DEFAULT '0',
`ip` varchar(50) NOT NULL,
`catid` int(11) NOT NULL,
`title` varchar(255) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`mobile` varchar(255) NOT NULL DEFAULT '',
`content` text,
`sex` varchar(255) NOT NULL DEFAULT '',
`city` varchar(200) NOT NULL DEFAULT '',
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_feedback_cat`
-- ----------------------------
DROP TABLE IF EXISTS `db_feedback_cat`;
CREATE TABLE `db_feedback_cat` (
`catid` smallint(4) NOT NULL AUTO_INCREMENT,
`status` tinyint(4) NOT NULL,
`lang` varchar(20) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`sort` int(11) NOT NULL DEFAULT '0',
`formtemp` text,
`is_enter` text,
`must_enter` text,
`verify_code` tinyint(3) NOT NULL,
`member_group` varchar(50) DEFAULT NULL,
`request_email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`catid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_feedback_field`
-- ----------------------------
DROP TABLE IF EXISTS `db_feedback_field`;
CREATE TABLE `db_feedback_field` (
`field_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`field` varchar(20) NOT NULL DEFAULT '' COMMENT '字段名',
`name` varchar(30) NOT NULL DEFAULT '' COMMENT '别名',
`fieldtype` varchar(30) NOT NULL COMMENT '字段类型',
`fieldlen` varchar(20) NOT NULL COMMENT '长度',
`formtype` varchar(20) NOT NULL DEFAULT '' COMMENT '字段类型',
`tips` text COMMENT '字段提示',
`pattern` varchar(255) NOT NULL DEFAULT '' COMMENT '数据校验正则',
`errortips` varchar(255) DEFAULT '' COMMENT '数据校验未通过的提示信息',
`savefun` varchar(255) DEFAULT NULL,
`sort` mediumint(8) unsigned NOT NULL DEFAULT '0',
`formwidth` smallint(4) DEFAULT NULL COMMENT '元素宽度',
`formheight` smallint(4) DEFAULT NULL COMMENT '元素高度',
`defaultval` text COMMENT '默认值',
`htmlcode` longtext COMMENT 'html代码',
PRIMARY KEY (`field_id`),
KEY `field` (`field`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='模型字段列表';
-- ----------------------------
-- Table structure for `db_file`
-- ----------------------------
DROP TABLE IF EXISTS `db_file`;
CREATE TABLE `db_file` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '文件ID',
`pubid` bigint(15) NOT NULL COMMENT '关联信息id',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '原始文件名',
`savename` varchar(255) NOT NULL DEFAULT '' COMMENT '保存名称',
`smallpath` varchar(255) DEFAULT NULL COMMENT '缩略图路径',
`filepath` varchar(255) NOT NULL COMMENT '完整的路径',
`savepath` varchar(255) NOT NULL DEFAULT '' COMMENT '文件保存路径',
`ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀',
`mime` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型',
`size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
`md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
`sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
`location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置',
`create_time` int(10) unsigned NOT NULL COMMENT '上传时间',
PRIMARY KEY (`id`),
KEY `uk_md5` (`md5`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='文件表';
-- ----------------------------
-- Table structure for `db_link`
-- ----------------------------
DROP TABLE IF EXISTS `db_link`;
CREATE TABLE `db_link` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL,
`status` tinyint(3) NOT NULL,
`pubid` bigint(15) NOT NULL,
`name` varchar(50) NOT NULL,
`thumb` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`sort` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_link_cat`
-- ----------------------------
DROP TABLE IF EXISTS `db_link_cat`;
CREATE TABLE `db_link_cat` (
`catid` int(11) NOT NULL AUTO_INCREMENT,
`pubid` bigint(15) NOT NULL,
`lang` varchar(50) DEFAULT NULL,
`name` varchar(50) NOT NULL,
`thumb` varchar(255) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`sort` int(11) NOT NULL,
PRIMARY KEY (`catid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_member`
-- ----------------------------
DROP TABLE IF EXISTS `db_member`;
CREATE TABLE `db_member` (
`member_id` int(11) NOT NULL AUTO_INCREMENT,
`mobile` varchar(20) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL COMMENT '密码',
`truename` varchar(20) DEFAULT NULL,
`company_name` varchar(255) DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '0',
`checked` tinyint(1) DEFAULT '0',
`checked_time` int(11) DEFAULT '0',
`register_time` int(11) DEFAULT NULL,
`login_num` int(11) DEFAULT '0',
`last_login_ip` varchar(255) DEFAULT NULL COMMENT '最后登陆IP',
`last_login_time` int(11) DEFAULT '0',
`token` varchar(50) DEFAULT NULL,
`zhuyinghangye` int(11) DEFAULT NULL COMMENT '主营行业',
`kehuxingzhi` int(11) DEFAULT NULL COMMENT '客户性质',
`guhua` varchar(255) DEFAULT NULL COMMENT '固定电话',
`lianxiren` varchar(255) DEFAULT NULL COMMENT '联系人',
`lianxiren_mobile` varchar(255) DEFAULT NULL COMMENT '联系人手机',
`email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`member_id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_member_address`
-- ----------------------------
DROP TABLE IF EXISTS `db_member_address`;
CREATE TABLE `db_member_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`member_id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`area` varchar(255) DEFAULT NULL,
`detail` varchar(255) DEFAULT NULL,
`sh_status` tinyint(4) DEFAULT '0',
`sp_status` tinyint(4) DEFAULT '0',
`create_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_member_group`
-- ----------------------------
DROP TABLE IF EXISTS `db_member_group`;
CREATE TABLE `db_member_group` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_member_invoice`
-- ----------------------------
DROP TABLE IF EXISTS `db_member_invoice`;
CREATE TABLE `db_member_invoice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`member_id` int(11) DEFAULT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1:增值税专票 0:普通发票',
`company_name` varchar(255) DEFAULT NULL,
`taxpayer_number` varchar(255) DEFAULT NULL,
`registration_address` varchar(255) DEFAULT NULL,
`registration_mobile` varchar(255) DEFAULT NULL,
`opening_bank` varchar(255) DEFAULT NULL,
`bank_account` varchar(255) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL,
`status` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_model`
-- ----------------------------
DROP TABLE IF EXISTS `db_model`;
CREATE TABLE `db_model` (
`modelid` smallint(4) NOT NULL AUTO_INCREMENT,
`table_id` smallint(4) NOT NULL,
`table_name` varchar(50) NOT NULL,
`status` tinyint(4) NOT NULL,
`name` varchar(50) NOT NULL,
`sort` int(11) NOT NULL DEFAULT '0',
`contribute` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否开启投稿',
`autochecked` smallint(4) NOT NULL COMMENT '自动审核 1为自动 0为人工',
`listtemp` varchar(255) DEFAULT NULL,
`formtemp` text,
`is_enter` text,
`is_contribute` text,
`must_enter` text,
`is_list` text,
`is_search` text,
`is_sort` text,
`cat_formtemp` text,
`cat_is_enter` text,
`cat_must_enter` text,
PRIMARY KEY (`modelid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_node`
-- ----------------------------
DROP TABLE IF EXISTS `db_node`;
CREATE TABLE `db_node` (
`id` smallint(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`title` varchar(50) DEFAULT NULL,
`status` tinyint(1) DEFAULT '0',
`remark` text,
`sort` smallint(6) unsigned DEFAULT NULL,
`pid` smallint(6) unsigned NOT NULL,
`level` tinyint(1) unsigned NOT NULL,
`icon` varchar(20) DEFAULT NULL COMMENT 'css class名',
`is_dev` smallint(4) DEFAULT NULL COMMENT '仅开发者模式可见',
`is_hide` smallint(4) DEFAULT NULL COMMENT '是否隐藏',
PRIMARY KEY (`id`),
KEY `level` (`level`),
KEY `pid` (`pid`),
KEY `status` (`status`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=351 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_page`
-- ----------------------------
DROP TABLE IF EXISTS `db_page`;
CREATE TABLE `db_page` (
`page_id` int(11) NOT NULL AUTO_INCREMENT,
`pubid` bigint(15) DEFAULT '0' COMMENT '附件表pubid',
`path_type` varchar(50) NOT NULL,
`classpath` varchar(255) NOT NULL,
`name` varchar(100) NOT NULL,
`title` varchar(100) DEFAULT NULL,
`lang` varchar(20) DEFAULT NULL,
`thumb` varchar(255) DEFAULT NULL,
`pagemod` varchar(20) NOT NULL COMMENT '1:直接页面式 2:模板式',
`template_id` int(11) DEFAULT NULL COMMENT '模板ID',
`pagetitle` varchar(50) DEFAULT '0',
`pagekey` varchar(255) DEFAULT '0' COMMENT '关键词',
`pagedes` text,
`pagetext` longtext NOT NULL,
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_pages`
-- ----------------------------
DROP TABLE IF EXISTS `db_pages`;
CREATE TABLE `db_pages` (
`pages_id` smallint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`path_type` varchar(20) NOT NULL,
`classpath` varchar(255) NOT NULL,
`lang` varchar(20) DEFAULT NULL,
`template_id` int(11) DEFAULT NULL COMMENT '模板ID',
`thumb` varchar(255) DEFAULT NULL,
`pagetitle` varchar(50) DEFAULT '0',
`pagekey` varchar(255) DEFAULT '0' COMMENT '关键词',
`pagedes` text,
`count_sql` text NOT NULL COMMENT '统计sql',
`select_sql` text NOT NULL COMMENT '查询sql',
`num_limit` tinyint(4) NOT NULL DEFAULT '0' COMMENT '条数限制',
`lencord` tinyint(4) NOT NULL DEFAULT '0' COMMENT '每页显示',
PRIMARY KEY (`pages_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_page_history`
-- ----------------------------
DROP TABLE IF EXISTS `db_page_history`;
CREATE TABLE `db_page_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`page_id` int(11) NOT NULL,
`addtime` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`username` varchar(100) NOT NULL,
`content` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_role`
-- ----------------------------
DROP TABLE IF EXISTS `db_role`;
CREATE TABLE `db_role` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`status` tinyint(1) unsigned DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`info_checked` text,
`info_view` text,
`info_add` text,
`info_editor` text,
`info_delete` text,
PRIMARY KEY (`id`),
KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `db_role_user`;
CREATE TABLE `db_role_user` (
`role_id` mediumint(9) unsigned DEFAULT NULL,
`user_id` char(32) DEFAULT NULL,
KEY `group_id` (`role_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_cart`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_cart`;
CREATE TABLE `db_shop_cart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`member_id` int(11) NOT NULL,
`catid` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`addtime` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=342 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `db_shop_order`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order`;
CREATE TABLE `db_shop_order` (
`order_id` int(11) NOT NULL AUTO_INCREMENT,
`order_num` varchar(50) CHARACTER SET utf8 NOT NULL,
`member_id` int(11) NOT NULL,
`money` float(11,2) NOT NULL DEFAULT '0.00',
`pay_money` float(11,2) NOT NULL DEFAULT '0.00' COMMENT '实付款',
`addtime` int(11) NOT NULL,
`remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`status_code` int(4) NOT NULL DEFAULT '0' COMMENT '状态码，详见/shop/mode/shopOrderModel.php',
`status_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '状态名称，详见/shop/mode/shopOrderModel.php',
`is_cancel` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否取消',
`is_pay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否支付',
`is_delivery` tinyint(4) NOT NULL DEFAULT '0' COMMENT '已发货',
`delivery_time` int(11) NOT NULL DEFAULT '0' COMMENT '发货时间',
`is_receipt` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否收货',
`is_offline_pay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否线下付款',
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `db_shop_order_address`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_address`;
CREATE TABLE `db_shop_order_address` (
`order_id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`area` varchar(255) DEFAULT NULL,
`detail` varchar(255) DEFAULT NULL,
`express_company_code` varchar(50) DEFAULT NULL,
`express_company_num` varchar(50) DEFAULT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_order_detail`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_detail`;
CREATE TABLE `db_shop_order_detail` (
`order_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`catid` int(11) NOT NULL DEFAULT '0',
`thumb` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8 NOT NULL,
`type_no` varchar(255) DEFAULT NULL,
`quantity` int(11) NOT NULL,
`price` float(10,2) NOT NULL,
`money` float(10,2) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `db_shop_order_invoice`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_invoice`;
CREATE TABLE `db_shop_order_invoice` (
`order_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1:增值税专票 0:普通发票',
`company_name` varchar(255) DEFAULT NULL,
`taxpayer_number` varchar(255) DEFAULT NULL,
`registration_address` varchar(255) DEFAULT NULL,
`registration_mobile` varchar(255) DEFAULT NULL,
`opening_bank` varchar(255) DEFAULT NULL,
`bank_account` varchar(255) DEFAULT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_order_invoice_address`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_invoice_address`;
CREATE TABLE `db_shop_order_invoice_address` (
`order_id` int(11) NOT NULL,
`username` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`province` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`area` varchar(255) DEFAULT NULL,
`detail` varchar(255) DEFAULT NULL,
`express_company_code` varchar(50) DEFAULT NULL,
`express_company_num` varchar(50) DEFAULT NULL,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_order_log`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_log`;
CREATE TABLE `db_shop_order_log` (
`order_id` int(11) NOT NULL,
`addtime` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
`content` text
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_order_payment`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_payment`;
CREATE TABLE `db_shop_order_payment` (
`order_id` int(11) NOT NULL,
`addtime` int(11) NOT NULL,
`paytype` varchar(20) DEFAULT NULL,
`detail` text,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_shop_order_refund`
-- ----------------------------
DROP TABLE IF EXISTS `db_shop_order_refund`;
CREATE TABLE `db_shop_order_refund` (
`order_id` int(11) NOT NULL,
`is_refund` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户发货退款',
`is_refund_time` int(11) NOT NULL DEFAULT '0' COMMENT '用户发起退款时间',
`is_rerund_agree` tinyint(1) NOT NULL DEFAULT '0' COMMENT '后台同意',
`is_rerund_disagree` tinyint(1) NOT NULL DEFAULT '0' COMMENT '后台不同意',
`is_back_money` tinyint(1) NOT NULL DEFAULT '0' COMMENT '已原路返款',
`is_refund_cancel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户自己取消退款',
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_table`
-- ----------------------------
DROP TABLE IF EXISTS `db_table`;
CREATE TABLE `db_table` (
`table_id` smallint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`table_name` varchar(50) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`sort` int(11) NOT NULL,
PRIMARY KEY (`table_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_table_field`
-- ----------------------------
DROP TABLE IF EXISTS `db_table_field`;
CREATE TABLE `db_table_field` (
`field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`table_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID',
`field` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名',
`name` varchar(30) NOT NULL DEFAULT '' COMMENT '别名',
`fieldtype` varchar(30) NOT NULL COMMENT '字段类型',
`fieldlen` varchar(20) NOT NULL COMMENT '长度',
`formtype` varchar(20) NOT NULL DEFAULT '' COMMENT '字段类型',
`tips` text COMMENT '字段提示',
`pattern` varchar(255) NOT NULL DEFAULT '' COMMENT '数据校验正则',
`errortips` varchar(255) DEFAULT '' COMMENT '数据校验未通过的提示信息',
`savefun` varchar(255) DEFAULT NULL,
`issystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否主表',
`isunique` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '值唯一',
`sort` mediumint(8) unsigned NOT NULL DEFAULT '0',
`formwidth` smallint(4) DEFAULT NULL COMMENT '元素宽度',
`formheight` smallint(4) DEFAULT NULL COMMENT '元素高度',
`imgwidth` smallint(6) DEFAULT '0' COMMENT '图片宽度',
`imgheight` smallint(6) DEFAULT '0' COMMENT '图片高度',
`defaultval` text COMMENT '默认值',
`htmlcode` longtext COMMENT 'html代码',
`memberhtmlcode` longtext COMMENT '会员投稿html代码',
PRIMARY KEY (`field_id`),
KEY `modelid` (`table_id`),
KEY `field` (`field`,`table_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='模型字段列表';
-- ----------------------------
-- Table structure for `db_template`
-- ----------------------------
DROP TABLE IF EXISTS `db_template`;
CREATE TABLE `db_template` (
`template_id` smallint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`lang` varchar(20) DEFAULT NULL COMMENT '语言',
`type` varchar(20) NOT NULL COMMENT 'index,list,view,public',
`myvar` varchar(20) DEFAULT NULL COMMENT '变更名称',
`sort` int(6) NOT NULL DEFAULT '0',
`isdefault` tinyint(1) NOT NULL DEFAULT '0' COMMENT '默认首页模板',
`content` longtext NOT NULL,
PRIMARY KEY (`template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_template_history`
-- ----------------------------
DROP TABLE IF EXISTS `db_template_history`;
CREATE TABLE `db_template_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`template_id` int(11) NOT NULL,
`addtime` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`username` varchar(100) NOT NULL,
`content` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_user`
-- ----------------------------
DROP TABLE IF EXISTS `db_user`;
CREATE TABLE `db_user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户组id',
`user_name` varchar(50) NOT NULL COMMENT '用户名',
`user_password` varchar(50) NOT NULL COMMENT '密码',
`is_admin` smallint(4) NOT NULL COMMENT '是否为管理员',
`user_mobile` varchar(20) DEFAULT NULL COMMENT '手机号码',
`user_email` varchar(50) DEFAULT NULL COMMENT '邮箱地址',
`status` smallint(4) DEFAULT NULL COMMENT '是否禁用',
`login_num` int(11) DEFAULT NULL COMMENT '登录次数',
`last_login_ip` varchar(255) DEFAULT NULL COMMENT '最后登陆IP',
`last_login_time` int(11) DEFAULT NULL,
`token` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_user_log`
-- ----------------------------
DROP TABLE IF EXISTS `db_user_log`;
CREATE TABLE `db_user_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`addtime` int(11) NOT NULL,
`nodestr` text,
`type` varchar(20) DEFAULT NULL,
`url` text,
`ip` varchar(50) DEFAULT NULL,
`table_name` varchar(50) DEFAULT NULL,
`primary_key` text,
`remark` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=567 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_user_login_log`
-- ----------------------------
DROP TABLE IF EXISTS `db_user_login_log`;
CREATE TABLE `db_user_login_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`username` varchar(50) NOT NULL,
`addtime` int(11) NOT NULL,
`status` tinyint(1) NOT NULL,
`ip` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_vars`
-- ----------------------------
DROP TABLE IF EXISTS `db_vars`;
CREATE TABLE `db_vars` (
`name` varchar(255) DEFAULT NULL,
`value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='常用变量表';
-- ----------------------------
-- Table structure for `db_visit`
-- ----------------------------
DROP TABLE IF EXISTS `db_visit`;
CREATE TABLE `db_visit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`daytime` int(11) NOT NULL COMMENT '0',
`ip` int(11) NOT NULL DEFAULT '0',
`pv` int(11) NOT NULL DEFAULT '0',
`visit_search` int(11) NOT NULL DEFAULT '0',
`visit_link` int(11) NOT NULL DEFAULT '0',
`visit_website` int(11) NOT NULL DEFAULT '0',
`engine_baidu` int(11) NOT NULL DEFAULT '0',
`engine_google` int(11) NOT NULL DEFAULT '0',
`engine_sogou` int(11) NOT NULL DEFAULT '0',
`engine_360` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `db_visit_48`
-- ----------------------------
DROP TABLE IF EXISTS `db_visit_48`;
CREATE TABLE `db_visit_48` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`visit_type` varchar(20) NOT NULL,
`visit_time` int(11) NOT NULL,
`search_engine` varchar(20) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `db_access` VALUES ('20','103','1',''), ('21','113','2',''), ('21','114','3',''), ('21','104','2',''), ('21','101','1',''), ('20','127','2',''), ('20','126','3',''), ('20','125','3',''), ('20','124','3',''), ('20','123','2',''), ('20','121','3',''), ('20','120','3',''), ('20','119','3',''), ('20','111','2',''), ('13','130','1',''), ('13','131','2',''), ('13','140','3',''), ('13','141','3',''), ('13','142','3',''), ('25','127','2',''), ('25','103','1',''), ('25','284','3',''), ('25','283','3',''), ('25','282','3',''), ('25','280','2',''), ('25','279','1',''), ('25','221','2',''), ('26','130','1',''), ('26','131','2',''), ('26','140','3',''), ('26','141','3',''), ('26','142','3',''), ('26','164','3',''), ('26','165','3',''), ('25','220','2',''), ('25','219','1',''), ('25','118','3',''), ('25','117','3',''), ('25','116','3',''), ('25','115','3',''), ('25','113','2',''), ('25','122','3',''), ('25','114','3',''), ('25','105','3',''), ('25','104','2',''), ('25','101','1',''), ('25','175','3',''), ('25','174','3',''), ('25','163','2',''), ('25','162','1',''), ('1','162','1',''), ('1','163','2',''), ('1','174','3',''), ('1','175','3',''), ('1','219','1',''), ('1','220','2',''), ('1','221','2',''), ('1','222','2',''), ('1','254','2',''), ('1','328','2',''), ('1','233','1',''), ('1','300','2',''), ('1','301','3',''), ('1','315','3',''), ('1','316','3',''), ('1','317','3',''), ('1','318','3',''), ('1','319','3',''), ('1','320','3',''), ('1','321','3',''), ('1','322','3',''), ('1','302','2',''), ('1','303','3',''), ('1','304','3',''), ('1','305','3',''), ('1','306','3',''), ('1','307','3',''), ('1','308','3',''), ('1','309','3',''), ('1','310','2',''), ('1','311','3',''), ('1','312','3',''), ('1','313','3',''), ('1','314','3',''), ('1','264','1',''), ('1','265','2',''), ('1','269','3',''), ('1','270','3',''), ('1','271','3',''), ('1','266','2',''), ('1','272','3',''), ('1','273','3',''), ('1','274','3',''), ('1','267','2',''), ('1','275','3',''), ('1','276','3',''), ('1','268','2',''), ('1','277','3',''), ('1','278','3',''), ('1','279','1','');
INSERT INTO `db_access` VALUES ('1','280','2',''), ('1','282','3',''), ('1','283','3',''), ('1','284','3',''), ('1','285','3',''), ('1','286','3',''), ('1','290','3',''), ('1','281','2',''), ('1','287','3',''), ('1','288','3',''), ('1','289','3',''), ('1','101','1',''), ('1','104','2',''), ('1','105','3',''), ('1','114','3',''), ('1','122','3',''), ('1','113','2',''), ('1','115','3',''), ('1','332','3',''), ('1','116','3',''), ('1','117','3',''), ('1','118','3',''), ('1','103','1',''), ('1','123','2',''), ('1','126','3',''), ('1','161','3',''), ('1','212','2',''), ('1','213','3',''), ('1','214','3',''), ('1','295','3',''), ('1','216','3',''), ('1','217','3',''), ('1','218','3',''), ('1','296','3',''), ('1','294','3',''), ('1','297','3',''), ('1','298','3',''), ('1','299','3',''), ('1','327','3',''), ('1','324','3',''), ('1','325','3',''), ('1','326','3',''), ('1','255','2',''), ('1','329','3',''), ('1','330','3',''), ('1','331','3',''), ('1','291','2',''), ('1','292','3',''), ('1','293','3',''), ('1','127','2',''), ('2','162','1',NULL), ('2','163','2',NULL), ('2','174','3',NULL), ('2','175','3',NULL), ('2','219','1',NULL), ('2','220','2',NULL), ('2','221','2',NULL), ('2','222','2',NULL), ('2','254','2',NULL), ('2','328','2',NULL);
INSERT INTO `db_ad` VALUES ('4','7','1529997956','0','公司厂房盛大开幕','tte2','','/d/image/20180626/5b31b892aeb50.jpg','http://doc.oschina.net/jijin','0',''), ('5','7','1529996119','1','第二张','','','/d/image/20180626/5b31b892c6638.jpg','','0',''), ('6','7','1558008330','1','test2','test4','','','','0','');
INSERT INTO `db_ad_cat` VALUES ('7','1529997869','首页banner广告','','图片轮播','','','0','');
INSERT INTO `db_cat` VALUES ('1','6','','15693086188164','/pro2/pro23/','product','马科','0','20','1','10','21','3','1','|15|21|',NULL,'6','3','','','','','0','0','static','static','','',NULL,''), ('11','5','','15661933204692','/news/','news','新闻中心','0','20','1','10','0','1','0','','|12|13|14|23|','8','7','123','1212','12121','212','0','0','static','static','newstime desc','views desc',NULL,''), ('12','6','','15680939306663','/fad/','product','新闻中心-1','0','20','1','10','11','2','0','|11|','|13|14|','8','7','','','','','0','0','static','static','','',NULL,''), ('13','5','','15680939692975','/news111/','news','新闻中心-1-1','0','20','1','10','12','3','0','|11|12|','|14|','8','7','','','','','0','0','static','static','','',NULL,''), ('14','5','','15680939762966','/fasadffsda/','news','新闻中心-1-1-1','0','20','1','10','13','4','1','|11|12|13|',NULL,'8','7','','','','','0','0','static','static','','',NULL,''), ('15','6','','15680939854166','/product/','product','产品中心','0','20','1','20','0','1','0','','|20|21|1|','6','3','','','','','0','0','static','static','','',NULL,''), ('20','6','','15693085898912','/pro1/','product','电子产品','0','20','1','10','15','2','1','|15|',NULL,'6','3','','','','','0','0','static','static','','',NULL,''), ('21','6','','15693086081185','/pro2/','product','小动物','0','20','1','20','15','2','0','|15|','|1|','6','3','','','','','0','0','static','static','','',NULL,''), ('23','5','','15694782963142','/news//path1/','news','mynews','0','20','1','20','11','2','1','|11|',NULL,'8','7','','2','3','4','0','1','rewrite','rewrite','id desc','1,2','|1|2|','12');
INSERT INTO `db_cat_data` VALUES ('11'), ('12'), ('13'), ('14'), ('15'), ('20'), ('21'), ('22'), ('23');
INSERT INTO `db_cat_field` VALUES ('55','test22','test22','varchar','','image','','','','','1','0','0','0','0','1000','0','','\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n - \r\n \r\n
\">
\r\n 删除
\r\n \r\n \r\n - \r\n
+
\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n - \r\n \r\n
\">
\r\n 删除
\r\n \r\n \r\n - \r\n
+
\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\r\n
\r\n
\r\n \" style=\"\"/>\r\n
\r\n
\" draggable=\"false\">\r\n \">\r\n \">\r\n
\">\r\n删除\r\n \r\n \r\n