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