--建表脚本--
create table T_PLM_CAD_CLIENTMEMORY(
FID bigint not null comment '标识'
,FMasterID bigint not null comment '多组织标识'
,FINTEGRATION int default null comment '集成软件id'
,FFOLDER bigint default null comment '文件夹标识'
,FUSER int default null comment '用户标识'
,FCATEGORY bigint default null comment '业务类型标识'
,primary key (FID)
) comment = 'cad文件夹记忆'
--查询--
select FID as "fid",FMasterID as "fmasterid",FINTEGRATION as "fintegration",FFOLDER as "ffolder",FUSER as "fuser",FCATEGORY as "fcategory" from T_PLM_CAD_CLIENTMEMORY
--查询(中文字段)--
select FID as "标识",FMasterID as "多组织标识",FINTEGRATION as "集成软件id",FFOLDER as "文件夹标识",FUSER as "用户标识",FCATEGORY as "业务类型标识" from T_PLM_CAD_CLIENTMEMORY
--INSERT脚本--
insert into T_PLM_CAD_CLIENTMEMORY(FID,FMasterID,FINTEGRATION,FFOLDER,FUSER,FCATEGORY) values (?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CAD_CLIENTMEMORY set FID=?,FMasterID=?,FINTEGRATION=?,FFOLDER=?,FUSER=?,FCATEGORY=? where FID=?
--delete脚本--
delete from T_PLM_CAD_CLIENTMEMORY where FID=?
--给字段加备注--
alter table T_PLM_CAD_CLIENTMEMORY comment 'cad文件夹记忆';
alter table T_PLM_CAD_CLIENTMEMORY modify column FID bigint not null comment '标识';
alter table T_PLM_CAD_CLIENTMEMORY modify column FMasterID bigint not null comment '多组织标识';
alter table T_PLM_CAD_CLIENTMEMORY modify column FINTEGRATION int default null comment '集成软件id';
alter table T_PLM_CAD_CLIENTMEMORY modify column FFOLDER bigint default null comment '文件夹标识';
alter table T_PLM_CAD_CLIENTMEMORY modify column FUSER int default null comment '用户标识';
alter table T_PLM_CAD_CLIENTMEMORY modify column FCATEGORY bigint default null comment '业务类型标识';
--建表脚本--
create table T_PLM_CFG_ADMIN(
FID bigint not null comment 'FID'
,FMasterID bigint not null comment '多组织主键id'
,primary key (FID)
) comment = 'plm管理员单据头'
--查询--
select FID as "fid",FMasterID as "fmasterid" from T_PLM_CFG_ADMIN
--查询(中文字段)--
select FID as "FID",FMasterID as "多组织主键id" from T_PLM_CFG_ADMIN
--INSERT脚本--
insert into T_PLM_CFG_ADMIN(FID,FMasterID) values (?,?)
--UPDATE脚本--
update T_PLM_CFG_ADMIN set FID=?,FMasterID=? where FID=?
--delete脚本--
delete from T_PLM_CFG_ADMIN where FID=?
--给字段加备注--
alter table T_PLM_CFG_ADMIN comment 'plm管理员单据头';
alter table T_PLM_CFG_ADMIN modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_ADMIN modify column FMasterID bigint not null comment '多组织主键id';
--建表脚本--
create table T_PLM_CFG_ADMINROLE(
FEntryID bigint not null comment 'FEntryID'
,FID bigint not null comment 'FID'
,FROLE int not null comment '角色'
,FENABLED char(1) not null comment '是否启用'
,primary key (FEntryID)
) comment = 'plm管理员单据体'
--查询--
select FEntryID as "fentryid",FID as "fid",FROLE as "frole",FENABLED as "fenabled" from T_PLM_CFG_ADMINROLE
--查询(中文字段)--
select FEntryID as "FEntryID",FID as "FID",FROLE as "角色",FENABLED as "是否启用" from T_PLM_CFG_ADMINROLE
--INSERT脚本--
insert into T_PLM_CFG_ADMINROLE(FEntryID,FID,FROLE,FENABLED) values (?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_ADMINROLE set FEntryID=?,FID=?,FROLE=?,FENABLED=? where FEntryID=?
--delete脚本--
delete from T_PLM_CFG_ADMINROLE where FEntryID=?
--给字段加备注--
alter table T_PLM_CFG_ADMINROLE comment 'plm管理员单据体';
alter table T_PLM_CFG_ADMINROLE modify column FEntryID bigint not null comment 'FEntryID';
alter table T_PLM_CFG_ADMINROLE modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_ADMINROLE modify column FROLE int not null comment '角色';
alter table T_PLM_CFG_ADMINROLE modify column FENABLED char(1) not null comment '是否启用';
--建表脚本--
create table T_PLM_CFG_AD_CATEGRYVIEW(
FEntryID bigint not null comment 'FEntryID'
,FID bigint not null comment 'FID'
,FCATEGORYID bigint not null comment '业务类型id'
,FADVIEWNAME nvarchar(50) not null comment '将要创建的视图名称'
,primary key (FEntryID)
) comment = '用户自定义视图名称记录表'
--查询--
select FEntryID as "fentryid",FID as "fid",FCATEGORYID as "fcategoryid",FADVIEWNAME as "fadviewname" from T_PLM_CFG_AD_CATEGRYVIEW
--查询(中文字段)--
select FEntryID as "FEntryID",FID as "FID",FCATEGORYID as "业务类型id",FADVIEWNAME as "将要创建的视图名称" from T_PLM_CFG_AD_CATEGRYVIEW
--INSERT脚本--
insert into T_PLM_CFG_AD_CATEGRYVIEW(FEntryID,FID,FCATEGORYID,FADVIEWNAME) values (?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_AD_CATEGRYVIEW set FEntryID=?,FID=?,FCATEGORYID=?,FADVIEWNAME=? where FEntryID=?
--delete脚本--
delete from T_PLM_CFG_AD_CATEGRYVIEW where FEntryID=?
--给字段加备注--
alter table T_PLM_CFG_AD_CATEGRYVIEW comment '用户自定义视图名称记录表';
alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FEntryID bigint not null comment 'FEntryID';
alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FCATEGORYID bigint not null comment '业务类型id';
alter table T_PLM_CFG_AD_CATEGRYVIEW modify column FADVIEWNAME nvarchar(50) not null comment '将要创建的视图名称';
--建表脚本--
create table T_PLM_CFG_AD_CONFIG(
FID bigint not null comment 'FID'
,FMasterID bigint not null comment 'FMasterID'
,FADSYNCHROGAZERDBURL nvarchar(50) not null comment '数据库地址'
,FADSYNCHROGAZERDBNAME nvarchar(50) not null comment '数据库名称'
,FADSYNCHROGAZERDBPASSWORD nvarchar(50) not null comment '数据库密码'
,FADSYNCHROGAZERDBACCOUNT nvarchar(50) not null comment '数据库账号'
,FADSYNCHRONIZATIONTIME int not null comment '更新间隔时间'
,FTEMPTIME nvarchar(50) not null comment '根据单位显示的时间'
,FTIMEUNIT varchar(20) not null comment '时间单位'
,primary key (FID)
) comment = 'ad数据同步数据库配置表'
--查询--
select FID as "fid",FMasterID as "fmasterid",FADSYNCHROGAZERDBURL as "fadsynchrogazerdburl",FADSYNCHROGAZERDBNAME as "fadsynchrogazerdbname",FADSYNCHROGAZERDBPASSWORD as "fadsynchrogazerdbpassword",FADSYNCHROGAZERDBACCOUNT as "fadsynchrogazerdbaccount",FADSYNCHRONIZATIONTIME as "fadsynchronizationtime",FTEMPTIME as "ftemptime",FTIMEUNIT as "ftimeunit" from T_PLM_CFG_AD_CONFIG
--查询(中文字段)--
select FID as "FID",FMasterID as "FMasterID",FADSYNCHROGAZERDBURL as "数据库地址",FADSYNCHROGAZERDBNAME as "数据库名称",FADSYNCHROGAZERDBPASSWORD as "数据库密码",FADSYNCHROGAZERDBACCOUNT as "数据库账号",FADSYNCHRONIZATIONTIME as "更新间隔时间",FTEMPTIME as "根据单位显示的时间",FTIMEUNIT as "时间单位" from T_PLM_CFG_AD_CONFIG
--INSERT脚本--
insert into T_PLM_CFG_AD_CONFIG(FID,FMasterID,FADSYNCHROGAZERDBURL,FADSYNCHROGAZERDBNAME,FADSYNCHROGAZERDBPASSWORD,FADSYNCHROGAZERDBACCOUNT,FADSYNCHRONIZATIONTIME,FTEMPTIME,FTIMEUNIT) values (?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_AD_CONFIG set FID=?,FMasterID=?,FADSYNCHROGAZERDBURL=?,FADSYNCHROGAZERDBNAME=?,FADSYNCHROGAZERDBPASSWORD=?,FADSYNCHROGAZERDBACCOUNT=?,FADSYNCHRONIZATIONTIME=?,FTEMPTIME=?,FTIMEUNIT=? where FID=?
--delete脚本--
delete from T_PLM_CFG_AD_CONFIG where FID=?
--给字段加备注--
alter table T_PLM_CFG_AD_CONFIG comment 'ad数据同步数据库配置表';
alter table T_PLM_CFG_AD_CONFIG modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_AD_CONFIG modify column FMasterID bigint not null comment 'FMasterID';
alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBURL nvarchar(50) not null comment '数据库地址';
alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBNAME nvarchar(50) not null comment '数据库名称';
alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBPASSWORD nvarchar(50) not null comment '数据库密码';
alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHROGAZERDBACCOUNT nvarchar(50) not null comment '数据库账号';
alter table T_PLM_CFG_AD_CONFIG modify column FADSYNCHRONIZATIONTIME int not null comment '更新间隔时间';
alter table T_PLM_CFG_AD_CONFIG modify column FTEMPTIME nvarchar(50) not null comment '根据单位显示的时间';
alter table T_PLM_CFG_AD_CONFIG modify column FTIMEUNIT varchar(20) not null comment '时间单位';
