| | |
| | | create sequence lf.sys_meta_id_seq increment by 1 minvalue 1 maxvalue 2147483647 start 1 cache 1; |
| | | alter sequence lf.sys_layer_id_seq restart with 1; |
| | | ----------------------------------------------------------------------------------------------------- 01.菜单表 |
| | | -- DROP TABLE IF EXISTS lf.sys_menu; |
| | | create table lf.sys_menu( |
| | |
| | | status smallint default 1, |
| | | precision varchar(50), |
| | | descr varchar(256), |
| | | fname varchar(50), |
| | | file_guid varchar(40) default new_guid(), |
| | | vname varchar(50), |
| | | view_guid varchar(40) default new_guid(), |
| | | create_user integer default 1, |
| | | create_time timestamp(6) without time zone default now(), |
| | |
| | | comment on column lf.sys_style.status is '状态:0-停用,1-启用'; |
| | | comment on column lf.sys_style.precision is '精度:如 1:1000'; |
| | | comment on column lf.sys_style.descr is '描述'; |
| | | comment on column lf.sys_style.fname is '样式文件名'; |
| | | comment on column lf.sys_style.file_guid is '样式文件ID'; |
| | | comment on column lf.sys_style.vname is '预览文件名'; |
| | | comment on column lf.sys_style.view_guid is '预览文件ID'; |
| | | comment on column lf.sys_style.create_user is '创建人ID'; |
| | | comment on column lf.sys_style.create_time is '创建时间'; |