From 06492d128df5d7d0905539dd04faa9d475e9de59 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 13 二月 2023 15:12:59 +0800
Subject: [PATCH] 1
---
data/update.sql | 32 ++++++++++++++++++++++++--------
1 files changed, 24 insertions(+), 8 deletions(-)
diff --git a/data/update.sql b/data/update.sql
index 4be2ac2..b6d2369 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -98,16 +98,32 @@
select fn_rec_query(a.dirid,'dir'),a.* from lf.sys_meta_new a where dirid = ANY(fn_rec_array((select id from rs), 'dir'));
select * from lf.sys_meta where substr(path,1,2) = '2\';
+--------------------------------------------------------- alter sequence lf.sys_meta_id_seq restart with 1;
+update lf.sys_operate set modular2='婧愭暟鎹鐞�' where modular2='鍏冩暟鎹�';
+
+delete from lf.sys_dep where id = 59;
+update lf.sys_dep set bak = null where bak = ' ';
+update lf.sys_dep set code = null;
+update lf.sys_dep set code = '00' where pid = 0;
+update lf.sys_dep set level = level + 1;
+alter table lf.sys_dep alter column code type varchar(24);
+
+select id,pid,name,code,level,order_num from lf.sys_dep where code is not null order by code;
---------------------------------------------------------
-select * from lf.sys_fme_log;
+select * from lf.sys_dir order by id;
+
+alter table lf.sys_dir alter column code type varchar(200);
+alter table lf.sys_dir rename column code to exts;
+alter table lf.sys_dir alter column bak type varchar(100);
+alter table lf.sys_dir rename column bak to checks;
+alter table lf.sys_dir add column bak varchar(1024);
+update lf.sys_dir set bak=checks where checks is not null and position('check' in checks)=0;
+update lf.sys_dir set checks=null where position('check' in checks)=0;
+alter table lf.sys_dir add column code varchar(24);
+
+select id,pid,name,code,level,order_num from lf.sys_dir where code is not null order by code;
+---------------------------------------------------------
select * from lf.sys_meta;
--- delete from lf.sys_meta where id> 31;
--- delete from lf.sys_meta;
--- alter sequence lf.sys_meta_id_seq restart with 1;
-
-
-
-
--
Gitblit v1.9.3