From 9776eab0645b2dfbe787e9d035f94ce80314e7fd Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 27 二月 2023 18:36:26 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 24 +++++++++++++++++++++++-
1 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 922aaa7..512d829 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -342,8 +342,30 @@
where pid = 0 order by code;
select * from lf.sys_download where guid='a0eab5c60810301c6bc86a295be1435a'
-select * from lf.sys_download order by id desc
+select * from lf.sys_meta where id = 1208 order by id desc
+select * from lf.sys_meta where rows > 0 and type in ('xls', 'xlsx');
+--bs.m_geocontrolpoint,6,1208
+select * from lf.sys_dict where ns='bs' and tab='project'
+select * from lf.sys_meta where id=1208
+--ad22a117-037c-4e30-ba86-d754584d23cb,bs.m_geocontrolpoint
+select * from lf.sys_meta where tab='bs.m_geocontrolpoint'
+update lf.sys_meta set eventid='ad22a117-037c-4e30-ba86-d754584d23cb' where
+
+select * from bs.m_geocontrolpoint where parentid='ad22a117-037c-4e30-ba86-d754584d23cb'
+update bs.m_geocontrolpoint set parentid='ad22a117-037c-4e30-ba86-d754584d23cb' where parentid='11'
+select * from bs.m_geocontrolpoint order by parentid
+
+update lf.sys_menu set pid=35,level=3,order_num=43 where cn_name='鏁版嵁缁熻';
+select * from lf.sys_menu where cn_name in ('杩愮淮鐩戞帶','鏁版嵁缁熻','绯荤粺鐩戞帶');
+select * from lf.sys_menu where pid=35 order by order_num;
+
+select * from lf.sys_menu where cn_name in ('椤圭洰绠＄悊','鏁版嵁搴撶鐞�') -- 85,86 level=2
+select * from lf.sys_menu where cn_name in ('鐩綍绠＄悊','椤圭洰淇℃伅','鐗堟湰绠＄悊') order by order_num;
+update lf.sys_menu set pid=85,level=3 where cn_name in ('椤圭洰淇℃伅','淇℃伅绠＄悊','鐗堟湰绠＄悊');
+
+select * from lf.sys_menu where cn_name in ('鏁版嵁涓婁紶','淇℃伅绠＄悊','鍊煎煙绠＄悊','瀛楀吀绠＄悊','鏍峰紡绠＄悊','鏁版嵁鏌ヨ') order by order_num;
+update lf.sys_menu set pid=86,level=3 where cn_name in ('鏁版嵁涓婁紶','淇℃伅绠＄悊','鍊煎煙绠＄悊','瀛楀吀绠＄悊','鏍峰紡绠＄悊','鏁版嵁鏌ヨ');
--
Gitblit v1.9.3