----------------------------------------------------------------------------------------------------- 菜单表
-- DROP TABLE IF EXISTS lf.sys_menu;
create table lf.sys_menu(
  id serial primary key,
  pid integer,
  cn_name varchar(50),
  en_name varchar(50),
  url varchar(256),
  perms varchar(512),
  type smallint,
  icon varchar(256),
  level integer,
  order_num integer,
  is_show smallint,
  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_menu is '菜单表';
comment on column lf.sys_menu.id is '主键';
comment on column lf.sys_menu.pid is '父ID,根节点-0';
comment on column lf.sys_menu.cn_name is '中文名称';
comment on column lf.sys_menu.en_name is '英文名称';
comment on column lf.sys_menu.url is '菜单Url';
comment on column lf.sys_menu.perms is '授权(多个用逗号分隔，如：user:list,user:create)';
comment on column lf.sys_menu.type is '类型：0-目录,1-菜单,2-按钮';
comment on column lf.sys_menu.icon is '图标';
comment on column lf.sys_menu.level is '层级,根节点-0';
comment on column lf.sys_menu.order_num is '排序号';
comment on column lf.sys_menu.is_show is '是否显示';
comment on column lf.sys_menu.create_user is '创建人ID';
comment on column lf.sys_menu.create_time is '创建时间';
comment on column lf.sys_menu.update_user is '更新人ID';
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;
create table lf.sys_dep(
  id serial primary key,
  pid integer,
  name varchar(150),
  sname 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_dep is '单位表';
comment on column lf.sys_dep.id is '主键';
comment on column lf.sys_dep.pid is '父ID,根节点-0';
comment on column lf.sys_dep.name 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 '地址';
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_dep.create_user is '创建人ID';
comment on column lf.sys_dep.create_time is '创建时间';
comment on column lf.sys_dep.update_user is '更新人ID';
comment on column lf.sys_dep.update_time is '更新时间';
comment on column lf.sys_dep.bak is '备注';

--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 '父ID,根节点-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 '创建人ID';
comment on column lf.sys_dir.create_time is '创建时间';
comment on column lf.sys_dir.update_user is '更新人ID';
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)
)