| | |
| | | select * from lf.sys_role_menu_auth; |
| | | ----------------------------------------------------------------------------------------------------- 16.元数据表 |
| | | -- DROP TABLE IF EXISTS lf.sys_meta; |
| | | create table lf.sys_meta_new ( |
| | | create table lf.sys_meta ( |
| | | id serial primary key, |
| | | eventid varchar(38) default new_guid(), |
| | | metaid integer default 0, |
| | |
| | | where c.uid = 'ptzh'; |
| | | --------------------------------------------------------- |
| | | select * from lf.sys_dir order by id |
| | | select * from lf.sys_meta |
| | | select * from lf.sys_meta where id is null |
| | | select * from lf.sys_fme_log |
| | | |
| | | |
| | |
| | | (eventid,metaid,dirid,depid,verid,name,type,guid,path,sizes,tab,rows,create_user,create_time,bak,geom) |
| | | values |
| | | <foreach collection="list" item="item" index="index" separator=","> |
| | | (#{item.eventid},#{item.metaid},#{item.dirid},#{item.depid},#{item.verid},#{item.name},#{item.type},#{item.guid},#{item.path},#{item.sizes},#{item.tab},#{item.rows},#{item.createUser},now(),#{item.bak},#{item.geom}) |
| | | (#{item.eventid},#{item.metaid},#{item.dirid},#{item.depid},#{item.verid},#{item.name},#{item.type},#{item.guid},#{item.path},#{item.sizes},#{item.tab},#{item.rows},#{item.createUser},#{item.createTime},#{item.bak},#{item.geom}) |
| | | </foreach> |
| | | </insert> |
| | | |