BOS-平台数据（3）

--建表脚本--

create table t_mdl_formbusiness(

FActionID int not null  comment '表单服务编码'

,FName varchar(50) not null  comment '名称'

,FTYPE int default null  comment '参数+适用事件'

,FAPPSCENARIOTYPE int not null  comment '应用场景类型'

,FSETCOMPONENT varchar(150) default null  comment '配置组件'

,FRUNCOMPONENT varchar(150) default null  comment '运行组件'

,FDESIGNERVISIBLE int not null  comment '设计器可见性'

,FREVERSEACTIONCLASS varchar(150) default null  comment '转换动作类'

,FPushComponent varchar(150) not null  comment '下推执行类'

,FDEFAULTRAISETYPE int not null  comment '缺省触发时机点'

,primary key (FActionID)

) comment = '可选表单服务'

--查询--

select FActionID as "factionid",FName as "fname",FTYPE as "ftype",FAPPSCENARIOTYPE as "fappscenariotype",FSETCOMPONENT as "fsetcomponent",FRUNCOMPONENT as "fruncomponent",FDESIGNERVISIBLE as "fdesignervisible",FREVERSEACTIONCLASS as "freverseactionclass",FPushComponent as "fpushcomponent",FDEFAULTRAISETYPE as "fdefaultraisetype" from t_mdl_formbusiness

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

select FActionID as "表单服务编码",FName as "名称",FTYPE as "参数+适用事件",FAPPSCENARIOTYPE as "应用场景类型",FSETCOMPONENT as "配置组件",FRUNCOMPONENT as "运行组件",FDESIGNERVISIBLE as "设计器可见性",FREVERSEACTIONCLASS as "转换动作类",FPushComponent as "下推执行类",FDEFAULTRAISETYPE as "缺省触发时机点" from t_mdl_formbusiness

--INSERT脚本--

insert into t_mdl_formbusiness(FActionID,FName,FTYPE,FAPPSCENARIOTYPE,FSETCOMPONENT,FRUNCOMPONENT,FDESIGNERVISIBLE,FREVERSEACTIONCLASS,FPushComponent,FDEFAULTRAISETYPE) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update t_mdl_formbusiness set FActionID=?,FName=?,FTYPE=?,FAPPSCENARIOTYPE=?,FSETCOMPONENT=?,FRUNCOMPONENT=?,FDESIGNERVISIBLE=?,FREVERSEACTIONCLASS=?,FPushComponent=?,FDEFAULTRAISETYPE=? where FActionID=?

--delete脚本--

delete from t_mdl_formbusiness where FActionID=?

--给字段加备注--

alter table t_mdl_formbusiness comment '可选表单服务';

alter table t_mdl_formbusiness modify column FActionID int not null  comment '表单服务编码';

alter table t_mdl_formbusiness modify column FName varchar(50) not null  comment '名称';

alter table t_mdl_formbusiness modify column FTYPE int default null  comment '参数+适用事件';

alter table t_mdl_formbusiness modify column FAPPSCENARIOTYPE int not null  comment '应用场景类型';

alter table t_mdl_formbusiness modify column FSETCOMPONENT varchar(150) default null  comment '配置组件';

alter table t_mdl_formbusiness modify column FRUNCOMPONENT varchar(150) default null  comment '运行组件';

alter table t_mdl_formbusiness modify column FDESIGNERVISIBLE int not null  comment '设计器可见性';

alter table t_mdl_formbusiness modify column FREVERSEACTIONCLASS varchar(150) default null  comment '转换动作类';

alter table t_mdl_formbusiness modify column FPushComponent varchar(150) not null  comment '下推执行类';

alter table t_mdl_formbusiness modify column FDEFAULTRAISETYPE int not null  comment '缺省触发时机点';

--建表脚本--

create table t_mdl_formbusiness_l(

FPKID int not null  comment '主键'

,FActionID int not null  comment '表单服务编码'

,FLocaleID int not null  comment '语言'

,FDesc nvarchar(255) default null  comment '描述'

,FSyntax nvarchar(255) default null  comment '语法说明'

,FParameter nvarchar(1000) default null  comment '参数说明'

,primary key (FPKID)

) comment = '可选表单服务多语言'

--查询--

select FPKID as "fpkid",FActionID as "factionid",FLocaleID as "flocaleid",FDesc as "fdesc",FSyntax as "fsyntax",FParameter as "fparameter" from t_mdl_formbusiness_l

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

select FPKID as "主键",FActionID as "表单服务编码",FLocaleID as "语言",FDesc as "描述",FSyntax as "语法说明",FParameter as "参数说明" from t_mdl_formbusiness_l

--INSERT脚本--

insert into t_mdl_formbusiness_l(FPKID,FActionID,FLocaleID,FDesc,FSyntax,FParameter) values (?,?,?,?,?,?)

--UPDATE脚本--

update t_mdl_formbusiness_l set FPKID=?,FActionID=?,FLocaleID=?,FDesc=?,FSyntax=?,FParameter=? where FPKID=?

--delete脚本--

delete from t_mdl_formbusiness_l where FPKID=?

