From ca53e4ba17c2e085762794023bf795498fcd13f1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 06 二月 2023 19:20:04 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index e71eb40..366ccce 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1122,4 +1122,39 @@
comment on column lf.sys_layer.bak is '澶囨敞';
select * from lf.sys_layer;
+----------------------------------------------------------------------------------------------------- 34.鏈嶅姟鏃ュ織琛�
+-- DROP TABLE IF EXISTS lf.sys_serve_log;
+create table lf.sys_serve_log(
+ id serial8,
+ resid integer,
+ name varchar(100),
+ type varchar(50),
+ url varchar(4096),
+ create_user integer,
+ create_time timestamp(6) without time zone default now(),
+ bak varchar(1024)
+) partition by range(create_time);
+
+create table lf.sys_serve_log_2023 partition of lf.sys_serve_log for values from ('2023-01-01') to ('2024-01-01');
+create INDEX index_sys_serve_log_2023_optime on lf.sys_serve_log_2023 (create_time);
+create table lf.sys_serve_log_2024 partition of lf.sys_serve_log for values from ('2024-01-01') to ('2025-01-01');
+create INDEX index_sys_serve_log_2024_optime on lf.sys_serve_log_2024 (create_time);
+create table lf.sys_serve_log_2025 partition of lf.sys_serve_log for values from ('2025-01-01') to ('2026-01-01');
+create INDEX index_sys_serve_log_2025_optime on lf.sys_serve_log_2025 (create_time);
+create table lf.sys_serve_log_2026 partition of lf.sys_serve_log for values from ('2026-01-01') to ('2027-01-01');
+create INDEX index_sys_serve_log_2026_optime on lf.sys_serve_log_2026 (create_time);
+create table lf.sys_serve_log_2027 partition of lf.sys_serve_log for values from ('2027-01-01') to ('2028-01-01');
+create INDEX index_sys_serve_log_2027_optime on lf.sys_serve_log_2027 (create_time);
+
+comment on table lf.sys_serve_log is '鏈嶅姟鏃ュ織琛�';
+comment on column lf.sys_serve_log.id is '涓婚敭ID';
+comment on column lf.sys_serve_log.resid is '鏈嶅姟ID';
+comment on column lf.sys_serve_log.name is '鍚嶇О';
+comment on column lf.sys_serve_log.type is '绫诲瀷';
+comment on column lf.sys_serve_log.url is '鍥惧眰鍦板潃';
+comment on column lf.sys_serve_log.create_user is '璁块棶浜篒D';
+comment on column lf.sys_serve_log.create_time is '璁块棶鏃堕棿';
+comment on column lf.sys_serve_log.bak is '澶囨敞';
+
+select * from lf.sys_serve_log;
----------------------------------------------------------------------------------------------------- vacuum analyze md.md_zxcg;
--
Gitblit v1.9.3