--字段的可重复升级
IF NOT EXISTS(SELECT c.Name
from sysobjects s
inner join syscolumns c on s.id = c.id where object_name(s.ID)='HM_EM_WorkInfo' and c.Name = 'InJobDate')
BEGIN
ALTER TABLE HM_EM_WorkInfo ADD [InJobDate] [Datetime] null
END
GO
--表的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('HR_SMS_OuterLinkman') and type = 'U')
BEGIN
create table HR_SMS_OuterLinkman (
ID uniqueidentifier not null,
Name nvarchar(20) not null,
Mobile nvarchar(20) not null,
Email nvarchar(50) null,
Address nvarchar(100) null,
Note nvarchar(250) null,
UserID uniqueidentifier not null,
constraint PK_HR_SMS_OUTERLINKMAN primary key (ID)
)
END
GO
--视图的可重复升级
IF EXISTS (SELECT 1 from sysobjects WHERE id = object_id(N'[视图名称 ]') AND OBJECTPROPERTY(id, N'IsView') = 1)
BEGIN
DROP VIEW 视图名称
END
GO
Create VIEW 视图名称
AS
GO
--存储过程的可重复升级
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE name ='HR_P_Rpt_EmployeeRedploy' and type='p')
begin
drop PROC 存储过程名
end
GO
create proc 存储过程名
(
参数
)
AS
BEGIN
END
GO
--外键的可重复升级
if not exists(select * from sysobjects where name='FK_HR_SMS_S_REFERENCE_HR_SMS_S' and xtype = 'F')
BEGIN
alter table HR_SMS_SMSItemOption
add constraint FK_HR_SMS_S_REFERENCE_HR_SMS_S foreign key (ItemID)
references HR_SMS_SMSQuenssiareItem (ID)
END
go
--索引的可重复升级
IF NOT EXISTS (SELECT 1
FROM sysindexes
WHERE id = OBJECT_ID('AP_Objective_Activities')
AND name = 'idx_AP_Objective_Activities_ProcInstIDNodeID')
CREATE INDEX idx_AP_Objective_Activities_ProcInstIDNodeID
ON AP_Objective_Activities
(
ProcInstID ASC,
NodeID ASC
)
GO
--主键的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name ='PK_Wf_WorkItemParticipants')
ALTER TABLE Wf_WorkItemParticipants ADD CONSTRAINT PK_Wf_WorkItemParticipants PRIMARY KEY
CLUSTERED
(
WorkItemId,
ParticipantId
) ON [PRIMARY]
GO
--字段约束的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name ='DF_HR_MothballManpower_IsDefaultSingletonValue')
ALTER TABLE [HR_MothballManpower] ADD CONSTRAINT [DF_HR_MothballManpower_IsDefaultSingletonValue] DEFAULT (0) FOR [IsDefaultSingletonValue]
GO
--触发器的可重复升级
if exists(select 1 from sysobjects where name='触发器物理名称' and type='TR')
Drop TRIGGER 触发器物理名称
GO
Create TRIGGER 触发器物理名称 ON 表的名称
FOR INSERT
AS
BEGIN
END
GO
IF NOT EXISTS(SELECT c.Name
from sysobjects s
inner join syscolumns c on s.id = c.id where object_name(s.ID)='HM_EM_WorkInfo' and c.Name = 'InJobDate')
BEGIN
ALTER TABLE HM_EM_WorkInfo ADD [InJobDate] [Datetime] null
END
GO
--表的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('HR_SMS_OuterLinkman') and type = 'U')
BEGIN
create table HR_SMS_OuterLinkman (
ID uniqueidentifier not null,
Name nvarchar(20) not null,
Mobile nvarchar(20) not null,
Email nvarchar(50) null,
Address nvarchar(100) null,
Note nvarchar(250) null,
UserID uniqueidentifier not null,
constraint PK_HR_SMS_OUTERLINKMAN primary key (ID)
)
END
GO
--视图的可重复升级
IF EXISTS (SELECT 1 from sysobjects WHERE id = object_id(N'[视图名称 ]') AND OBJECTPROPERTY(id, N'IsView') = 1)
BEGIN
DROP VIEW 视图名称
END
GO
Create VIEW 视图名称
AS
GO
--存储过程的可重复升级
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE name ='HR_P_Rpt_EmployeeRedploy' and type='p')
begin
drop PROC 存储过程名
end
GO
create proc 存储过程名
(
参数
)
AS
BEGIN
END
GO
--外键的可重复升级
if not exists(select * from sysobjects where name='FK_HR_SMS_S_REFERENCE_HR_SMS_S' and xtype = 'F')
BEGIN
alter table HR_SMS_SMSItemOption
add constraint FK_HR_SMS_S_REFERENCE_HR_SMS_S foreign key (ItemID)
references HR_SMS_SMSQuenssiareItem (ID)
END
go
--索引的可重复升级
IF NOT EXISTS (SELECT 1
FROM sysindexes
WHERE id = OBJECT_ID('AP_Objective_Activities')
AND name = 'idx_AP_Objective_Activities_ProcInstIDNodeID')
CREATE INDEX idx_AP_Objective_Activities_ProcInstIDNodeID
ON AP_Objective_Activities
(
ProcInstID ASC,
NodeID ASC
)
GO
--主键的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name ='PK_Wf_WorkItemParticipants')
ALTER TABLE Wf_WorkItemParticipants ADD CONSTRAINT PK_Wf_WorkItemParticipants PRIMARY KEY
CLUSTERED
(
WorkItemId,
ParticipantId
) ON [PRIMARY]
GO
--字段约束的可重复升级
IF NOT EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name ='DF_HR_MothballManpower_IsDefaultSingletonValue')
ALTER TABLE [HR_MothballManpower] ADD CONSTRAINT [DF_HR_MothballManpower_IsDefaultSingletonValue] DEFAULT (0) FOR [IsDefaultSingletonValue]
GO
--触发器的可重复升级
if exists(select 1 from sysobjects where name='触发器物理名称' and type='TR')
Drop TRIGGER 触发器物理名称
GO
Create TRIGGER 触发器物理名称 ON 表的名称
FOR INSERT
AS
BEGIN
END
GO