| | |
|---|
| | | order_num int4 default 0, |
|---|
| | | path varchar(200) default ''::varchar, |
|---|
| | | component varchar(255) default null::varchar, |
|---|
| | | query varchar(255) default null::varchar, |
|---|
| | | query_param varchar(255) default null::varchar, |
|---|
| | | is_frame int4 default 1, |
|---|
| | | is_cache int4 default 0, |
|---|
| | | menu_type char default ''::bpchar, |
|---|
| | |
|---|
| | | comment on column sys_menu.order_num is '显示顺序'; |
|---|
| | | comment on column sys_menu.path is '路由地址'; |
|---|
| | | comment on column sys_menu.component is '组件路径'; |
|---|
| | | comment on column sys_menu.query is '路由参数'; |
|---|
| | | comment on column sys_menu.query_param is '路由参数'; |
|---|
| | | comment on column sys_menu.is_frame is '是否为外链（0是 1否）'; |
|---|
| | | comment on column sys_menu.is_cache is '是否缓存（0缓存 1不缓存）'; |
|---|
| | | comment on column sys_menu.menu_type is '菜单类型（M目录 C菜单 F按钮）'; |
|---|
| | |
|---|
| | | insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', now(), 'admin', now(), null); |
|---|
| | | insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', now(), 'admin', now(), null); |
|---|
| | | insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', now(), 'admin', now(), null); |
|---|
| | | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 函数 ，代替mysql的find_in_set |
|---|
| | | -- 例如： select * from sys_dept where FIND_IN_SET (101,ancestors) <> 0 |
|---|
| | | -- ---------------------------- |
|---|
| | | create or replace function find_in_set(arg1 int8, arg2 varchar) |
|---|
| | | returns int8 as $body$ |
|---|
| | | declare pos int8; |
|---|
| | | begin |
|---|
| | | select position(','||arg1||',' IN ','||arg2||',') into pos; |
|---|
| | | return pos; |
|---|
| | | end; |
|---|
| | | $body$ |
|---|
| | | language plpgsql |
|---|
