From ca53e4ba17c2e085762794023bf795498fcd13f1 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 06 二月 2023 19:20:04 +0800
Subject: [PATCH] 1
---
data/ts.sql | 27 +++++++++++++++++----------
1 files changed, 17 insertions(+), 10 deletions(-)
diff --git a/data/ts.sql b/data/ts.sql
index 05e029c..acb8123 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -98,9 +98,6 @@
select depid from bd.dlg_agnp group by depid;
-- update bd.dlg_agnp set depid=1 where depid is null or depid=0
-select * from lf.sys_meta order by id desc limit 10;
-select * from lf.sys_fme_log order by id desc;
-
select * from lf.sys_flow where applyid = 9; -- 47,48,49
select id,userid,depids,tabs,entities,pwd,status,count,descr,wkt from lf.sys_apply;
-- status is '鐘舵�侊細-10-浣滃簾锛�-1-鎵撳洖锛�0~9-瀹℃牳涓紝10-閫氳繃';
@@ -110,20 +107,30 @@
select * from lf.sys_user where id in (47,48,49);
select * from lf.sys_download;
-select * from bs.m_marker where parentid is not null; -- 涓夋々涓�鐗� photono
+select * from bs.m_marker where parentid is not null; -- delete from bs.m_marker; createtime
+select * from bs.m_hydraulic_protection;
-- update bs.m_marker set parentid='df150a0d-eb8c-48d6-887d-c0901f4f61c5' where photono in ('璀︾ず鐗�10002', '璀︾ず鐗�10004', '璀︾ず鐗�10013');
-- INSERT INTO bs.m_marker(eventid, segname, markername, photono, createtime, createuser, dirid, depid, verid) VALUES (md5(''), 'seg', '10002', '璀︾ず鐗�10002', now(), 1, 1, 1, 0);
-- INSERT INTO bs.m_marker(eventid, segname, markername, photono, createtime, createuser, dirid, depid, verid) VALUES (md5(''), 'seg', '10004', '璀︾ず鐗�10004', now(), 1, 1, 1, 0);
-select * from lf.sys_meta where type='xls' order by id desc;
+select * from lf.sys_meta where type='xls' or type='xlsx' order by id desc;
+select * from lf.sys_fme_log order by id desc;
+insert into lf.sys_fme_log (pg_ns,tcdm,create_time) values ('bs','m_marker','2023-02-06 13:26:01');
+insert into lf.sys_fme_log (pg_ns,tcdm) values ('bs','m_marker');
+delete from lf.sys_fme_log where id > 99;
+select * from bs.m_geocontrolpoint where createtime is not null;
+-- delete from bs.m_geocontrolpoint; insert into bs.m_geocontrolpoint(eventid,createtime) values (md5(''),now());
+
+insert into lf.sys_fme_log (pg_ns,tcdm,create_time) values ('bs','m_marker',20230206132933); delete lf.sys_fme_log where id = 99;
select * from lf.sys_meta where type in ('xls', 'xlsx') and eventid is not null and tab is not null and rows > 0 and id in (1209,1180,1387);
select * from lf.sys_attach order by id desc;
+select * from lf.sys_dir where id = 74;
+select * from lf.sys_dict where field='gid';
+select field,type,count(*) from lf.sys_dict where field='gid' group by field,type;
+update lf.sys_dict set type='integer' where field='updateuser';
-
-
-
-
-
+select * from lf.sys_layer;
+alter sequence lf.sys_layer_id_seq restart with 1;
--
Gitblit v1.9.3