BOS/系统功能菜单

--建表脚本--

create table T_META_CONSOLEDETAIL(

FDETAILFUNCID varchar(50) not null  comment '明细菜单编码'

,FSUBFUNCID varchar(50) not null  comment '模块菜单编码'

,FNUMBER nvarchar(50) not null  comment '明细菜单代码'

,fobjectid varchar(36) not null  comment '业务对象'

,ftype varchar(50) not null  comment '类型'

,fstatus char(1) not null  comment '状态'

,FAuthPMObjectTypeId varchar(180) default '' ''  comment '验证权限的业务对象内码'

,fpermissionitemid varchar(36) not null  comment '权限内码'

,fseq int not null  comment '序号'

,fparam nvarchar(512) default null  comment '参数'

,fcustomparams nvarchar(512) default ''  comment '自定义参数'

,FThumb varchar(80) default null  comment '缩略图'

,FLEVEL int default null  comment '级别'

,FVisible int default -1  comment '可见性'

,FFunctionGroup int default null  comment '分组'

,FHtmlStatus char(1) default ''0''  comment 'html发布状态'

,FExcelStatus char(1) default ''0''  comment 'excel发布状态'

,FH5OBJECTID varchar(36) default null  comment '业务对象h5布局'

,primary key (FDETAILFUNCID)

) comment = '明细功能菜单表'

--查询--

select FDETAILFUNCID as "fdetailfuncid",FSUBFUNCID as "fsubfuncid",FNUMBER as "fnumber",fobjectid as "fobjectid",ftype as "ftype",fstatus as "fstatus",FAuthPMObjectTypeId as "fauthpmobjecttypeid",fpermissionitemid as "fpermissionitemid",fseq as "fseq",fparam as "fparam",fcustomparams as "fcustomparams",FThumb as "fthumb",FLEVEL as "flevel",FVisible as "fvisible",FFunctionGroup as "ffunctiongroup",FHtmlStatus as "fhtmlstatus",FExcelStatus as "fexcelstatus",FH5OBJECTID as "fh5objectid" from T_META_CONSOLEDETAIL

--查询(中文字段)--

select FDETAILFUNCID as "明细菜单编码",FSUBFUNCID as "模块菜单编码",FNUMBER as "明细菜单代码",fobjectid as "业务对象",ftype as "类型",fstatus as "状态",FAuthPMObjectTypeId as "验证权限的业务对象内码",fpermissionitemid as "权限内码",fseq as "序号",fparam as "参数",fcustomparams as "自定义参数",FThumb as "缩略图",FLEVEL as "级别",FVisible as "可见性",FFunctionGroup as "分组",FHtmlStatus as "html发布状态",FExcelStatus as "excel发布状态",FH5OBJECTID as "业务对象h5布局" from T_META_CONSOLEDETAIL

--INSERT脚本--

insert into T_META_CONSOLEDETAIL(FDETAILFUNCID,FSUBFUNCID,FNUMBER,fobjectid,ftype,fstatus,FAuthPMObjectTypeId,fpermissionitemid,fseq,fparam,fcustomparams,FThumb,FLEVEL,FVisible,FFunctionGroup,FHtmlStatus,FExcelStatus,FH5OBJECTID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_META_CONSOLEDETAIL set FDETAILFUNCID=?,FSUBFUNCID=?,FNUMBER=?,fobjectid=?,ftype=?,fstatus=?,FAuthPMObjectTypeId=?,fpermissionitemid=?,fseq=?,fparam=?,fcustomparams=?,FThumb=?,FLEVEL=?,FVisible=?,FFunctionGroup=?,FHtmlStatus=?,FExcelStatus=?,FH5OBJECTID=? where FDETAILFUNCID=?

--delete脚本--

delete from T_META_CONSOLEDETAIL where FDETAILFUNCID=?

--给字段加备注--

alter table T_META_CONSOLEDETAIL comment '明细功能菜单表';

alter table T_META_CONSOLEDETAIL modify column FDETAILFUNCID varchar(50) not null  comment '明细菜单编码';

alter table T_META_CONSOLEDETAIL modify column FSUBFUNCID varchar(50) not null  comment '模块菜单编码';

alter table T_META_CONSOLEDETAIL modify column FNUMBER nvarchar(50) not null  comment '明细菜单代码';

alter table T_META_CONSOLEDETAIL modify column fobjectid varchar(36) not null  comment '业务对象';

alter table T_META_CONSOLEDETAIL modify column ftype varchar(50) not null  comment '类型';

alter table T_META_CONSOLEDETAIL modify column fstatus char(1) not null  comment '状态';

alter table T_META_CONSOLEDETAIL modify column FAuthPMObjectTypeId varchar(180) default '' ''  comment '验证权限的业务对象内码';

alter table T_META_CONSOLEDETAIL modify column fpermissionitemid varchar(36) not null  comment '权限内码';

alter table T_META_CONSOLEDETAIL modify column fseq int not null  comment '序号';

alter table T_META_CONSOLEDETAIL modify column fparam nvarchar(512) default null  comment '参数';

alter table T_META_CONSOLEDETAIL modify column fcustomparams nvarchar(512) default ''  comment '自定义参数';

alter table T_META_CONSOLEDETAIL modify column FThumb varchar(80) default null  comment '缩略图';

alter table T_META_CONSOLEDETAIL modify column FLEVEL int default null  comment '级别';

alter table T_META_CONSOLEDETAIL modify column FVisible int default -1  comment '可见性';

alter table T_META_CONSOLEDETAIL modify column FFunctionGroup int default null  comment '分组';

alter table T_META_CONSOLEDETAIL modify column FHtmlStatus char(1) default ''0''  comment 'html发布状态';

alter table T_META_CONSOLEDETAIL modify column FExcelStatus char(1) default ''0''  comment 'excel发布状态';

alter table T_META_CONSOLEDETAIL modify column FH5OBJECTID varchar(36) default null  comment '业务对象h5布局';