--给字段加备注--

alter table t_mdl_formbusiness_l comment '可选表单服务多语言';

alter table t_mdl_formbusiness_l modify column FPKID int not null  comment '主键';

alter table t_mdl_formbusiness_l modify column FActionID int not null  comment '表单服务编码';

alter table t_mdl_formbusiness_l modify column FLocaleID int not null  comment '语言';

alter table t_mdl_formbusiness_l modify column FDesc nvarchar(255) default null  comment '描述';

alter table t_mdl_formbusiness_l modify column FSyntax nvarchar(255) default null  comment '语法说明';

alter table t_mdl_formbusiness_l modify column FParameter nvarchar(1000) default null  comment '参数说明';

--建表脚本--

create table t_mdl_formbusinessparams_l(

FPKID int not null  comment '主键'

,FParamID int not null  comment '参数编码'

,FLocaleID int not null  comment '语言'

,FDesc nvarchar(100) default null  comment '描述'

,primary key (FPKID)

) comment = '可选表单服务参数多语言'

--查询--

select FPKID as "fpkid",FParamID as "fparamid",FLocaleID as "flocaleid",FDesc as "fdesc" from t_mdl_formbusinessparams_l

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

select FPKID as "主键",FParamID as "参数编码",FLocaleID as "语言",FDesc as "描述" from t_mdl_formbusinessparams_l

--INSERT脚本--

insert into t_mdl_formbusinessparams_l(FPKID,FParamID,FLocaleID,FDesc) values (?,?,?,?)

--UPDATE脚本--

update t_mdl_formbusinessparams_l set FPKID=?,FParamID=?,FLocaleID=?,FDesc=? where FPKID=?

--delete脚本--

delete from t_mdl_formbusinessparams_l where FPKID=?

--给字段加备注--

alter table t_mdl_formbusinessparams_l comment '可选表单服务参数多语言';

alter table t_mdl_formbusinessparams_l modify column FPKID int not null  comment '主键';

alter table t_mdl_formbusinessparams_l modify column FParamID int not null  comment '参数编码';

alter table t_mdl_formbusinessparams_l modify column FLocaleID int not null  comment '语言';

alter table t_mdl_formbusinessparams_l modify column FDesc nvarchar(100) default null  comment '描述';

--建表脚本--

create table t_mdl_formoperationtype_l(

FPKID int not null  comment '主键'

,FID int not null  comment '表单操作编码'

,FLocaleID int not null  comment '语言'

,FName nvarchar(255) default null  comment '名称'

,primary key (FPKID)

) comment = '可选操作多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FName as "fname" from t_mdl_formoperationtype_l

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

select FPKID as "主键",FID as "表单操作编码",FLocaleID as "语言",FName as "名称" from t_mdl_formoperationtype_l

--INSERT脚本--

insert into t_mdl_formoperationtype_l(FPKID,FID,FLocaleID,FName) values (?,?,?,?)

--UPDATE脚本--

update t_mdl_formoperationtype_l set FPKID=?,FID=?,FLocaleID=?,FName=? where FPKID=?

--delete脚本--

delete from t_mdl_formoperationtype_l where FPKID=?

--给字段加备注--

alter table t_mdl_formoperationtype_l comment '可选操作多语言';

alter table t_mdl_formoperationtype_l modify column FPKID int not null  comment '主键';

alter table t_mdl_formoperationtype_l modify column FID int not null  comment '表单操作编码';

alter table t_mdl_formoperationtype_l modify column FLocaleID int not null  comment '语言';

alter table t_mdl_formoperationtype_l modify column FName nvarchar(255) default null  comment '名称';

--建表脚本--

create table t_mdl_imageresource_l(

FPKID varchar(36) not null  comment '主键'

,FKey varchar(30) not null  comment '图片标示'

,FLocaleID int not null  comment '语言'

,FDescription nvarchar(100) default null  comment '描述'

,primary key (FPKID)

) comment = '图片资源多语言'

--查询--

select FPKID as "fpkid",FKey as "fkey",FLocaleID as "flocaleid",FDescription as "fdescription" from t_mdl_imageresource_l

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

select FPKID as "主键",FKey as "图片标示",FLocaleID as "语言",FDescription as "描述" from t_mdl_imageresource_l

--INSERT脚本--

insert into t_mdl_imageresource_l(FPKID,FKey,FLocaleID,FDescription) values (?,?,?,?)

--UPDATE脚本--

update t_mdl_imageresource_l set FPKID=?,FKey=?,FLocaleID=?,FDescription=? where FPKID=?

--delete脚本--

delete from t_mdl_imageresource_l where FPKID=?

--给字段加备注--

alter table t_mdl_imageresource_l comment '图片资源多语言';

alter table t_mdl_imageresource_l modify column FPKID varchar(36) not null  comment '主键';

alter table t_mdl_imageresource_l modify column FKey varchar(30) not null  comment '图片标示';

alter table t_mdl_imageresource_l modify column FLocaleID int not null  comment '语言';

alter table t_mdl_imageresource_l modify column FDescription nvarchar(100) default null  comment '描述';