--建表脚本--

create table T_ATS_IMPORTLISTSOURCE(

FID int not null  comment '手工引入方案id'

,FVALUE int not null  comment '手工引入下拉值'

,FNAME nvarchar(80) default null  comment '手工引入下拉名称'

,primary key (FID,FVALUE)

) comment = '下拉列表源字段'

--查询--

select FID as "fid",FVALUE as "fvalue",FNAME as "fname" from T_ATS_IMPORTLISTSOURCE

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

select FID as "手工引入方案id",FVALUE as "手工引入下拉值",FNAME as "手工引入下拉名称" from T_ATS_IMPORTLISTSOURCE

--INSERT脚本--

insert into T_ATS_IMPORTLISTSOURCE(FID,FVALUE,FNAME) values (?,?,?)

--UPDATE脚本--

update T_ATS_IMPORTLISTSOURCE set FID=?,FVALUE=?,FNAME=? where FID=? AND FVALUE=?

--delete脚本--

delete from T_ATS_IMPORTLISTSOURCE where FID=? AND FVALUE=?

--给字段加备注--

alter table T_ATS_IMPORTLISTSOURCE comment '下拉列表源字段';

alter table T_ATS_IMPORTLISTSOURCE modify column FID int not null  comment '手工引入方案id';

alter table T_ATS_IMPORTLISTSOURCE modify column FVALUE int not null  comment '手工引入下拉值';

alter table T_ATS_IMPORTLISTSOURCE modify column FNAME nvarchar(80) default null  comment '手工引入下拉名称';

--建表脚本--

create table T_ATS_IMPRESULT(

FENTRYID int not null  comment '内码'

,FID int default null  comment '方案内码'

,FIMPORTFILE nvarchar(255) default null  comment '导入文件'

,FIMPORTTIME datetime default null  comment '导入时间'

,FIMPORTRESULT char(1) default null  comment '导入结果'

,FCONTENT NTEXT default null  comment '导入结果明细'

,primary key (FENTRYID)

) comment = '定时导入结果'

--查询--

select FENTRYID as "fentryid",FID as "fid",FIMPORTFILE as "fimportfile",FIMPORTTIME as "fimporttime",FIMPORTRESULT as "fimportresult",FCONTENT as "fcontent" from T_ATS_IMPRESULT

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

select FENTRYID as "内码",FID as "方案内码",FIMPORTFILE as "导入文件",FIMPORTTIME as "导入时间",FIMPORTRESULT as "导入结果",FCONTENT as "导入结果明细" from T_ATS_IMPRESULT

--INSERT脚本--

insert into T_ATS_IMPRESULT(FENTRYID,FID,FIMPORTFILE,FIMPORTTIME,FIMPORTRESULT,FCONTENT) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_ATS_IMPRESULT set FENTRYID=?,FID=?,FIMPORTFILE=?,FIMPORTTIME=?,FIMPORTRESULT=?,FCONTENT=? where FENTRYID=?

--delete脚本--

delete from T_ATS_IMPRESULT where FENTRYID=?

--给字段加备注--

alter table T_ATS_IMPRESULT comment '定时导入结果';

alter table T_ATS_IMPRESULT modify column FENTRYID int not null  comment '内码';

alter table T_ATS_IMPRESULT modify column FID int default null  comment '方案内码';

alter table T_ATS_IMPRESULT modify column FIMPORTFILE nvarchar(255) default null  comment '导入文件';

alter table T_ATS_IMPRESULT modify column FIMPORTTIME datetime default null  comment '导入时间';

alter table T_ATS_IMPRESULT modify column FIMPORTRESULT char(1) default null  comment '导入结果';

alter table T_ATS_IMPRESULT modify column FCONTENT NTEXT default null  comment '导入结果明细';

--建表脚本--

create table T_ATS_ITEMTABLES(

FID int not null  comment '主键'

,FTABLETYPE char(1) not null  comment '表类型'

,FTABLENAME nvarchar(80) not null  comment '表名'

,FBAKTABLENAME nvarchar(80) not null  comment '归档表名'

,FITEMCOUNT int not null  comment '考勤项目数'

,primary key (FID)

) comment = '考勤计算表信息'

--查询--

select FID as "fid",FTABLETYPE as "ftabletype",FTABLENAME as "ftablename",FBAKTABLENAME as "fbaktablename",FITEMCOUNT as "fitemcount" from T_ATS_ITEMTABLES

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

select FID as "主键",FTABLETYPE as "表类型",FTABLENAME as "表名",FBAKTABLENAME as "归档表名",FITEMCOUNT as "考勤项目数" from T_ATS_ITEMTABLES

--INSERT脚本--

insert into T_ATS_ITEMTABLES(FID,FTABLETYPE,FTABLENAME,FBAKTABLENAME,FITEMCOUNT) values (?,?,?,?,?)

--UPDATE脚本--

update T_ATS_ITEMTABLES set FID=?,FTABLETYPE=?,FTABLENAME=?,FBAKTABLENAME=?,FITEMCOUNT=? where FID=?

--delete脚本--

delete from T_ATS_ITEMTABLES where FID=?

--给字段加备注--

alter table T_ATS_ITEMTABLES comment '考勤计算表信息';

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

alter table T_ATS_ITEMTABLES modify column FTABLETYPE char(1) not null  comment '表类型';

alter table T_ATS_ITEMTABLES modify column FTABLENAME nvarchar(80) not null  comment '表名';

alter table T_ATS_ITEMTABLES modify column FBAKTABLENAME nvarchar(80) not null  comment '归档表名';

alter table T_ATS_ITEMTABLES modify column FITEMCOUNT int not null  comment '考勤项目数';