From 8a373a66936407266e860a19c0d44c406baae7cc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 23 十二月 2022 11:11:18 +0800
Subject: [PATCH] 1

---
 data/db_tab.sql |   17 ++---------------
 1 files changed, 2 insertions(+), 15 deletions(-)

diff --git a/data/db_tab.sql b/data/db_tab.sql
index 4ebc013..7c10166 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1017,7 +1017,7 @@
 ----------------------------------------------------------------------------------------------------- 29.涓嬭浇鏃ュ織琛�
 -- drop table if exists lf.sys_downlog;
 create table lf.sys_downlog (
-    id serial8,
+    id serial primary key,
 	downid integer default 0,
 	name varchar(50),
     type smallint default 1,
@@ -1027,20 +1027,7 @@
     create_time timestamp(6) without time zone default now(),
     update_user integer,
     update_time timestamp(6) without time zone
-) partition by range(create_time);
-create table lf.sys_downlog_2022 partition of lf.sys_downlog for values from ('2022-01-01') to ('2023-01-01');
-create index index_sys_downlog_2022_create_time on lf.sys_downlog_2022 (create_time);
-create table lf.sys_downlog_2023 partition of lf.sys_downlog for values from ('2023-01-01') to ('2024-01-01');
-create index index_sys_downlog_2023_create_time on lf.sys_downlog_2023 (create_time);
-create table lf.sys_downlog_2024 partition of lf.sys_downlog for values from ('2024-01-01') to ('2025-01-01');
-create index index_sys_downlog_2024_create_time on lf.sys_downlog_2024 (create_time);
-create table lf.sys_downlog_2025 partition of lf.sys_downlog for values from ('2025-01-01') to ('2026-01-01');
-create index index_sys_downlog_2025_create_time on lf.sys_downlog_2025 (create_time);
-create table lf.sys_downlog_2026 partition of lf.sys_downlog for values from ('2026-01-01') to ('2027-01-01');
-create index index_sys_downlog_2026_create_time on lf.sys_downlog_2026 (create_time);
-create table lf.sys_downlog_2027 partition of lf.sys_downlog for values from ('2027-01-01') to ('2028-01-01');
-create index index_sys_downlog_2027_create_time on lf.sys_downlog_2027 (create_time);
-
+);
 comment on table lf.sys_downlog is '涓嬭浇鏃ュ織琛�';
 comment on column lf.sys_downlog.id is '涓婚敭id';
 comment on column lf.sys_downlog.name is '鍚嶇О';

--
Gitblit v1.9.3