--建表脚本--

create table T_BAS_HAMONITORMAIL(

FID bigint not null  comment '主键'

,FDATETIME datetime default null  comment '发送时间'

,FTITLE nvarchar(50) default null  comment '邮件标题'

,FCONTENT nvarchar(255) default null  comment '邮件内容'

,FRECEIVER nvarchar(50) default null  comment '接收人'

,FSTATUS nvarchar(50) default null  comment '发送状态'

,primary key (FID)

) comment = '管理中心高可用监控邮件发送记录'

--查询--

select FID as "fid",FDATETIME as "fdatetime",FTITLE as "ftitle",FCONTENT as "fcontent",FRECEIVER as "freceiver",FSTATUS as "fstatus" from T_BAS_HAMONITORMAIL

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

select FID as "主键",FDATETIME as "发送时间",FTITLE as "邮件标题",FCONTENT as "邮件内容",FRECEIVER as "接收人",FSTATUS as "发送状态" from T_BAS_HAMONITORMAIL

--INSERT脚本--

insert into T_BAS_HAMONITORMAIL(FID,FDATETIME,FTITLE,FCONTENT,FRECEIVER,FSTATUS) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_BAS_HAMONITORMAIL set FID=?,FDATETIME=?,FTITLE=?,FCONTENT=?,FRECEIVER=?,FSTATUS=? where FID=?

--delete脚本--

delete from T_BAS_HAMONITORMAIL where FID=?

--给字段加备注--

alter table T_BAS_HAMONITORMAIL comment '管理中心高可用监控邮件发送记录';

alter table T_BAS_HAMONITORMAIL modify column FID bigint not null  comment '主键';

alter table T_BAS_HAMONITORMAIL modify column FDATETIME datetime default null  comment '发送时间';

alter table T_BAS_HAMONITORMAIL modify column FTITLE nvarchar(50) default null  comment '邮件标题';

alter table T_BAS_HAMONITORMAIL modify column FCONTENT nvarchar(255) default null  comment '邮件内容';

alter table T_BAS_HAMONITORMAIL modify column FRECEIVER nvarchar(50) default null  comment '接收人';

alter table T_BAS_HAMONITORMAIL modify column FSTATUS nvarchar(50) default null  comment '发送状态';

--建表脚本--

create table T_BAS_LICIMPORTRECORDING(

FID int not null  comment '主键id'

,FPACKAGEID varchar(36) default null  comment 'lic包id'

,FCREATETIME datetime not null  comment '创建时间'

,FCREATORID bigint not null  comment '创建者id'

,FLICTYPE int not null  comment '许可类型'

,primary key (FID)

) comment = '许可引入记录'

--查询--

select FID as "fid",FPACKAGEID as "fpackageid",FCREATETIME as "fcreatetime",FCREATORID as "fcreatorid",FLICTYPE as "flictype" from T_BAS_LICIMPORTRECORDING

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

select FID as "主键id",FPACKAGEID as "lic包id",FCREATETIME as "创建时间",FCREATORID as "创建者id",FLICTYPE as "许可类型" from T_BAS_LICIMPORTRECORDING

--INSERT脚本--

insert into T_BAS_LICIMPORTRECORDING(FID,FPACKAGEID,FCREATETIME,FCREATORID,FLICTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_BAS_LICIMPORTRECORDING set FID=?,FPACKAGEID=?,FCREATETIME=?,FCREATORID=?,FLICTYPE=? where FID=?

--delete脚本--

delete from T_BAS_LICIMPORTRECORDING where FID=?

--给字段加备注--

alter table T_BAS_LICIMPORTRECORDING comment '许可引入记录';

alter table T_BAS_LICIMPORTRECORDING modify column FID int not null  comment '主键id';

alter table T_BAS_LICIMPORTRECORDING modify column FPACKAGEID varchar(36) default null  comment 'lic包id';

alter table T_BAS_LICIMPORTRECORDING modify column FCREATETIME datetime not null  comment '创建时间';

alter table T_BAS_LICIMPORTRECORDING modify column FCREATORID bigint not null  comment '创建者id';

alter table T_BAS_LICIMPORTRECORDING modify column FLICTYPE int not null  comment '许可类型';