-- phpMyAdmin SQL Dump -- version 4.0.10.20 -- https://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2022-03-29 14:19:10 -- 服务器版本: 5.6.42 -- PHP 版本: 5.4.45 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `szjshop` -- -- -------------------------------------------------------- -- -- 表的结构 `szj_accesss` -- CREATE TABLE IF NOT EXISTS `szj_accesss` ( `access_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '节点ID', `access_name` varchar(20) NOT NULL COMMENT '节点名称', `pid` int(10) unsigned NOT NULL COMMENT '上级ID', `router_path` varchar(255) NOT NULL COMMENT '跳转地址', `router_name` varchar(100) NOT NULL COMMENT '节点路由 对应vue路由', `access_icon` varchar(30) NOT NULL COMMENT '节点图标', `access_sort` int(10) unsigned NOT NULL COMMENT '节点排序', `level` tinyint(1) unsigned NOT NULL COMMENT '节点等级', `is_nav` tinyint(1) unsigned NOT NULL COMMENT '是否导航节点', `admin_id` int(10) unsigned NOT NULL COMMENT '操作管理员', `access_status` tinyint(1) unsigned NOT NULL COMMENT '节点状态', `vuecomponent` varchar(255) NOT NULL COMMENT '加载页面', `mobile_show` tinyint(1) unsigned NOT NULL COMMENT '移动端是否显示', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '变动时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`access_id`), KEY `is_nav` (`is_nav`,`access_status`), KEY `mobile_show` (`mobile_show`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理节点' AUTO_INCREMENT=90 ; -- -- 转存表中的数据 `szj_accesss` -- INSERT INTO `szj_accesss` (`access_id`, `access_name`, `pid`, `router_path`, `router_name`, `access_icon`, `access_sort`, `level`, `is_nav`, `admin_id`, `access_status`, `vuecomponent`, `mobile_show`, `update_time`, `create_time`) VALUES (1, '系统管理', 0, '', 'system', '', 10, 1, 1, 17, 1, '', 1, '2022-02-19 09:48:20', '2020-10-23 17:01:01'), (2, '权限管理', 1, '', 'system_auth', '', 10, 2, 1, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-23 17:02:20'), (3, '管理员列表', 2, 'users', 'admin_user', '', 5, 3, 1, 1, 1, 'adminUser.vue', 1, '2022-02-19 09:48:20', '2020-10-23 17:02:37'), (4, '角色列表', 2, 'roles', 'admin_role', '', 15, 3, 1, 1, 1, 'roles.vue', 1, '2022-02-19 09:48:20', '2020-10-23 17:03:00'), (5, '权限节点', 2, 'access', 'admin_access', '', 20, 3, 1, 1, 1, 'accesss.vue', 0, '2022-02-19 09:48:20', '2020-10-23 17:43:57'), (8, '添加管理员', 2, '', 'create_admin_user', '', 6, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 11:14:15'), (9, '编辑管理员', 2, '', 'update_admin_user', '', 7, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 11:15:23'), (10, '删除管理员', 2, '', 'delete_admin_user', '', 8, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 11:16:10'), (11, '添加权限节点', 2, '', 'create_admin_access', '', 21, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2020-10-26 12:24:13'), (12, '编辑权限节点', 2, '', 'update_admin_access', '', 22, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2020-10-26 12:43:23'), (13, '删除权限节点', 2, '', 'delete_admin_access', '', 23, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2020-10-26 14:21:54'), (23, '添加角色', 2, '', 'create_admin_role', '', 16, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 17:15:52'), (24, '编辑角色', 2, '', 'update_admin_role', '', 17, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 17:17:12'), (25, '删除角色', 2, '', 'delete_admin_role', '', 18, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 17:17:34'), (26, '角色授权', 2, '', 'admin_role_access', '', 19, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-26 17:18:18'), (27, '配置管理', 1, '', 'configs', '', 15, 2, 1, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-29 18:28:45'), (28, '配置列表', 27, 'configs', 'config_list', '', 5, 3, 1, 1, 1, 'configs.vue', 1, '2022-02-19 09:48:20', '2020-10-29 18:30:02'), (29, '配置设置', 27, 'confset', 'config_setting', '', 15, 3, 1, 1, 1, 'confset.vue', 1, '2022-02-19 09:48:20', '2020-10-29 18:30:56'), (30, '添加配置', 27, '', 'create_config', '', 6, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-31 13:57:59'), (31, '编辑配置', 27, '', 'update_config', '', 7, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-31 13:58:31'), (32, '删除配置', 27, '', 'delete_config', '', 8, 3, 0, 1, 1, '', 1, '2022-02-19 09:48:20', '2020-10-31 13:59:00'), (45, '文章管理', 1, '', 'articles', '', 20, 2, 1, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 18:56:26'), (46, '文章列表', 45, 'articles', 'article_index', '', 5, 3, 1, 1, 1, 'articles.vue', 0, '2022-02-19 09:48:20', '2021-05-25 18:57:30'), (47, '文章分类', 45, 'articles/category', 'article_category', '', 10, 3, 1, 1, 1, 'articlesCategory.vue', 0, '2022-02-19 09:48:20', '2021-05-25 18:57:58'), (48, '添加文章', 45, '', 'create_article', '', 6, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:05:25'), (49, '更新文章', 45, '', 'update_article', '', 7, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:05:59'), (50, '删除文章', 45, '', 'delete_article', '', 8, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:06:35'), (51, '添加文章分类', 45, '', 'create_article_category', '', 11, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:10:38'), (52, '更新文章分类', 45, '', 'update_article_category', '', 12, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:11:10'), (53, '删除文章分类', 45, '', 'delete_article_category', '', 13, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2021-05-25 19:11:45'), (55, '商城管理', 0, '', 'shops', '', 5, 1, 1, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-01-17 12:12:15'), (58, '商品管理', 55, '', 'shopsProduct', '', 10, 2, 1, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:35:21'), (59, '商品列表', 58, 'shops/productList', 'select_products', '', 10, 3, 1, 1, 1, 'shops/products.vue', 0, '2022-02-19 09:48:20', '2022-02-09 11:36:46'), (60, '商品分类', 58, 'shops/productCategory', 'select_product_category', '', 20, 3, 1, 1, 1, 'shops/productCategory.vue', 0, '2022-02-19 09:48:20', '2022-02-09 11:37:43'), (61, '商品类型', 58, 'shops/productTypes', 'select_product_types', '', 30, 3, 1, 1, 1, 'shops/productTypes.vue', 0, '2022-02-19 09:48:20', '2022-02-09 11:38:39'), (62, '供货商列表', 58, 'shops/productSuppliers', 'select_product_suppliers', '', 40, 3, 1, 1, 1, 'shops/productSuppliers.vue', 0, '2022-02-19 09:48:20', '2022-02-09 11:39:37'), (63, '添加商品', 58, '', 'create_products', '', 12, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:41:10'), (64, '更新商品', 58, '', 'update_products', '', 14, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:41:40'), (65, '删除商品', 58, '', 'delete_products', '', 16, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:42:03'), (66, '添加商品分类', 58, '', 'create_product_category', '', 22, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:43:24'), (67, '更新商品分类', 58, '', 'update_product_category', '', 24, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:43:47'), (68, '删除商品分类', 58, '', 'delete_product_category', '', 26, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:44:15'), (69, '添加商品类型', 58, '', 'create_product_types', '', 32, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:44:45'), (70, '更新商品类型', 58, '', 'update_product_types', '', 34, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:45:08'), (71, '删除商品类型', 58, '', 'delete_product_types', '', 36, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:45:39'), (72, '添加供货商', 58, '', 'create_product_suppliers', '', 42, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:46:29'), (73, '更新供货商', 58, '', 'update_product_suppliers', '', 44, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:47:01'), (74, '删除供货商', 58, '', 'delete_product_suppliers', '', 46, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-09 11:47:26'), (75, '商品类型属性', 58, 'shops/productTypesItem', 'select_product_types_item', '', 50, 3, 0, 1, 1, 'shops/productTypesItem.vue', 0, '2022-02-19 09:48:20', '2022-02-12 15:24:25'), (78, '订单管理', 55, '', 'shopOrders', '', 20, 2, 1, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-17 09:19:54'), (79, '订单列表', 78, 'shops/OrderList', 'select_orders', '', 10, 3, 1, 1, 1, 'shops/orderList.vue', 0, '2022-02-19 09:48:20', '2022-02-17 09:20:52'), (80, '订单详情', 78, 'shops/orderInfo', 'select_orders_info', '', 15, 3, 0, 1, 1, 'shops/orderInfo.vue', 0, '2022-02-19 09:48:20', '2022-02-18 16:35:42'), (81, '商城配置', 55, '', 'shopsConfig', '', 30, 2, 1, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:08:11'), (82, '支付配置', 81, 'shops/paysConfig', 'select_pays_config', '', 10, 3, 1, 1, 1, 'shops/paysConfig.vue', 0, '2022-02-19 09:48:20', '2022-02-19 10:09:01'), (83, '添加支付配置', 81, '', 'create_pays_config', '', 12, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:09:35'), (84, '更新支付配置', 81, '', 'update_pays_config', '', 14, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:10:08'), (85, '删除支付配置', 81, '', 'delete_pays_config', '', 16, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:10:35'), (86, '配送方式', 81, 'shops/shippingsConfig', 'select_shippings_config', '', 20, 3, 1, 1, 1, 'shops/shippingsConfig.vue', 0, '2022-02-19 09:48:20', '2022-02-19 10:11:37'), (87, '添加配送方式', 81, '', 'create_shippings_config', '', 22, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:12:10'), (88, '更新配送方式', 81, '', 'update_shippings_config', '', 24, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:12:38'), (89, '删除配送方式', 81, '', 'delete_shippings_config', '', 26, 3, 0, 1, 1, '', 0, '2022-02-19 09:48:20', '2022-02-19 10:13:07'); -- -------------------------------------------------------- -- -- 表的结构 `szj_access_role` -- CREATE TABLE IF NOT EXISTS `szj_access_role` ( `role_id` int(10) unsigned NOT NULL COMMENT '角色ID', `access_id` varchar(5000) NOT NULL COMMENT '节点ID', PRIMARY KEY (`role_id`), KEY `access_id` (`access_id`(255)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限节点'; -- -- 转存表中的数据 `szj_access_role` -- INSERT INTO `szj_access_role` (`role_id`, `access_id`) VALUES (1, '1,2,3,8,9,10,4,23,24,25,26,5,11,12,13,27,28,30,31,32,29,45,46,48,49,50,47,51,52,53'), (3, '1,2,3,4,5,27,28,45,46,48,47,52'); -- -------------------------------------------------------- -- -- 表的结构 `szj_address` -- CREATE TABLE IF NOT EXISTS `szj_address` ( `address_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '地址ID', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `uname` varchar(255) NOT NULL COMMENT '收货人姓名', `mobile` varchar(11) NOT NULL COMMENT '收货人电话', `province_id` int(10) unsigned NOT NULL COMMENT '所在省ID', `province_name` varchar(255) NOT NULL COMMENT '所在省名称', `city_id` int(10) unsigned NOT NULL COMMENT '所在市ID', `city_name` varchar(255) NOT NULL COMMENT '所在市名称', `county_id` int(10) unsigned NOT NULL COMMENT '所在县ID', `county_name` varchar(255) NOT NULL COMMENT '所在县名称', `address` varchar(255) NOT NULL COMMENT '地址详情', `is_use` tinyint(1) unsigned NOT NULL COMMENT '是否使用', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`address_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收货地址表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_address` -- INSERT INTO `szj_address` (`address_id`, `user_id`, `uname`, `mobile`, `province_id`, `province_name`, `city_id`, `city_name`, `county_id`, `county_name`, `address`, `is_use`, `update_time`, `create_time`) VALUES (4, 1, '一个小哥', '15219840108', 440000, '广东省', 441600, '河源市', 441602, '源城区', '宝源学校公交车站', 1, '2022-03-26 12:03:57', '2022-03-18 17:06:49'), (5, 1, '罗生', '15219840108', 510000, '四川省', 510700, '绵阳市', 510722, '三台县', '刘营镇7村二组', 0, '2022-03-26 12:03:51', '2022-03-22 09:30:24'), (6, 2, '罗勇', '15219840108', 440000, '广东省', 441600, '河源市', 441602, '源城区', '永福农贸中心市场三楼', 1, '2022-03-29 02:58:20', '2022-03-29 10:57:35'); -- -------------------------------------------------------- -- -- 表的结构 `szj_admin_user` -- CREATE TABLE IF NOT EXISTS `szj_admin_user` ( `admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID', `username` varchar(20) NOT NULL, `password` varchar(255) NOT NULL, `role_id` int(10) unsigned NOT NULL, `admin_status` tinyint(1) unsigned NOT NULL, `login_ip` varchar(15) NOT NULL, `login_time` datetime NOT NULL, `login_count` int(10) unsigned NOT NULL COMMENT '登录次数', `admin_token` varchar(255) NOT NULL, `admin_code` char(6) NOT NULL, `other_auth` varchar(255) NOT NULL, `action_user` int(10) unsigned NOT NULL COMMENT '操作user_id', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '变动时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`admin_id`), KEY `role_id` (`role_id`), KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台管理员' AUTO_INCREMENT=18 ; -- -- 转存表中的数据 `szj_admin_user` -- INSERT INTO `szj_admin_user` (`admin_id`, `username`, `password`, `role_id`, `admin_status`, `login_ip`, `login_time`, `login_count`, `admin_token`, `admin_code`, `other_auth`, `action_user`, `update_time`, `create_time`) VALUES (1, 'szjcomo', '4a4232bf90b84f41223e88eb06895b21', 0, 1, '127.0.0.1', '2022-03-29 09:07:18', 230, '', 'abcd', '', 1, '2022-03-29 01:07:57', '2020-10-22 18:43:14'), (13, '宁晓欣', '079d3d19737fa31306abac3064cf6916', 1, 1, '192.168.1.222', '2021-03-01 17:24:11', 2, '', '3844', '', 1, '2021-12-16 04:10:15', '2021-03-01 17:19:17'), (17, '天地乾坤', 'a09b8ad35c7decf3addba761edc154e4', 1, 1, '192.168.1.158', '2022-01-20 18:56:53', 16, '', '5393', '', 1, '2022-03-19 10:09:32', '2021-12-16 15:46:52'); -- -------------------------------------------------------- -- -- 表的结构 `szj_articles` -- CREATE TABLE IF NOT EXISTS `szj_articles` ( `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章ID', `article_title` varchar(200) NOT NULL COMMENT '文章标题', `article_desc` varchar(255) NOT NULL COMMENT '文章描述', `article_content` text NOT NULL COMMENT '文章内容', `article_image` varchar(255) NOT NULL COMMENT '封面图片', `article_type` tinyint(1) unsigned NOT NULL COMMENT '文章类型 0文章 1视频', `category_id` int(10) unsigned NOT NULL COMMENT '分类ID', `article_tags` varchar(255) NOT NULL COMMENT '文章标签,多个用逗号隔开', `article_status` tinyint(1) unsigned NOT NULL COMMENT '文章状态', `article_author` varchar(100) NOT NULL COMMENT '文章作者', `article_views` int(10) unsigned NOT NULL COMMENT '浏览次数', `article_template_info` varchar(255) NOT NULL COMMENT '文章详情模版', `article_recommend` tinyint(1) unsigned NOT NULL COMMENT '文章推荐 0不推荐 1推荐', `article_template_list` varchar(255) NOT NULL COMMENT '文章列表模版', `article_sort` int(10) unsigned NOT NULL COMMENT '文章排序', `view_auth` tinyint(1) unsigned NOT NULL COMMENT '0 所有人 1超管', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`article_id`), KEY `category_id` (`category_id`), KEY `article_status` (`article_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章表' AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `szj_articles` -- INSERT INTO `szj_articles` (`article_id`, `article_title`, `article_desc`, `article_content`, `article_image`, `article_type`, `category_id`, `article_tags`, `article_status`, `article_author`, `article_views`, `article_template_info`, `article_recommend`, `article_template_list`, `article_sort`, `view_auth`, `admin_id`, `update_time`, `create_time`) VALUES (2, '发表第一篇文章', '', '
如何搭配长春花蓝
Good times
01

