From 779101288af008e185780399b5e47ca8493bed14 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期日, 23 四月 2023 16:31:37 +0800 Subject: [PATCH] 1 --- data/db_tab.sql | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index d0afca8..f4fabe8 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -1301,4 +1301,21 @@ -- insert into lf.sys_meta_pub (metaid,pubid) values (1399,1); select * from lf.sys_meta_pub; +----------------------------------------------------------------------------------------------------- 38.鏁版嵁鍙戝竷-涓嬭浇琛� +-- drop table if exists lf.sys_pub_down; +create table lf.sys_pub_down( + id serial primary key, + pubid integer, + downid integer, + create_user integer default 1, + create_time timestamp(6) without time zone default now() +); +comment on table lf.sys_pub_down is '鏁版嵁鍙戝竷-涓嬭浇琛�'; +comment on column lf.sys_pub_down.id is '涓婚敭ID'; +comment on column lf.sys_pub_down.pubid is '鏁版嵁鍙戝竷ID'; +comment on column lf.sys_pub_down.downid is '涓嬭浇ID'; +comment on column lf.sys_pub_down.create_user is '鍒涘缓浜篒D'; +comment on column lf.sys_pub_down.create_time is '鍒涘缓鏃堕棿'; + +select * from lf.sys_pub_down; ----------------------------------------------------------------------------------------------------- -- Gitblit v1.9.3