• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1/*
2 * Copyright (c) 2023 Hunan OpenValley Digital Industry Development Co., Ltd.
3 * Licensed under the Apache License, Version 2.0 (the "License");
4 * you may not use this file except in compliance with the License.
5 * You may obtain a copy of the License at
6 *
7 *     http://www.apache.org/licenses/LICENSE-2.0
8 *
9 * Unless required by applicable law or agreed to in writing, software
10 * distributed under the License is distributed on an "AS IS" BASIS,
11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 * See the License for the specific language governing permissions and
13 * limitations under the License.
14 */
15
16/*
17 Navicat Premium Data Transfer
18
19 Source Server         : jeecg-boot
20 Source Server Type    : MySQL
21 Source Server Version : 50741
22 Source Host           : localhost:3306
23 Source Schema         : jeecg-boot
24
25 Target Server Type    : MySQL
26 Target Server Version : 50741
27 File Encoding         : 65001
28
29 Date: 14/12/2023 09:58:00
30*/
31
32SET NAMES utf8mb4;
33SET FOREIGN_KEY_CHECKS = 0;
34
35-- ----------------------------
36-- Table structure for oh_sample_short_video
37-- ----------------------------
38DROP TABLE IF EXISTS `oh_sample_short_video`;
39CREATE TABLE `oh_sample_short_video`
40(
41    `id`          varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL,
42    `create_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
43    `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
44    `update_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
45    `update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
46    `name`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频名称',
47    `url`         varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频链接',
48    `status`      int(1) NULL DEFAULT 0 COMMENT '状态',
49    `del_flag`    int(1) NULL DEFAULT 0 COMMENT '删除状态',
50    `cover`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面',
51    `remark`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
52    PRIMARY KEY (`id`) USING BTREE
53) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
54
55-- ----------------------------
56-- Table structure for oh_sample_business
57-- ----------------------------
58DROP TABLE IF EXISTS `oh_sample_business`;
59CREATE TABLE `oh_sample_business`  (
60  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
61  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
62  `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
63  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
64  `update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
65  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商家名称',
66  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面',
67  `is_open` int(1) NULL DEFAULT NULL COMMENT '是否营业0否1是',
68  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
69  `longitude` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
70  `latitude` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
71  `phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商家手机号',
72  `start_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开始时间',
73  `end_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结束时间',
74  `notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告',
75  `start_price` float NULL DEFAULT NULL COMMENT '起送价格',
76  `delivery_price` float NULL DEFAULT NULL COMMENT '配送费',
77  `del_flag` int(1) NULL DEFAULT 0 COMMENT '删除状态',
78  `distance` double NULL DEFAULT NULL COMMENT '距离',
79  `score` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评分',
80  `monthly_sale` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '月销',
81  `per_capita` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '人均',
82  `delivery_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配送时间',
83  `ranking` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '排名',
84  PRIMARY KEY (`id`) USING BTREE
85) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
86
87-- ----------------------------
88-- Table structure for oh_sample_business_comment
89-- ----------------------------
90DROP TABLE IF EXISTS `oh_sample_business_comment`;
91CREATE TABLE `oh_sample_business_comment`
92(
93    `id`          varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
94    `business_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商家id',
95    `create_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
96    `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
97    `update_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
98    `update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
99    `user_name`   varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论用户名',
100    `star`        int(1) NULL DEFAULT NULL COMMENT '评级1-5',
101    `content`     varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容',
102    `del_flag`    int(1) NULL DEFAULT 0 COMMENT '删除状态',
103    PRIMARY KEY (`id`) USING BTREE
104) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
105
106    -- ----------------------------
107-- Table structure for oh_sample_business_goods
108-- ----------------------------
109DROP TABLE IF EXISTS `oh_sample_business_goods`;
110CREATE TABLE `oh_sample_business_goods`
111(
112    `id`            varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL,
113    `business_id`   varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
114    `create_by`     varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
115    `create_time`   datetime NULL DEFAULT NULL COMMENT '创建日期',
116    `update_by`     varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
117    `update_time`   datetime NULL DEFAULT NULL COMMENT '更新日期',
118    `name`          varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
119    `cover`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面',
120    `price`         varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '价格',
121    `sale_price`    varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '折后价',
122    `price_explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '价格说明',
123    `sales_number`  varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销量',
124    `total_number`  varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总量',
125    `description`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
126    `standards`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格',
127    `weight`        varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '重量',
128    `brand`         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌',
129    `breed`         varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品种',
130    `made`          int(2) NULL DEFAULT NULL COMMENT '国产0，进口1',
131    `producer`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产地',
132    `quality_date`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保质期',
133    `packing`       varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '包装方式',
134    `category`      varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类别',
135    `taste`         varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '口味',
136    `keep_type`     varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '储存方式',
137    `del_flag`      int(1) NULL DEFAULT 0 COMMENT '删除状态',
138    PRIMARY KEY (`id`) USING BTREE
139) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
140
141    -- ----------------------------
142-- Table structure for oh_sample_group_site
143-- ----------------------------
144DROP TABLE IF EXISTS `oh_sample_group_site`;
145CREATE TABLE `oh_sample_group_site`
146(
147    `id`          varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL,
148    `create_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
149    `create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
150    `update_by`   varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
151    `update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
152    `name`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商家名称',
153    `cover`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面',
154    `is_open`     int(1) NULL DEFAULT NULL COMMENT '是否营业0否1是',
155    `address`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
156    `longitude`   varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
157    `latitude`    varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
158    `start_time`  varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开始时间',
159    `end_time`    varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结束时间',
160    `notice`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告',
161    `del_flag`    int(1) NULL DEFAULT 0 COMMENT '删除状态',
162    `distance`    double NULL DEFAULT NULL COMMENT '距离',
163    PRIMARY KEY (`id`) USING BTREE
164) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
165
166INSERT INTO `jeecg-boot`.`sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `client_id`, `login_tenant_id`, `bpm_status`) VALUES ('1735185182555668482', '13700000001', 'oh_sample_1', '0a2336450341645a716669413a1b0c52', 'oU4VHkXh', NULL, NULL, NULL, '13700000001@163.com', '13700000001', NULL, 1, 0, NULL, NULL, 1, '1', 'wcpjwwunmr', NULL, 'admin', '2023-12-14 14:29:20', NULL, NULL, 1, '', NULL, NULL, NULL);
167INSERT INTO `jeecg-boot`.`sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `client_id`, `login_tenant_id`, `bpm_status`) VALUES ('1735185294220623873', '13700000002', 'oh_sample_2', '5bdaf0a843efdafeddf60b8d0c7a75d0', 'Z4CjoI2U', NULL, NULL, NULL, '13700000002@163.com', '13700000002', NULL, 1, 0, NULL, NULL, 1, '2', 'wcpjwwunmr', NULL, 'admin', '2023-12-14 14:29:47', NULL, NULL, 1, '', NULL, NULL, NULL);
168INSERT INTO `jeecg-boot`.`sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `client_id`, `login_tenant_id`, `bpm_status`) VALUES ('1735185403566129153', '13700000003', 'oh_sample_3', '1f44876976e04ae134eddc7482cd7460', 'KLBnYPbC', NULL, NULL, NULL, '13700000003@163.com', '13700000003', NULL, 1, 0, NULL, NULL, 1, '3', 'wcpjwwunmr', NULL, 'admin', '2023-12-14 14:30:13', NULL, NULL, 1, '', NULL, NULL, NULL);
169
170
171INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735104068424167426', '', 'oh-sample', '/oh-sample', 'layouts/RouteView', 1, '', NULL, 0, NULL, '0', 1.00, 0, 'ant-design:insert-row-above-outlined', 0, 0, 0, 0, NULL, 'admin', '2023-12-14 09:07:01', 'admin', '2023-12-14 09:38:13', 0, 0, NULL, 0);
172INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735106177429270529', '1735104068424167426', '短视频应用', '/oh-sample/video', 'oh-sample/video', 1, '', NULL, 1, NULL, '0', 1.00, 0, 'ant-design:video-camera-add-outlined', 0, 0, 0, 0, NULL, 'admin', '2023-12-14 09:15:24', 'admin', '2023-12-14 09:17:28', 0, 0, NULL, 0);
173INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735106861096628225', '1735104068424167426', '外卖应用', '/oh-sample/takeaway', 'oh-sample/takeaway', 1, '', NULL, 1, NULL, '0', 1.00, 0, 'ant-design:shopping-cart-outlined', 0, 0, 0, 0, NULL, 'admin', '2023-12-14 09:18:07', 'admin', '2023-12-14 09:22:53', 0, 0, NULL, 0);
174INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735106998653022209', '1735106861096628225', '商家列表', '/oh-sample/takeaway/business/index', 'oh-sample/takeaway/business/index', 1, '', NULL, 1, NULL, '0', 1.00, 0, 'ant-design:unordered-list-outlined', 1, 0, 0, 0, NULL, 'admin', '2023-12-14 09:18:40', 'admin', '2023-12-14 09:37:12', 0, 0, NULL, 0);
175INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735107116215169025', '1735106861096628225', '站点列表', '/oh-sample/takeaway/site/index', 'oh-sample/takeaway/site/index', 1, '', NULL, 1, NULL, '0', 2.00, 0, 'ant-design:shop-twotone', 1, 0, 0, 0, NULL, 'admin', '2023-12-14 09:19:08', 'admin', '2023-12-14 09:37:17', 0, 0, NULL, 0);
176INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735107238571405314', '1735106861096628225', '商品列表', '/oh-sample/takeaway/goods/index', 'oh-sample/takeaway/goods/index', 1, '', NULL, 1, NULL, '0', 3.00, 0, 'ant-design:shopping-outlined', 1, 0, 0, 0, NULL, 'admin', '2023-12-14 09:19:37', 'admin', '2023-12-14 09:37:23', 0, 0, NULL, 0);
177INSERT INTO `jeecg-boot`.`sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `is_route`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_leaf`, `keep_alive`, `hidden`, `hide_tab`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1735111480019382274', '1735106177429270529', '视频审核列表', '/oh-sample/video/index', 'oh-sample/video/index', 1, '', NULL, 1, NULL, '0', 1.00, 0, NULL, 1, 0, 0, 0, NULL, 'admin', '2023-12-14 09:36:28', NULL, NULL, 0, 0, NULL, 0);
178
179INSERT INTO `jeecg-boot`.`sys_dict` (`id`, `dict_name`, `dict_code`, `description`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `type`, `tenant_id`, `low_app_id`) VALUES ('1735113660168269825', '进口/国产', 'made', NULL, 0, 'admin', '2023-12-14 09:45:08', NULL, NULL, 0, 0, NULL);
180INSERT INTO `jeecg-boot`.`sys_dict` (`id`, `dict_name`, `dict_code`, `description`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `type`, `tenant_id`, `low_app_id`) VALUES ('1735114494528581633', '审核状态', 'check_status', NULL, 0, 'admin', '2023-12-14 09:48:27', NULL, NULL, 0, 0, NULL);
181
182INSERT INTO `jeecg-boot`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1739838713310814210', '1735113660168269825', '进口', '2', NULL, 1, 1, 'admin', '2023-12-27 10:40:49', NULL, NULL);
183INSERT INTO `jeecg-boot`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1739838686651817985', '1735113660168269825', '国产', '1', NULL, 1, 1, 'admin', '2023-12-27 10:40:42', NULL, NULL);
184INSERT INTO `jeecg-boot`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1739838622470578178', '1735114494528581633', '审核不通过', '2', NULL, 1, 1, 'admin', '2023-12-27 10:40:27', NULL, NULL);
185INSERT INTO `jeecg-boot`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1739838590564507649', '1735114494528581633', '审核通过', '1', NULL, 1, 1, 'admin', '2023-12-27 10:40:19', NULL, NULL);
186INSERT INTO `jeecg-boot`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES ('1739838540337717249', '1735114494528581633', '未审核', '0', NULL, 1, 1, 'admin', '2023-12-27 10:40:07', NULL, NULL);
187
188INSERT INTO `jeecg-boot`.`sys_position` (`id`, `code`, `name`, `post_rank`, `company_id`, `create_by`, `create_time`, `update_by`, `update_time`, `sys_org_code`, `tenant_id`) VALUES ('1735119103519223810', 'wcpjwwunmr', 'oh-sample', NULL, NULL, 'admin', '2023-12-14 10:06:46', NULL, NULL, 'A01', 0);
189
190INSERT INTO `jeecg-boot`.`sys_role` (`id`, `role_name`, `role_code`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`) VALUES ('1735118567969517570', 'oh-sample', 'oh_sample', 'OH Sample示例', 'admin', '2023-12-14 10:04:38', NULL, NULL, 0);
191
192
193
194INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147061915650', '1735118567969517570', '1735104068424167426', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
195INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147061915651', '1735118567969517570', '1735106177429270529', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
196INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147070304257', '1735118567969517570', '1735111480019382274', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
197INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147070304258', '1735118567969517570', '1735106861096628225', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
198INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147070304259', '1735118567969517570', '1735106998653022209', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
199INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147070304260', '1735118567969517570', '1735107116215169025', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
200INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196147070304261', '1735118567969517570', '1735107238571405314', NULL, '2023-12-14 15:12:55', '0:0:0:0:0:0:0:1');
201INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088681398274', 'f6817f48af4fb3af11b9e8bf182f618b', '1735104068424167426', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
202INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592578', 'f6817f48af4fb3af11b9e8bf182f618b', '1735106177429270529', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
203INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592579', 'f6817f48af4fb3af11b9e8bf182f618b', '1735111480019382274', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
204INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592580', 'f6817f48af4fb3af11b9e8bf182f618b', '1735106861096628225', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
205INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592581', 'f6817f48af4fb3af11b9e8bf182f618b', '1735106998653022209', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
206INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592582', 'f6817f48af4fb3af11b9e8bf182f618b', '1735107116215169025', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
207INSERT INTO `jeecg-boot`.`sys_role_permission` (`id`, `role_id`, `permission_id`, `data_rule_ids`, `operate_date`, `operate_ip`) VALUES ('1735196088685592583', 'f6817f48af4fb3af11b9e8bf182f618b', '1735107238571405314', NULL, '2023-12-14 15:12:41', '0:0:0:0:0:0:0:1');
208
209INSERT INTO `jeecg-boot`.`sys_user_role` (`id`, `user_id`, `role_id`, `tenant_id`) VALUES ('1735202450614288385', '1735185403566129153', '1735118567969517570', 0);
210INSERT INTO `jeecg-boot`.`sys_user_role` (`id`, `user_id`, `role_id`, `tenant_id`) VALUES ('1735202471145406466', '1735185294220623873', '1735118567969517570', 0);
211INSERT INTO `jeecg-boot`.`sys_user_role` (`id`, `user_id`, `role_id`, `tenant_id`) VALUES ('1735202493056450562', '1735185182555668482', '1735118567969517570', 0);
212
213
214INSERT INTO `jeecg-boot`.`oh_sample_short_video` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `url`, `status`, `del_flag`, `cover`, `remark`) VALUES ('1', NULL, '2023-12-14 13:39:21', NULL, '2023-12-14 13:39:36', '2023再见，2024加油！', 'opt/upFiles/video/test2.mp4', 0, 0, NULL, '奋斗，努力！');
215INSERT INTO `jeecg-boot`.`oh_sample_short_video` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `url`, `status`, `del_flag`, `cover`, `remark`) VALUES ('2', NULL, '2023-12-14 13:52:00', NULL, '2023-12-14 13:52:04', '好风景', 'opt/upFiles/video/test.mp4', 0, 0, NULL, NULL);
216
217INSERT INTO `jeecg-boot`.`oh_sample_business` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `phone_number`, `start_time`, `end_time`, `notice`, `start_price`, `delivery_price`, `del_flag`, `distance`, `score`, `monthly_sale`, `per_capita`, `delivery_time`, `ranking`) VALUES ('1735112443329376257', 'admin', '2023-12-14 09:40:18', '13700000001', '2023-12-14 13:51:12', '绿野水果', 'temp/mt.png', 1, '长沙市岳麓区金茂览秀城3F305', '112.900443', '28.0939', '17365456544', '8::00', '18:00', '新店运营！活动多多！', 5, 2, 0, NULL, NULL, NULL, NULL, NULL, NULL);
218INSERT INTO `jeecg-boot`.`oh_sample_business` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `phone_number`, `start_time`, `end_time`, `notice`, `start_price`, `delivery_price`, `del_flag`, `distance`, `score`, `monthly_sale`, `per_capita`, `delivery_time`, `ranking`) VALUES ('1735145719947456513', '13700000001', '2023-12-14 11:52:32', '13700000001', '2023-12-14 13:51:01', '商家3', NULL, 1, '长沙市岳麓区上回路88号', '112.900443', '28.1958', NULL, '8::00', '24:00', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
219INSERT INTO `jeecg-boot`.`oh_sample_business` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `phone_number`, `start_time`, `end_time`, `notice`, `start_price`, `delivery_price`, `del_flag`, `distance`, `score`, `monthly_sale`, `per_capita`, `delivery_time`, `ranking`) VALUES ('1735146768917721089', '13700000001', '2023-12-14 11:56:42', '13700000001', '2023-12-14 13:51:08', '商家2', NULL, 1, '深圳市南山产业园14栋', '112.945791', '28.0939', NULL, '8::00', '24:00', NULL, 2, 3, 0, NULL, NULL, NULL, NULL, NULL, NULL);
220INSERT INTO `jeecg-boot`.`oh_sample_business` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `phone_number`, `start_time`, `end_time`, `notice`, `start_price`, `delivery_price`, `del_flag`, `distance`, `score`, `monthly_sale`, `per_capita`, `delivery_time`, `ranking`) VALUES ('1735146876761665538', '13700000001', '2023-12-14 11:57:08', '13700000001', '2023-12-14 13:51:05', '商家1', NULL, 0, '深圳市南山产业园10栋', '112.945791', '28.0939', '13700000001', '8::00', '24:00', '哈哈哈哈哈哈哈哈哈哈或或或或或', 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
221
222INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735113203391787009', '1735112443329376257', 'admin', '2023-12-14 09:43:19', 'admin', '2023-12-14 09:46:03', '赣州蜜橙', NULL, '4.8/斤', '3.8/斤', NULL, '100kg', '1000kg', '很好吃的赣州蜜橙！', '约2000g/份', '2000g', '赣州蜜橙', '橙子', 2, '赣州', '2023-12-29', '袋装', '水果', '酸甜', '常温', 0);
223INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735144596624764930', '1735112443329376257', '13700000001', '2023-12-14 11:48:04', NULL, NULL, '湘西香柚', NULL, '4.8/斤', '3.8/斤', NULL, '22', '2222', '湘西香柚，又香又甜！', '约250g/个', '250g', '湘西香柚', '柚子', 2, '湘西', '2023-12-31', '袋装', '水果', '酸甜', '常温', 0);
224INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735147314898661377', '1735146768917721089', '13700000001', '2023-12-14 11:58:52', '13700000001', '2023-12-14 12:00:58', '商品1', NULL, '10', '10', NULL, '0', '100kg', '哒哒哒哒哒哒', '约2000g/份', NULL, '红富士', '苹果', 2, '中国', '2025-01-01', '袋装', '水果', '33', '冷藏', 0);
225INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735147721351884801', '1735145719947456513', '13700000001', '2023-12-14 12:00:29', NULL, NULL, '商品', NULL, '4.8/斤', '3.8/斤', NULL, '100kg', '1000kg', '啊啊啊啊啊啊啊啊啊啊啊', '约2000g/份', '2000g', '红富士', '榴莲', 1, '欧洲', '2024-12-14', '袋装', '水果', '酸甜', '常温', 0);
226INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735148168150118401', '1735146876761665538', '13700000001', '2023-12-14 12:02:15', NULL, NULL, '菠萝', NULL, '10', '3.8/斤', NULL, '100kg', '2222', '啊啊啊啊啊啊啊啊', '约2000g/份', NULL, '菠萝', '菠萝', 1, '东南亚', '2023-12-14', '袋装', '水果', '菠萝', '常温', 0);
227INSERT INTO `jeecg-boot`.`oh_sample_business_goods` (`id`, `business_id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `price`, `sale_price`, `price_explain`, `sales_number`, `total_number`, `description`, `standards`, `weight`, `brand`, `breed`, `made`, `producer`, `quality_date`, `packing`, `category`, `taste`, `keep_type`, `del_flag`) VALUES ('1735174913712553985', '1735112443329376257', '13700000001', '2023-12-14 13:48:32', NULL, NULL, '商品3', NULL, '4.8/斤', '3.8/斤', NULL, '100kg', '100kg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '水果', NULL, NULL, 0);
228
229INSERT INTO `jeecg-boot`.`oh_sample_group_site` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `start_time`, `end_time`, `notice`, `del_flag`, `distance`) VALUES ('1735148355887165442', '13700000001', '2023-12-14 12:03:00', '13700000001', '2023-12-14 12:04:20', '站点名称1', 'temp/mt.png', 1, '长沙市桐梓坡西路8888号', '112.900443', '22.35', '8::00', '18:00', '红红火火恍恍惚惚', 0, NULL);
230INSERT INTO `jeecg-boot`.`oh_sample_group_site` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `start_time`, `end_time`, `notice`, `del_flag`, `distance`) VALUES ('1735148510505988097', '13700000001', '2023-12-14 12:03:37', NULL, NULL, '站点名称2', 'temp/mt.png', 1, '长沙市岳麓区金茂览秀城', '11.33', '22.35', '8::00', '18:00', 'wwwwwwwwwww', 0, NULL);
231INSERT INTO `jeecg-boot`.`oh_sample_group_site` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `name`, `cover`, `is_open`, `address`, `longitude`, `latitude`, `start_time`, `end_time`, `notice`, `del_flag`, `distance`) VALUES ('1735148634997125122', '13700000001', '2023-12-14 12:04:07', NULL, NULL, '站点名称3', 'temp/mt.png', 0, '长沙市桐梓坡西路', '112.900443', NULL, '6:00', '18:00', '啊啊啊啊啊啊', 0, NULL);
232
233SET
234FOREIGN_KEY_CHECKS = 1;