透过暖色调及冷色调的搭配运用，达到互相补强的效果，有活力。

融合大自然色调，突出绿色与温和的PANTONE 17-3938的兼容性。

围绕着所有蓝色色调中最快乐和最温暖的色调，搭配经典和中性色调。


', 'http://attachs.sizhijie.com/szjkj-common-oss/a9473cab62a3de960c0f982927241d02fe000d99.png', 0, 1, '', 1, '', 10, '', 0, '', 99, 0, 1, '2022-01-17 03:06:37', '2021-12-18 18:57:48'), (3, '发表第二篇文章', '', '
工作成果与亮点

01
长春花蓝搭配技巧

透过暖色调及冷色调的搭配运用，达到互相补强的效果，有活力。

02
长春花蓝搭配技巧

透过暖色调及冷色调的搭配运用，达到互相补强的效果，有活力。

03
长春花蓝搭配技巧

透过暖色调及冷色调的搭配运用，达到互相补强的效果，有活力。


', 'http://attachs.sizhijie.com/szjkj-common-oss/71ef9c02dc55929b0d5c29e3ea37f5c3216eb911.jpeg', 0, 1, '', 1, '', 10, '', 0, '', 99, 0, 1, '2022-01-17 03:06:06', '2021-12-18 19:01:59'); -- -------------------------------------------------------- -- -- 表的结构 `szj_articles_category` -- CREATE TABLE IF NOT EXISTS `szj_articles_category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `category_name` varchar(200) NOT NULL COMMENT '分类名称', `category_desc` varchar(255) NOT NULL COMMENT '分类描述', `category_image` varchar(255) NOT NULL COMMENT '分类图片', `pid` int(10) unsigned NOT NULL COMMENT '上级id', `category_sort` int(10) unsigned NOT NULL COMMENT '分类排序', `category_status` tinyint(1) unsigned NOT NULL COMMENT '分类状态', `category_level` tinyint(1) unsigned NOT NULL COMMENT '分类等级', `category_recommend` tinyint(1) unsigned NOT NULL COMMENT '是否推荐', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '添加时间', PRIMARY KEY (`category_id`), KEY `category_status` (`category_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_articles_category` -- INSERT INTO `szj_articles_category` (`category_id`, `category_name`, `category_desc`, `category_image`, `pid`, `category_sort`, `category_status`, `category_level`, `category_recommend`, `admin_id`, `update_time`, `create_time`) VALUES (1, '测试分类', '', 'http://attachs.sizhijie.com/szjkj-common-oss/36f609a1e4c56beee5a00982f802bdc682a99f2a.jpeg', 0, 99, 1, 1, 0, 1, '2021-12-21 03:34:31', '2021-08-08 18:57:42'), (3, '市教育局', '', 'http://attachs.sizhijie.com/szjkj-common-oss/61e036fbe8e8cacd8d0f5654b24191fc41c0795c.png', 0, 99, 1, 1, 0, 1, '2021-12-21 03:37:33', '2021-12-18 17:56:36'), (4, '源城区教育局', '', '', 3, 99, 1, 2, 0, 1, '2022-01-17 03:57:55', '2021-12-18 17:57:16'), (5, '江东新区教育办', '', '', 3, 99, 1, 2, 0, 1, '2021-12-18 09:59:03', '2021-12-18 17:58:06'), (6, '紫金县教育局', '', '', 3, 99, 1, 2, 0, 1, '2021-12-18 09:59:25', '2021-12-18 17:58:28'); -- -------------------------------------------------------- -- -- 表的结构 `szj_carts` -- CREATE TABLE IF NOT EXISTS `szj_carts` ( `cart_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '购物车ID', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `product_count` int(10) unsigned NOT NULL COMMENT '商品数量', `is_select` tinyint(1) unsigned NOT NULL COMMENT '是否选中', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `random_key` varchar(10) NOT NULL COMMENT '随机数', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`cart_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户购物车表' AUTO_INCREMENT=86 ; -- -------------------------------------------------------- -- -- 表的结构 `szj_collects` -- CREATE TABLE IF NOT EXISTS `szj_collects` ( `collect_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '收藏ID', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`collect_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户收藏表' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的结构 `szj_configs` -- CREATE TABLE IF NOT EXISTS `szj_configs` ( `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID', `field_index` varchar(100) NOT NULL COMMENT '索引字段', `field_type` varchar(20) NOT NULL COMMENT '字段类型仅支持[text,textarea,number,switch,datetime,image,images]', `field_label` varchar(20) NOT NULL COMMENT '表单label', `field_group` varchar(50) NOT NULL COMMENT '所属分组', `field_options` varchar(255) NOT NULL COMMENT '其它选项', `field_desc` varchar(50) NOT NULL COMMENT '提示文字', `field_status` tinyint(1) unsigned NOT NULL COMMENT '配置状态', `field_value` text NOT NULL COMMENT '字段值', `field_sort` int(10) unsigned NOT NULL COMMENT '配置排序', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`config_id`), KEY `config_name` (`field_index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置设置' AUTO_INCREMENT=25 ; -- -- 转存表中的数据 `szj_configs` -- INSERT INTO `szj_configs` (`config_id`, `field_index`, `field_type`, `field_label`, `field_group`, `field_options`, `field_desc`, `field_status`, `field_value`, `field_sort`, `admin_id`, `update_time`, `create_time`) VALUES (1, 'system_group', 'textarea', '总配置组', 'website', '', '请输入系统总配置分组项', 1, 'website|系统设置\nwechat|微信配置\nthird_party|思智捷服务', 1, 1, '2022-03-28 08:54:45', '2020-10-24 12:11:57'), (2, 'website_title', 'text', '商城名称', 'website', '', '请输入商城名称', 1, '思智捷科技数据管理系统', 2, 1, '2022-03-28 01:56:16', '2020-10-24 13:43:35'), (8, 'home_swipers', 'images', '首页轮播', 'website', '', '请配置商城首页轮播图', 1, 'http://attachs.sizhijie.com/szjkj-common-oss/bcb2e93e3f7fcbc4ea8d4df9f23dc83e60b21504.jpg', 4, 1, '2022-03-28 01:57:28', '2020-10-31 14:15:06'), (11, 'editor_templates_uri', 'text', '编辑器模版接口', 'third_party', '', '请输入思智捷科技提供的编辑器模版调用接口地址', 1, 'https://apis.sizhijie.com/templates/list', 5, 1, '2022-03-28 08:59:03', '2021-01-14 10:37:52'), (13, 'files_upload_uri', 'text', '资料上传域名', 'third_party', '', '请配置思智捷科技提供的图片文件上传的域名', 1, 'https://apis.sizhijie.com/oss/v1/upload?identity=eyJkYXRhIjp7InVzZXiOjE0LCJ1c2VyXZGUiOiJtWHJYVloifX0=JfaWQ2Nv', 4, 1, '2022-03-28 08:59:21', '2021-08-09 19:05:14'), (14, 'image_ocr_uri', 'text', '图像识别域名', 'third_party', '', '请配置思智捷科技图像识别调用接口地址', 1, 'https://apis.sizhijie.com', 6, 1, '2022-03-28 08:58:45', '2021-08-09 19:06:17'), (15, 'wechat_account_appid', 'text', '公众号appid', 'wechat', '', '请输入微信公众号appid', 1, 'wx6aab892e5b7b6023', 10, 1, '2022-03-28 07:54:02', '2022-03-28 09:51:19'), (16, 'wechat_account_secret', 'text', '公众号secret', 'wechat', '', '微信公众号secret', 1, 'b000a5a1d69925397b6725db34879167', 15, 1, '2022-03-28 07:54:02', '2022-03-28 09:52:14'), (17, 'wechat_account_token', 'text', '公众号token', 'wechat', '', '请配置微信公众号通信的token', 1, 'szjcomo2022', 20, 1, '2022-03-28 07:55:07', '2022-03-28 09:54:56'), (18, 'wechat_account_jsapi_uri', 'text', '页面调用地址', 'wechat', '', '请配置公众号JSAPI页面调用地址', 1, 'http://test.enroll.sizhijie.com/#/shop/home', 25, 1, '2022-03-28 06:54:52', '2022-03-28 11:47:01'), (19, 'wechat_account_jsapi_list', 'text', '公众号JS接口', 'wechat', '', '请配置微信公众号jsapi需要调用的接口列表,用,号隔开', 1, 'chooseWXPay,updateTimelineShareData,updateAppMessageShareData,chooseImage', 30, 1, '2022-03-28 06:56:49', '2022-03-28 11:48:51'), (20, 'wechat_account_jsapi_debug', 'radio', '公众号js调试', 'wechat', '[{"name":"开启","value":1},{"name":"关闭","value":0}]', '是否开启微信公众号jsapi调试模式', 1, '0', 35, 1, '2022-03-28 08:15:02', '2022-03-28 11:49:57'), (21, 'wechat_pay_token', 'text', '微信支付赁证', 'third_party', '', '请配置思智捷科技提供的微信支付调用赁证', 1, 'eyJkYXRhIjp7InVzZXJfaWQiOjMsImNJiaGhGSGEiLCJ1c2VyX3R5cGUiInBheV90eXBlIjoxfX0=vZGUiOiOjAs', 10, 1, '2022-03-29 02:35:59', '2022-03-28 16:55:14'), (22, 'wechat_pay_domain', 'text', '微信支付域名', 'third_party', '', '请配置思智捷科技提供的微信支付调用的域名', 1, 'https://apis.sizhijie.com', 15, 1, '2022-03-28 08:58:24', '2022-03-28 16:56:53'), (23, 'wechat_pay_callback', 'text', '支付回调地址', 'wechat', '', '请配置微信支付后回调通知地址', 1, 'http://test.enroll.sizhijie.com/oneshop/wechat/pay/callbck', 40, 1, '2022-03-28 09:15:09', '2022-03-28 17:03:31'), (24, 'wechat_pay_key', 'text', '微信支付密钥', 'wechat', '', '请配置微信支付密钥', 1, '4f85c69db495f09529b69947adddb0ee', 45, 1, '2022-03-29 02:44:14', '2022-03-29 10:43:17'); -- -------------------------------------------------------- -- -- 表的结构 `szj_orders` -- CREATE TABLE IF NOT EXISTS `szj_orders` ( `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID', `order_sn` char(22) NOT NULL COMMENT '订单号', `order_status` tinyint(3) unsigned NOT NULL COMMENT '订单状态 0待付款 1 待发货 2待收货 3待评价 4已完成 6已关闭', `pay_sn` varchar(255) NOT NULL COMMENT '支付单号', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `order_amount` float(10,2) unsigned NOT NULL COMMENT '实际支付总金额', `user_remarks` varchar(255) NOT NULL COMMENT '用户备注说明', `seller_remarks` varchar(255) NOT NULL COMMENT '卖家备注', `consignee` varchar(255) NOT NULL COMMENT '收货人姓名', `province_id` int(10) unsigned NOT NULL COMMENT '收货省份ID', `city_id` int(10) unsigned NOT NULL COMMENT '收货城市ID', `county_id` int(10) unsigned NOT NULL COMMENT '收货县/区ID', `address` varchar(255) NOT NULL COMMENT '详细地址', `mobile` varchar(255) NOT NULL COMMENT '收货人电话', `shipping_id` int(10) unsigned NOT NULL COMMENT '用户选择的配送方式', `pay_id` int(10) unsigned NOT NULL COMMENT '用户选择的支付方式', `shipping_fee` float(10,2) unsigned NOT NULL COMMENT '配送费用', `surplus_amout` float(10,2) unsigned NOT NULL COMMENT '余额使用金额', `activity_id` int(11) NOT NULL COMMENT '全局活动ID', `activity_name` varchar(255) NOT NULL COMMENT '活动名称', `activity_desc` varchar(255) NOT NULL COMMENT '全局活动名称', `is_urge` tinyint(3) unsigned NOT NULL COMMENT '是否催发货 及催发货次数', `is_express` tinyint(1) unsigned NOT NULL COMMENT '是否需要快递', `express_sn` varchar(255) NOT NULL COMMENT '快递单号', `express_id` int(10) unsigned NOT NULL COMMENT '快递公司ID', `deliver_desc` varchar(255) NOT NULL COMMENT '发货说明', `deliver_time` datetime NOT NULL COMMENT '发货时间', `query_time` datetime NOT NULL COMMENT '用户确认收货时间', `success_time` datetime NOT NULL COMMENT '交易完成时间', `create_time` datetime NOT NULL COMMENT '订单创建时间', PRIMARY KEY (`order_id`), KEY `user_id` (`user_id`), KEY `shipping_id` (`shipping_id`), KEY `pay_id` (`pay_id`), KEY `order_sn` (`order_sn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表' AUTO_INCREMENT=21 ; -- -- 转存表中的数据 `szj_orders` -- INSERT INTO `szj_orders` (`order_id`, `order_sn`, `order_status`, `pay_sn`, `user_id`, `order_amount`, `user_remarks`, `seller_remarks`, `consignee`, `province_id`, `city_id`, `county_id`, `address`, `mobile`, `shipping_id`, `pay_id`, `shipping_fee`, `surplus_amout`, `activity_id`, `activity_name`, `activity_desc`, `is_urge`, `is_express`, `express_sn`, `express_id`, `deliver_desc`, `deliver_time`, `query_time`, `success_time`, `create_time`) VALUES (1, 'W20220326185442388300', 4, 'Y2022032618544201158', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 1194.00, 0, '', '', 1, 2, '', 0, '您买的商品已经发货,请保持联系电话畅通!', '2022-03-26 18:58:40', '2022-03-26 19:58:34', '2022-03-27 15:46:40', '2022-03-26 18:54:42'), (2, 'W20220326194826633052', 4, 'Y2022032619482601458', 1, 8202.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 8202.00, 0, '', '', 2, 2, '', 0, '订单已发货,请保持联系电话畅通', '2022-03-26 19:50:33', '2022-03-26 19:58:24', '2022-03-27 15:44:48', '2022-03-26 19:48:26'), (3, 'W20220327162022356741', 4, 'Y2022032716202201572', 1, 5622.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 5622.00, 0, '', '', 0, 2, '', 0, '已发货', '2022-03-27 19:02:54', '2022-03-27 19:03:06', '2022-03-27 19:04:34', '2022-03-27 16:20:22'), (4, 'W20220327164943407064', 4, 'Y2022032716494301393', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 1194.00, 0, '', '', 0, 2, '', 0, '已发货,请保持联系电话畅通', '2022-03-27 16:51:20', '2022-03-27 16:51:44', '2022-03-27 16:53:49', '2022-03-27 16:49:43'), (5, 'W20220327165558763224', 6, '', 1, 1598.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 50.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 16:55:58'), (6, 'W20220327190139130299', 6, '', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 50.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 19:01:39'), (7, 'W20220327191130219379', 6, '', 1, 3594.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 19:11:30'), (9, 'W20220327191744723029', 6, '', 1, 799.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 19:17:44'), (10, 'W20220327191845258781', 6, '', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 19:18:45'), (11, 'W20220327202657633061', 6, '', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 20:26:57'), (12, 'W20220327202803123126', 2, 'Y2022032720280301855', 1, 1194.00, '', '', '一个小哥', 440000, 441600, 441602, '广东省河源市源城区宝源学校公交车站', '15219840108', 0, 1, 0.00, 1194.00, 0, '', '', 1, 2, '', 0, '订单已发货,请电话畅通', '2022-03-27 20:29:48', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-27 20:28:03'), (13, 'W20220329105750596109', 0, '', 2, 1194.00, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 10.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 10:57:50'), (14, 'W20220329110647161176', 0, '', 2, 1194.00, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:06:47'), (15, 'W20220329110814138579', 0, '', 2, 1194.00, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:08:14'), (16, 'W20220329111244202920', 0, '', 2, 1194.00, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:12:44'), (17, 'W20220329111843291657', 0, '', 2, 1194.00, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:18:43'), (18, 'W20220329112531761799', 0, '', 2, 0.10, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:25:31'), (19, 'W20220329112605646837', 0, '', 2, 0.10, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:26:05'), (20, 'W20220329113057244351', 0, '', 2, 0.10, '', '', '罗勇', 440000, 441600, 441602, '广东省河源市源城区永福农贸中心市场三楼', '15219840108', 0, 1, 0.00, 0.00, 0, '', '', 0, 0, '', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2022-03-29 11:30:57'); -- -------------------------------------------------------- -- -- 表的结构 `szj_orders_action` -- CREATE TABLE IF NOT EXISTS `szj_orders_action` ( `action_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `order_id` int(10) unsigned NOT NULL COMMENT '订单ID', `action_desc` varchar(255) NOT NULL COMMENT '操作描述', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单操作记录表' AUTO_INCREMENT=26 ; -- -- 转存表中的数据 `szj_orders_action` -- INSERT INTO `szj_orders_action` (`action_id`, `admin_id`, `order_id`, `action_desc`, `update_time`, `create_time`) VALUES (1, 0, 1, '用户催发货', '2022-03-26 10:56:28', '2022-03-26 18:56:21'), (2, 1, 1, '订单发货', '2022-03-26 10:58:47', '2022-03-26 18:58:40'), (3, 0, 2, '用户催发货', '2022-03-26 11:49:59', '2022-03-26 19:49:53'), (4, 0, 2, '用户催发货', '2022-03-26 11:50:05', '2022-03-26 19:49:59'), (5, 1, 2, '订单发货', '2022-03-26 11:50:39', '2022-03-26 19:50:33'), (6, 0, 2, '用户已收货', '2022-03-26 11:58:31', '2022-03-26 19:58:24'), (7, 0, 1, '用户已收货', '2022-03-26 11:58:40', '2022-03-26 19:58:34'), (8, 0, 2, '商品进行评价', '2022-03-27 07:30:40', '2022-03-27 15:30:34'), (9, 0, 2, '商品进行评价', '2022-03-27 07:44:54', '2022-03-27 15:44:48'), (10, 0, 1, '商品进行评价', '2022-03-27 07:46:46', '2022-03-27 15:46:40'), (11, 1, 4, '订单发货', '2022-03-27 08:51:26', '2022-03-27 16:51:20'), (12, 0, 4, '用户已收货', '2022-03-27 08:51:49', '2022-03-27 16:51:44'), (13, 0, 4, '商品进行评价', '2022-03-27 08:53:55', '2022-03-27 16:53:49'), (14, 0, 6, '用户取消订单', '2022-03-27 11:02:23', '2022-03-27 19:02:17'), (15, 0, 5, '用户取消订单', '2022-03-27 11:02:29', '2022-03-27 19:02:23'), (16, 1, 3, '订单发货', '2022-03-27 11:03:00', '2022-03-27 19:02:54'), (17, 0, 3, '用户已收货', '2022-03-27 11:03:11', '2022-03-27 19:03:06'), (18, 0, 3, '商品进行评价', '2022-03-27 11:03:47', '2022-03-27 19:03:41'), (19, 0, 3, '商品进行评价', '2022-03-27 11:04:40', '2022-03-27 19:04:34'), (20, 0, 7, '用户取消订单', '2022-03-27 11:16:43', '2022-03-27 19:16:37'), (21, 0, 9, '用户取消订单', '2022-03-27 11:18:11', '2022-03-27 19:18:06'), (22, 0, 10, '用户取消订单', '2022-03-27 11:19:17', '2022-03-27 19:19:11'), (23, 0, 11, '用户取消订单', '2022-03-27 12:27:36', '2022-03-27 20:27:30'), (24, 0, 12, '用户催发货', '2022-03-27 12:29:26', '2022-03-27 20:29:20'), (25, 1, 12, '订单发货', '2022-03-27 12:29:54', '2022-03-27 20:29:48'); -- -------------------------------------------------------- -- -- 表的结构 `szj_orders_products` -- CREATE TABLE IF NOT EXISTS `szj_orders_products` ( `rec_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `order_id` int(10) unsigned NOT NULL COMMENT '订单ID', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `product_name` varchar(255) NOT NULL COMMENT '商品名称', `product_image` varchar(255) NOT NULL COMMENT '商品图片', `product_count` int(10) unsigned NOT NULL COMMENT '商品数量', `shop_price` float(10,2) unsigned NOT NULL COMMENT '商品价格', `goods_type` tinyint(1) unsigned NOT NULL COMMENT '商品类型', `activity_id` int(10) unsigned NOT NULL COMMENT '活动ID', `activity_name` varchar(255) NOT NULL COMMENT '活动名称', `activity_desc` varchar(255) NOT NULL COMMENT '活动描述', `is_deliver` tinyint(1) unsigned NOT NULL COMMENT '是否已发货', `deliver_count` int(10) unsigned NOT NULL COMMENT '发货数量', `total_price` float(10,2) unsigned NOT NULL COMMENT '小计金额', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`rec_id`), KEY `order_id` (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单商品表' AUTO_INCREMENT=23 ; -- -- 转存表中的数据 `szj_orders_products` -- INSERT INTO `szj_orders_products` (`rec_id`, `order_id`, `product_id`, `product_name`, `product_image`, `product_count`, `shop_price`, `goods_type`, `activity_id`, `activity_name`, `activity_desc`, `is_deliver`, `deliver_count`, `total_price`, `create_time`) VALUES (1, 1, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 2, 1194.00, 1, 0, '', '', 1, 1, 1194.00, '2022-03-26 18:54:42'), (2, 2, 5, '贵州茅台醇1998柔和酱香型白酒53度高度纯粮食酒水500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/ce4acb695a79c3bb148395c375babbc5d60fc635.jpeg', 1, 2214.00, 1, 0, '', '', 1, 1, 2214.00, '2022-03-26 19:48:26'), (3, 2, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 1, 1, 1194.00, '2022-03-26 19:48:26'), (4, 2, 1, '茅台醇天青柔和酱香型白酒53度500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/3197e529c82e18d911510c974936e33e4dc27786.jpeg', 1, 4794.00, 1, 0, '', '', 1, 1, 4794.00, '2022-03-26 19:48:26'), (5, 3, 5, '贵州茅台醇1998柔和酱香型白酒53度高度纯粮食酒水500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/ce4acb695a79c3bb148395c375babbc5d60fc635.jpeg', 2, 2214.00, 1, 0, '', '', 1, 2, 4428.00, '2022-03-27 16:20:22'), (6, 3, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 1, 1, 1194.00, '2022-03-27 16:20:22'), (7, 4, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 1, 1, 1194.00, '2022-03-27 16:49:43'), (8, 5, 2, '茅台醇天青柔和酱香型白酒53度500ml*2瓶礼盒装', 'http://attachs.sizhijie.com/ycjj-oss/202bded37a52b30a0c92602647e943f71bd94f24.jpeg', 1, 1598.00, 1, 0, '', '', 0, 0, 1598.00, '2022-03-27 16:55:58'), (9, 6, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-27 19:01:39'), (10, 7, 4, '贵州茅台醇1992柔和酱香型白酒53度纯粮食酒高度酒水珍珠白瓶装礼盒500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/793f2ace3552bdd16f724c0a0c6d1ced1e8dd2be.jpeg', 1, 3594.00, 1, 0, '', '', 0, 0, 3594.00, '2022-03-27 19:11:30'), (11, 9, 3, '茅台醇天青柔和酱香型白酒53度500ml单瓶礼盒装', 'http://attachs.sizhijie.com/ycjj-oss/f4823e8c50cef6739548a0e0c795612201834bd8.jpeg', 1, 799.00, 1, 0, '', '', 0, 0, 799.00, '2022-03-27 19:17:44'), (12, 10, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-27 19:18:45'), (13, 11, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-27 20:26:57'), (14, 12, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 1, 1, 1194.00, '2022-03-27 20:28:03'), (15, 13, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-29 10:57:50'), (16, 14, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-29 11:06:47'), (17, 15, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-29 11:08:14'), (18, 16, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-29 11:12:44'), (19, 17, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 1194.00, 1, 0, '', '', 0, 0, 1194.00, '2022-03-29 11:18:43'), (20, 18, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 0.10, 1, 0, '', '', 0, 0, 0.10, '2022-03-29 11:25:31'), (21, 19, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 0.10, 1, 0, '', '', 0, 0, 0.10, '2022-03-29 11:26:05'), (22, 20, 6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 1, 0.10, 1, 0, '', '', 0, 0, 0.10, '2022-03-29 11:30:57'); -- -------------------------------------------------------- -- -- 表的结构 `szj_payments` -- CREATE TABLE IF NOT EXISTS `szj_payments` ( `payment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `pay_id` int(10) unsigned NOT NULL COMMENT '支付方式', `out_trade_no` varchar(30) NOT NULL COMMENT '商户单号', `total_fee` int(10) unsigned NOT NULL COMMENT '交易总金额 分', `trade_type` varchar(100) NOT NULL COMMENT '交易类型', `transaction_id` varchar(255) NOT NULL COMMENT '微信单号', `time_end` varchar(100) NOT NULL COMMENT '交易完成时间', `openid` varchar(100) NOT NULL COMMENT '用户openid', `sub_is_subscribe` varchar(10) NOT NULL COMMENT '是否关注子商户', `sub_openid` varchar(100) NOT NULL COMMENT '子商户用户openid', `is_subscribe` varchar(10) NOT NULL COMMENT '是否关注商户', `fee_type` varchar(100) NOT NULL COMMENT '货币类型', `bank_type` varchar(100) NOT NULL COMMENT '银行卡类型', `cash_fee` int(10) unsigned NOT NULL COMMENT '现金支付金额 分', `is_refund` tinyint(1) unsigned NOT NULL COMMENT '是否退款', `refund_trade_no` varchar(100) NOT NULL COMMENT '退款单号', `refund_desc` varchar(255) NOT NULL COMMENT '退款描述', `refund_time` datetime NOT NULL COMMENT '退款时间', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '写入时间', PRIMARY KEY (`payment_id`), KEY `out_trade_no` (`out_trade_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付和退费记录表' AUTO_INCREMENT=6 ; -- -- 转存表中的数据 `szj_payments` -- INSERT INTO `szj_payments` (`payment_id`, `user_id`, `pay_id`, `out_trade_no`, `total_fee`, `trade_type`, `transaction_id`, `time_end`, `openid`, `sub_is_subscribe`, `sub_openid`, `is_subscribe`, `fee_type`, `bank_type`, `cash_fee`, `is_refund`, `refund_trade_no`, `refund_desc`, `refund_time`, `create_time`) VALUES (1, 1, 0, 'Y2022032618544201158', 119400, '余额支付', '', '20220326185442', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', '', '', '', '余额', '商城余额', 119400, 0, '', '', '0000-00-00 00:00:00', '2022-03-26 10:54:42'), (2, 1, 0, 'Y2022032619482601458', 820200, '余额支付', '', '20220326194826', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', '', '', '', '余额', '商城余额', 820200, 0, '', '', '0000-00-00 00:00:00', '2022-03-26 11:48:26'), (3, 1, 0, 'Y2022032716202201572', 562200, '余额支付', '', '20220327162022', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', '', '', '', '余额', '商城余额', 562200, 0, '', '', '0000-00-00 00:00:00', '2022-03-27 08:20:22'), (4, 1, 0, 'Y2022032716494301393', 119400, '余额支付', '', '20220327164943', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', '', '', '', '余额', '商城余额', 119400, 0, '', '', '0000-00-00 00:00:00', '2022-03-27 08:49:43'), (5, 1, 0, 'Y2022032720280301855', 119400, '余额支付', '', '20220327202803', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', '', '', '', '余额', '商城余额', 119400, 0, '', '', '0000-00-00 00:00:00', '2022-03-27 12:28:03'); -- -------------------------------------------------------- -- -- 表的结构 `szj_pays_config` -- CREATE TABLE IF NOT EXISTS `szj_pays_config` ( `pay_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '支付ID', `pay_name` varchar(255) NOT NULL COMMENT '支付名称', `pay_logo` varchar(255) NOT NULL COMMENT '支付logo', `pay_params_index` varchar(255) NOT NULL COMMENT '支付参数索引 关联配置表里面的索引', `pay_status` tinyint(1) unsigned NOT NULL COMMENT '是否启用', `pay_sort` tinyint(1) unsigned NOT NULL COMMENT '排序序号', `is_default` tinyint(1) unsigned NOT NULL COMMENT '是否默认', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`pay_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='支付配置表' AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `szj_pays_config` -- INSERT INTO `szj_pays_config` (`pay_id`, `pay_name`, `pay_logo`, `pay_params_index`, `pay_status`, `pay_sort`, `is_default`, `admin_id`, `update_time`, `create_time`) VALUES (1, '微信支付', 'https://pic38.photophoto.cn/20160325/0007019842511399_b.jpg', '', 1, 99, 1, 1, '2022-03-27 08:49:31', '2022-02-19 11:47:52'), (2, '找人代付', 'https://pic38.photophoto.cn/20160325/0007019842511399_b.jpg', '', 0, 99, 0, 1, '2022-03-27 08:49:26', '2022-02-19 11:48:21'); -- -------------------------------------------------------- -- -- 表的结构 `szj_products` -- CREATE TABLE IF NOT EXISTS `szj_products` ( `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品ID', `product_name` varchar(255) NOT NULL COMMENT '产品名称', `product_desction` varchar(255) NOT NULL COMMENT '产品简单描述', `product_stock` int(10) unsigned NOT NULL COMMENT '产品库存', `product_image` varchar(255) NOT NULL COMMENT '产品封面图', `market_price` float(10,2) unsigned NOT NULL COMMENT '市场价', `cost_price` float(10,2) unsigned NOT NULL COMMENT '成本价', `shop_price` float(10,2) unsigned NOT NULL COMMENT '商詀销售价 如果有活动,活动价优化优先', `activity_id` int(10) unsigned NOT NULL COMMENT '活动ID', `carousel_id` int(10) unsigned NOT NULL COMMENT '产品相册集', `category_id` int(10) unsigned NOT NULL COMMENT '产品分类', `product_sn` char(20) NOT NULL COMMENT '产品货号', `supplier_id` int(10) unsigned NOT NULL COMMENT '供货商ID', `is_sale` tinyint(1) unsigned NOT NULL COMMENT '是否在销售中', `alert_stock` int(10) unsigned NOT NULL COMMENT '库存告警数', `goods_type` tinyint(1) unsigned NOT NULL COMMENT '货物类型 1实物 2虚拟产品 3配件', `sale_count` int(10) unsigned NOT NULL COMMENT '销售数量', `is_new` tinyint(1) unsigned NOT NULL COMMENT '是否新品', `is_home` tinyint(1) unsigned NOT NULL COMMENT '首页展示', `is_hot` tinyint(1) unsigned NOT NULL COMMENT '是否热销', `content_id` int(10) unsigned NOT NULL COMMENT '产品内容详情ID', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_products` -- INSERT INTO `szj_products` (`product_id`, `product_name`, `product_desction`, `product_stock`, `product_image`, `market_price`, `cost_price`, `shop_price`, `activity_id`, `carousel_id`, `category_id`, `product_sn`, `supplier_id`, `is_sale`, `alert_stock`, `goods_type`, `sale_count`, `is_new`, `is_home`, `is_hot`, `content_id`, `admin_id`, `update_time`, `create_time`) VALUES (1, '茅台醇天青柔和酱香型白酒53度500ml*6瓶整箱装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/3197e529c82e18d911510c974936e33e4dc27786.jpeg', 11985.00, 0.00, 4794.00, 0, 1, 1, '20220216161925-87878', 0, 1, 10, 1, 0, 0, 1, 0, 1, 1, '2022-03-09 08:28:52', '2022-02-16 16:19:25'), (2, '茅台醇天青柔和酱香型白酒53度500ml*2瓶礼盒装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/202bded37a52b30a0c92602647e943f71bd94f24.jpeg', 3995.00, 0.00, 1598.00, 0, 2, 2, '20220216162337-97259', 0, 1, 10, 1, 0, 0, 1, 0, 2, 1, '2022-03-09 08:28:45', '2022-02-16 16:23:37'), (3, '茅台醇天青柔和酱香型白酒53度500ml单瓶礼盒装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/f4823e8c50cef6739548a0e0c795612201834bd8.jpeg', 1997.50, 0.00, 799.00, 0, 3, 3, '20220216162636-65523', 0, 1, 10, 1, 0, 1, 1, 0, 3, 1, '2022-03-09 08:28:40', '2022-02-16 16:26:35'), (4, '贵州茅台醇1992柔和酱香型白酒53度纯粮食酒高度酒水珍珠白瓶装礼盒500ml*6瓶整箱装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/793f2ace3552bdd16f724c0a0c6d1ced1e8dd2be.jpeg', 8985.00, 0.00, 3594.00, 0, 4, 1, '20220216163202-57989', 0, 1, 10, 1, 0, 0, 1, 0, 4, 1, '2022-03-09 08:28:28', '2022-02-16 16:32:02'), (5, '贵州茅台醇1998柔和酱香型白酒53度高度纯粮食酒水500ml*6瓶整箱装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/ce4acb695a79c3bb148395c375babbc5d60fc635.jpeg', 5535.00, 0.00, 2214.00, 0, 5, 1, '20220216164354-13148', 0, 1, 0, 1, 0, 0, 1, 1, 5, 1, '2022-03-09 08:28:34', '2022-02-16 16:43:53'), (6, '贵州茅台醇2008柔和酱香型白酒53度高度纯粮食酒酒水旗舰店500ml*6瓶整箱装', '', 99, 'http://attachs.sizhijie.com/ycjj-oss/aea0e5e6a8a09d25c3c0dfb37013f33d2de47365.jpeg', 2985.00, 0.00, 0.10, 0, 6, 1, '20220216164806-84900', 4, 1, 10, 1, 10, 1, 1, 0, 6, 1, '2022-03-29 03:23:53', '2022-02-16 16:48:06'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_brands` -- CREATE TABLE IF NOT EXISTS `szj_product_brands` ( `brand_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品品牌表', `brand_name` varchar(255) NOT NULL, `brand_logo` varchar(255) NOT NULL COMMENT '品牌logo', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`brand_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='品牌表' AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `szj_product_brands` -- INSERT INTO `szj_product_brands` (`brand_id`, `brand_name`, `brand_logo`, `admin_id`, `update_time`, `create_time`) VALUES (2, '茅台淳', 'http://attachs.sizhijie.com/szjkj-common-oss/9a40418e50e8d5dc2ec55c60e24d3d646d768664.png', 1, '2022-02-09 08:34:05', '2022-02-09 16:26:47'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_carousels` -- CREATE TABLE IF NOT EXISTS `szj_product_carousels` ( `carousel_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '相册ID', `content` text NOT NULL COMMENT '相册内容', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`carousel_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品相册表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_product_carousels` -- INSERT INTO `szj_product_carousels` (`carousel_id`, `content`, `admin_id`, `update_time`, `create_time`) VALUES (1, 'http://attachs.sizhijie.com/ycjj-oss/94134786bd665861f5f3fc286f8f64f8449d9518.jpg,http://attachs.sizhijie.com/ycjj-oss/21468249089150cb7af9732c846650d1b4db4390.jpg,http://attachs.sizhijie.com/ycjj-oss/34a98d5f4d22edc0425f136e488bd2ee15233e48.jpg,http://attachs.sizhijie.com/ycjj-oss/3cbe3175336a5a9eef5853d360b1d8c19b748a0a.jpg,http://attachs.sizhijie.com/ycjj-oss/a1893e63f3010a6ce652ee9abc639d9466c859c4.jpg,http://attachs.sizhijie.com/ycjj-oss/f62dee61e21e4ef51671ddd880f088bb1741f898.jpg', 1, '2022-02-16 08:22:48', '2022-02-16 16:19:25'), (2, 'http://attachs.sizhijie.com/ycjj-oss/202bded37a52b30a0c92602647e943f71bd94f24.jpeg,http://attachs.sizhijie.com/ycjj-oss/34a98d5f4d22edc0425f136e488bd2ee15233e48.jpg,http://attachs.sizhijie.com/ycjj-oss/3cbe3175336a5a9eef5853d360b1d8c19b748a0a.jpg,http://attachs.sizhijie.com/ycjj-oss/21468249089150cb7af9732c846650d1b4db4390.jpg,http://attachs.sizhijie.com/ycjj-oss/a1893e63f3010a6ce652ee9abc639d9466c859c4.jpg,http://attachs.sizhijie.com/ycjj-oss/f62dee61e21e4ef51671ddd880f088bb1741f898.jpg', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (3, 'http://attachs.sizhijie.com/ycjj-oss/d7dd24a267c65789fe6c73eee847f301cc44e810.jpg,http://attachs.sizhijie.com/ycjj-oss/21468249089150cb7af9732c846650d1b4db4390.jpg,http://attachs.sizhijie.com/ycjj-oss/34a98d5f4d22edc0425f136e488bd2ee15233e48.jpg,http://attachs.sizhijie.com/ycjj-oss/a1893e63f3010a6ce652ee9abc639d9466c859c4.jpg,http://attachs.sizhijie.com/ycjj-oss/3cbe3175336a5a9eef5853d360b1d8c19b748a0a.jpg,http://attachs.sizhijie.com/ycjj-oss/f62dee61e21e4ef51671ddd880f088bb1741f898.jpg', 1, '2022-02-16 08:29:59', '2022-02-16 16:26:35'), (4, 'http://attachs.sizhijie.com/ycjj-oss/6f01a82b76e00255e2f4d3f0103d624d5b848b4d.jpg,http://attachs.sizhijie.com/ycjj-oss/ffeb39b631bf5107bcbbd823a95f807edaf90650.jpg,http://attachs.sizhijie.com/ycjj-oss/3607236c92c958858074254d8d0ca89c84fdc86a.jpg,http://attachs.sizhijie.com/ycjj-oss/ac65bc91c9603467e1ab0dab0098b7456fdf52d7.jpg,http://attachs.sizhijie.com/ycjj-oss/14944de0d272afcbdadf1df11a83add3e21af66a.jpg,http://attachs.sizhijie.com/ycjj-oss/4b8edff24ede7758cf708c2a3f1775dfa4a79473.jpg', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (5, 'http://attachs.sizhijie.com/ycjj-oss/edd8720897c61735d1c2a8f803cf91637c1ccba3.jpg,http://attachs.sizhijie.com/ycjj-oss/555d8c6d613e9356e5c861cdc3482d4a28a71795.jpg,http://attachs.sizhijie.com/ycjj-oss/f671ba9fc88ca4f25a3b099556119afda28c669b.jpg,http://attachs.sizhijie.com/ycjj-oss/1030a5b8c3676dcd229a25b1a1f029e661ce4de4.jpg,http://attachs.sizhijie.com/ycjj-oss/b9589f6deb871b96ea50ac23a335a877ce4d2910.jpg,http://attachs.sizhijie.com/ycjj-oss/374d2aa3d031210ab028be10f59486de5cbe21ae.jpg', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:53'), (6, 'http://attachs.sizhijie.com/ycjj-oss/56922c6ddccbe92b82c518b3bb5a33676a9eca3d.jpg,http://attachs.sizhijie.com/ycjj-oss/64bdb612569aeec035a2181a894b7ffe039a1fbe.jpg,http://attachs.sizhijie.com/ycjj-oss/c6a658fa3af88528aaefeb8abf18ee51671d9f42.jpg,http://attachs.sizhijie.com/ycjj-oss/7ae4663c0bed0006aeb322ba9b961c12456b1689.jpg,http://attachs.sizhijie.com/ycjj-oss/cea8b97cceac550be46fa3a67282581513f96bac.jpg,http://attachs.sizhijie.com/ycjj-oss/2ca0dff0e0c82318cc7c1da6f44e3597359a0012.jpg', 1, '2022-03-29 03:23:53', '2022-02-16 16:48:06'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_category` -- CREATE TABLE IF NOT EXISTS `szj_product_category` ( `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID', `category_name` varchar(255) NOT NULL COMMENT '分类名称', `pid` int(10) unsigned NOT NULL COMMENT '上级ID', `category_image` varchar(255) NOT NULL COMMENT '分类图片', `category_sort` int(10) unsigned NOT NULL COMMENT '分类排序', `is_show` tinyint(1) unsigned NOT NULL COMMENT '是否显示', `is_nav` tinyint(1) unsigned NOT NULL COMMENT '是否设为导航', `category_attrs` text NOT NULL COMMENT '分类属性', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人员', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品分类表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_product_category` -- INSERT INTO `szj_product_category` (`category_id`, `category_name`, `pid`, `category_image`, `category_sort`, `is_show`, `is_nav`, `category_attrs`, `admin_id`, `update_time`, `create_time`) VALUES (1, '整箱', 0, '', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:08:11', '2022-02-16 15:48:46'), (2, '两瓶', 0, '', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:07:38', '2022-02-16 15:49:02'), (3, '单瓶', 0, '', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:07:00', '2022-02-16 15:49:18'), (4, '1992', 0, 'https://imge.tianfuture.com/1407/image/2021/02/5428c0b8251cd6372f88e11f938ec5b0.jpg?imageMogr2/auto-orient/thumbnail/2000x/format/jpg/blur/2x0/quality/95|imageslim', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:06:23', '2022-02-16 15:49:34'), (5, '1998', 0, '', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:05:29', '2022-02-16 15:49:50'), (6, '2008', 0, '', 99, 1, 0, '[{"item_id":7,"is_filter":false,"type_id":1},{"item_id":6,"is_filter":false,"type_id":1},{"item_id":5,"is_filter":false,"type_id":1},{"item_id":4,"is_filter":false,"type_id":1},{"item_id":3,"is_filter":false,"type_id":1},{"item_id":2,"is_filter":false,"type_id":1},{"item_id":1,"is_filter":false,"type_id":1}]', 1, '2022-02-16 08:05:49', '2022-02-16 15:50:28'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_comment` -- CREATE TABLE IF NOT EXISTS `szj_product_comment` ( `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论ID', `product_rate` tinyint(1) unsigned NOT NULL COMMENT '商品评分', `order_id` int(10) unsigned NOT NULL COMMENT '订单ID', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `comment` varchar(255) NOT NULL COMMENT '评论内容', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `status` tinyint(1) unsigned NOT NULL COMMENT '评论状态 0未审核 1审核通过 2不显示', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`comment_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品评论表' AUTO_INCREMENT=8 ; -- -- 转存表中的数据 `szj_product_comment` -- INSERT INTO `szj_product_comment` (`comment_id`, `product_rate`, `order_id`, `product_id`, `comment`, `user_id`, `status`, `update_time`, `create_time`) VALUES (1, 3, 2, 5, '商品不错,值得推荐', 1, 1, '2022-03-27 09:57:26', '2022-03-27 11:53:38'), (2, 5, 2, 6, '商品不错,值得推荐', 1, 1, '2022-03-27 09:51:59', '2022-03-27 15:30:33'), (3, 5, 2, 1, '性价比很高,您值得拥有', 1, 1, '2022-03-27 09:57:29', '2022-03-27 15:44:48'), (4, 5, 1, 6, '商品很好,值得推荐', 1, 1, '2022-03-27 09:57:32', '2022-03-27 15:46:40'), (5, 4, 4, 6, '商品很好,下次还继续买', 1, 1, '2022-03-27 09:52:03', '2022-03-27 16:53:48'), (6, 5, 3, 6, '商品不错,值得推荐,下次还莱购买', 1, 0, '2022-03-27 11:03:47', '2022-03-27 19:03:41'), (7, 5, 3, 5, '酒质量不错,喝了不上头,口感很好', 1, 0, '2022-03-27 11:04:40', '2022-03-27 19:04:34'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_contents` -- CREATE TABLE IF NOT EXISTS `szj_product_contents` ( `content_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '内容ID', `desction` text NOT NULL COMMENT '详情', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`content_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品内容详情介绍表' AUTO_INCREMENT=7 ; -- -- 转存表中的数据 `szj_product_contents` -- INSERT INTO `szj_product_contents` (`content_id`, `desction`, `admin_id`, `update_time`, `create_time`) VALUES (1, '

', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (2, '

', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (3, '

', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (4, '

', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (5, '

', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (6, '



', 1, '2022-03-29 03:23:53', '2022-02-16 16:48:06'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_spes` -- CREATE TABLE IF NOT EXISTS `szj_product_spes` ( `spe_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `item_id` int(10) unsigned NOT NULL COMMENT '商品类型属性ID 关联商品类型属性表', `spes_value` varchar(255) NOT NULL COMMENT '用户设置的值 供检索', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`spe_id`), KEY `goods_id` (`product_id`), KEY `item_id` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品属性设置表' AUTO_INCREMENT=64 ; -- -- 转存表中的数据 `szj_product_spes` -- INSERT INTO `szj_product_spes` (`spe_id`, `product_id`, `item_id`, `spes_value`, `admin_id`, `update_time`, `create_time`) VALUES (1, 1, 1, '其它', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (2, 1, 2, '茅台醇', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (3, 1, 3, '1.75kg', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (4, 1, 4, '500-749mL', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (5, 1, 5, '50度及以上', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (6, 1, 6, '酱香型', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (7, 1, 7, '中国大陆', 1, '2022-02-16 08:22:49', '2022-02-16 16:19:25'), (8, 2, 1, '其它', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (9, 2, 2, '茅台醇', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (10, 2, 3, '1.4kg', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (11, 2, 4, '500-749mL', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (12, 2, 5, '50度及以上', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (13, 2, 6, '酱香型', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (14, 2, 7, '中国大陆', 1, '2022-02-16 08:27:01', '2022-02-16 16:23:37'), (15, 3, 1, '其它', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (16, 3, 2, '茅台醇', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (17, 3, 3, '1.35kg', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (18, 3, 4, '500-749mL', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (19, 3, 5, '50度及以上', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (20, 3, 6, '酱香型', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (21, 3, 7, '中国大陆', 1, '2022-02-16 08:30:00', '2022-02-16 16:26:36'), (22, 4, 1, '其它', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (23, 4, 2, '茅台醇', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (24, 4, 3, '1.75kg', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (25, 4, 4, '500-749mL', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (26, 4, 5, '50度及以上', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (27, 4, 6, '酱香型', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (28, 4, 7, '中国大陆', 1, '2022-02-16 08:35:26', '2022-02-16 16:32:02'), (29, 5, 1, '其它', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (30, 5, 2, '茅台醇', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (31, 5, 3, '1.75kg', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (32, 5, 4, '500-749mL', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (33, 5, 5, '50度及以上', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (34, 5, 6, '酱香型', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (35, 5, 7, '中国大陆', 1, '2022-02-16 08:47:17', '2022-02-16 16:43:54'), (57, 6, 1, '其它', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (58, 6, 2, '茅台醇', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (59, 6, 3, '1.75kg', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (60, 6, 4, '500-749mL', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (61, 6, 5, '50度及以上', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (62, 6, 6, '酱香型', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'), (63, 6, 7, '中国大陆', 1, '2022-03-29 03:24:32', '2022-03-29 11:23:53'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_suppliers` -- CREATE TABLE IF NOT EXISTS `szj_product_suppliers` ( `supplier_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '供货商ID', `supplier_name` varchar(255) NOT NULL COMMENT '联系人', `supplier_phone` varchar(255) NOT NULL COMMENT '电话', `supplier_status` tinyint(1) unsigned NOT NULL COMMENT '状态 1稳定 2异常 0未知', `admin_id` int(10) unsigned NOT NULL COMMENT '操作人员', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`supplier_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供货商表' AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `szj_product_suppliers` -- INSERT INTO `szj_product_suppliers` (`supplier_id`, `supplier_name`, `supplier_phone`, `supplier_status`, `admin_id`, `update_time`, `create_time`) VALUES (2, '源森家具-小罗', '07623379398', 1, 1, '2022-02-09 07:55:48', '2022-02-09 14:46:06'), (3, '茅台集团-老刘', '13750229481', 1, 1, '2022-02-09 07:51:13', '2022-02-09 15:40:58'), (4, '思智捷科技-罗生', '15219840108', 1, 1, '2022-02-09 07:58:44', '2022-02-09 15:55:18'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_types` -- CREATE TABLE IF NOT EXISTS `szj_product_types` ( `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类型id', `type_name` varchar(255) NOT NULL COMMENT '类型名称', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品类型表' AUTO_INCREMENT=2 ; -- -- 转存表中的数据 `szj_product_types` -- INSERT INTO `szj_product_types` (`type_id`, `type_name`, `admin_id`, `update_time`, `create_time`) VALUES (1, '茅台醇', 1, '2022-02-16 07:54:41', '2022-02-16 15:51:17'); -- -------------------------------------------------------- -- -- 表的结构 `szj_product_types_item` -- CREATE TABLE IF NOT EXISTS `szj_product_types_item` ( `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '属性ID', `type_id` int(10) unsigned NOT NULL COMMENT '关联商品类型表 product_types', `item_name` varchar(255) NOT NULL COMMENT '属性名称', `item_type` tinyint(1) unsigned NOT NULL COMMENT '属性类型 1输入 2单选 3多选', `item_value` varchar(255) NOT NULL COMMENT '属性值', `is_search` tinyint(1) unsigned NOT NULL COMMENT '是否可以检索', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`item_id`), KEY `is_search` (`is_search`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品类型属性表' AUTO_INCREMENT=8 ; -- -- 转存表中的数据 `szj_product_types_item` -- INSERT INTO `szj_product_types_item` (`item_id`, `type_id`, `item_name`, `item_type`, `item_value`, `is_search`, `admin_id`, `update_time`, `create_time`) VALUES (1, 1, '包装', 2, '其它', 0, 1, '2022-02-16 08:23:09', '2022-02-16 15:51:37'), (2, 1, '品牌', 2, '茅台醇', 0, 1, '2022-02-16 07:55:28', '2022-02-16 15:52:04'), (3, 1, '商品毛重', 2, '1.75kg|1.35kg|1.4kg', 0, 1, '2022-02-16 07:59:27', '2022-02-16 15:52:32'), (4, 1, '容量', 2, '500-749mL', 0, 1, '2022-02-16 07:56:24', '2022-02-16 15:53:01'), (5, 1, '度数', 2, '50度及以上', 0, 1, '2022-02-16 07:56:50', '2022-02-16 15:53:27'), (6, 1, '香型', 2, '酱香型', 0, 1, '2022-02-16 07:57:11', '2022-02-16 15:53:47'), (7, 1, '商品产地', 2, '中国大陆', 0, 1, '2022-02-16 07:58:12', '2022-02-16 15:54:48'); -- -------------------------------------------------------- -- -- 表的结构 `szj_roles` -- CREATE TABLE IF NOT EXISTS `szj_roles` ( `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID', `role_desc` varchar(255) NOT NULL COMMENT '角色描述', `role_name` varchar(20) NOT NULL COMMENT '角色名称', `admin_id` int(10) unsigned NOT NULL COMMENT '操作管理员', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员角色表' AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `szj_roles` -- INSERT INTO `szj_roles` (`role_id`, `role_desc`, `role_name`, `admin_id`, `update_time`, `create_time`) VALUES (1, '拥有全站的所有权限,属最高级别管理员', '超级管理员', 1, '2020-10-26 08:35:37', '2020-10-23 14:00:34'), (3, '有查看数据管理中心的基本权限', '测试人员', 1, '2022-01-20 03:31:45', '2020-10-24 10:55:38'); -- -------------------------------------------------------- -- -- 表的结构 `szj_shippings_config` -- CREATE TABLE IF NOT EXISTS `szj_shippings_config` ( `shipping_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配送ID', `shipping_name` varchar(255) NOT NULL COMMENT '配送名称', `shipping_logo` varchar(255) NOT NULL COMMENT '配送logo', `shipping_params_index` varchar(255) NOT NULL COMMENT '配送参数设置 关联配置表filed_index', `shipping_status` tinyint(1) unsigned NOT NULL COMMENT '是否启用', `shipping_sort` tinyint(1) unsigned NOT NULL COMMENT '排序', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`shipping_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配送方式配置表' AUTO_INCREMENT=4 ; -- -- 转存表中的数据 `szj_shippings_config` -- INSERT INTO `szj_shippings_config` (`shipping_id`, `shipping_name`, `shipping_logo`, `shipping_params_index`, `shipping_status`, `shipping_sort`, `admin_id`, `update_time`, `create_time`) VALUES (1, '同城配送', '', '', 1, 99, 1, '2022-02-19 07:34:44', '2022-02-19 11:57:22'), (2, '上门自提', '', '', 1, 99, 1, '2022-02-19 07:34:09', '2022-02-19 11:57:40'), (3, '快递包邮', '', '', 1, 99, 1, '2022-02-19 04:06:48', '2022-02-19 11:57:57'); -- -------------------------------------------------------- -- -- 表的结构 `szj_users` -- CREATE TABLE IF NOT EXISTS `szj_users` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID', `nickname` varchar(255) NOT NULL COMMENT '用户昵称', `account_name` varchar(255) NOT NULL COMMENT '用户账号', `openid` varchar(255) NOT NULL COMMENT '微信ID', `password` varchar(255) NOT NULL COMMENT '登录密码', `money` float(10,2) unsigned NOT NULL COMMENT '用户余额', `intergral` int(10) unsigned NOT NULL COMMENT '用户积分', `headimgurl` varchar(255) NOT NULL COMMENT '用户头像', `login_time` datetime NOT NULL COMMENT '登录时间', `city` varchar(255) NOT NULL COMMENT '所在城市', `province` varchar(255) NOT NULL COMMENT '所在省', `country` varchar(255) NOT NULL COMMENT '所在国家', `sex` char(1) NOT NULL COMMENT '性别', `subscribe` tinyint(1) unsigned NOT NULL COMMENT '是否关注公众号', `unionid` varchar(255) NOT NULL COMMENT '微信联合ID', `update_ttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `create_time` datetime NOT NULL COMMENT '注册时间', PRIMARY KEY (`user_id`), KEY `openid` (`openid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表' AUTO_INCREMENT=3 ; -- -- 转存表中的数据 `szj_users` -- INSERT INTO `szj_users` (`user_id`, `nickname`, `account_name`, `openid`, `password`, `money`, `intergral`, `headimgurl`, `login_time`, `city`, `province`, `country`, `sex`, `subscribe`, `unionid`, `update_ttime`, `create_time`) VALUES (1, 'como', 'cJxhuA173731', 'oSF4duIAfTLdEMukzNOpYPAuJxEo', 'e10adc3949ba59abbe56e057f20f883e', 8806.00, 0, 'https://thirdwx.qlogo.cn/mmopen/vi_32/6rSrIHWIDmibMnJxVuHFnS6rEoKCzUhHgg0whHatM3kRMRBsppo9lueRFYaVhzzlQ5db103IHrsArOzVAYejugw/132', '2022-03-10 17:37:31', '', '', '', '0', 0, '', '2022-03-27 12:28:09', '2022-03-10 17:37:31'), (2, 'como', 'Hf8KyZ103308', 'okXHRwVqk39baIntOSADkiFLSNNQ', 'e10adc3949ba59abbe56e057f20f883e', 0.00, 0, 'https://thirdwx.qlogo.cn/mmopen/vi_32/0OwCTB6MGMdMXOZFS5lqsDZicia67OFNWImWP3VicmxeCjdYmhIotkgicX3oHO525yRnFmnwYvIHF50p9U9a9OX17Q/132', '2022-03-29 10:33:08', '', '', '', '0', 0, '', '2022-03-29 02:58:29', '2022-03-29 10:33:08'); -- -------------------------------------------------------- -- -- 表的结构 `szj_users_money_logs` -- CREATE TABLE IF NOT EXISTS `szj_users_money_logs` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录ID', `log_desc` varchar(255) NOT NULL COMMENT '变动说明', `money` float(10,2) NOT NULL COMMENT '变动金额', `user_id` int(10) unsigned NOT NULL COMMENT '用户ID', `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '变动时间', PRIMARY KEY (`log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户余额变动记录表' AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `szj_users_money_logs` -- INSERT INTO `szj_users_money_logs` (`log_id`, `log_desc`, `money`, `user_id`, `change_time`) VALUES (1, '商品下单时余额抵扣,订单编号是:W20220327202657633061', -100.00, 1, '2022-03-27 12:27:03'), (2, '订单取消,退回订单抵扣的余额,订单编号是:W20220327202657633061', 100.00, 1, '2022-03-27 12:27:35'), (3, '商品下单时余额抵扣,订单编号是:W20220327202803123126', -1194.00, 1, '2022-03-27 12:28:09'), (4, '商品下单时余额抵扣,订单编号是:W20220329105750596109', -10.00, 2, '2022-03-29 02:58:29'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;