From f6051b7cf2026a2436d255a42c8c5a2817112778 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 19 十一月 2024 17:22:46 +0800 Subject: [PATCH] 1 --- docker-compose/mysql/initdb/se_cloud_20241119.sql | 42 ++++++++++++++++++++++++++---------------- 1 files changed, 26 insertions(+), 16 deletions(-) diff --git a/docker-compose/mysql/initdb/se_cloud_20241119.sql b/docker-compose/mysql/initdb/se_cloud_20241119.sql index 255db4b..45b711f 100644 --- a/docker-compose/mysql/initdb/se_cloud_20241119.sql +++ b/docker-compose/mysql/initdb/se_cloud_20241119.sql @@ -141,11 +141,11 @@ -- ---------------------------- --- 07銆佸憡璀﹁〃 +-- 07銆佹帶鍒惰〃 -- ---------------------------- -drop table if exists sys_warn; -create table sys_warn ( - warn_id bigint(20) not null auto_increment comment '鍛婅ID', +drop table if exists sys_ctrl; +create table sys_ctrl ( + ctrl_id bigint(20) not null auto_increment comment '鎺у埗ID', name varchar(200) not null comment '鍚嶇О', type char(1) default '0' comment '绫诲瀷', descr varchar(500) comment '鎻忚堪', @@ -157,18 +157,28 @@ update_by varchar(64) default '' comment '鏇存柊鑰�', update_time datetime comment '鏇存柊鏃堕棿', remark varchar(500) default '' comment '澶囨敞', - primary key (warn_id) -) engine=innodb auto_increment=1 comment = '鍛婅琛�'; -select * from sys_warn order by warn_id; + primary key (ctrl_id) +) engine=innodb auto_increment=1 comment = '鎺у埗琛�'; +select * from sys_ctrl order by ctrl_id; - - - - - - - - - +-- ---------------------------- +-- 08銆佹帶鍒舵棩蹇楄〃 +-- ---------------------------- +drop table if exists sys_ctrl_log; +create table sys_ctrl_log ( + log_id bigint(20) not null auto_increment comment '鏃ュ織ID', + title varchar(100) not null comment '鏍囬', + type char(1) default '0' comment '绫诲瀷', + ip varchar(50) comment 'IP', + url varchar(4000) comment 'URL', + method varchar(20) comment '鏂规硶', + args varchar(4000) comment '鍙傛暟', + msg varchar(2000) comment '娑堟伅', + oper varchar(50) comment '鎿嶄綔鍛�', + time datetime default now() comment '鎿嶄綔鏃堕棿', + remark varchar(500) default '' comment '澶囨敞', + primary key (log_id) +) engine=innodb auto_increment=1 comment = '鎺у埗鏃ュ織琛�'; +select * from sys_ctrl_log order by log_id; -- Gitblit v1.9.3