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