From 642ebd764c51c99b4ab1c3cf8bccd333ee79eed3 Mon Sep 17 00:00:00 2001
From: Surpriseplus <845948745@qq.com>
Date: 星期五, 23 九月 2022 16:32:31 +0800
Subject: [PATCH] 111

---
 data/db.sql |   71 +++++++++++++++++++++++++++++++++--
 1 files changed, 66 insertions(+), 5 deletions(-)

diff --git a/data/db.sql b/data/db.sql
index 339c06e..6c1e417 100644
--- a/data/db.sql
+++ b/data/db.sql
@@ -37,6 +37,8 @@
 comment on column lf.sys_menu.update_time is '鏇存柊鏃堕棿';
 comment on column lf.sys_menu.bak is '澶囨敞';
 
+--update lf.sys_menu set bak=null,create_time=now() where 1=1;
+
 select * from lf.sys_menu;
 ----------------------------------------------------------------------------------------------------- 缁勭粐鏈烘瀯琛�
 -- DROP TABLE IF EXISTS lf.sys_dep;
@@ -44,7 +46,7 @@
   id serial primary key,
   pid integer,
   name varchar(150),
-  short varchar(50),
+  sname varchar(50),
   code varchar(50),
   uncode varchar(50),
   addr varchar(300),
@@ -66,7 +68,7 @@
 comment on column lf.sys_dep.id is '涓婚敭';
 comment on column lf.sys_dep.pid is '鐖禝D,鏍硅妭鐐�-0';
 comment on column lf.sys_dep.name is '鍚嶇О';
-comment on column lf.sys_dep.short is '绠�绉�';
+comment on column lf.sys_dep.sname is '绠�绉�';
 comment on column lf.sys_dep.code is '缂栫爜';
 comment on column lf.sys_dep.uncode is '鏈烘瀯浠ｇ爜';
 comment on column lf.sys_dep.addr is '鍦板潃';
@@ -83,13 +85,72 @@
 comment on column lf.sys_dep.update_time is '鏇存柊鏃堕棿';
 comment on column lf.sys_dep.bak is '澶囨敞';
 
-update lf.sys_dep set bak=null where 1=1;
+--alter table lf.sys_dep rename short to sname;
+--update lf.sys_dep set bak=null,create_time=now() where 1=1;
+
 select * from lf.sys_dep;
+----------------------------------------------------------------------------------------------------- 鐩綍绠＄悊
+-- DROP TABLE IF EXISTS lf.sys_dir;
+create table lf.sys_dir(
+  id serial primary key,
+  pid integer,
+  name varchar(150),
+  short varchar(50),
+  code varchar(50),
+  uncode varchar(50),
+  addr varchar(300),
+  contact varchar(50),
+  fax varchar(50),
+  email varchar(50),
+  post varchar(20),
+  website varchar(1024),
+  level integer,
+  order_num integer,
+  create_user integer,
+  create_time timestamp(6) without time zone default now(),
+  update_user integer,
+  update_time timestamp(6) without time zone,
+  bak varchar(256)
+);
+
+comment on table lf.sys_dir is '鍗曚綅琛�';
+comment on column lf.sys_dir.id is '涓婚敭';
+comment on column lf.sys_dir.pid is '鐖禝D,鏍硅妭鐐�-0';
+comment on column lf.sys_dir.name is '鍚嶇О';
+
+comment on column lf.sys_dep.short is '绠�绉�';
+comment on column lf.sys_dep.code is '缂栫爜';
+comment on column lf.sys_dep.uncode is '鏈烘瀯浠ｇ爜';
+comment on column lf.sys_dep.addr is '鍦板潃';
+comment on column lf.sys_dep.contact is '鑱旂郴鏂瑰紡';
+comment on column lf.sys_dep.fax is '浼犵湡';
+comment on column lf.sys_dep.email is '鐢靛瓙閭欢';
+comment on column lf.sys_dep.post is '閭斂缂栫爜';
+comment on column lf.sys_dep.website is '缃戠珯鍦板潃';
+comment on column lf.sys_dep.level is '灞傜骇,鏍硅妭鐐�-0';
+comment on column lf.sys_dep.order_num is '鎺掑簭鍙�';
+
+comment on column lf.sys_dir.create_user is '鍒涘缓浜篒D';
+comment on column lf.sys_dir.create_time is '鍒涘缓鏃堕棿';
+comment on column lf.sys_dir.update_user is '鏇存柊浜篒D';
+comment on column lf.sys_dir.update_time is '鏇存柊鏃堕棿';
+comment on column lf.sys_dir.bak is '澶囨敞';
+
+--update lf.sys_dir set bak=null,create_time=now() where 1=1;
+
+select * from lf.sys_dir;
 -----------------------------------------------------------------------------------------------------------
+select * from public.addr
 
 
-
-
+CREATE TABLE IF NOT EXISTS public.data_dir
+(
+    id integer NOT NULL,
+    name character varying(60) COLLATE pg_catalog."default",
+    pid integer NOT NULL,
+    oid integer DEFAULT 1,
+    CONSTRAINT data_dir_pkey PRIMARY KEY (id)
+)
 
 
 

--
Gitblit v1.9.3