框架结构表_category_menu

-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2018-10-07 00:15:05
-- 服务器版本： 5.5.57-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `spacemengcom`
--

-- --------------------------------------------------------

--
-- 表的结构 `Webmeng_category_menu`
--

CREATE TABLE `Webmeng_category_menu` (
  `cat_id` smallint(5) UNSIGNED NOT NULL,
  `cat_name` varchar(30) NOT NULL COMMENT '类别名称',
  `intro` varchar(100) DEFAULT NULL COMMENT '类别描述',
  `level` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '类别层级',
  `parent_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父类id',
  `sort_path` varchar(255) NOT NULL DEFAULT '0' COMMENT '类别路径',
  `sort` smallint(5) NOT NULL DEFAULT '1' COMMENT '类别排序',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 0已删除 1已启用 2已禁用'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `Webmeng_category_menu`
--

INSERT INTO `Webmeng_category_menu` (`cat_id`, `cat_name`, `intro`, `level`, `parent_id`, `sort_path`, `sort`, `status`) VALUES
(1, '设置', 'system', 0, 0, '0,1,', 1, 1),
(2, '商城', 'shop', 0, 0, '0,2,', 4, 1),
(3, '用户', 'user', 0, 0, '0,3,', 5, 1),
(4, '内容', 'cms', 0, 0, '0,4,', 3, 1),
(5, '应用', 'application', 0, 0, '0,5,', 6, 1),
(6, 'WebMeng', 'webmeng', 0, 0, '0,6,', 7, 1),
(7, '设置', '', 0, 1, '0,1,7,', 1, 1),
(8, '模块', 'modules', 0, 0, '0,8,', 2, 1),
(9, '站点信息', 'system/main', 0, 7, '0,1,7,9,', 0, 1),
(10, '站点设置', 'system/setting', 0, 7, '0,1,7,10,', 1, 1),
(11, '上传设置', 'system/upload', 0, 7, '0,1,7,11,', 3, 1),
(12, '客服设置', 'system/service', 0, 7, '0,1,7,12,', 4, 1),
(13, '地区设置', 'Category_areas', 0, 7, '0,1,7,13,', 5, 1),
(14, '公告管理', 'modules/notice/list', 1, 96, '0,8,96,14,', 1, 1),
(15, '广告管理', 'modules/adv/list', 1, 96, '0,8,96,15,', 97, 1),
(16, '设置', '', 0, 2, '0,2,16,', 1, 1),
(17, '商品', '', 0, 2, '0,2,17,', 2, 1),
(18, 'SEO设置', 'shop/setting', 2, 7, '0,1,7,18,', 2, 1),
(19, '图片设置', 'shop/upload', 0, 16, '0,2,16,19,', 2, 1),
(20, '发布商品', 'shop/goods/add', 0, 17, '0,2,17,20,', 1, 1),
(21, '商品列表', 'shop/goods/list', 0, 17, '0,2,17,21,', 2, 1),
(22, '分类管理', 'Category_goods', 0, 17, '0,2,17,22,', 3, 1),
(23, '设置', '', 0, 3, '0,3,23,', 0, 1),
(24, '成员', '', 0, 3, '0,3,24,', 2, 1),
(25, '会员设置', 'user/setting', 0, 23, '0,3,23,25,', 1, 1),
(26, '等级经验值', 'user/member_exp', 0, 23, '0,3,23,26,', 2, 0),
(27, '清理缓存', 'system/cache', 0, 7, '0,1,7,27,', 6, 1),
(28, '友情链接', 'modules/link/list', 1, 96, '0,8,96,28,', 99, 1),
(29, '全站搜索', 'modules/search/settings', 1, 96, '0,8,96,29,', 98, 1),
(30, '搜索设置', 'shop/search', 2, 16, '0,2,16,30,', 3, 1),
(31, '管理', '', 0, 1, '0,1,31,', 3, 1),
(32, '权限设置', 'system/admin/list', 0, 31, '0,1,31,32,', 1, 1),
(33, '管理员管理', 'system/admin', 0, 31, '0,1,31,33,', 2, 1),
(34, '角色管理', 'system/admin/role', 0, 31, '0,1,31,34,', 3, 1),
(35, '添加角色', 'system/admin/role_add', 0, 31, '0,1,31,35,', 4, 1),
(36, '操作日志', 'system/admin/log', 0, 31, '0,1,31,36,', 5, 1),
(37, '品牌管理', 'shop/brand/list', 0, 17, '0,2,17,37,', 4, 1),
(38, '类型管理', 'shop/goods/model', 0, 17, '0,2,17,38,', 5, 1),
(39, '单位管理', 'shop/goods/unit', 0, 17, '0,2,17,39,', 6, 1),
(40, '价格区间管理', 'shop/goods/price', 0, 17, '0,2,17,40,', 7, 1),
(41, '交易', '', 0, 2, '0,2,41,', 3, 1),
(42, '专题', '', 0, 2, '0,2,42,', 4, 0),
(43, '内容', '', 1, 4, '0,4,43,', 1, 1),
(44, '评论', '', 0, 2, '0,2,44,', 6, 1),
(45, '统计', '', 0, 2, '0,2,45,', 7, 0),
(46, '商品订单', 'shop/order/list', 0, 41, '0,2,41,46,', 1, 1),
(47, '评价管理', 'shop/comment/list', 0, 41, '0,2,41,47,', 2, 1),
(48, '投诉管理', 'shop/comment/complain', 0, 41, '0,2,41,48,', 3, 1),
(49, '专题管理', 'cms/special/list', 0, 42, '0,2,42,49,', 1, 0),
(50, '发布专题', 'cms/special/add', 0, 42, '0,2,42,50,', 2, 0),
(51, '专题分类', 'Category_special', 0, 42, '0,2,42,51,', 3, 0),
(52, '新闻管理', 'cms/news/list', 2, 43, '0,4,43,52,', 3, 1),
(53, '文章管理', 'cms/inews/list', 2, 43, '0,4,43,53,', 4, 1),
(54, '图片管理', 'cms/photo/list', 0, 43, '0,2,43,54,', 3, 0),
(55, '帮助管理', 'cms/help/list', 2, 43, '0,4,43,55,', 9, 1),
(56, '商品评论', 'cms/comment/goods', 0, 44, '0,2,44,56,', 1, 1),
(57, '文章评论', 'cms/comment/inews', 0, 44, '0,2,44,57,', 2, 0),
(58, '新闻评论', 'cms/comment/news', 0, 44, '0,2,44,58,', 3, 0),
(59, '图片评论', 'cms/comment/photo', 0, 44, '0,2,44,59,', 4, 0),
(60, '专题评论', 'cms/comment/special', 0, 44, '0,2,44,60,', 5, 0),
(61, '帮助评论', 'cms/comment/help', 0, 44, '0,2,44,61,', 6, 0),
(62, '概述及设置', 'shop/stat/general', 0, 45, '0,2,45,62,', 1, 0),
(63, '积分管理', 'user/points', 0, 23, '0,3,23,63,', 3, 0),
(64, '分享绑定', 'user/sns_sharesetting', 0, 23, '0,3,23,64,', 4, 0),
(65, '会员列表', 'user/member', 0, 24, '0,3,24,65,', 1, 1),
(66, '添加会员', 'user/add', 0, 24, '0,3,24,66,', 2, 1),
(67, '用户协议', 'user/agreement', 0, 24, '0,3,24,67,', 3, 1),
(68, '风格', '', 1, 1, '0,1,68,', 6, 1),
(69, '定制', '', 0, 4, '0,4,69,', 99, 1),
(113, '直播管理', 'cms/live/list', 0, 43, '0,4,43,113,', 0, 1),
(70, '风格设置', 'templates/settings', 2, 68, '0,1,68,70,', 1, 1),
(71, '风格添加', 'templates/add', 2, 68, '0,1,68,71,', 2, 1),
(72, '风格评论', 'templates/comment', 2, 68, '0,1,68,72,', 3, 1),
(73, '我的风格列表', 'templates/list', 0, 69, '0,4,69,73,', 1, 1),
(74, '官方风格列表', 'templates/webmeng', 0, 69, '0,4,69,74,', 2, 1),
(75, '我要定制风格', 'templates/commission', 0, 69, '0,4,69,75,', 3, 1),
(76, '设置', '', 0, 5, '0,5,76,', 1, 1),
(77, '支付', '', 0, 5, '0,5,77,', 2, 1),
(78, '组件', '', 0, 5, '0,5,78,', 3, 1),
(79, '应用设置', 'application/setting', 0, 76, '0,5,76,79,', 1, 1),
(80, '移动端安装', 'application/installation_app', 0, 76, '0,5,76,80,', 2, 1),
(81, '意见反馈', 'application/feedback', 0, 76, '0,5,76,81,', 3, 1),
(82, '微信二维码', 'application/wx_dimensional_code', 0, 76, '0,5,76,82,', 4, 1),
(83, '支付管理', 'application/payment/manage', 0, 77, '0,5,77,83,', 5, 1),
(84, '支付宝', 'application/payment/alipay', 0, 77, '0,5,77,84,', 2, 1),
(85, '微信支付', 'application/payment/weipay', 0, 77, '0,5,77,85,', 3, 1),
(86, '客服组件', 'application/plugins/express', 0, 78, '0,5,78,86,', 1, 1),
(87, '邮件接口', 'application/plugins/express_api', 0, 78, '0,5,78,87,', 2, 1),
(88, 'App接口', 'application/plugins/waybill', 0, 78, '0,5,78,88,', 3, 1),
(89, '设置', '', 0, 6, '0,6,89,', 1, 1),
(90, '管理', '', 0, 6, '0,6,90,', 2, 1),
(91, '应用设置', 'webmeng/setting', 0, 89, '0,6,89,91,', 1, 1),
(92, '移动端安装', 'webmeng/app', 0, 89, '0,6,89,92,', 2, 1),
(93, '产品管理', 'webmeng/cp', 0, 90, '0,6,90,93,', 1, 1),
(94, '用户管理', 'webmeng/user', 0, 90, '0,6,90,94,', 2, 1),
(95, '框架目录', 'Category_menu', 0, 89, '0,6,89,95,', 3, 1),
(96, '模块管理', '1', 0, 8, '0,8,96,', 2, 1),
(97, '模块设置', '', 0, 8, '0,8,97,', 1, 1),
(98, '关于我们', 'cms/about/list', 2, 43, '0,4,43,98,', 2, 1),
(99, '店面模块', 'modules/shop/list', 0, 96, '0,8,96,99,', 5, 1),
(100, '预约模块', 'modules/ordered/list', 0, 96, '0,8,96,100,', 6, 1),
(101, '品牌历史', 'modules/history/list', 0, 96, '0,8,96,101,', 7, 1),
(102, '优惠券', 'modules/coupons/list', 0, 96, '0,8,96,102,', 8, 1),
(103, '运输', 'application/express/list', 0, 5, '0,5,103,', 3, 1),
(104, '快递公司', 'application/express/list', 0, 103, '0,5,103,104,', 1, 1),
(105, '快递接口', 'application/express/express_api', 0, 103, '0,5,103,105,', 2, 1),
(106, '积分商城', 'modules/integral/list', 0, 96, '0,8,96,106,', 100, 1),
(107, '模块设置', 'modules/setting', 0, 97, '0,8,97,107,', 1, 1),
(108, '产品列表', 'cms/products/list', 0, 43, '0,4,43,108,', 6, 1),
(109, '专题列表', 'cms/special/list', 0, 43, '0,4,43,109,', 10, 1),
(110, '图片列表', 'cms/photo/list', 0, 43, '0,4,43,110,', 11, 1),
(111, '下载列表', 'cms/download/list', 0, 43, '0,4,43,111,', 12, 1),
(112, '留言列表', 'cms/comment/list', 0, 43, '0,4,43,112,', 13, 1),
(114, '视频管理', 'cms/video/list', 1, 43, '0,4,43,114,', 1, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Webmeng_category_menu`
--
ALTER TABLE `Webmeng_category_menu`
  ADD PRIMARY KEY (`cat_id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `Webmeng_category_menu`
--
ALTER TABLE `Webmeng_category_menu`
  MODIFY `cat_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;