/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : project

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 04/05/2021 16:45:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hs_admin
-- ----------------------------
DROP TABLE IF EXISTS `hs_admin`;
CREATE TABLE `hs_admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `head_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `role_id` int(11) NOT NULL DEFAULT 0 COMMENT '角色ID',
  `last_login` int(11) NOT NULL DEFAULT 0 COMMENT '最后登录时间',
  `last_ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后登录ip',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_admin
-- ----------------------------
INSERT INTO `hs_admin` VALUES (1, 'kkadmin', '12QjiwTBZXZPE', '/static/files/955-605948b8d4bd2.jpg', 0, 1620052743, '127.0.0.1', 0, 1618217311, 1620052743);
INSERT INTO `hs_admin` VALUES (2, 'qqadmin', '121XTSd79A6.o', '/static/files/955-605948b8d4bd2.jpg', 1, 1618308159, '127.0.0.1', 0, 1618306264, 1618308159);

-- ----------------------------
-- Table structure for hs_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `hs_admin_log`;
CREATE TABLE `hs_admin_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `aid` int(11) NOT NULL DEFAULT 0 COMMENT '管理员ID',
  `admin_user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员名',
  `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `log_time` int(11) NOT NULL DEFAULT 0 COMMENT '登录时间',
  `log_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP',
  `remark` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录日记' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_admin_log
-- ----------------------------
INSERT INTO `hs_admin_log` VALUES (1, 1, 'kkadmin', NULL, 1620045404, '127.0.0.1', '登录系统');
INSERT INTO `hs_admin_log` VALUES (2, 0, 'asdsad', '未知人员', 1620049409, '127.0.0.1', '登录失败');
INSERT INTO `hs_admin_log` VALUES (3, 1, 'kkadmin', NULL, 1620049420, '127.0.0.1', '登录系统');
INSERT INTO `hs_admin_log` VALUES (4, 1, 'kkadmin', NULL, 1620052743, '127.0.0.1', '登录系统');

-- ----------------------------
-- Table structure for hs_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `hs_admin_role`;
CREATE TABLE `hs_admin_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `ability` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '权限',
  `desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_admin_role
-- ----------------------------
INSERT INTO `hs_admin_role` VALUES (1, '测试', 'Dbd@dbdlist,Dbd@dbdadd,Dbd@dbddel,Dbd@fieldlist,Dbd@fieldadd,Dbd@fielddel,Index@home', '测试', 1618032250, 1618366236, 0);
INSERT INTO `hs_admin_role` VALUES (2, '测试2', 'Index@home', '测试2', 1618032268, 1618154801, 0);
INSERT INTO `hs_admin_role` VALUES (3, '测试3', '', '测试31', 1618036789, 1618221755, 1);

-- ----------------------------
-- Table structure for hs_article
-- ----------------------------
DROP TABLE IF EXISTS `hs_article`;
CREATE TABLE `hs_article`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章标题',
  `cat_id` int(11) NOT NULL DEFAULT 0 COMMENT '文章类型ID',
  `thum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图',
  `is_show` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',
  `abstract` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '摘要',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文章内容',
  `click` int(11) NOT NULL DEFAULT 0 COMMENT '点击量',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_article
-- ----------------------------
INSERT INTO `hs_article` VALUES (1, '第一个标题', 1, '/static/files/971-video.png', 1, '', '阿斯顿阿斯顿', '阿斯顿asd<img src=\"/static//files/614-605aa82dd5b53.jpg\" alt=\"undefined\">', 0, 1618453691, 1618454415, 0);
INSERT INTO `hs_article` VALUES (2, '第二个标题', 3, '/static/files/162-0910_avatar.png', 0, '', 'asd', 'zxccasd', 0, 1618454451, 0, 1);

-- ----------------------------
-- Table structure for hs_article_cat
-- ----------------------------
DROP TABLE IF EXISTS `hs_article_cat`;
CREATE TABLE `hs_article_cat`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级ID',
  `thum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图',
  `is_show` tinyint(4) NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `px` int(11) NULL DEFAULT 50 COMMENT '排序',
  `desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章分类' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_article_cat
