From 2bfc1f7d89030434546832de57b31fec6943702e Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 19 十一月 2022 15:10:59 +0800 Subject: [PATCH] 1 --- data/db_tab.sql | 8 +++++--- 1 files changed, 5 insertions(+), 3 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index 27896bf..39af894 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -82,8 +82,9 @@ comment on column lf.sys_dep.update_user is '鏇存柊浜篒D'; comment on column lf.sys_dep.update_time is '鏇存柊鏃堕棿'; comment on column lf.sys_dep.bak is '澶囨敞'; ---alter sequence lf.sys_dep_id_seq restart with 45; ---alter table lf.sys_dep rename short to sname; alter table lf.sys_dep alter column bak type varchar(1024); +-- alter sequence lf.sys_dep_id_seq restart with 45; +-- alter table lf.sys_dep rename short to sname; alter table lf.sys_dep alter column bak type varchar(1024); +-- update lf.sys_dep set name='涓浗xxx宸ョ▼鏈夐檺鍏徃' where name='涓浗鐭虫补澶╃劧姘旂閬撳伐绋嬫湁闄愬叕鍙�'; select * from lf.sys_dep order by id; ----------------------------------------------------------------------------------------------------- 3.鐩綍琛� @@ -668,9 +669,10 @@ comment on column lf.sys_ver.create_time is '鍒涘缓鏃堕棿'; comment on column lf.sys_ver.update_user is '鏇存柊浜篒D'; comment on column lf.sys_ver.update_time is '鏇存柊鏃堕棿'; +insert into lf.sys_ver (id,dirid,name) values (0,0,'榛樿'); --insert into lf.sys_ver (dirid,name) values (1003,'2020-02-01'); -select * from lf.sys_ver; +select * from lf.sys_ver order by id; ----------------------------------------------------------------------------------------------------- 20.鏁版嵁瀛楀吀琛� -- DROP TABLE IF EXISTS lf.sys_dict; create table lf.sys_dict( -- Gitblit v1.9.3