From 70b3b3d060808ac5a959ac2c02cfad7ae48fbb00 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 09 二月 2023 16:45:26 +0800
Subject: [PATCH] 1

---
 data/db_tab.sql |  115 +++++++++++++++++++++++----------------------------------
 1 files changed, 46 insertions(+), 69 deletions(-)

diff --git a/data/db_tab.sql b/data/db_tab.sql
index 337aa8e..bb843ce 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1,4 +1,4 @@
------------------------------------------------------------------------------------------------------ 1.鑿滃崟琛�
+----------------------------------------------------------------------------------------------------- 01.鑿滃崟琛�
 -- DROP TABLE IF EXISTS lf.sys_menu;
 create table lf.sys_menu(
   id serial primary key,
@@ -41,7 +41,7 @@
 --alter sequence lf.sys_menu_id_seq restart with 44;
 
 select * from lf.sys_menu order by order_num;
------------------------------------------------------------------------------------------------------ 2.鍗曚綅琛�
+----------------------------------------------------------------------------------------------------- 02.鍗曚綅琛�
 -- DROP TABLE IF EXISTS lf.sys_dep;
 create table lf.sys_dep(
   id serial primary key,
@@ -89,7 +89,7 @@
 -- update lf.sys_dep set name='涓浗xxx宸ョ▼鏈夐檺鍏徃' where name='涓浗鐭虫补澶╃劧姘旂閬撳伐绋嬫湁闄愬叕鍙�';
 
 select * from lf.sys_dep order by id;
------------------------------------------------------------------------------------------------------ 3.鐩綍琛�
+----------------------------------------------------------------------------------------------------- 03.鐩綍琛�
 -- DROP TABLE IF EXISTS lf.sys_dir;
 create table lf.sys_dir(
   id serial primary key,
@@ -121,7 +121,7 @@
 --alter sequence lf.sys_dir_id_seq restart with 124;
 
 select * from lf.sys_dir order by id;
------------------------------------------------------------------------------------------------------ 4.鐢ㄦ埛琛�
+----------------------------------------------------------------------------------------------------- 04.鐢ㄦ埛琛�
 -- DROP TABLE IF EXISTS lf.sys_user;
 create table lf.sys_user(
   id serial primary key,
@@ -175,7 +175,7 @@
 update lf.sys_user set pwd='b37f70636f1164e86cc8796201737933f65af63918d8442b'; */
 
 select * from lf.sys_user order by id;
------------------------------------------------------------------------------------------------------ 5.鐧诲綍鏃ュ織琛�
+----------------------------------------------------------------------------------------------------- 05.鐧诲綍鏃ュ織琛�
 -- DROP TABLE IF EXISTS lf.sys_login;
 create table lf.sys_login(
   id serial8,
@@ -216,7 +216,7 @@
 
 select * from lf.sys_login; select * from lf.sys_login_2022; select * from lf.sys_login_2024;
 select a.*,b.uname from lf.sys_login a inner join lf.sys_user b on a.userid = b.id;
------------------------------------------------------------------------------------------------------ 6.鎿嶄綔鏃ュ織琛�
+----------------------------------------------------------------------------------------------------- 06.鎿嶄綔鏃ュ織琛�
 -- DROP TABLE IF EXISTS lf.sys_operate;
 create table lf.sys_operate(
   id serial8,
@@ -267,7 +267,7 @@
 
 select a.*,b.uname from lf.sys_operate a inner join lf.sys_user b on a.userid = b.id;
 select * from lf.sys_operate; select * from lf.sys_operate_2022; select * from lf.sys_operate_2024;
------------------------------------------------------------------------------------------------------ 7.浠ょ墝琛�
+----------------------------------------------------------------------------------------------------- 07.浠ょ墝琛�
 -- DROP TABLE IF EXISTS lf.sys_token;
 create table lf.sys_token(
   id serial8,
@@ -314,7 +314,7 @@
 select * from lf.sys_user where id=(select create_user from lf.sys_token where token='91cf74dc-1d03-4937-983f-88810589b112' and expire > now() limit 1);
 
 select * from lf.sys_token; select * from lf.sys_token_2022; select * from lf.sys_token_2023; select now()::timestamp + '1 year 4 hour';
------------------------------------------------------------------------------------------------------ 8.璧勬簮琛�
+----------------------------------------------------------------------------------------------------- 08.璧勬簮琛�
 -- DROP TABLE IF EXISTS lf.sys_res;
 create table lf.sys_res(
   id serial primary key,
@@ -351,7 +351,7 @@
 insert into lf.sys_res (name) values ('澶╁湴鍥剧煝閲�'); */
 
 select * from lf.sys_res;
------------------------------------------------------------------------------------------------------ 9.璧勬簮鎿嶄綔琛�
+----------------------------------------------------------------------------------------------------- 09.璧勬簮鎿嶄綔琛�
 -- DROP TABLE IF EXISTS lf.sys_res_op;
 create table lf.sys_res_op(
   id serial8,
@@ -588,7 +588,7 @@
 -- insert into lf.sys_meta(dirid,depid,geom,sizes,name,path) values (1,1,ST_PolygonFromText('MultiPolygon (((100 0,120 0,120 20,100 20,100 0)))', 4490),0.001,'a.jpg','c:\a.jpg');
 
 select a.*,st_astext(geom) from lf.sys_meta a; select id,name,dirid,depid,verid,type,sizes,create_user,create_time,update_user,update_time,st_astext(geom) from lf.sys_meta;
------------------------------------------------------------------------------------------------------ 18.闄勪欢琛�
+----------------------------------------------------------------------------------------------------- 17.闄勪欢琛�
 -- DROP TABLE IF EXISTS lf.sys_attach;
 create table lf.sys_attach(
   id serial primary key,
@@ -619,7 +619,7 @@
 --alter table lf.sys_attach alter column sizes type float8;
 
 select * from lf.sys_attach; select length(guid) from lf.sys_attach limit 1; select * from lf.sys_attach;
------------------------------------------------------------------------------------------------------ 19.鐗堟湰琛�
+----------------------------------------------------------------------------------------------------- 18.鐗堟湰琛�
 -- DROP TABLE IF EXISTS lf.sys_ver;
 create table lf.sys_ver(
   id serial primary key,
@@ -644,7 +644,7 @@
 --insert into lf.sys_ver (dirid,name) values (1003,'2020-02-01');
 
 select * from lf.sys_ver order by id;
------------------------------------------------------------------------------------------------------ 20.鏁版嵁瀛楀吀琛�
+----------------------------------------------------------------------------------------------------- 19.鏁版嵁瀛楀吀琛�
 -- DROP TABLE IF EXISTS lf.sys_dict;
 create table lf.sys_dict(
   id serial primary key,
@@ -696,7 +696,7 @@
 select count(*) from lf.sys_dict where status=0 and tab='sys_user';
 select * from lf.sys_dict order by ns,tab,order_num limit 10 offset 0;
 select distinct ns,tab,fn_get_entity(tab) entity,tab_desc,tabletype from lf.sys_dict order by tab;
------------------------------------------------------------------------------------------------------ 21.鏍峰紡琛�
+----------------------------------------------------------------------------------------------------- 20.鏍峰紡琛�
 -- DROP TABLE IF EXISTS lf.sys_style;
 create table lf.sys_style(
   id serial primary key,
@@ -737,7 +737,7 @@
 
 select count(*) from lf.sys_style where name like '%.edp';
 select * from lf.sys_style order by ns,tab,order_num limit 10 offset 0;
------------------------------------------------------------------------------------------------------ 22.涓嬭浇璁板綍琛�
+----------------------------------------------------------------------------------------------------- 21.涓嬭浇璁板綍琛�
 -- DROP TABLE IF EXISTS lf.sys_download;
 create table lf.sys_download(
   id serial primary key,
@@ -781,7 +781,7 @@
 -- insert into lf.sys_download (name,pwd,url,descr) values ('2022-09-27','123456','','娴嬭瘯涓嬭浇');
 
 select * from lf.sys_download order by id;
------------------------------------------------------------------------------------------------------ 23.娑堟伅閫氱煡琛�
+----------------------------------------------------------------------------------------------------- 22.娑堟伅閫氱煡琛�
 -- DROP TABLE IF EXISTS lf.sys_msg;
 create table lf.sys_msg(
   id serial primary key,
@@ -805,7 +805,7 @@
 --insert into lf.sys_msg (title,msg,guid,update_user) values ('2022-09-26','鏁版嵁涓嬭浇',new_guid(),2);
 
 select * from lf.sys_msg;
------------------------------------------------------------------------------------------------------ 24.鍙傛暟璁剧疆琛�
+----------------------------------------------------------------------------------------------------- 23.鍙傛暟璁剧疆琛�
 -- DROP TABLE IF EXISTS lf.sys_args;
 create table lf.sys_args(
   id serial primary key,
@@ -848,7 +848,7 @@
 insert into lf.sys_args (name,cvalue,dvalue,min_value,max_value,times,descr,mark) values ('鏈嶅姟涓婇檺',5000,5000,5,1000000,1,'褰撹秴鍑烘湇鍔′笂闄愭椂锛屽氨鎷掔粷璁块棶銆�','MAX_SERVERS'); */
 
 select * from lf.sys_args order by id;
------------------------------------------------------------------------------------------------------ 25.榛戝悕鍗曡〃
+----------------------------------------------------------------------------------------------------- 24.榛戝悕鍗曡〃
 -- DROP TABLE IF EXISTS lf.sys_blacklist;
 create table lf.sys_blacklist(
   id serial primary key,
@@ -878,7 +878,7 @@
 insert into lf.sys_blacklist (ip,type) values ('0:0:0:0:0:0:0:1',2);*/
 
 select * from lf.sys_blacklist;
------------------------------------------------------------------------------------------------------ 26.鏍囩粯琛�
+----------------------------------------------------------------------------------------------------- 25.鏍囩粯琛�
 -- DROP TABLE IF EXISTS lf.sys_mark;
 create table lf.sys_mark(
   id serial primary key,
@@ -899,7 +899,7 @@
 comment on column lf.sys_mark.update_time is '鏇存柊鏃堕棿';
 
 select * from lf.sys_mark;
------------------------------------------------------------------------------------------------------ 27.鍊煎煙琛�
+----------------------------------------------------------------------------------------------------- 26.鍊煎煙琛�
 -- drop table if exists lf.sys_domain;
 create table if not exists lf.sys_domain(
     id serial primary key,
@@ -932,57 +932,34 @@
 comment on column lf.sys_domain.bak is '澶囨敞';
 
 select * from lf.sys_domain order by dom_name,orderid;
------------------------------------------------------------------------------------------------------ 28.椤圭洰琛�
--- drop table if exists lf.sys_project;
-create table if not exists lf.sys_project (
+----------------------------------------------------------------------------------------------------- 27.鎶ュ憡妯℃澘琛�
+-- drop table if exists lf.sys_report;
+create table if not exists lf.sys_report (
     id serial primary key,
-    dirid integer default 0,
-    depid integer default 0,
-    projname varchar(200),
-    projtype varchar(50),
-    location varchar(200),
-    province varchar(50),
-    country varchar(50),
-    corpname varchar(200),
-    department varchar(200),
-    conperiod varchar(20),
-    contents varchar(500),
-    projstate varchar(50),
-	remarks varchar(250),
-    belongsid varchar(100),
-    datastatus varchar(10),
+    name varchar(100),
+    type varchar(50),
+    path varchar(512),
+    code varchar(50),
     create_user integer default 1,
     create_time timestamp(6) without time zone default now(),
     update_user integer,
     update_time timestamp(6) without time zone,
-    geom geometry(Point, 4490)
-); -- drop index index_sys_project_geom;
-create index index_sys_project_geom on lf.sys_project using gist (geom);
-comment on table lf.sys_project is '椤圭洰琛�';
-comment on column lf.sys_project.id is '涓婚敭id';
-comment on column lf.sys_project.dirid is '鐩綍id';
-comment on column lf.sys_project.depid is '鍗曚綅id';
-comment on column lf.sys_project.projname is '椤圭洰鍚嶇О';
-comment on column lf.sys_project.projtype is '椤圭洰绫诲瀷';
-comment on column lf.sys_project.location is '鍦扮悊浣嶇疆';
-comment on column lf.sys_project.province is '鎵�灞炵渷浠�';
-comment on column lf.sys_project.country is '鎵�灞炲浗瀹�';
-comment on column lf.sys_project.corpname is '寤鸿鍗曚綅鍚嶇О';
-comment on column lf.sys_project.department is '涓荤閮ㄩ棬';
-comment on column lf.sys_project.conperiod is '寤鸿宸ユ湡';
-comment on column lf.sys_project.contents is '宸ョ▼鍐呭';
-comment on column lf.sys_project.projstate is '椤圭洰鐘舵��';
-comment on column lf.sys_project.remarks is '澶囨敞';
-comment on column lf.sys_project.belongsid is '鏉冮檺浠g爜';
-comment on column lf.sys_project.datastatus is '鏁版嵁鐘舵��';
-comment on column lf.sys_project.create_user is '鍒涘缓浜篿d';
-comment on column lf.sys_project.create_time is '鍒涘缓鏃堕棿';
-comment on column lf.sys_project.update_user is '鏇存柊浜篿d';
-comment on column lf.sys_project.update_time is '鏇存柊鏃堕棿';
-comment on column lf.sys_project.geom is '绌洪棿浣嶇疆';
+    bak varchar(1024)
+);
+comment on table lf.sys_report is '鎶ュ憡妯℃澘琛�';
+comment on column lf.sys_report.id is '涓婚敭ID';
+comment on column lf.sys_report.name is '鍚嶇О';
+comment on column lf.sys_report.type is '绫诲瀷';
+comment on column lf.sys_report.path is '璺緞';
+comment on column lf.sys_report.code is '缂栫爜';
+comment on column lf.sys_report.create_user is '鍒涘缓浜篿d';
+comment on column lf.sys_report.create_time is '鍒涘缓鏃堕棿';
+comment on column lf.sys_report.update_user is '鏇存柊浜篿d';
+comment on column lf.sys_report.update_time is '鏇存柊鏃堕棿';
+comment on column lf.sys_report.bak is '澶囨敞';
 
-select * from lf.sys_project;
------------------------------------------------------------------------------------------------------ 29.涓嬭浇鏃ュ織琛�
+select * from lf.sys_report;
+----------------------------------------------------------------------------------------------------- 28.涓嬭浇鏃ュ織琛�
 -- drop table if exists lf.sys_downlog;
 create table lf.sys_downlog (
     id serial primary key,
@@ -1003,7 +980,7 @@
 -- insert into lf.sys_downlog(downid,ip,create_user) values (100,'192.168.20.39',1);
 
 select * from lf.sys_downlog;
------------------------------------------------------------------------------------------------------ 30.鏁版嵁鐢宠琛�
+----------------------------------------------------------------------------------------------------- 29.鏁版嵁鐢宠琛�
 -- drop table if exists lf.sys_apply;
 create table lf.sys_apply (
     id serial primary key,
@@ -1038,7 +1015,7 @@
 comment on column lf.sys_apply.update_time is '鏇存柊鏃堕棿';
 
 select * from lf.sys_apply;
------------------------------------------------------------------------------------------------------ 31.鐢宠娴佺▼琛�
+----------------------------------------------------------------------------------------------------- 30.鐢宠娴佺▼琛�
 -- drop table if exists lf.sys_flow;
 create table lf.sys_flow (
     id serial primary key,
@@ -1065,7 +1042,7 @@
 comment on column lf.sys_flow.update_time is '鏇存柊鏃堕棿';
 
 select * from lf.sys_flow;
------------------------------------------------------------------------------------------------------ 32.FME鏃ュ織琛�
+----------------------------------------------------------------------------------------------------- 31.FME鏃ュ織琛�
 create table lf.sys_fme_log (
   id serial primary key,
   parentid varchar(38),
@@ -1087,7 +1064,7 @@
 comment on column lf.sys_fme_log.create_time is '鍒涘缓鏃堕棿';
 
 select * from lf.sys_fme_log; -- delete from lf.sys_fme_log;
------------------------------------------------------------------------------------------------------ 33.鍥惧眰琛�
+----------------------------------------------------------------------------------------------------- 32.鍥惧眰琛�
 -- DROP TABLE IF EXISTS lf.sys_layer;
 create table lf.sys_layer(
   id serial primary key,
@@ -1126,7 +1103,7 @@
 comment on column lf.sys_layer.bak is '澶囨敞';
 
 select * from lf.sys_layer;
------------------------------------------------------------------------------------------------------ 34.鏈嶅姟鏃ュ織琛�
+----------------------------------------------------------------------------------------------------- 33.鏈嶅姟鏃ュ織琛�
 -- DROP TABLE IF EXISTS lf.sys_serve_log;
 create table lf.sys_serve_log(
   id serial8,

--
Gitblit v1.9.3