From 70ddec6cf736c0174bafaef0a9bfe4c9412af133 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 25 三月 2023 16:37:32 +0800 Subject: [PATCH] 1 --- data/db_tab.sql | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index 7ba6609..1b3d5fe 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -1072,7 +1072,8 @@ tcmc varchar(150), tcdm varchar(50), count integer default 0, - create_time timestamp(6) without time zone default now() + create_time timestamp(6) without time zone default now(), + update_time timestamp(6) without time zone ); comment on table lf.sys_fme_log is 'FME鏃ュ織琛�'; comment on column lf.sys_fme_log.id is '涓婚敭ID'; @@ -1083,8 +1084,9 @@ comment on column lf.sys_fme_log.tcdm is '琛ㄥ悕'; comment on column lf.sys_fme_log.count is '琛屾暟'; comment on column lf.sys_fme_log.create_time is '鍒涘缓鏃堕棿'; +comment on column lf.sys_fme_log.update_time is '鏇存柊鏃堕棿'; -select * from lf.sys_fme_log; -- delete from lf.sys_fme_log; +select * from lf.sys_fme_log order by id desc; -- delete from lf.sys_fme_log; ----------------------------------------------------------------------------------------------------- 32.鍥惧眰琛� -- DROP TABLE IF EXISTS lf.sys_layer; create table lf.sys_layer( -- Gitblit v1.9.3