-- ----------------------------
INSERT INTO `hs_article_cat` VALUES (1, '文章类型', 0, '/static/files/955-605948b8d4bd2.jpg', 1, 50, 'c测试c', 0, 1618395183, 1619142712);
INSERT INTO `hs_article_cat` VALUES (2, '测试2', 0, '/static/files/955-605948b8d4bd2.jpg', 1, 49, '测试2', 0, 1618395215, 1618448732);
INSERT INTO `hs_article_cat` VALUES (3, '测试3', 1, '', 1, 50, 'das', 0, 1618395240, 1619143880);
INSERT INTO `hs_article_cat` VALUES (4, 'asd', 3, '/static/files/955-605948b8d4bd2.jpg', 1, 50, 'asd', 1, 1618395251, 1618414249);

-- ----------------------------
-- Table structure for hs_column
-- ----------------------------
DROP TABLE IF EXISTS `hs_column`;
CREATE TABLE `hs_column`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目名称',
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '上级ID',
  `column_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目图片',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '栏目内容',
  `is_show` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `px` int(11) NOT NULL DEFAULT 50 COMMENT '排序',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '栏目表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_column
-- ----------------------------
INSERT INTO `hs_column` VALUES (1, '首页', 0, '/static/files/513-banner1.jpg', 'sad', 1, 50, 1619685741, 1619749701, 0);
INSERT INTO `hs_column` VALUES (2, '测试也', 1, '/static/files/176-goodsPIC3.png', 'asd&nbsp;', 0, 50, 1619687004, 1619688552, 1);
INSERT INTO `hs_column` VALUES (3, '购物车', 0, '/static/files/203-buy_banner.jpg', '', 1, 50, 1619749830, 0, 0);

-- ----------------------------
-- Table structure for hs_config
-- ----------------------------
DROP TABLE IF EXISTS `hs_config`;
CREATE TABLE `hs_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置的KEY名',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置的VAL名',
  `inc_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置分组',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for hs_goods
-- ----------------------------
DROP TABLE IF EXISTS `hs_goods`;
CREATE TABLE `hs_goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `cat_id` int(11) NOT NULL DEFAULT 0 COMMENT '类型ID',
  `goods_sn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编号',
  `thum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图',
  `goods_img` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品图片',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简单描述',
  `original_price` decimal(10, 2) NOT NULL DEFAULT 0.01 COMMENT '原价',
  `price` decimal(10, 2) NOT NULL DEFAULT 0.01 COMMENT '售价',
  `storage` int(11) NOT NULL DEFAULT 1 COMMENT '库存量',
  `is_pinkage` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0不包邮1包邮',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1推荐',
  `px` int(11) NOT NULL DEFAULT 999 COMMENT '排序',
  `is_show` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `sales` int(11) NOT NULL DEFAULT 0 COMMENT '销量',
  `virtual_sales` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '虚拟销量',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容介绍',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_goods
