From 83cc589740899a441685a9350b85925fa8fd0a3b Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 18 二月 2023 14:03:27 +0800
Subject: [PATCH] 1
---
data/update.sql | 65 ++++++++++++++------------------
1 files changed, 28 insertions(+), 37 deletions(-)
diff --git a/data/update.sql b/data/update.sql
index ef543a9..87b9655 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -204,7 +204,34 @@
order by c.id limit 1;
select * from lf.sys_role;
---------------------------------------------------------- 09 淇敼琛ㄧ粨鏋�
+--------------------------------------------------------- 09
+select * from lf.sys_dir
+select * from lf.sys_meta order by id desc; --1062,1398
+
+
+
+
+
+---------------------------------------------------------
+-- 0100000000,02000000,030000,040100,0100000002,02000002,040102,0100000003,02000003,0100000001,02000001,040101,030001,01,02,02000001
+select * from lf.sys_meta where dircode like '01%' or dircode like '02%' or dircode like '030000%'
+ or dircode like '030001%' or dircode like '040100%' or dircode like '040101%' or dircode like '040102%';
+
+select code "key", name "value" from lf.sys_dir where pid = 0 and id > 1;
+select code "key", name "value" from lf.sys_dir where pid = 1;
+select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
+ where name in ('娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�') group by name order by name;
+
+select count(*) from bd.dlg_25w_aanp where 1 = 1
+
+select a.*, fn_tab_count(a.ns, a.tab, '1=1') "rows" from
+(select distinct ns,tab,fn_get_entity(tab) entity,tab_desc,tableType from lf.sys_dict
+order by tab
+limit 10 offset 0) a
+
+select dirid,depid from bd.dlg_25w_resa group by dirid,depid
+select * from lf.sys_dict where tab='dlg_25w_resa'
+--------------------------------------------------------- A0 淇敼琛ㄧ粨鏋�
-- drop function fn_alter_tab_fields();
create or replace function fn_alter_tab_fields()
returns integer as $$
@@ -251,39 +278,3 @@
select gid,depid,dirid from bd.dlg_25w_resa limit 10;
select gid,depid,dirid from bd.dlg_25w_boul limit 10;
---------------------------------------------------------
-select count(*) from bd.b_borehole;
-
-select gid,depid,dirid,verid from bd.b_borehole; -- 357824
-select * from lf.sys_dir where id=0;
-select * from lf.sys_dep where id=0;
----------------------------------------------------------
--- 0100000000,02000000,030000,040100,0100000002,02000002,040102,0100000003,02000003,0100000001,02000001,040101,030001,01,02,02000001
-select * from lf.sys_meta where dircode like '01%' or dircode like '02%' or dircode like '030000%'
- or dircode like '030001%' or dircode like '040100%' or dircode like '040101%' or dircode like '040102%';
-
-select code "key", name "value" from lf.sys_dir where pid = 0 and id > 1;
-select code "key", name "value" from lf.sys_dir where pid = 1;
-select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
- where name in ('娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�') group by name order by name;
-
-select count(*) from bd.dlg_25w_aanp where 1 = 1
-
-select a.*, fn_tab_count(a.ns, a.tab, '1=1') "rows" from
-(select distinct ns,tab,fn_get_entity(tab) entity,tab_desc,tableType from lf.sys_dict
-order by tab
-limit 10 offset 0) a
-
-select dirid,depid from bd.dlg_25w_resa group by dirid,depid
-select * from lf.sys_dict where tab='dlg_25w_resa'
-
-
-
-
-
-
-
-
-
-
-
-
--
Gitblit v1.9.3