From 06492d128df5d7d0905539dd04faa9d475e9de59 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 13 二月 2023 15:12:59 +0800
Subject: [PATCH] 1

---
 data/db_tab.sql |   12 ++++++++----
 1 files changed, 8 insertions(+), 4 deletions(-)

diff --git a/data/db_tab.sql b/data/db_tab.sql
index ba162b5..145a649 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -50,7 +50,7 @@
   pid integer,
   name varchar(150),
   sname varchar(50),
-  code varchar(50),
+  code varchar(24),
   uncode varchar(50),
   addr varchar(300),
   contact varchar(50),
@@ -97,9 +97,11 @@
   id serial primary key,
   pid integer,
   name varchar(150),
-  code varchar(50),
+  exts varchar(200),
   descr varchar(1024),
   level integer,
+  checks varchar(100),
+  code varchar(24),
   order_num integer,
   create_user integer,
   create_time timestamp(6) without time zone default now(),
@@ -114,6 +116,8 @@
 comment on column lf.sys_dir.code is '鐩綍缂栫爜';
 comment on column lf.sys_dir.descr is '鐩綍璇存槑';
 comment on column lf.sys_dir.level is '灞傜骇锛�0-鏍硅妭鐐�';
+comment on column lf.sys_dir.checks is '妫�鏌ラ」';
+comment on column lf.sys_dir.code is '缂栫爜';
 comment on column lf.sys_dir.order_num is '鎺掑簭鍙�';
 comment on column lf.sys_dir.create_user is '鍒涘缓浜篒D';
 comment on column lf.sys_dir.create_time is '鍒涘缓鏃堕棿';
@@ -540,7 +544,7 @@
 --insert into lf.sys_role_menu_auth (roleid,menu_auth_id) values (1,1);
 
 select * from lf.sys_role_menu_auth;
------------------------------------------------------------------------------------------------------ 16.鍏冩暟鎹〃
+----------------------------------------------------------------------------------------------------- 16.婧愭暟鎹〃
 -- DROP TABLE IF EXISTS lf.sys_meta;
 create table lf.sys_meta (
   id serial primary key,
@@ -566,7 +570,7 @@
 );
 -- drop index index_sys_meta_geom;
 create index index_sys_meta_geom on lf.sys_meta using GIST (geom);
-comment on table lf.sys_meta is '鍏冩暟鎹〃';
+comment on table lf.sys_meta is '婧愭暟鎹〃';
 comment on column lf.sys_meta.id is '涓婚敭ID';
 comment on column lf.sys_meta.eventid is 'GUID';
 comment on column lf.sys_meta.metaid is '鐖跺厓鏁版嵁ID锛�0-娌℃湁';

--
Gitblit v1.9.3