-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathsql.sql
More file actions
186 lines (146 loc) · 48.5 KB
/
Copy pathsql.sql
File metadata and controls
186 lines (146 loc) · 48.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 8.0.31 : Database - account_book
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`account_book` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `account_book`;
/*Table structure for table `book` */
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'book的id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`type` varchar(20) DEFAULT NULL COMMENT '收支类型',
`amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
`category` varchar(20) DEFAULT NULL COMMENT '类别',
`subcategory` varchar(20) DEFAULT NULL COMMENT '子类',
`account` varchar(100) DEFAULT NULL COMMENT '账户',
`book` varchar(100) DEFAULT NULL COMMENT '账本名称',
`reimbursement_account` varchar(100) DEFAULT NULL COMMENT '报销账户',
`reimbursement_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '报销金额',
`remark` varchar(100) DEFAULT NULL COMMENT '备注',
`label` varchar(100) DEFAULT NULL COMMENT '标签',
`address` varchar(100) DEFAULT NULL COMMENT '地址',
`user` bigint DEFAULT NULL COMMENT '创建用户的id',
`attachment1` varchar(100) DEFAULT NULL COMMENT '附件1的oss路径',
`attachment2` varchar(100) DEFAULT NULL COMMENT '附件2的oss路径',
`attachment3` varchar(100) DEFAULT NULL COMMENT '附件3的oss路径',
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记(0:不可用 1:可用)',
PRIMARY KEY (`id`),
KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB AUTO_INCREMENT=1701955991521873922 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*Data for the table `book` */
/*Table structure for table `dict` */
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`parent_id` bigint NOT NULL DEFAULT '0' COMMENT '上级id',
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`value` int DEFAULT NULL COMMENT '值',
`dict_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '编码',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_parent_id_value` (`parent_id`,`value`) USING BTREE,
KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1686027871794266114 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='数据字典';
/*Data for the table `dict` */
insert into `dict`(`id`,`parent_id`,`name`,`value`,`dict_code`,`create_time`,`update_time`,`is_deleted`) values (1,0,'全部分类',NULL,'ROOT','2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20000,1,'A吃喝外食',NULL,'eat','2023-07-30 19:25:44','2023-09-13 18:17:46',0),(20001,20000,'a 早饭（外）',1,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20002,20000,'a 中饭（外）',2,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20003,20000,'a 晚饭（外）',3,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20004,20000,'a 宵夜',4,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20005,20000,'a 买菜',5,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20006,20000,'a 点外卖',6,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20007,20000,'a 酒品',7,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20008,20000,'a 茶品',8,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20009,20000,'a 水果',9,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20010,20000,'a 甜点',10,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20011,20000,'a 零食',11,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20012,20000,'a 香烟',12,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20013,20000,'a 奶制品',13,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20014,20000,'a 饮料',14,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20015,20000,'a 营养品',15,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(20016,20000,'aa 吃喝-其它',16,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(30000,1,'B衣物鞋帽',NULL,'clothes','2023-07-30 19:25:44','2023-07-30 19:25:44',0),(30001,30000,'b 上衣',1,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(30002,30000,'b 裙裤',2,NULL,'2023-07-30 19:25:44','2023-07-30 19:25:44',0),(30003,30000,'b 内衣',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(30004,30000,'b 鞋子',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(30005,30000,'b 围巾',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(30006,30000,'b 帽子',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(30007,30000,'b 袜子',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(30008,30000,'bb 衣物-其它',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40000,1,'C交通出行',NULL,'transport','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40001,40000,'c 油费',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40002,40000,'c 过路费',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40003,40000,'c 停车费',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40004,40000,'c 车险',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40005,40000,'c 修洗养配',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40006,40000,'c 公交',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40007,40000,'c taxi',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40008,40000,'c 共享单车',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40009,40000,'c 地铁',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40010,40000,'c 高铁',10,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40011,40000,'c 飞机',11,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(40012,40000,'cc 交通-其它',12,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50000,1,'D房水电话',NULL,'house','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50001,50000,'d 宽带',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50002,50000,'d 水费',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50003,50000,'d 电费',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50004,50000,'d 话费',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50005,50000,'d 燃气',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50006,50000,'d 物业',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50007,50000,'d 房租',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50008,50000,'d 房贷',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50009,50000,'d 日租房',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(50010,50000,'dd 房水-其它',10,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60000,1,'E生活日用',NULL,'daily','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60001,60000,'e 家电',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60002,60000,'e 洗漱',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60003,60000,'e 家居用品',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60004,60000,'e 炊事用品',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60005,60000,'e 装饰用品',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60006,60000,'e 床上用品',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60007,60000,'e 数码内外设',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60008,60000,'e 情趣用品',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(60009,60000,'ee 生活-其它',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70000,1,'F腐败玩耍',NULL,'play','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70001,70000,'f 电影',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70002,70000,'f 门票',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70003,70000,'f 大乐透',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70004,70000,'f 网吧',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70005,70000,'f 桌游',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70006,70000,'f 洗浴、按摩',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70007,70000,'f Ktv',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70008,70000,'f 打牌',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70009,70000,'f 追星 追漫 周边',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70010,70000,'f 酒吧',10,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70011,70000,'f 游戏产品',11,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(70012,70000,'ff 腐败-其它',12,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80000,1,'G软件会员',NULL,'software','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80001,80000,'g 购物会员',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80002,80000,'g 影视会员',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80003,80000,'g 音乐会员',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80004,80000,'g 知识类会员',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80005,80000,'g 下载、云',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80006,80000,'g 微软',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80007,80000,'g adobe',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80008,80000,'g 设计类',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(80009,80000,'gg 软件-其它',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90000,1,'H护肤',NULL,'selfcare','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90001,90000,'h 洁面',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90002,90000,'h 黑头',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90003,90000,'h 美白',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90004,90000,'h 面膜',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90005,90000,'h 防晒',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90006,90000,'h 美容院',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(90007,90000,'hh 护肤-其它',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100000,1,'I彩妆',NULL,'makeup','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100001,100000,'i 眉毛',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100002,100000,'i 美瞳',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100003,100000,'i 睫毛',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100004,100000,'i 嘴唇',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100005,100000,'i 指甲',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100006,100000,'i 卸妆',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100007,100000,'ii 彩妆-其它',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100008,100000,'i 底妆',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100009,100000,'i 眼线',9,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100010,100000,'i 眼影',10,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(100011,100000,'i 剪头发',11,NULL,'2023-08-01 08:42:14','2023-08-01 08:42:14',0),(110000,1,'J人情通达',NULL,'relative','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110001,110000,'j 长辈',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110002,110000,'j 上级',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110003,110000,'j 晚辈',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110004,110000,'j 同辈',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110005,110000,'j 情侣',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110006,110000,'j 追求',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110007,110000,'j 公益',7,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(110008,110000,'jj 人情-其它',8,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120000,1,'K旅游',NULL,'itinerary','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120001,120000,'k 吃喝',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120002,120000,'k 住宿',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120003,120000,'k 交通',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120004,120000,'k 门票',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(120005,120000,'kk 旅游-其它',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130000,1,'L医疗保险',NULL,'medicine','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130001,130000,'l 保险',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130002,130000,'l 药品',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130003,130000,'l 医院',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130004,130000,'l 养生保健',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(130005,130000,'lI 医疗-其它',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140000,1,'M学习爱我',NULL,'improvement','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140001,140000,'m 书籍',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140002,140000,'m 学费',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140003,140000,'m 考试',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140004,140000,'m 培训',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140005,140000,'m 学习工具',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(140006,140000,'mm 学习-其它',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150000,1,'N其它',NULL,'other','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150001,150000,'n 育儿',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150002,150000,'n 装修',2,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150003,150000,'n 礼节性',3,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150004,150000,'n 工本费',4,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150005,150000,'n 当日活动啥的',5,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150006,150000,'nn 其它-其它',6,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(150007,150000,'n 奖金',7,NULL,'2023-08-01 08:44:02','2023-08-01 08:44:02',0),(160000,1,'O无支出',NULL,'zero','2023-07-30 19:25:45','2023-07-30 19:25:45',0),(160001,160000,'o 无支出',1,NULL,'2023-07-30 19:25:45','2023-07-30 19:25:45',0),(170000,1,'支付方式',NULL,'payMethods','2023-07-31 22:54:55','2023-07-31 23:00:01',0),(170001,170000,'微信',1,NULL,'2023-07-31 22:55:11','2023-07-31 23:00:29',0),(170002,170000,'支付宝',2,NULL,'2023-07-31 22:55:22','2023-07-31 23:00:29',0),(170003,170000,'银行卡',3,NULL,'2023-07-31 22:55:33','2023-07-31 23:00:29',0),(170004,170000,'信用卡',4,NULL,'2023-07-31 22:55:44','2023-07-31 23:00:29',0);
/*Table structure for table `sys_menu` */
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`parent_id` bigint NOT NULL DEFAULT '0' COMMENT '所属上级',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
`type` tinyint NOT NULL DEFAULT '0' COMMENT '类型(0:目录,1:菜单,2:按钮)',
`path` varchar(100) DEFAULT NULL COMMENT '路由地址',
`component` varchar(100) DEFAULT NULL COMMENT '组件路径',
`perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
`icon` varchar(100) DEFAULT NULL COMMENT '图标',
`sort_value` int DEFAULT NULL COMMENT '排序',
`status` tinyint DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单表';
/*Data for the table `sys_menu` */
insert into `sys_menu`(`id`,`parent_id`,`name`,`type`,`path`,`component`,`perms`,`icon`,`sort_value`,`status`,`create_time`,`update_time`,`is_deleted`) values (2,0,'系统管理',0,'system','Layout',NULL,'el-icon-s-tools',1,1,'2021-05-31 18:05:37','2022-06-09 09:23:24',0),(4,2,'角色管理',1,'sysRole','system/sysRole/list','','el-icon-user-solid',2,1,'2021-05-31 18:05:37','2022-06-09 09:37:18',0),(5,2,'菜单管理',1,'sysMenu','system/sysMenu/list','','el-icon-s-unfold',3,1,'2021-05-31 18:05:37','2022-06-09 09:37:21',0),(10,4,'查看',2,NULL,NULL,'bnt.sysRole.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(11,4,'添加',2,NULL,NULL,'bnt.sysRole.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(12,4,'修改',2,NULL,NULL,'bnt.sysRole.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(13,4,'删除',2,NULL,NULL,'bnt.sysRole.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(14,5,'查看',2,NULL,NULL,'bnt.sysMenu.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(15,5,'添加',2,NULL,NULL,'bnt.sysMenu.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(16,5,'修改',2,NULL,NULL,'bnt.sysMenu.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(17,5,'删除',2,NULL,NULL,'bnt.sysMenu.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(40,2,'用户管理',1,'user','system/user/list',NULL,'el-icon-s-unfold',4,1,'2023-08-07 18:27:50','2023-08-07 18:27:50',0),(41,2,'账单管理',1,'accountBook','system/accountBook/list','','el-icon-setting',1,1,'2023-09-13 16:29:51','2023-09-13 08:29:48',0),(42,2,'字典管理',1,'dict','system/dict/dict','','el-icon-tickets',1,1,'2023-09-13 16:30:38','2023-09-13 16:51:15',0),(43,40,'分配角色',2,NULL,NULL,'bnt.sysUser.assignRole',NULL,1,1,'2021-05-31 18:05:37','2023-09-13 08:52:54',0),(44,4,'分配权限',2,'assignAuth','system/sysRole/assignAuth','bnt.sysRole.assignAuth',NULL,1,1,'2021-05-31 18:05:37','2021-05-31 18:05:37',0),(45,40,'查看',2,NULL,NULL,'bnt.sysUser.list',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(46,40,'添加',2,NULL,NULL,'bnt.sysUser.add',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(47,40,'修改',2,NULL,NULL,'bnt.sysUser.update',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(48,40,'删除',2,NULL,NULL,'bnt.sysUser.remove',NULL,1,1,'2021-05-31 18:05:37','2022-06-09 09:22:38',0),(49,41,'查看',2,'','','bnt.account.list','',1,1,'2023-09-13 18:01:29','2023-09-13 10:01:27',0),(50,41,'添加',2,'','','bnt.account.add','',1,1,'2023-09-13 18:01:46','2023-09-13 10:01:43',0),(51,41,'修改',2,'','','bnt.account.update','',1,1,'2023-09-13 18:02:02','2023-09-13 10:01:59',0),(52,41,'删除',2,'','','bnt.account.remove','',1,1,'2023-09-13 18:02:23','2023-09-13 10:02:20',0),(53,41,'下载',2,'','','bnt.account.download','',1,1,'2023-09-13 18:02:41','2023-09-13 10:02:38',0),(54,41,'上传',2,'','','bnt.account.upload','',1,1,'2023-09-13 18:02:57','2023-09-13 10:02:54',0),(55,42,'查看',2,'','','bnt.dict.list','',1,1,'2023-09-13 18:03:29','2023-09-13 10:03:26',0),(56,42,'添加',2,'','','bnt.dict.add','',1,1,'2023-09-13 18:03:41','2023-09-13 10:03:38',0),(57,42,'修改',2,'','','bnt.dict.update','',1,1,'2023-09-13 18:03:52','2023-09-13 10:03:49',0),(58,42,'删除',2,'','','bnt.dict.remove','',1,1,'2023-09-13 18:04:01','2023-09-13 10:03:58',0),(59,42,'上传',2,'','','bnt.dict.upload','',1,1,'2023-09-13 18:04:12','2023-09-13 10:04:09',0),(60,42,'下载',2,'','','bnt.dict.download','',1,1,'2023-09-13 18:04:24','2023-09-13 10:04:21',0),(61,2,'数据分析',1,'echarts','system/echarts/list','','el-icon-s-help',1,1,'2023-09-13 18:27:32','2023-09-13 18:28:36',0),(62,61,'查看',2,'','','bnt.echarts.list','',1,1,'2023-09-13 18:29:27','2023-09-13 10:29:24',0);
/*Table structure for table `sys_role` */
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色id',
`role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称',
`role_code` varchar(20) DEFAULT NULL COMMENT '角色编码',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1701904865820712962 DEFAULT CHARSET=utf8mb3 COMMENT='角色';
/*Data for the table `sys_role` */
insert into `sys_role`(`id`,`role_name`,`role_code`,`description`,`create_time`,`update_time`,`is_deleted`) values (1,'系统管理员','SYSTEM','系统管理员666','2021-05-31 18:09:18','2023-06-15 15:42:05',0),(2,'普通管理员','COMMON','普通管理员','2021-06-01 08:38:40','2023-06-10 16:12:00',0),(8,'用户管理员','123',NULL,'2022-06-08 17:39:04','2023-09-13 10:24:52',1),(9,'裘千尺','vip','这是一个超级管理员','2023-06-06 16:39:47','2023-06-11 18:11:58',1),(10,'乔峰222','vip','超级管理员222','2023-06-06 19:13:43','2023-06-11 18:11:58',1),(11,'段誉','vvip','超级管理员','2023-06-06 19:14:22','2023-06-11 18:11:58',1),(12,'段誉','vvip','超级管理员','2023-06-06 19:14:29','2023-06-11 18:11:58',1),(13,'张三丰','vvvip','武当派','2023-06-06 19:14:57','2023-06-11 18:11:58',1),(14,'谢逊9','vvip','金毛狮王','2023-06-06 19:15:16','2023-06-11 18:11:58',1),(15,'马钰','射雕英雄传','全真剑法','2023-06-06 19:56:19','2023-06-11 18:11:58',1),(16,'一灯','射雕英雄传','一阳指','2023-06-06 19:56:33','2023-06-11 18:11:58',1),(17,'无崖子','天龙八部','北冥神功','2023-06-06 19:56:54','2023-06-11 18:11:58',1),(18,'慕容博','天龙八部','斗转星移','2023-06-06 19:57:17','2023-06-11 18:11:58',1),(19,'林朝英','神雕侠侣','玉女心经','2023-06-06 19:57:48','2023-06-11 18:11:58',1),(20,'测试管理员','testAdministor',NULL,'2023-06-10 16:16:14','2023-06-11 18:11:58',1),(21,'1616管理员','1616',NULL,'2023-06-10 16:17:00','2023-06-11 18:11:58',1),(22,'1617管理员','1617',NULL,'2023-06-10 16:17:41','2023-06-11 18:11:58',1),(23,'1618管理员','1618',NULL,'2023-06-10 16:18:17','2023-06-11 18:11:58',1),(24,'456管理员','456',NULL,'2023-06-10 16:56:38','2023-06-11 18:11:58',1),(25,'曹操','dd',NULL,'2023-06-10 18:32:38','2023-06-11 18:11:58',1),(26,'dfdfdfd11','dfd11',NULL,'2023-06-10 18:32:50','2023-06-11 18:11:58',1),(27,'扽1','扽1',NULL,'2023-06-10 18:38:39','2023-06-11 18:11:58',1),(28,'测试222','测试2222',NULL,'2023-06-10 18:43:38','2023-06-11 18:11:58',1),(29,'超级管理员','001',NULL,'2023-06-12 08:26:15','2023-09-13 10:24:52',1),(30,'测试角色','test00',NULL,'2023-06-13 08:32:02','2023-06-15 10:32:08',1),(31,'硅谷管理员','guigu',NULL,'2023-06-14 08:25:48','2023-09-13 10:24:52',1),(1701904865820712961,'普通用户','COMMON_USER',NULL,'2023-09-13 18:25:15','2023-09-13 10:25:12',0);
/*Table structure for table `sys_role_menu` */
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`role_id` bigint NOT NULL DEFAULT '0',
`menu_id` bigint NOT NULL DEFAULT '0',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1701906017299767299 DEFAULT CHARSET=utf8mb3 COMMENT='角色菜单';
/*Data for the table `sys_role_menu` */
insert into `sys_role_menu`(`id`,`role_id`,`menu_id`,`create_time`,`update_time`,`is_deleted`) values (65,1,2,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(66,1,3,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(67,1,6,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(68,1,7,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(69,1,8,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(70,1,9,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(71,1,18,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(72,1,4,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(73,1,10,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(74,1,11,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(75,1,12,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(76,1,13,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(77,1,19,'2023-06-13 18:20:22','2023-09-13 08:48:59',1),(78,1,5,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(79,1,14,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(80,1,15,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(81,1,16,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(82,1,17,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(83,1,20,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(84,1,21,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(85,1,24,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(86,1,25,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(87,1,26,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(88,1,22,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(89,1,23,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(90,1,27,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(91,1,28,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(92,1,29,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(93,1,35,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(94,1,38,'2023-06-13 18:20:23','2023-09-13 08:48:59',1),(1701880654989488129,1,2,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655018848258,1,4,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655148871681,1,10,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655215980545,1,11,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655283089410,1,12,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655408918529,1,13,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655476027394,1,44,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655538941953,1,5,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655601856514,1,14,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655668965378,1,15,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655731879937,1,16,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655798988801,1,17,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880655929012226,1,40,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880656121950209,1,41,'2023-09-13 16:49:02','2023-09-13 08:56:14',1),(1701880656184864769,1,42,'2023-09-13 16:49:03','2023-09-13 08:56:14',1),(1701882478534455297,1,2,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478601564161,1,4,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478668673025,1,10,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478735781889,1,11,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478802890754,1,12,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478865805313,1,13,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882478932914177,1,44,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479000023042,1,5,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479130046466,1,14,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479192961025,1,15,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479260069889,1,16,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479327178753,1,17,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479394287618,1,40,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479457202177,1,43,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479520116737,1,45,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479587225602,1,46,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479717249026,1,47,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479784357889,1,48,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479847272449,1,41,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701882479914381314,1,42,'2023-09-13 16:56:17','2023-09-13 10:04:38',1),(1701899690167070722,1,2,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690234179586,1,4,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690297094145,1,10,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690364203009,1,11,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690427117569,1,12,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690490032129,1,13,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690557140993,1,44,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690624249858,1,5,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690691358721,1,14,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690817187842,1,15,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690884296706,1,16,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899690951405569,1,17,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691014320130,1,40,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691081428993,1,43,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691148537858,1,45,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691215646721,1,46,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691282755586,1,47,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691349864449,1,48,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691416973313,1,41,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691479887874,1,49,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691614105602,1,50,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691681214466,1,51,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691748323330,1,52,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691815432193,1,53,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691878346753,1,54,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899691945455618,1,42,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692075479042,1,55,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692142587905,1,56,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692205502465,1,57,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692272611330,1,58,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692335525889,1,59,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899692402634753,1,60,'2023-09-13 18:04:41','2023-09-13 10:04:46',1),(1701899723725697026,1,2,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899723792805889,1,4,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899723855720450,1,10,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899723922829314,1,11,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899723985743874,1,12,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724052852738,1,13,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724119961602,1,44,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724182876162,1,5,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724245790721,1,14,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724312899585,1,15,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724380008450,1,16,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724442923010,1,17,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724510031874,1,40,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724577140737,1,43,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724644249602,1,45,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724711358466,1,46,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724778467330,1,47,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724908490754,1,48,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899724971405313,1,41,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725034319874,1,49,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725101428737,1,50,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725168537602,1,51,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725231452161,1,52,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725298561026,1,53,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725361475586,1,54,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725428584449,1,42,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725491499009,1,55,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725558607874,1,56,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725621522434,1,57,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725684436994,1,58,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725751545857,1,59,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701899725885763586,1,60,'2023-09-13 18:04:49','2023-09-13 10:08:34',1),(1701900680458944514,1,2,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680538636290,1,4,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680601550849,1,10,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680668659713,1,11,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680731574273,1,12,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680861597697,1,13,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680928706561,1,44,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900680991621121,1,5,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681058729986,1,14,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681188753410,1,15,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681255862274,1,16,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681318776833,1,17,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681385885698,1,40,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681448800257,1,43,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681511714817,1,45,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681637543938,1,46,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681700458498,1,47,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681767567362,1,48,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681834676225,1,41,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681897590786,1,49,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900681964699649,1,42,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701900682027614209,1,55,'2023-09-13 18:08:37','2023-09-13 10:27:47',1),(1701905040026935297,1701904865820712961,2,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040094044162,1701904865820712961,41,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040156958722,1701904865820712961,49,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040224067586,1701904865820712961,50,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040291176450,1701904865820712961,51,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040354091010,1701904865820712961,52,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040484114434,1701904865820712961,53,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040542834689,1701904865820712961,54,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040677052417,1701904865820712961,42,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040739966978,1701904865820712961,55,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905040802881538,1701904865820712961,56,'2023-09-13 18:25:56','2023-09-13 10:27:53',1),(1701905518030790658,1,2,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518093705218,1,4,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518160814082,1,10,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518223728642,1,11,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518290837506,1,12,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518353752066,1,13,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518483775489,1,44,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518550884353,1,5,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518613798914,1,14,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518676713473,1,15,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518739628034,1,16,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518802542593,1,17,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518932566018,1,40,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905518995480578,1,43,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519066783745,1,45,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519129698306,1,46,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519192612866,1,47,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519259721729,1,48,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519318441986,1,41,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519385550850,1,49,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519448465410,1,42,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519515574274,1,55,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905519578488834,1,61,'2023-09-13 18:27:50','2023-09-13 10:29:33',1),(1701905544379408385,1701904865820712961,2,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544442322946,1701904865820712961,41,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544505237506,1701904865820712961,49,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544635260929,1701904865820712961,50,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544635260930,1701904865820712961,51,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544702369793,1701904865820712961,52,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544836587522,1701904865820712961,53,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544899502082,1701904865820712961,54,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905544966610946,1701904865820712961,42,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905545029525506,1701904865820712961,55,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905545096634369,1701904865820712961,56,'2023-09-13 18:27:56','2023-09-13 10:29:46',1),(1701905545159548929,1701904865820712961,61,'2023-09-13 18:27:57','2023-09-13 10:29:46',1),(1701905962404716546,1,2,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962471825410,1,4,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962534739969,1,10,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962597654530,1,11,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962664763394,1,12,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962731872257,1,13,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962798981122,1,44,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962861895681,1,5,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962929004545,1,14,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905962991919106,1,15,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963121942530,1,16,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963189051393,1,17,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963251965953,1,40,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963314880514,1,43,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963381989378,1,45,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963516207106,1,46,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963579121666,1,47,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963642036225,1,48,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963709145090,1,41,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963772059649,1,49,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963839168514,1,42,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963902083073,1,55,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905963969191937,1,61,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701905964032106498,1,62,'2023-09-13 18:29:36','2023-09-13 10:29:33',0),(1701906016515432450,1701904865820712961,2,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016582541313,1701904865820712961,41,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016649650177,1701904865820712961,49,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016712564738,1701904865820712961,50,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016779673602,1701904865820712961,51,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016842588162,1701904865820712961,52,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016909697025,1701904865820712961,53,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906016976805889,1701904865820712961,54,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906017039720450,1701904865820712961,42,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906017102635009,1701904865820712961,55,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906017169743874,1701904865820712961,56,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906017236852737,1701904865820712961,61,'2023-09-13 18:29:49','2023-09-13 10:29:46',0),(1701906017299767298,1701904865820712961,62,'2023-09-13 18:29:49','2023-09-13 10:29:46',0);
/*Table structure for table `sys_user` */
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '会员id',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '密码',
`name` varchar(50) DEFAULT NULL COMMENT '姓名',
`phone` varchar(11) DEFAULT NULL COMMENT '手机',
`head_url` varchar(200) DEFAULT NULL COMMENT '头像地址',
`salt` char(6) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '密码盐',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`status` tinyint DEFAULT NULL COMMENT '状态（1：正常 0：停用）',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=1701932644964540419 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';
/*Data for the table `sys_user` */
insert into `sys_user`(`id`,`username`,`password`,`name`,`phone`,`head_url`,`salt`,`description`,`status`,`create_time`,`update_time`,`is_deleted`) values (1,'admin','$2a$10$s63g8Ssn/5x/yb2a7Bb6MuNTrfHDlLmFPLm2NcEgybZ5s23YkBYTG','admin','11111111','https://obsidiantuchuanggavin.oss-cn-beijing.aliyuncs.com/img/20180629210546_CQARA.jpeg','adedfa',NULL,1,'2023-08-03 22:58:24','2023-09-13 13:49:22',0);
/*Table structure for table `sys_user_role` */
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
`role_id` bigint NOT NULL DEFAULT '0' COMMENT '角色id',
`user_id` bigint NOT NULL DEFAULT '0' COMMENT '用户id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_admin_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1701932645287501826 DEFAULT CHARSET=utf8mb3 COMMENT='用户角色';
/*Data for the table `sys_user_role` */
insert into `sys_user_role`(`id`,`role_id`,`user_id`,`create_time`,`update_time`,`is_deleted`) values (51,2,1,'2023-06-11 20:23:19','2023-06-12 18:11:36',1),(52,8,1,'2023-06-11 20:23:19','2023-06-12 18:11:36',1),(74,2,1,'2023-06-12 18:11:36','2023-09-13 09:02:14',1),(75,1,1,'2023-06-12 18:11:36','2023-09-13 09:02:14',1),(83,1,1687030184168923138,'2023-09-13 11:52:25','2023-09-13 09:03:20',1),(1701883988286763010,2,1,'2023-09-13 17:02:17','2023-09-13 09:02:58',1),(1701883988454535169,1,1,'2023-09-13 17:02:17','2023-09-13 09:02:58',1),(1701883988651667458,8,1,'2023-09-13 17:02:17','2023-09-13 09:02:58',1),(1701884172152467458,2,1,'2023-09-13 17:03:01','2023-09-13 09:03:02',1),(1701884172219576321,1,1,'2023-09-13 17:03:01','2023-09-13 09:03:02',1),(1701884172349599746,8,1,'2023-09-13 17:03:01','2023-09-13 09:03:02',1),(1701884172475428866,29,1,'2023-09-13 17:03:01','2023-09-13 09:03:02',1),(1701884187906273281,2,1,'2023-09-13 17:03:05','2023-09-13 09:03:05',1),(1701884188036296705,1,1,'2023-09-13 17:03:05','2023-09-13 09:03:05',1),(1701884200724066305,1,1,'2023-09-13 17:03:08','2023-09-13 09:10:09',1),(1701884263307276289,1,1687030184168923138,'2023-09-13 17:03:23','2023-09-13 09:10:33',1),(1701885981550047234,1,1,'2023-09-13 17:10:12','2023-09-13 10:09:16',1),(1701885981617156097,2,1,'2023-09-13 17:10:12','2023-09-13 10:09:16',1),(1701885981747179521,8,1,'2023-09-13 17:10:12','2023-09-13 10:09:16',1),(1701886080153939970,1,1687030184168923138,'2023-09-13 17:10:36','2023-09-13 09:58:33',1),(1701886080283963393,2,1687030184168923138,'2023-09-13 17:10:36','2023-09-13 09:58:33',1),(1701886094569762817,2,1687030340201226241,'2023-09-13 17:10:39','2023-09-13 09:10:36',0),(1701886094699786242,1,1687030340201226241,'2023-09-13 17:10:39','2023-09-13 09:10:36',0),(1701898161691389954,1,1687030184168923138,'2023-09-13 17:58:36','2023-09-13 10:09:20',1),(1701898161745915905,2,1687030184168923138,'2023-09-13 17:58:36','2023-09-13 10:09:20',1),(1701898161875939330,29,1687030184168923138,'2023-09-13 17:58:36','2023-09-13 10:09:20',1),(1701898161938853889,31,1687030184168923138,'2023-09-13 17:58:36','2023-09-13 10:09:20',1),(1701898162073071618,8,1687030184168923138,'2023-09-13 17:58:36','2023-09-13 10:09:20',1),(1701900859195015169,1,1,'2023-09-13 18:09:19','2023-09-13 10:09:16',0),(1701900875137564673,1,1687030184168923138,'2023-09-13 18:09:23','2023-09-13 10:09:20',0),(1701916848066404354,1701904865820712961,1701916850503294978,'2023-09-13 19:12:51','2023-09-13 11:21:00',0),(1701923527944314881,1701904865820712961,1701923528074338305,'2023-09-13 19:39:24','2023-09-13 11:40:04',0),(1701923806265847810,1701904865820712961,1701923803430498306,'2023-09-13 19:40:30','2023-09-13 11:40:30',0),(1701931456500097026,1701904865820712961,1701931456298770433,'2023-09-13 20:10:54','2023-09-13 12:10:54',0),(1701932645287501825,1701904865820712961,1701932644964540418,'2023-09-13 20:15:38','2023-09-13 12:15:37',0);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;