From 481eb2249f2886c3a6ea8445820a2ec5f153d4da Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期五, 14 八月 2026 14:19:47 +0800
Subject: [PATCH] 销售报价编辑详情返回规格，辅单位
---
sql/dm/ruoyi-vue-pro-dm8.sql | 679 ++++++++++++++++++++++++++++----------------------------
1 files changed, 340 insertions(+), 339 deletions(-)
diff --git a/sql/dm/ruoyi-vue-pro-dm8.sql b/sql/dm/ruoyi-vue-pro-dm8.sql
index 3cc9a9a..bea8245 100644
--- a/sql/dm/ruoyi-vue-pro-dm8.sql
+++ b/sql/dm/ruoyi-vue-pro-dm8.sql
@@ -14,27 +14,27 @@
-- ----------------------------
CREATE TABLE infra_api_access_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- trace_id varchar(64) DEFAULT '' NULL,
+ trace_id varchar(64 char) DEFAULT '' NULL,
user_id bigint DEFAULT 0 NOT NULL,
user_type smallint DEFAULT 0 NOT NULL,
- application_name varchar(50) NOT NULL,
- request_method varchar(16) DEFAULT '' NULL,
- request_url varchar(255) DEFAULT '' NULL,
+ application_name varchar(50 char) NOT NULL,
+ request_method varchar(16 char) DEFAULT '' NULL,
+ request_url varchar(255 char) DEFAULT '' NULL,
request_params text NULL,
response_body text NULL,
- user_ip varchar(50) NOT NULL,
- user_agent varchar(512) NOT NULL,
- operate_module varchar(50) DEFAULT NULL NULL,
- operate_name varchar(50) DEFAULT NULL NULL,
+ user_ip varchar(50 char) NOT NULL,
+ user_agent varchar(512 char) NOT NULL,
+ operate_module varchar(50 char) DEFAULT NULL NULL,
+ operate_name varchar(50 char) DEFAULT NULL NULL,
operate_type smallint DEFAULT 0 NULL,
begin_time datetime NOT NULL,
end_time datetime NOT NULL,
duration int NOT NULL,
result_code int DEFAULT 0 NOT NULL,
- result_msg varchar(512) DEFAULT '' NULL,
- creator varchar(64) DEFAULT '' NULL,
+ result_msg varchar(512 char) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -74,30 +74,30 @@
-- ----------------------------
CREATE TABLE infra_api_error_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- trace_id varchar(64) NOT NULL,
+ trace_id varchar(64 char) NOT NULL,
user_id bigint DEFAULT 0 NOT NULL,
user_type smallint DEFAULT 0 NOT NULL,
- application_name varchar(50) NOT NULL,
- request_method varchar(16) NOT NULL,
- request_url varchar(255) NOT NULL,
- request_params varchar(8000) NOT NULL,
- user_ip varchar(50) NOT NULL,
- user_agent varchar(512) NOT NULL,
+ application_name varchar(50 char) NOT NULL,
+ request_method varchar(16 char) NOT NULL,
+ request_url varchar(255 char) NOT NULL,
+ request_params varchar(8000 char) NOT NULL,
+ user_ip varchar(50 char) NOT NULL,
+ user_agent varchar(512 char) NOT NULL,
exception_time datetime NOT NULL,
- exception_name varchar(128) DEFAULT '' NULL,
+ exception_name varchar(128 char) DEFAULT '' NULL,
exception_message text NOT NULL,
exception_root_cause_message text NOT NULL,
exception_stack_trace text NOT NULL,
- exception_class_name varchar(512) NOT NULL,
- exception_file_name varchar(512) NOT NULL,
- exception_method_name varchar(512) NOT NULL,
+ exception_class_name varchar(512 char) NOT NULL,
+ exception_file_name varchar(512 char) NOT NULL,
+ exception_method_name varchar(512 char) NOT NULL,
exception_line_number int NOT NULL,
process_status smallint NOT NULL,
process_time datetime DEFAULT NULL NULL,
process_user_id int DEFAULT 0 NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -141,25 +141,25 @@
CREATE TABLE infra_codegen_column (
id bigint NOT NULL PRIMARY KEY IDENTITY,
table_id bigint NOT NULL,
- column_name varchar(200) NOT NULL,
- data_type varchar(100) NOT NULL,
- column_comment varchar(500) NOT NULL,
+ column_name varchar(200 char) NOT NULL,
+ data_type varchar(100 char) NOT NULL,
+ column_comment varchar(500 char) NOT NULL,
nullable bit NOT NULL,
primary_key bit NOT NULL,
ordinal_position int NOT NULL,
- java_type varchar(32) NOT NULL,
- java_field varchar(64) NOT NULL,
- dict_type varchar(200) DEFAULT '' NULL,
- example varchar(64) DEFAULT NULL NULL,
+ java_type varchar(32 char) NOT NULL,
+ java_field varchar(64 char) NOT NULL,
+ dict_type varchar(200 char) DEFAULT '' NULL,
+ example varchar(64 char) DEFAULT NULL NULL,
create_operation bit NOT NULL,
update_operation bit NOT NULL,
list_operation bit NOT NULL,
- list_operation_condition varchar(32) DEFAULT '=' NOT NULL,
+ list_operation_condition varchar(32 char) DEFAULT '=' NOT NULL,
list_operation_result bit NOT NULL,
- html_type varchar(32) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ html_type varchar(32 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -198,14 +198,14 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
data_source_config_id bigint NOT NULL,
scene smallint DEFAULT 1 NOT NULL,
- table_name varchar(200) DEFAULT '' NULL,
- table_comment varchar(500) DEFAULT '' NULL,
- remark varchar(500) DEFAULT NULL NULL,
- module_name varchar(30) NOT NULL,
- business_name varchar(30) NOT NULL,
- class_name varchar(100) DEFAULT '' NULL,
- class_comment varchar(50) NOT NULL,
- author varchar(50) NOT NULL,
+ table_name varchar(200 char) DEFAULT '' NULL,
+ table_comment varchar(500 char) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ module_name varchar(30 char) NOT NULL,
+ business_name varchar(30 char) NOT NULL,
+ class_name varchar(100 char) DEFAULT '' NULL,
+ class_comment varchar(50 char) NOT NULL,
+ author varchar(50 char) NOT NULL,
template_type smallint DEFAULT 1 NOT NULL,
front_type smallint NOT NULL,
parent_menu_id bigint DEFAULT NULL NULL,
@@ -214,9 +214,9 @@
sub_join_many bit DEFAULT NULL NULL,
tree_parent_column_id bigint DEFAULT NULL NULL,
tree_name_column_id bigint DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -252,16 +252,16 @@
-- ----------------------------
CREATE TABLE infra_config (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- category varchar(50) NOT NULL,
+ category varchar(50 char) NOT NULL,
type smallint NOT NULL,
- name varchar(100) DEFAULT '' NULL,
- config_key varchar(100) DEFAULT '' NULL,
- value varchar(500) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
+ config_key varchar(100 char) DEFAULT '' NULL,
+ value varchar(500 char) DEFAULT '' NULL,
visible bit NOT NULL,
- remark varchar(500) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -304,13 +304,13 @@
-- ----------------------------
CREATE TABLE infra_data_source_config (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(100) DEFAULT '' NULL,
- url varchar(1024) NOT NULL,
- username varchar(255) NOT NULL,
- password varchar(255) DEFAULT '' NULL,
- creator varchar(64) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
+ url varchar(1024 char) NOT NULL,
+ username varchar(255 char) NOT NULL,
+ password varchar(255 char) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -333,14 +333,14 @@
CREATE TABLE infra_file (
id bigint NOT NULL PRIMARY KEY IDENTITY,
config_id bigint DEFAULT NULL NULL,
- name varchar(256) DEFAULT NULL NULL,
- path varchar(512) NOT NULL,
- url varchar(1024) NOT NULL,
- type varchar(128) DEFAULT NULL NULL,
+ name varchar(256 char) DEFAULT NULL NULL,
+ path varchar(512 char) NOT NULL,
+ url varchar(1024 char) NOT NULL,
+ type varchar(128 char) DEFAULT NULL NULL,
size int NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -364,14 +364,14 @@
-- ----------------------------
CREATE TABLE infra_file_config (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(63) NOT NULL,
+ name varchar(63 char) NOT NULL,
storage smallint NOT NULL,
- remark varchar(255) DEFAULT NULL NULL,
+ remark varchar(255 char) DEFAULT NULL NULL,
master bit NOT NULL,
- config varchar(4096) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ config varchar(4096 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -415,11 +415,11 @@
CREATE TABLE infra_file_content (
id bigint NOT NULL PRIMARY KEY IDENTITY,
config_id bigint NOT NULL,
- path varchar(512) NOT NULL,
+ path varchar(512 char) NOT NULL,
content blob NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -442,17 +442,17 @@
-- ----------------------------
CREATE TABLE infra_job (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(32) NOT NULL,
+ name varchar(32 char) NOT NULL,
status smallint NOT NULL,
- handler_name varchar(64) NOT NULL,
- handler_param varchar(255) DEFAULT NULL NULL,
- cron_expression varchar(32) NOT NULL,
+ handler_name varchar(64 char) NOT NULL,
+ handler_param varchar(255 char) DEFAULT NULL NULL,
+ cron_expression varchar(32 char) NOT NULL,
retry_count int DEFAULT 0 NOT NULL,
retry_interval int DEFAULT 0 NOT NULL,
monitor_timeout int DEFAULT 0 NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -506,17 +506,17 @@
CREATE TABLE infra_job_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
job_id bigint NOT NULL,
- handler_name varchar(64) NOT NULL,
- handler_param varchar(255) DEFAULT NULL NULL,
+ handler_name varchar(64 char) NOT NULL,
+ handler_param varchar(255 char) DEFAULT NULL NULL,
execute_index smallint DEFAULT 1 NOT NULL,
begin_time datetime NOT NULL,
end_time datetime DEFAULT NULL NULL,
duration int DEFAULT NULL NULL,
status smallint NOT NULL,
- result varchar(4000) DEFAULT '' NULL,
- creator varchar(64) DEFAULT '' NULL,
+ result varchar(4000 char) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -546,16 +546,16 @@
-- ----------------------------
CREATE TABLE system_dept (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(30) DEFAULT '' NULL,
+ name varchar(30 char) DEFAULT '' NULL,
parent_id bigint DEFAULT 0 NOT NULL,
sort int DEFAULT 0 NOT NULL,
leader_user_id bigint DEFAULT NULL NULL,
- phone varchar(11) DEFAULT NULL NULL,
- email varchar(50) DEFAULT NULL NULL,
+ phone varchar(11 char) DEFAULT NULL NULL,
+ email varchar(50 char) DEFAULT NULL NULL,
status smallint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -582,7 +582,7 @@
-- ----------------------------
-- @formatter:off
SET IDENTITY_INSERT system_dept ON;
-INSERT INTO system_dept (id, name, parent_id, sort, leader_user_id, phone, email, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (100, '鑺嬮亾婧愮爜', 0, 0, 1, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2026-01-04 18:01:12', '0', 1);
+INSERT INTO system_dept (id, name, parent_id, sort, leader_user_id, phone, email, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (100, '瓒呯骇绠＄悊鍛�', 0, 0, 1, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2026-01-04 18:01:12', '0', 1);
INSERT INTO system_dept (id, name, parent_id, sort, leader_user_id, phone, email, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (101, '娣卞湷鎬诲叕鍙�', 100, 1, 104, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2025-03-29 15:49:55', '0', 1);
INSERT INTO system_dept (id, name, parent_id, sort, leader_user_id, phone, email, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (102, '闀挎矙鍒嗗叕鍙�', 100, 2, NULL, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '', '2021-12-15 05:01:40', '0', 1);
INSERT INTO system_dept (id, name, parent_id, sort, leader_user_id, phone, email, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (103, '鐮斿彂閮ㄩ棬', 101, 1, 104, '15888888888', 'ry@qq.com', 0, 'admin', '2021-01-05 17:03:47', '1', '2026-01-04 18:01:24', '0', 1);
@@ -608,16 +608,16 @@
CREATE TABLE system_dict_data (
id bigint NOT NULL PRIMARY KEY IDENTITY,
sort int DEFAULT 0 NOT NULL,
- label varchar(100) DEFAULT '' NULL,
- value varchar(100) DEFAULT '' NULL,
- dict_type varchar(100) DEFAULT '' NULL,
+ label varchar(100 char) DEFAULT '' NULL,
+ value varchar(100 char) DEFAULT '' NULL,
+ dict_type varchar(100 char) DEFAULT '' NULL,
status smallint DEFAULT 0 NOT NULL,
- color_type varchar(100) DEFAULT '' NULL,
- css_class varchar(100) DEFAULT '' NULL,
- remark varchar(500) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ color_type varchar(100 char) DEFAULT '' NULL,
+ css_class varchar(100 char) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -1270,6 +1270,8 @@
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3034, 1, 'ttt', 'tt', 'iot_ota_task_record_status', 0, 'success', '', NULL, '1', '2025-09-06 00:02:21', '1', '2025-09-06 00:02:31', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3035, 40, '鏀粯瀹濆皬绋嬪簭', '40', 'system_social_type', 0, '', '', '', '1', '2023-11-04 13:05:38', '1', '2023-11-04 13:07:16', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3036, 60, 'Admin Uniapp 绉诲姩绔�', '60', 'infra_codegen_front_type', 0, '', '', NULL, '1', '2025-12-16 19:25:51', '1', '2025-12-17 09:46:15', '0');
+INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3037, 42, 'Vben5.0 Antdv Next Schema 妯＄増', '42', 'infra_codegen_front_type', 0, '', '', '', '1', NOW(), '1', NOW(), '0');
+INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3038, 43, 'Vben5.0 Antdv Next 鏍囧噯妯＄増', '43', 'infra_codegen_front_type', 0, '', '', '', '1', NOW(), '1', NOW(), '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3040, 1, 'UDP', 'udp', 'iot_protocol_type', 0, '', '', 'UDP 鍗忚', '1', '2026-02-04 00:32:47', '1', '2026-02-04 00:32:47', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3041, 2, 'WebSocket', 'websocket', 'iot_protocol_type', 0, '', '', 'WebSocket 鍗忚', '1', '2026-02-04 00:32:55', '1', '2026-02-04 00:32:55', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3042, 3, 'HTTP', 'http', 'iot_protocol_type', 0, '', '', 'HTTP 鍗忚', '1', '2026-02-04 00:32:55', '1', '2026-02-04 00:32:55', '0');
@@ -1552,9 +1554,9 @@
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3443, 1, '鑽夌', '0', 'mes_wm_product_produce_status', 0, 'info', '', '鑽夌鐘舵��', '1', '2026-04-05 15:53:46', '1', '2026-04-05 15:53:46', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3444, 2, '宸插畬鎴�', '4', 'mes_wm_product_produce_status', 0, 'success', '', '宸插畬鎴愮姸鎬�', '1', '2026-04-05 15:53:46', '1', '2026-04-05 15:53:46', '0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3445, 3, '宸插彇娑�', '5', 'mes_wm_product_produce_status', 0, 'danger', '', '宸插彇娑堢姸鎬�', '1', '2026-04-05 15:53:46', '1', '2026-04-05 15:53:46', '0');
-INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3446, 0, '猫聧鈥懊�', '0', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
-INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3447, 1, '氓路虏氓庐艗忙藛聬', '4', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
-INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3448, 2, '氓路虏氓聫鈥撁β端�', '5', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
+INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3446, 0, '鑽夌', '0', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
+INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3447, 1, '宸插畬鎴�', '4', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
+INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted) VALUES (3448, 2, '宸插彇娑�', '5', 'mes_pro_task_status', 0, '', '', NULL, '1', '2026-04-16 09:47:00', '1', '2026-04-16 09:47:00', '0');
COMMIT;
SET IDENTITY_INSERT system_dict_data OFF;
-- @formatter:on
@@ -1564,13 +1566,13 @@
-- ----------------------------
CREATE TABLE system_dict_type (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(100) DEFAULT '' NULL,
- type varchar(100) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
+ type varchar(100 char) DEFAULT '' NULL,
status smallint DEFAULT 0 NOT NULL,
- remark varchar(500) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
deleted_time datetime DEFAULT NULL NULL
@@ -1790,16 +1792,16 @@
CREATE TABLE system_login_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
log_type bigint NOT NULL,
- trace_id varchar(64) DEFAULT '' NULL,
+ trace_id varchar(64 char) DEFAULT '' NULL,
user_id bigint DEFAULT 0 NOT NULL,
user_type smallint DEFAULT 0 NOT NULL,
- username varchar(50) DEFAULT '' NULL,
+ username varchar(50 char) DEFAULT '' NULL,
result smallint NOT NULL,
- user_ip varchar(50) NOT NULL,
- user_agent varchar(512) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ user_ip varchar(50 char) NOT NULL,
+ user_agent varchar(512 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -1830,16 +1832,16 @@
-- ----------------------------
CREATE TABLE system_mail_account (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- mail varchar(255) NOT NULL,
- username varchar(255) NOT NULL,
- password varchar(255) NOT NULL,
- host varchar(255) NOT NULL,
+ mail varchar(255 char) NOT NULL,
+ username varchar(255 char) NOT NULL,
+ password varchar(255 char) NOT NULL,
+ host varchar(255 char) NOT NULL,
port int NOT NULL,
ssl_enable bit DEFAULT '0' NOT NULL,
starttls_enable bit DEFAULT '0' NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -1879,24 +1881,24 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint DEFAULT NULL NULL,
user_type smallint DEFAULT NULL NULL,
- to_mails varchar(1024) NOT NULL,
- cc_mails varchar(1024) DEFAULT NULL NULL,
- bcc_mails varchar(1024) DEFAULT NULL NULL,
+ to_mails varchar(1024 char) NOT NULL,
+ cc_mails varchar(1024 char) DEFAULT NULL NULL,
+ bcc_mails varchar(1024 char) DEFAULT NULL NULL,
account_id bigint NOT NULL,
- from_mail varchar(255) NOT NULL,
+ from_mail varchar(255 char) NOT NULL,
template_id bigint NOT NULL,
- template_code varchar(63) NOT NULL,
- template_nickname varchar(255) DEFAULT NULL NULL,
- template_title varchar(255) NOT NULL,
+ template_code varchar(63 char) NOT NULL,
+ template_nickname varchar(255 char) DEFAULT NULL NULL,
+ template_title varchar(255 char) NOT NULL,
template_content text NOT NULL,
- template_params varchar(255) NOT NULL,
+ template_params varchar(255 char) NOT NULL,
send_status smallint DEFAULT 0 NOT NULL,
send_time datetime DEFAULT NULL NULL,
- send_message_id varchar(255) DEFAULT NULL NULL,
- send_exception varchar(4096) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ send_message_id varchar(255 char) DEFAULT NULL NULL,
+ send_exception varchar(4096 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -1931,18 +1933,18 @@
-- ----------------------------
CREATE TABLE system_mail_template (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(63) NOT NULL,
- code varchar(63) NOT NULL,
+ name varchar(63 char) NOT NULL,
+ code varchar(63 char) NOT NULL,
account_id bigint NOT NULL,
- nickname varchar(255) DEFAULT NULL NULL,
- title varchar(255) NOT NULL,
- content varchar(10240) NOT NULL,
- params varchar(255) NOT NULL,
+ nickname varchar(255 char) DEFAULT NULL NULL,
+ title varchar(255 char) NOT NULL,
+ content varchar(10240 char) NOT NULL,
+ params varchar(255 char) NOT NULL,
status smallint NOT NULL,
- remark varchar(255) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(255 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -1970,7 +1972,7 @@
-- @formatter:off
SET IDENTITY_INSERT system_mail_template ON;
INSERT INTO system_mail_template (id, name, code, account_id, nickname, title, content, params, status, remark, creator, create_time, updater, update_time, deleted) VALUES (13, '鍚庡彴鐢ㄦ埛鐭俊鐧诲綍', 'admin-sms-login', 1, '濂ョ壒鏇�', '浣犵寽鎴戠寽', '<p>鎮ㄧ殑楠岃瘉鐮佹槸{code}锛屽悕瀛楁槸{name}</p>', '["code","name"]', 0, '3', '1', '2021-10-11 08:10:00', '1', '2023-12-02 19:51:14', '0');
-INSERT INTO system_mail_template (id, name, code, account_id, nickname, title, content, params, status, remark, creator, create_time, updater, update_time, deleted) VALUES (14, '娴嬭瘯妯＄増', 'test_01', 2, '鑺嬭壙', '涓�涓爣棰�', '<p>浣犳槸 {key01} 鍚楋紵</p><p><br></p><p>鏄殑璇濓紝璧剁揣 {key02} 涓�涓嬶紒</p>', '["key01","key02"]', 0, NULL, '1', '2023-01-26 01:27:40', '1', '2025-07-26 21:48:45', '0');
+INSERT INTO system_mail_template (id, name, code, account_id, nickname, title, content, params, status, remark, creator, create_time, updater, update_time, deleted) VALUES (14, '娴嬭瘯妯＄増', 'test_01', 2, '绠＄悊鍛�', '涓�涓爣棰�', '<p>浣犳槸 {key01} 鍚楋紵</p><p><br></p><p>鏄殑璇濓紝璧剁揣 {key02} 涓�涓嬶紒</p>', '["key01","key02"]', 0, NULL, '1', '2023-01-26 01:27:40', '1', '2025-07-26 21:48:45', '0');
INSERT INTO system_mail_template (id, name, code, account_id, nickname, title, content, params, status, remark, creator, create_time, updater, update_time, deleted) VALUES (15, '3', '2', 2, '7', '4', '<p>45</p>', '[]', 1, '80', '1', '2023-01-27 15:50:35', '1', '2025-07-26 21:47:49', '1');
COMMIT;
SET IDENTITY_INSERT system_mail_template OFF;
@@ -1981,22 +1983,22 @@
-- ----------------------------
CREATE TABLE system_menu (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(50) NOT NULL,
- permission varchar(100) DEFAULT '' NULL,
+ name varchar(50 char) NOT NULL,
+ permission varchar(100 char) DEFAULT '' NULL,
type smallint NOT NULL,
sort int DEFAULT 0 NOT NULL,
parent_id bigint DEFAULT 0 NOT NULL,
- path varchar(200) DEFAULT '' NULL,
- icon varchar(100) DEFAULT '#' NULL,
- component varchar(255) DEFAULT NULL NULL,
- component_name varchar(255) DEFAULT NULL NULL,
+ path varchar(200 char) DEFAULT '' NULL,
+ icon varchar(100 char) DEFAULT '#' NULL,
+ component varchar(255 char) DEFAULT NULL NULL,
+ component_name varchar(255 char) DEFAULT NULL NULL,
status smallint DEFAULT 0 NOT NULL,
visible bit DEFAULT '1' NOT NULL,
keep_alive bit DEFAULT '1' NOT NULL,
always_show bit DEFAULT '1' NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -3357,13 +3359,13 @@
-- ----------------------------
CREATE TABLE system_notice (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- title varchar(50) NOT NULL,
+ title varchar(50 char) NOT NULL,
content text NOT NULL,
type smallint NOT NULL,
status smallint DEFAULT 0 NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3387,7 +3389,7 @@
-- ----------------------------
-- @formatter:off
SET IDENTITY_INSERT system_notice ON;
-INSERT INTO system_notice (id, title, content, type, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (1, '鑺嬮亾鐨勫叕浼�', '<p>鏂扮増鏈唴瀹�133222</p>', 1, 0, 'admin', '2021-01-05 17:03:48', '"1"', '2025-08-31 09:38:22', '0', 1);
+INSERT INTO system_notice (id, title, content, type, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (1, '瓒呯骇绠＄悊鍛樼殑鍏憡', '<p>鏂扮増鏈唴瀹�133222</p>', 1, 0, 'admin', '2021-01-05 17:03:48', '"1"', '2025-08-31 09:38:22', '0', 1);
INSERT INTO system_notice (id, title, content, type, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (2, '缁存姢閫氱煡锛�2018-07-01 绯荤粺鍑屾櫒缁存姢', '<p><img src="http://test.yudao.iocoder.cn/b7cb3cf49b4b3258bf7309a09dd2f4e5.jpg" alt="" data-href="">11112222<img src="http://test.yudao.iocoder.cn/fe44fc7bdb82ca421184b2eebbaee9e2148d4a1827479a4eb4521e11d2a062ba.png" alt="image" data-href="http://test.yudao.iocoder.cn/fe44fc7bdb82ca421184b2eebbaee9e2148d4a1827479a4eb4521e11d2a062ba.png">3333</p>', 2, 1, 'admin', '2021-01-05 17:03:48', '1', '2025-04-18 23:56:40', '0', 1);
INSERT INTO system_notice (id, title, content, type, status, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (4, '鎴戞槸娴嬭瘯鏍囬', '<p>鍝堝搱鍝堝搱123</p>', 1, 0, '110', '2022-02-22 01:01:25', '110', '2022-02-22 01:01:46', '0', 121);
COMMIT;
@@ -3402,16 +3404,16 @@
user_id bigint NOT NULL,
user_type smallint NOT NULL,
template_id bigint NOT NULL,
- template_code varchar(64) NOT NULL,
- template_nickname varchar(63) NOT NULL,
- template_content varchar(1024) NOT NULL,
+ template_code varchar(64 char) NOT NULL,
+ template_nickname varchar(63 char) NOT NULL,
+ template_content varchar(1024 char) NOT NULL,
template_type int NOT NULL,
- template_params varchar(255) NOT NULL,
+ template_params varchar(255 char) NOT NULL,
read_status bit NOT NULL,
read_time datetime DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3446,8 +3448,8 @@
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (2, 1, 2, 1, 'test', '123', '鎴戞槸 1锛屾垜寮�濮� 2 浜�', 1, '{"name":"1","what":"2"}', '1', '2025-12-15 21:24:36', '1', '2023-01-28 11:44:08', '1', '2025-12-15 21:24:36', '0', 1);
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (3, 1, 2, 1, 'test', '123', '鎴戞槸 1锛屾垜寮�濮� 2 浜�', 1, '{"name":"1","what":"2"}', '1', '2025-12-15 21:24:36', '1', '2023-01-28 11:45:04', '1', '2025-12-15 21:24:36', '0', 1);
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (4, 103, 2, 2, 'register', '绯荤粺娑堟伅', '浣犲ソ锛屾杩� 鍝堝搱 鍔犲叆澶у搴紒', 2, '{"name":"鍝堝搱"}', '0', NULL, '1', '2023-01-28 21:02:20', '1', '2023-01-28 21:02:20', '0', 1);
-INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (5, 1, 2, 1, 'test', '123', '鎴戞槸 鑺嬭壙锛屾垜寮�濮� 鍐欎唬鐮� 浜�', 1, '{"name":"鑺嬭壙","what":"鍐欎唬鐮�"}', '1', '2025-12-08 17:25:28', '1', '2023-01-28 22:21:42', '1', '2025-12-08 17:25:28', '0', 1);
-INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (6, 1, 2, 1, 'test', '123', '鎴戞槸 鑺嬭壙锛屾垜寮�濮� 鍐欎唬鐮� 浜�', 1, '{"name":"鑺嬭壙","what":"鍐欎唬鐮�"}', '1', '2025-12-08 17:25:30', '1', '2023-01-28 22:22:07', '1', '2025-12-08 17:25:30', '0', 1);
+INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (5, 1, 2, 1, 'test', '123', '鎴戞槸 绠＄悊鍛橈紝鎴戝紑濮� 鍐欎唬鐮� 浜�', 1, '{"name":"绠＄悊鍛�","what":"鍐欎唬鐮�"}', '1', '2025-12-08 17:25:28', '1', '2023-01-28 22:21:42', '1', '2025-12-08 17:25:28', '0', 1);
+INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (6, 1, 2, 1, 'test', '123', '鎴戞槸 绠＄悊鍛橈紝鎴戝紑濮� 鍐欎唬鐮� 浜�', 1, '{"name":"绠＄悊鍛�","what":"鍐欎唬鐮�"}', '1', '2025-12-08 17:25:30', '1', '2023-01-28 22:22:07', '1', '2025-12-08 17:25:30', '0', 1);
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (7, 1, 2, 1, 'test', '123', '鎴戞槸 2锛屾垜寮�濮� 3 浜�', 1, '{"name":"2","what":"3"}', '1', '2025-12-08 17:25:22', '1', '2023-01-28 23:45:21', '1', '2025-12-08 17:25:22', '0', 1);
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (8, 1, 2, 2, 'register', '绯荤粺娑堟伅', '浣犲ソ锛屾杩� 123 鍔犲叆澶у搴紒', 2, '{"name":"123"}', '1', '2025-12-08 16:46:01', '1', '2023-01-28 23:50:21', '1', '2025-12-08 16:46:01', '0', 1);
INSERT INTO system_notify_message (id, user_id, user_type, template_id, template_code, template_nickname, template_content, template_type, template_params, read_status, read_time, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (9, 247, 1, 4, 'brokerage_withdraw_audit_approve', 'system', '鎮ㄥ湪2023-09-28 08:35:46鎻愮幇锟�0.09鍏冪殑鐢宠宸查�氳繃瀹℃牳', 2, '{"reason":null,"createTime":"2023-09-28 08:35:46","price":"0.09"}', '0', NULL, '1', '2023-09-28 16:36:22', '1', '2023-09-28 16:36:22', '0', 1);
@@ -3461,17 +3463,17 @@
-- ----------------------------
CREATE TABLE system_notify_template (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(63) NOT NULL,
- code varchar(64) NOT NULL,
- nickname varchar(255) NOT NULL,
- content varchar(1024) NOT NULL,
+ name varchar(63 char) NOT NULL,
+ code varchar(64 char) NOT NULL,
+ nickname varchar(255 char) NOT NULL,
+ content varchar(1024 char) NOT NULL,
type smallint NOT NULL,
- params varchar(255) DEFAULT NULL NULL,
+ params varchar(255 char) DEFAULT NULL NULL,
status smallint NOT NULL,
- remark varchar(255) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(255 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -3499,15 +3501,15 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint NOT NULL,
user_type smallint NOT NULL,
- user_info varchar(512) NOT NULL,
- access_token varchar(255) NOT NULL,
- refresh_token varchar(32) NOT NULL,
- client_id varchar(255) NOT NULL,
- scopes varchar(255) DEFAULT NULL NULL,
+ user_info varchar(512 char) NOT NULL,
+ access_token varchar(255 char) NOT NULL,
+ refresh_token varchar(32 char) NOT NULL,
+ client_id varchar(255 char) NOT NULL,
+ scopes varchar(255 char) DEFAULT NULL NULL,
expires_time datetime NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3540,13 +3542,13 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint NOT NULL,
user_type smallint NOT NULL,
- client_id varchar(255) NOT NULL,
- scope varchar(255) DEFAULT '' NULL,
+ client_id varchar(255 char) NOT NULL,
+ scope varchar(255 char) DEFAULT '' NULL,
approved bit DEFAULT '0' NOT NULL,
expires_time datetime NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3574,24 +3576,24 @@
-- ----------------------------
CREATE TABLE system_oauth2_client (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- client_id varchar(255) NOT NULL,
- secret varchar(255) NOT NULL,
- name varchar(255) NOT NULL,
- logo varchar(255) NOT NULL,
- description varchar(255) DEFAULT NULL NULL,
+ client_id varchar(255 char) NOT NULL,
+ secret varchar(255 char) NOT NULL,
+ name varchar(255 char) NOT NULL,
+ logo varchar(255 char) NOT NULL,
+ description varchar(255 char) DEFAULT NULL NULL,
status smallint NOT NULL,
access_token_validity_seconds int NOT NULL,
refresh_token_validity_seconds int NOT NULL,
- redirect_uris varchar(255) NOT NULL,
- authorized_grant_types varchar(255) NOT NULL,
- scopes varchar(255) DEFAULT NULL NULL,
- auto_approve_scopes varchar(255) DEFAULT NULL NULL,
- authorities varchar(255) DEFAULT NULL NULL,
- resource_ids varchar(255) DEFAULT NULL NULL,
- additional_information varchar(4096) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ redirect_uris varchar(255 char) NOT NULL,
+ authorized_grant_types varchar(255 char) NOT NULL,
+ scopes varchar(255 char) DEFAULT NULL NULL,
+ auto_approve_scopes varchar(255 char) DEFAULT NULL NULL,
+ authorities varchar(255 char) DEFAULT NULL NULL,
+ resource_ids varchar(255 char) DEFAULT NULL NULL,
+ additional_information varchar(4096 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -3626,7 +3628,7 @@
-- ----------------------------
-- @formatter:off
SET IDENTITY_INSERT system_oauth2_client ON;
-INSERT INTO system_oauth2_client (id, client_id, secret, name, logo, description, status, access_token_validity_seconds, refresh_token_validity_seconds, redirect_uris, authorized_grant_types, scopes, auto_approve_scopes, authorities, resource_ids, additional_information, creator, create_time, updater, update_time, deleted) VALUES (1, 'default', 'admin123', '鑺嬮亾婧愮爜', 'http://test.yudao.iocoder.cn/20250502/sort2_1746189740718.png', '鎴戞槸鎻忚堪', 0, 1800, 2592000, '["https://www.iocoder.cn","https://doc.iocoder.cn"]', '["password","authorization_code","implicit","refresh_token","client_credentials"]', '["user.read","user.write"]', '[]', '["user.read","user.write"]', '[]', '{}', '1', '2022-05-11 21:47:12', '1', '2025-12-07 20:07:09', '0');
+INSERT INTO system_oauth2_client (id, client_id, secret, name, logo, description, status, access_token_validity_seconds, refresh_token_validity_seconds, redirect_uris, authorized_grant_types, scopes, auto_approve_scopes, authorities, resource_ids, additional_information, creator, create_time, updater, update_time, deleted) VALUES (1, 'default', 'admin123', '瓒呯骇绠＄悊鍛�', 'http://test.yudao.iocoder.cn/20250502/sort2_1746189740718.png', '鎴戞槸鎻忚堪', 0, 1800, 2592000, '["https://www.iocoder.cn","https://doc.iocoder.cn"]', '["password","authorization_code","implicit","refresh_token","client_credentials"]', '["user.read","user.write"]', '[]', '["user.read","user.write"]', '[]', '{}', '1', '2022-05-11 21:47:12', '1', '2025-12-07 20:07:09', '0');
INSERT INTO system_oauth2_client (id, client_id, secret, name, logo, description, status, access_token_validity_seconds, refresh_token_validity_seconds, redirect_uris, authorized_grant_types, scopes, auto_approve_scopes, authorities, resource_ids, additional_information, creator, create_time, updater, update_time, deleted) VALUES (40, 'test', 'test2', 'biubiu', 'http://test.yudao.iocoder.cn/20251227/javayuanma_1766829882970.jpg', '鍟﹀暒鍟﹀暒', 0, 1800, 43200, '["https://www.iocoder.cn"]', '["password","authorization_code","implicit"]', '["user_info","projects"]', '["user_info"]', '[]', '[]', '{}', '1', '2022-05-12 00:28:20', '1', '2025-12-27 18:04:44', '0');
INSERT INTO system_oauth2_client (id, client_id, secret, name, logo, description, status, access_token_validity_seconds, refresh_token_validity_seconds, redirect_uris, authorized_grant_types, scopes, auto_approve_scopes, authorities, resource_ids, additional_information, creator, create_time, updater, update_time, deleted) VALUES (41, 'yudao-sso-demo-by-code', 'test', '鍩轰簬鎺堟潈鐮佹ā寮忥紝濡備綍瀹炵幇 SSO 鍗曠偣鐧诲綍锛�', 'http://test.yudao.iocoder.cn/it/20250502/sign_1746181948685.png', NULL, 0, 1800, 43200, '["http://127.0.0.1:18080"]', '["authorization_code","refresh_token"]', '["user.read","user.write"]', '[]', '[]', '[]', NULL, '1', '2022-09-29 13:28:31', '1', '2025-05-02 18:32:30', '0');
INSERT INTO system_oauth2_client (id, client_id, secret, name, logo, description, status, access_token_validity_seconds, refresh_token_validity_seconds, redirect_uris, authorized_grant_types, scopes, auto_approve_scopes, authorities, resource_ids, additional_information, creator, create_time, updater, update_time, deleted) VALUES (42, 'yudao-sso-demo-by-password', 'test', '鍩轰簬瀵嗙爜妯″紡锛屽浣曞疄鐜� SSO 鍗曠偣鐧诲綍锛�', 'http://test.yudao.iocoder.cn/20251025/images (3)_1761360515810.jpeg', NULL, 0, 1800, 43200, '["http://127.0.0.1:18080"]', '["password","refresh_token"]', '["user.read","user.write"]', '[]', '[]', '[]', NULL, '1', '2022-10-04 17:40:16', '1', '2025-10-25 10:49:40', '0');
@@ -3641,15 +3643,15 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint NOT NULL,
user_type smallint NOT NULL,
- code varchar(32) NOT NULL,
- client_id varchar(255) NOT NULL,
- scopes varchar(255) DEFAULT '' NULL,
+ code varchar(32 char) NOT NULL,
+ client_id varchar(255 char) NOT NULL,
+ scopes varchar(255 char) DEFAULT '' NULL,
expires_time datetime NOT NULL,
- redirect_uri varchar(255) DEFAULT NULL NULL,
- state varchar(255) DEFAULT '' NULL,
- creator varchar(64) DEFAULT '' NULL,
+ redirect_uri varchar(255 char) DEFAULT NULL NULL,
+ state varchar(255 char) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3680,14 +3682,14 @@
CREATE TABLE system_oauth2_refresh_token (
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint NOT NULL,
- refresh_token varchar(32) NOT NULL,
+ refresh_token varchar(32 char) NOT NULL,
user_type smallint NOT NULL,
- client_id varchar(255) NOT NULL,
- scopes varchar(255) DEFAULT NULL NULL,
+ client_id varchar(255 char) NOT NULL,
+ scopes varchar(255 char) DEFAULT NULL NULL,
expires_time datetime NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3715,22 +3717,22 @@
-- ----------------------------
CREATE TABLE system_operate_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- trace_id varchar(64) DEFAULT '' NULL,
+ trace_id varchar(64 char) DEFAULT '' NULL,
user_id bigint NOT NULL,
user_type smallint DEFAULT 0 NOT NULL,
- type varchar(50) NOT NULL,
- sub_type varchar(50) NOT NULL,
+ type varchar(50 char) NOT NULL,
+ sub_type varchar(50 char) NOT NULL,
biz_id bigint NOT NULL,
- action varchar(2000) DEFAULT '' NULL,
+ action varchar(2000 char) DEFAULT '' NULL,
success bit DEFAULT '1' NOT NULL,
- extra varchar(2000) DEFAULT '' NULL,
- request_method varchar(16) DEFAULT '' NULL,
- request_url varchar(255) DEFAULT '' NULL,
- user_ip varchar(50) DEFAULT NULL NULL,
- user_agent varchar(512) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ extra varchar(2000 char) DEFAULT '' NULL,
+ request_method varchar(16 char) DEFAULT '' NULL,
+ request_url varchar(255 char) DEFAULT '' NULL,
+ user_ip varchar(50 char) DEFAULT NULL NULL,
+ user_agent varchar(512 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3766,14 +3768,14 @@
-- ----------------------------
CREATE TABLE system_post (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- code varchar(64) NOT NULL,
- name varchar(50) NOT NULL,
+ code varchar(64 char) NOT NULL,
+ name varchar(50 char) NOT NULL,
sort int NOT NULL,
status smallint NOT NULL,
- remark varchar(500) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3811,17 +3813,17 @@
-- ----------------------------
CREATE TABLE system_role (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(30) NOT NULL,
- code varchar(100) NOT NULL,
+ name varchar(30 char) NOT NULL,
+ code varchar(100 char) NOT NULL,
sort int NOT NULL,
data_scope smallint DEFAULT 1 NOT NULL,
- data_scope_dept_ids varchar(500) DEFAULT '' NULL,
+ data_scope_dept_ids varchar(500 char) DEFAULT '' NULL,
status smallint NOT NULL,
type smallint NOT NULL,
- remark varchar(500) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -3866,9 +3868,9 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
role_id bigint NOT NULL,
menu_id bigint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -4787,16 +4789,16 @@
-- ----------------------------
CREATE TABLE system_sms_channel (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- signature varchar(12) NOT NULL,
- code varchar(63) NOT NULL,
+ signature varchar(12 char) NOT NULL,
+ code varchar(63 char) NOT NULL,
status smallint NOT NULL,
- remark varchar(255) DEFAULT NULL NULL,
- api_key varchar(128) NOT NULL,
- api_secret varchar(128) DEFAULT NULL NULL,
- callback_url varchar(255) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(255 char) DEFAULT NULL NULL,
+ api_key varchar(128 char) NOT NULL,
+ api_secret varchar(128 char) DEFAULT NULL NULL,
+ callback_url varchar(255 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -4833,17 +4835,17 @@
-- ----------------------------
CREATE TABLE system_sms_code (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- mobile varchar(11) NOT NULL,
- code varchar(6) NOT NULL,
- create_ip varchar(15) NOT NULL,
+ mobile varchar(11 char) NOT NULL,
+ code varchar(6 char) NOT NULL,
+ create_ip varchar(15 char) NOT NULL,
scene smallint NOT NULL,
today_index smallint NOT NULL,
used smallint NOT NULL,
used_time datetime DEFAULT NULL NULL,
- used_ip varchar(255) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ used_ip varchar(255 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -4874,29 +4876,29 @@
CREATE TABLE system_sms_log (
id bigint NOT NULL PRIMARY KEY IDENTITY,
channel_id bigint NOT NULL,
- channel_code varchar(63) NOT NULL,
+ channel_code varchar(63 char) NOT NULL,
template_id bigint NOT NULL,
- template_code varchar(63) NOT NULL,
+ template_code varchar(63 char) NOT NULL,
template_type smallint NOT NULL,
- template_content varchar(255) NOT NULL,
- template_params varchar(255) NOT NULL,
- api_template_id varchar(63) NOT NULL,
- mobile varchar(11) NOT NULL,
+ template_content varchar(255 char) NOT NULL,
+ template_params varchar(255 char) NOT NULL,
+ api_template_id varchar(63 char) NOT NULL,
+ mobile varchar(11 char) NOT NULL,
user_id bigint DEFAULT NULL NULL,
user_type smallint DEFAULT NULL NULL,
send_status smallint DEFAULT 0 NOT NULL,
send_time datetime DEFAULT NULL NULL,
- api_send_code varchar(63) DEFAULT NULL NULL,
- api_send_msg varchar(255) DEFAULT NULL NULL,
- api_request_id varchar(255) DEFAULT NULL NULL,
- api_serial_no varchar(255) DEFAULT NULL NULL,
+ api_send_code varchar(63 char) DEFAULT NULL NULL,
+ api_send_msg varchar(255 char) DEFAULT NULL NULL,
+ api_request_id varchar(255 char) DEFAULT NULL NULL,
+ api_serial_no varchar(255 char) DEFAULT NULL NULL,
receive_status smallint DEFAULT 0 NOT NULL,
receive_time datetime DEFAULT NULL NULL,
- api_receive_code varchar(63) DEFAULT NULL NULL,
- api_receive_msg varchar(255) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ api_receive_code varchar(63 char) DEFAULT NULL NULL,
+ api_receive_msg varchar(255 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -4937,17 +4939,17 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
type smallint NOT NULL,
status smallint NOT NULL,
- code varchar(63) NOT NULL,
- name varchar(63) NOT NULL,
- content varchar(255) NOT NULL,
- params varchar(255) NOT NULL,
- remark varchar(255) DEFAULT NULL NULL,
- api_template_id varchar(63) NOT NULL,
+ code varchar(63 char) NOT NULL,
+ name varchar(63 char) NOT NULL,
+ content varchar(255 char) NOT NULL,
+ params varchar(255 char) NOT NULL,
+ remark varchar(255 char) DEFAULT NULL NULL,
+ api_template_id varchar(63 char) NOT NULL,
channel_id bigint NOT NULL,
- channel_code varchar(63) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ channel_code varchar(63 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -4999,17 +5001,17 @@
-- ----------------------------
CREATE TABLE system_social_client (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(255) NOT NULL,
+ name varchar(255 char) NOT NULL,
social_type smallint NOT NULL,
user_type smallint NOT NULL,
- client_id varchar(255) NOT NULL,
- client_secret varchar(255) NOT NULL,
- agent_id varchar(255) DEFAULT NULL NULL,
- public_key varchar(2048) DEFAULT NULL NULL,
+ client_id varchar(255 char) NOT NULL,
+ client_secret varchar(255 char) NOT NULL,
+ agent_id varchar(255 char) DEFAULT NULL NULL,
+ public_key varchar(2048 char) DEFAULT NULL NULL,
status smallint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5055,17 +5057,17 @@
CREATE TABLE system_social_user (
id bigint NOT NULL PRIMARY KEY IDENTITY,
type smallint NOT NULL,
- openid varchar(32) NOT NULL,
- token varchar(256) DEFAULT NULL NULL,
- raw_token_info varchar(1024) NOT NULL,
- nickname varchar(32) NOT NULL,
- avatar varchar(255) DEFAULT NULL NULL,
- raw_user_info varchar(1024) NOT NULL,
- code varchar(256) NOT NULL,
- state varchar(256) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ openid varchar(32 char) NOT NULL,
+ token varchar(256 char) DEFAULT NULL NULL,
+ raw_token_info varchar(1024 char) NOT NULL,
+ nickname varchar(32 char) NOT NULL,
+ avatar varchar(255 char) DEFAULT NULL NULL,
+ raw_user_info varchar(1024 char) NOT NULL,
+ code varchar(256 char) NOT NULL,
+ state varchar(256 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5101,9 +5103,9 @@
user_type smallint NOT NULL,
social_type smallint NOT NULL,
social_user_id bigint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5129,18 +5131,18 @@
-- ----------------------------
CREATE TABLE system_tenant (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(30) NOT NULL,
+ name varchar(30 char) NOT NULL,
contact_user_id bigint DEFAULT NULL NULL,
- contact_name varchar(30) NOT NULL,
- contact_mobile varchar(500) DEFAULT NULL NULL,
+ contact_name varchar(30 char) NOT NULL,
+ contact_mobile varchar(500 char) DEFAULT NULL NULL,
status smallint DEFAULT 0 NOT NULL,
- websites varchar(1024) DEFAULT '' NULL,
+ websites varchar(1024 char) DEFAULT '' NULL,
package_id bigint NOT NULL,
expire_time datetime NOT NULL,
account_count int NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -5167,9 +5169,9 @@
-- ----------------------------
-- @formatter:off
SET IDENTITY_INSERT system_tenant ON;
-INSERT INTO system_tenant (id, name, contact_user_id, contact_name, contact_mobile, status, websites, package_id, expire_time, account_count, creator, create_time, updater, update_time, deleted) VALUES (1, '鑺嬮亾婧愮爜', NULL, '鑺嬭壙', '17321315478', 0, 'www.iocoder.cn,127.0.0.1:3000,wxc4598c446f8a9cb3', 0, '2099-02-19 17:14:16', 9999, '1', '2021-01-05 17:03:47', '1', '2025-08-19 05:18:41', '0');
+INSERT INTO system_tenant (id, name, contact_user_id, contact_name, contact_mobile, status, websites, package_id, expire_time, account_count, creator, create_time, updater, update_time, deleted) VALUES (1, '瓒呯骇绠＄悊鍛�', NULL, '绠＄悊鍛�', '17321315478', 0, 'www.iocoder.cn,127.0.0.1:3000,wxc4598c446f8a9cb3', 0, '2099-02-19 17:14:16', 9999, '1', '2021-01-05 17:03:47', '1', '2025-08-19 05:18:41', '0');
INSERT INTO system_tenant (id, name, contact_user_id, contact_name, contact_mobile, status, websites, package_id, expire_time, account_count, creator, create_time, updater, update_time, deleted) VALUES (121, '灏忕鎴�', 110, '灏忕帇2', '15601691300', 0, 'zsxq.iocoder.cn,123321', 111, '2026-07-10 00:00:00', 30, '1', '2022-02-22 00:56:14', '1', '2025-08-19 21:19:29', '0');
-INSERT INTO system_tenant (id, name, contact_user_id, contact_name, contact_mobile, status, websites, package_id, expire_time, account_count, creator, create_time, updater, update_time, deleted) VALUES (122, '娴嬭瘯绉熸埛', 113, '鑺嬮亾', '15601691300', 0, 'test.iocoder.cn,222,333', 111, '2023-04-29 00:00:00', 50, '1', '2022-03-07 21:37:58', '1', '2025-12-21 09:50:00', '0');
+INSERT INTO system_tenant (id, name, contact_user_id, contact_name, contact_mobile, status, websites, package_id, expire_time, account_count, creator, create_time, updater, update_time, deleted) VALUES (122, '娴嬭瘯绉熸埛', 113, '瓒呯骇绠＄悊鍛�', '15601691300', 0, 'test.iocoder.cn,222,333', 111, '2023-04-29 00:00:00', 50, '1', '2022-03-07 21:37:58', '1', '2025-12-21 09:50:00', '0');
COMMIT;
SET IDENTITY_INSERT system_tenant OFF;
-- @formatter:on
@@ -5179,13 +5181,13 @@
-- ----------------------------
CREATE TABLE system_tenant_package (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(30) NOT NULL,
+ name varchar(30 char) NOT NULL,
status smallint DEFAULT 0 NOT NULL,
- remark varchar(256) DEFAULT '' NULL,
- menu_ids varchar(4096) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ remark varchar(256 char) DEFAULT '' NULL,
+ menu_ids varchar(4096 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL
);
@@ -5219,9 +5221,9 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint DEFAULT 0 NOT NULL,
post_id bigint DEFAULT 0 NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5265,9 +5267,9 @@
id bigint NOT NULL PRIMARY KEY IDENTITY,
user_id bigint NOT NULL,
role_id bigint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NULL,
deleted bit DEFAULT '0' NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5321,22 +5323,22 @@
-- ----------------------------
CREATE TABLE system_users (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- username varchar(30) NOT NULL,
- password varchar(100) DEFAULT '' NULL,
- nickname varchar(30) NOT NULL,
- remark varchar(500) DEFAULT NULL NULL,
+ username varchar(30 char) NOT NULL,
+ password varchar(100 char) DEFAULT '' NULL,
+ nickname varchar(30 char) NOT NULL,
+ remark varchar(500 char) DEFAULT NULL NULL,
dept_id bigint DEFAULT NULL NULL,
- post_ids varchar(255) DEFAULT NULL NULL,
- email varchar(50) DEFAULT '' NULL,
- mobile varchar(11) DEFAULT '' NULL,
+ post_ids varchar(255 char) DEFAULT NULL NULL,
+ email varchar(50 char) DEFAULT '' NULL,
+ mobile varchar(11 char) DEFAULT '' NULL,
sex smallint DEFAULT 0 NULL,
- avatar varchar(512) DEFAULT '' NULL,
+ avatar varchar(512 char) DEFAULT '' NULL,
status smallint DEFAULT 0 NOT NULL,
- login_ip varchar(50) DEFAULT '' NULL,
+ login_ip varchar(50 char) DEFAULT '' NULL,
login_date datetime DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5374,17 +5376,17 @@
-- ----------------------------
-- @formatter:off
SET IDENTITY_INSERT system_users ON;
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (1, 'admin', '$2a$04$.vd8nPeLwxt6hnSzmAoAyul8BOLX7Cib6QhcxRe30rfvrIPQHH1OG', '鑺嬮亾婧愮爜', '绠＄悊鍛�', 103, '[1,2]', '13aoteman@126.com', '18818260272', 1, 'http://test.yudao.iocoder.cn/user/avatar/20251220/blob_1766215463801.jpg', 0, '0:0:0:0:0:0:0:1', '2026-04-17 08:47:40', 'admin', '2021-01-05 17:03:47', NULL, '2026-04-17 08:47:40', '0', 1);
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (100, 'yudao', '$2a$04$h.aaPKgO.odHepnk5PCsWeEwKdojFWdTItxGKfx1r0e1CSeBzsTJ6', '鑺嬮亾', '涓嶈鍚撴垜', 104, '[1]', 'yudao@iocoder.cn', '15601691300', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2025-12-15 21:47:26', '', '2021-01-07 09:07:17', NULL, '2025-12-15 21:47:26', '0', 1);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (1, 'admin', '$2a$04$.vd8nPeLwxt6hnSzmAoAyul8BOLX7Cib6QhcxRe30rfvrIPQHH1OG', '瓒呯骇绠＄悊鍛�', '绠＄悊鍛�', 103, '[1,2]', '13aoteman@126.com', '18818260272', 1, 'http://test.yudao.iocoder.cn/user/avatar/20251220/blob_1766215463801.jpg', 0, '0:0:0:0:0:0:0:1', '2026-04-17 08:47:40', 'admin', '2021-01-05 17:03:47', NULL, '2026-04-17 08:47:40', '0', 1);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (100, 'yudao', '$2a$04$h.aaPKgO.odHepnk5PCsWeEwKdojFWdTItxGKfx1r0e1CSeBzsTJ6', '瓒呯骇绠＄悊鍛�', '涓嶈鍚撴垜', 104, '[1]', 'yudao@iocoder.cn', '15601691300', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2025-12-15 21:47:26', '', '2021-01-07 09:07:17', NULL, '2025-12-15 21:47:26', '0', 1);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (103, 'yuanma', '$2a$04$fUBSmjKCPYAUmnMzOb6qE.eZCGPhHi1JmAKclODbfS/O7fHOl2bH6', '婧愮爜', NULL, 106, NULL, 'yuanma@iocoder.cn', '15601701300', 0, NULL, 0, '0:0:0:0:0:0:0:1', '2024-08-11 17:48:12', '', '2021-01-13 23:50:35', '1', '2025-07-09 23:41:58', '0', 1);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (104, 'test', '$2a$04$BrwaYn303hjA/6TnXqdGoOLhyHOAA0bVrAFu6.1dJKycqKUnIoRz2', '娴嬭瘯鍙�', NULL, 107, '[1,2]', '111@qq.com', '15601691200', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2026-01-04 18:09:54', '', '2021-01-21 02:13:53', NULL, '2026-01-04 18:09:54', '0', 1);
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (107, 'admin107', '$2a$10$dYOOBKMO93v/.ReCqzyFg.o67Tqk.bbc2bhrpyBGkIw9aypCtr2pm', '鑺嬭壙', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 22:59:33', '1', '2025-04-21 14:23:08', '0', 118);
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (108, 'admin108', '$2a$10$y6mfvKoNYL1GXWak8nYwVOH.kCWqjactkzdoIDgiKl93WN3Ejg.Lu', '鑺嬭壙', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 23:00:50', '1', '2025-04-21 14:23:08', '0', 119);
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (109, 'admin109', '$2a$10$JAqvH0tEc0I7dfDVBI7zyuB4E3j.uH6daIjV53.vUS6PknFkDJkuK', '鑺嬭壙', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 23:11:50', '1', '2025-04-21 14:23:08', '0', 120);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (107, 'admin107', '$2a$10$dYOOBKMO93v/.ReCqzyFg.o67Tqk.bbc2bhrpyBGkIw9aypCtr2pm', '绠＄悊鍛�', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 22:59:33', '1', '2025-04-21 14:23:08', '0', 118);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (108, 'admin108', '$2a$10$y6mfvKoNYL1GXWak8nYwVOH.kCWqjactkzdoIDgiKl93WN3Ejg.Lu', '绠＄悊鍛�', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 23:00:50', '1', '2025-04-21 14:23:08', '0', 119);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (109, 'admin109', '$2a$10$JAqvH0tEc0I7dfDVBI7zyuB4E3j.uH6daIjV53.vUS6PknFkDJkuK', '绠＄悊鍛�', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '', NULL, '1', '2022-02-20 23:11:50', '1', '2025-04-21 14:23:08', '0', 120);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (110, 'admin110', '$2a$10$mRMIYLDtRHlf6.9ipiqH1.Z.bh/R9dO9d5iHiGYPigi6r5KOoR2Wm', '灏忕帇', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '0:0:0:0:0:0:0:1', '2024-07-20 22:23:17', '1', '2022-02-22 00:56:14', NULL, '2025-04-21 14:23:08', '0', 121);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (111, 'test', '$2a$10$mRMIYLDtRHlf6.9ipiqH1.Z.bh/R9dO9d5iHiGYPigi6r5KOoR2Wm', '娴嬭瘯鐢ㄦ埛', NULL, NULL, '[]', '', '', 0, NULL, 0, '0:0:0:0:0:0:0:1', '2023-12-30 11:42:17', '110', '2022-02-23 13:14:33', NULL, '2025-04-21 14:23:08', '0', 121);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (112, 'newobject', '$2a$04$dB0z8Q819fJWz0hbaLe6B.VfHCjYgWx6LFfET5lyz3JwcqlyCkQ4C', '鏂板璞�', NULL, 100, '[]', '', '15601691235', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2024-03-16 23:11:38', '1', '2022-02-23 19:08:03', NULL, '2025-04-21 14:23:08', '0', 1);
-INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (113, 'aoteman', '$2a$10$0acJOIk2D25/oC87nyclE..0lzeu9DtQ/n3geP4fkun/zIVRhHJIO', '鑺嬮亾1', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '127.0.0.1', '2022-03-19 18:38:51', '1', '2022-03-07 21:37:58', '1', '2025-05-05 15:30:53', '0', 122);
+INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (113, 'aoteman', '$2a$10$0acJOIk2D25/oC87nyclE..0lzeu9DtQ/n3geP4fkun/zIVRhHJIO', '瓒呯骇绠＄悊鍛�1', NULL, NULL, NULL, '', '15601691300', 0, NULL, 0, '127.0.0.1', '2022-03-19 18:38:51', '1', '2022-03-07 21:37:58', '1', '2025-05-05 15:30:53', '0', 122);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (114, 'hrmgr', '$2a$10$TR4eybBioGRhBmDBWkqWLO6NIh3mzYa8KBKDDB5woiGYFVlRAi.fu', 'hr 灏忓濮�', NULL, NULL, '[5]', '', '15601691236', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2026-01-04 18:16:01', '1', '2022-03-19 21:50:58', NULL, '2026-01-04 18:16:01', '0', 1);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (115, 'aotemane', '$2a$04$GcyP0Vyzb2F2Yni5PuIK9ueGxM0tkZGMtDwVRwrNbtMvorzbpNsV2', '闃垮憜', '11222', 102, '[1,2]', '7648@qq.com', '15601691229', 2, NULL, 0, '', NULL, '1', '2022-04-30 02:55:43', '1', '2025-04-21 14:23:08', '0', 1);
INSERT INTO system_users (id, username, password, nickname, remark, dept_id, post_ids, email, mobile, sex, avatar, status, login_ip, login_date, creator, create_time, updater, update_time, deleted, tenant_id) VALUES (117, 'admin123', '$2a$04$sEtimsHu9YCkYY4/oqElHem2Ijc9ld20eYO6lN.g/21NfLUTDLB9W', '娴嬭瘯鍙�02', '1111', 100, '[2]', '', '15601691234', 1, NULL, 0, '0:0:0:0:0:0:0:1', '2024-10-02 10:16:20', '1', '2022-07-09 17:40:26', '1', '2025-05-14 09:56:04', '0', 1);
@@ -5403,14 +5405,14 @@
-- ----------------------------
CREATE TABLE yudao_demo01_contact (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(100) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
sex smallint NOT NULL,
birthday datetime NOT NULL,
- description varchar(255) NOT NULL,
- avatar varchar(512) DEFAULT NULL NULL,
- creator varchar(64) DEFAULT '' NULL,
+ description varchar(255 char) NOT NULL,
+ avatar varchar(512 char) DEFAULT NULL NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5445,11 +5447,11 @@
-- ----------------------------
CREATE TABLE yudao_demo02_category (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(100) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
parent_id bigint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5488,11 +5490,11 @@
CREATE TABLE yudao_demo03_course (
id bigint NOT NULL PRIMARY KEY IDENTITY,
student_id bigint NOT NULL,
- name varchar(100) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
score smallint NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5542,11 +5544,11 @@
CREATE TABLE yudao_demo03_grade (
id bigint NOT NULL PRIMARY KEY IDENTITY,
student_id bigint NOT NULL,
- name varchar(100) DEFAULT '' NULL,
- teacher varchar(255) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
+ teacher varchar(255 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5581,13 +5583,13 @@
-- ----------------------------
CREATE TABLE yudao_demo03_student (
id bigint NOT NULL PRIMARY KEY IDENTITY,
- name varchar(100) DEFAULT '' NULL,
+ name varchar(100 char) DEFAULT '' NULL,
sex smallint NOT NULL,
birthday datetime NOT NULL,
- description varchar(255) NOT NULL,
- creator varchar(64) DEFAULT '' NULL,
+ description varchar(255 char) NOT NULL,
+ creator varchar(64 char) DEFAULT '' NULL,
create_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
- updater varchar(64) DEFAULT '' NULL,
+ updater varchar(64 char) DEFAULT '' NULL,
update_time datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
deleted bit DEFAULT '0' NOT NULL,
tenant_id bigint DEFAULT 0 NOT NULL
@@ -5617,4 +5619,3 @@
COMMIT;
SET IDENTITY_INSERT yudao_demo03_student OFF;
-- @formatter:on
-
--
Gitblit v1.9.3