From 450bcae3cfffe9923dc09dea2a4e89312bb373d7 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期五, 31 七月 2026 15:01:03 +0800
Subject: [PATCH] 库存流水修改
---
sql/dm/ruoyi-vue-pro-dm8.sql | 651 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 326 insertions(+), 325 deletions(-)
diff --git a/sql/dm/ruoyi-vue-pro-dm8.sql b/sql/dm/ruoyi-vue-pro-dm8.sql
index 3cc9a9a..fb67458 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
@@ -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
);
@@ -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
@@ -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
@@ -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
);
@@ -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
);
@@ -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
@@ -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