-- ----------------------------
INSERT INTO `hs_goods` VALUES (1, '第一个标题', 1, 'Goods6083b86966181', '/static/files/162-0910_avatar.png', '/static/files/196-goodsPIC2.png', '阿三大苏打', 0.02, 0.01, 1, 0, 0, 999, 1, 0, 100, '', '萨达萨达是', 1619245161, 1619763230, 1);
INSERT INTO `hs_goods` VALUES (2, '第二给标题', 2, 'Goods6083bffe35aa3', '/static/files/345-goodsPIC4.png', '/static/files/162-0910_avatar.png,/static/files/176-goodsPIC3.png,/static/files/162-0910_avatar.png,/static/files/162-0910_avatar.png', 'asdasd ', 10.00, 5.00, 10, 0, 0, 999, 1, 0, 0, '', 'zxcxz&nbsp;', 1619247102, 1619763228, 1);
INSERT INTO `hs_goods` VALUES (3, '宝宝五彩袜棉质舒服11', 4, 'ces001214', '/static/files/460-s_img2.jpg', '/static/files/460-s_img2.jpg,/static/files/460-s_img2.jpg', '啊大苏打萨达萨达阿松大', 99.00, 25.00, 1000, 0, 1, 999, 1, 0, 10, '', '<img src=\"/static//files/183-details_img2.jpg\" alt=\"undefined\">asdasd&nbsp;', 1619763546, 1619849361, 0);
INSERT INTO `hs_goods` VALUES (4, '宝宝五彩袜棉质舒服', 5, 'cs34425', '/static/files/904-new1.jpg', '/static/files/904-new1.jpg,/static/files/460-s_img2.jpg', 'sdfwe', 99.00, 12.00, 999, 1, 1, 999, 1, 0, 0, '', 'sdf', 1619763958, 1619847206, 0);
INSERT INTO `hs_goods` VALUES (5, '宝宝五彩袜棉质舒服', 5, '423423', '/static/files/618-details_img2.jpg', '/static/files/636-more3.jpg,/static/files/561-hot4.png,/static/files/174-hot3.png', 'sffsddgg', 99.00, 76.00, 1111, 0, 1, 998, 1, 0, 55, '', 'dgdfgdf', 1619764190, 1619766236, 0);
INSERT INTO `hs_goods` VALUES (6, '大撒大撒大撒', 4, '143241', '/static/files/460-s_img2.jpg', '/static/files/561-hot4.png,/static/files/460-s_img2.jpg,/static/files/904-new1.jpg', '巍峨我热胜多负少', 50.00, 10.00, 444, 0, 1, 999, 1, 0, 12, '', '撒打发', 1619764287, 1619847195, 0);
INSERT INTO `hs_goods` VALUES (7, '啊啊大苏打萨达', 3, 'asd3423', '/static/files/561-hot4.png', '/static/files/904-new1.jpg', 'sad', 50.00, 12.00, 333, 0, 1, 999, 1, 0, 18, '', 'asd', 1619766025, 1619847335, 0);
INSERT INTO `hs_goods` VALUES (8, 'asd阿三大苏打', 3, 'asdasd3', '/static/files/618-details_img2.jpg', '/static/files/460-s_img2.jpg,/static/files/618-details_img2.jpg', 'aasdas', 111.00, 44.00, 64564, 0, 1, 999, 1, 0, 88, '', 'asdas asd&nbsp;', 1619766071, 1619847307, 0);
INSERT INTO `hs_goods` VALUES (9, '撒大大asda阿松大', 3, '21313123', '/static/files/636-more3.jpg', '/static/files/618-details_img2.jpg,/static/files/174-hot3.png', 'sadasd', 99.00, 59.00, 66666, 0, 1, 999, 1, 0, 33, '', 'asdas<img src=\"/static//files/617-s_img4.jpg\" alt=\"undefined\">', 1619766141, 1619847325, 0);
INSERT INTO `hs_goods` VALUES (10, ' gfdgh撒打发士大夫', 4, '1321231', '/static/files/460-s_img2.jpg', '/static/files/460-s_img2.jpg,/static/files/561-hot4.png', 'sdfsdfsf ', 88.00, 66.00, 100000, 0, 0, 999, 1, 0, 12, '', 'sdfdfs', 1619766194, 1619847316, 0);

-- ----------------------------
-- Table structure for hs_goods_cat
-- ----------------------------
DROP TABLE IF EXISTS `hs_goods_cat`;
CREATE TABLE `hs_goods_cat`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '上级ID',
  `thum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图',
  `px` int(11) NOT NULL DEFAULT 50 COMMENT '排序',
  `is_show` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1顶置',
  `is_hot` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1热门',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品类型' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_goods_cat
-- ----------------------------
INSERT INTO `hs_goods_cat` VALUES (1, '电子设备', 0, '/static/files/162-0910_avatar.png', 50, 1, 1, 0, 1619166802, 1619763239, 1);
INSERT INTO `hs_goods_cat` VALUES (2, 'css', 1, '', 50, 1, 0, 1, 1619166891, 1619763233, 1);
INSERT INTO `hs_goods_cat` VALUES (3, '服装', 0, '/static/files/203-buy_banner.jpg', 50, 1, 0, 1, 1619763370, 1619769808, 0);
INSERT INTO `hs_goods_cat` VALUES (4, '袜子', 3, '', 50, 1, 0, 1, 1619763391, 1619764445, 0);
INSERT INTO `hs_goods_cat` VALUES (5, '儿童衣物', 3, '/static/files/232-tuan_img_banner.jpg', 50, 1, 0, 0, 1619763419, 1619769710, 0);

-- ----------------------------
-- Table structure for hs_goods_spec
-- ----------------------------
DROP TABLE IF EXISTS `hs_goods_spec`;
CREATE TABLE `hs_goods_spec`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `good_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格名称',
  `price` decimal(10, 2) NOT NULL DEFAULT 0.01 COMMENT '售价',
  `storage` int(11) NOT NULL DEFAULT 1 COMMENT '库存',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品规格' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_goods_spec
