From bdeb03a42dace46b1211bf12f3ad66837814035d Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期一, 23 三月 2026 11:39:01 +0800
Subject: [PATCH] feat: 更新系统
---
src/main/resources/db/schema.sql | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/db/schema.sql b/src/main/resources/db/schema.sql
index b1e3d6b..ca439e8 100644
--- a/src/main/resources/db/schema.sql
+++ b/src/main/resources/db/schema.sql
@@ -9,6 +9,8 @@
status NUMBER(1) DEFAULT 1,
create_time DATE DEFAULT SYSDATE,
update_time DATE DEFAULT SYSDATE,
+ create_by VARCHAR2(50 CHAR),
+ update_by VARCHAR2(50 CHAR),
deleted NUMBER(1) DEFAULT 0,
version NUMBER(10) DEFAULT 1
);
@@ -25,6 +27,8 @@
status NUMBER(1) DEFAULT 1,
create_time DATE DEFAULT SYSDATE,
update_time DATE DEFAULT SYSDATE,
+ create_by VARCHAR2(50 CHAR),
+ update_by VARCHAR2(50 CHAR),
deleted NUMBER(1) DEFAULT 0,
version NUMBER(10) DEFAULT 1
);
@@ -51,14 +55,35 @@
status NUMBER(1) DEFAULT 1,
create_time DATE DEFAULT SYSDATE,
update_time DATE DEFAULT SYSDATE,
+ create_by VARCHAR2(50 CHAR),
+ update_by VARCHAR2(50 CHAR),
deleted NUMBER(1) DEFAULT 0,
version NUMBER(10) DEFAULT 1
+);
+
+-- 鏁版嵁浠诲姟琛�
+CREATE TABLE data_task (
+ id NUMBER(19) PRIMARY KEY,
+ unit_code VARCHAR2(50 CHAR),
+ unit_name VARCHAR2(200 CHAR),
+ status NUMBER(1) DEFAULT 0,
+ task_count NUMBER(10),
+ success_count NUMBER(10),
+ remark VARCHAR2(1000 CHAR),
+ create_time DATE DEFAULT SYSDATE,
+ update_time DATE DEFAULT SYSDATE,
+ create_by VARCHAR2(50 CHAR),
+ update_by VARCHAR2(50 CHAR),
+ deleted NUMBER(1) DEFAULT 0,
+ version NUMBER(10) DEFAULT 1,
+ last_time DATE DEFAULT SYSDATE
);
-- 鍒涘缓搴忓垪
CREATE SEQUENCE seq_sys_department START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE seq_sys_user START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE seq_data_excel START WITH 1 INCREMENT BY 1;
+CREATE SEQUENCE seq_data_task START WITH 1 INCREMENT BY 1;
-- 鍒涘缓瑙﹀彂鍣紙鑷姩濉厖ID锛�
CREATE OR REPLACE TRIGGER trg_sys_department
@@ -85,6 +110,14 @@
END;
/
+CREATE OR REPLACE TRIGGER trg_data_task
+BEFORE INSERT ON data_task
+FOR EACH ROW
+BEGIN
+ SELECT seq_data_task.NEXTVAL INTO :NEW.id FROM DUAL;
+END;
+/
+
-- 鎻掑叆鍒濆鍖栨暟鎹�
INSERT INTO sys_department (dept_code, dept_name, parent_code, sort_order, description, status) VALUES
('001', '鎬诲叕鍙�', '0', 1, '鎬诲叕鍙�', 1);
--
Gitblit v1.9.1