| | |
| | | id serial primary key, |
| | | name varchar(256), |
| | | tab varchar(100), |
| | | tab_guid varchar(40), |
| | | guid varchar(40) default new_guid(), |
| | | path varchar(512), |
| | | create_user integer default 1, |
| | |
| | | comment on column lf.sys_attach.update_user is '更新人ID'; |
| | | comment on column lf.sys_attach.update_time is '更新时间'; |
| | | --insert into lf.sys_attach (name,tab,path) values ('a.jpg','public.data_dir','c:\a.jpg'); |
| | | --alter table lf.sys_attach add tab_guid varchar(40); |
| | | |
| | | select length(guid) from lf.sys_attach limit 1; select * from lf.sys_attach; |
| | | select * from lf.sys_attach; select length(guid) from lf.sys_attach limit 1; select * from lf.sys_attach; |
| | | ----------------------------------------------------------------------------------------------------- 19.版本表 |
| | | -- DROP TABLE IF EXISTS lf.sys_ver; |
| | | create table lf.sys_ver( |