-- ----------------------------
INSERT INTO `hs_goods_spec` VALUES (1, 3, 'S码', 10.00, 99);
INSERT INTO `hs_goods_spec` VALUES (2, 3, 'M码', 9.00, 100);

-- ----------------------------
-- Table structure for hs_menus
-- ----------------------------
DROP TABLE IF EXISTS `hs_menus`;
CREATE TABLE `hs_menus`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `ico` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `controller` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制器',
  `action` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法',
  `is_show` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
  `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `del` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0正常1删除',
  `px` int(11) NOT NULL DEFAULT 99 COMMENT '排序',
  `add_date` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `rep_date` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台菜单' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of hs_menus
-- ----------------------------
INSERT INTO `hs_menus` VALUES (1, 0, '欢迎首页', 'iconfont icon-xianshiqi', 'Index', 'home', 1, '欢迎首页', 0, 120, 1617955800, 1619145155);
INSERT INTO `hs_menus` VALUES (2, 0, '系统管理', 'layui-icon layui-icon-set', '', '', 1, '系统管理', 0, 99, 1617955977, 1618407707);
INSERT INTO `hs_menus` VALUES (3, 2, '菜单管理', 'layui-icon layui-icon-spread-left', 'MenusItem', 'list', 1, '菜单管理', 0, 99, 1617956050, 1618018172);
INSERT INTO `hs_menus` VALUES (4, 2, '数据库管理', 'layui-icon layui-icon-template-1', 'Dbd', 'dbdlist', 1, '数据库管理', 0, 99, 1617957060, 1618018413);
INSERT INTO `hs_menus` VALUES (5, 6, '角色管理', 'iconfont icon-yonghu1', 'AdminRole', 'list', 1, '角色管理', 0, 99, 1618024731, 1618221738);
INSERT INTO `hs_menus` VALUES (6, 0, '权限管理', 'layui-icon layui-icon-password', '', '', 1, '权限管理', 0, 99, 1618155371, 1618407709);
INSERT INTO `hs_menus` VALUES (7, 6, '管理员', 'iconfont icon-wodeyewuyuan', 'Admin', 'list', 1, '管理员', 0, 99, 1618220806, 1618221536);
INSERT INTO `hs_menus` VALUES (8, 0, '文章管理', 'layui-icon layui-icon-list', '', '', 1, '文章管理', 0, 100, 1618388046, 1619145195);
INSERT INTO `hs_menus` VALUES (9, 8, '文章类型', 'layui-icon layui-icon-tabs', 'ArticleCat', 'list', 1, ' 文章类型', 0, 99, 1618388133, 0);
INSERT INTO `hs_menus` VALUES (10, 8, '文章列表', 'layui-icon layui-icon-read', 'Article', 'list', 1, '文章列表', 0, 99, 1618415465, 0);
INSERT INTO `hs_menus` VALUES (11, 2, '文件管理', 'layui-icon layui-icon-file-b', 'Files', 'list', 1, '文件管理', 1, 99, 1619146021, 1619148037);
INSERT INTO `hs_menus` VALUES (12, 0, '商品管理', 'iconfont icon-shangpin', '', '', 1, '商品管理', 0, 99, 1619156408, 0);
INSERT INTO `hs_menus` VALUES (13, 12, '普通商品', 'iconfont icon-shangpin', 'Goods', 'list', 1, '普通商品', 0, 99, 1619156448, 1619156507);
INSERT INTO `hs_menus` VALUES (14, 12, '商品类型', 'layui-icon layui-icon-list', 'GoodsCat', 'list', 1, '商品类型', 0, 100, 1619157279, 1619162672);
INSERT INTO `hs_menus` VALUES (15, 0, '前台管理', 'iconfont icon-shouye', '', '', 1, '前台管理', 0, 101, 1619620269, 1619620348);
INSERT INTO `hs_menus` VALUES (16, 15, '栏目管理', 'layui-icon layui-icon-slider', 'Column', 'list', 1, '栏目管理', 0, 99, 1619620327, 0);

-- ----------------------------
-- Table structure for hs_order
-- ----------------------------
DROP TABLE IF EXISTS `hs_order`;
CREATE TABLE `hs_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `order_sn` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号',
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;