| | |
| | | comment on column lf.sys_meta.update_user is '更新人ID'; |
| | | comment on column lf.sys_meta.update_time is '更新时间'; |
| | | comment on column lf.sys_meta.bak is '备注'; |
| | | comment on column lf.sys_meta.geom is '空间位置 |
| | | comment on column lf.sys_meta.geom is '空间位置'; |
| | | -- insert into lf.sys_meta(dirid,depid,geom,sizes,name,path) values (1,1,ST_PolygonFromText('MultiPolygon (((100 0,120 0,120 20,100 20,100 0)))', 4490),0.001,'a.jpg','c:\a.jpg'); |
| | | |
| | | select a.*,st_astext(geom) from lf.sys_meta a; select id,name,dirid,depid,verid,type,sizes,create_user,create_time,update_user,update_time,st_astext(geom) from lf.sys_meta; |
| | |
| | | select * from lf.sys_menu; |
| | | select * from lf.sys_serve_log; |
| | | |
| | | |
| | | |
| | | |
| | | select * from lf.sys_report where id=9 |
| | | select * from lf.sys_attach where guid='b0a2ef1bd7c3f8eb1cdbfef43f1ba1cb' |
| | | select * from lf.sys_layer order by id; |
| | | |
| | | |
| | | |