| | |
|---|
| | | 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按钮）'; |
|---|
| | | comment on column sys_menu.visible is '菜单状态（0显示 1隐藏）'; |
|---|
| | | comment on column sys_menu.visible is '显示状态（0显示 1隐藏）'; |
|---|
| | | comment on column sys_menu.status is '菜单状态（0正常 1停用）'; |
|---|
| | | comment on column sys_menu.perms is '权限标识'; |
|---|
| | | comment on column sys_menu.icon is '菜单图标'; |
|---|
| | |
|---|
| | | insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1', '', 'admin', now(), 'admin', now(), null); |
|---|
| | | insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1', '', 'admin', now(), 'admin', now(), NULL); |
|---|
| | | |
|---|
| | | -- 字符串自动转时间 避免框架时间查询报错问题 |
|---|
| | | create or replace function cast_varchar_to_timestamp(varchar) returns timestamptz as $$ |
|---|
| | | select to_timestamp($1, 'yyyy-mm-dd hh24:mi:ss'); |
|---|
| | | $$ language sql strict ; |
|---|
| | | |
|---|
| | | create cast (varchar as timestamptz) with function cast_varchar_to_timestamp as IMPLICIT; |
|---|
