96 lines
5.0 KiB
Transact-SQL
96 lines
5.0 KiB
Transact-SQL
/*
|
||
Wednesday, February 06, 20192:17:07 PM
|
||
User:
|
||
Server: FAJITA\DEV_SQL
|
||
Database: DataPRO
|
||
Application:
|
||
*/
|
||
|
||
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
|
||
BEGIN TRANSACTION
|
||
SET QUOTED_IDENTIFIER ON
|
||
SET ARITHABORT ON
|
||
SET NUMERIC_ROUNDABORT OFF
|
||
SET CONCAT_NULL_YIELDS_NULL ON
|
||
SET ANSI_NULLS ON
|
||
SET ANSI_PADDING ON
|
||
SET ANSI_WARNINGS ON
|
||
COMMIT
|
||
BEGIN TRANSACTION
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware
|
||
DROP CONSTRAINT FK_TestSetupHardware_TestSetups
|
||
GO
|
||
ALTER TABLE dbo.TestSetups SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
COMMIT
|
||
BEGIN TRANSACTION
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware
|
||
DROP CONSTRAINT FK_TestSetupHardware_DAS
|
||
GO
|
||
ALTER TABLE dbo.DAS SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
COMMIT
|
||
BEGIN TRANSACTION
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware
|
||
DROP CONSTRAINT DF_TestSetupHardware_TestSetupId
|
||
GO
|
||
CREATE TABLE dbo.Tmp_TestSetupHardware
|
||
(
|
||
TestSetupHardwareId int NOT NULL IDENTITY (1, 1),
|
||
DASId int NOT NULL,
|
||
TestSetupId int NOT NULL,
|
||
AddOrRemove bit NOT NULL,
|
||
SamplesPerSecond float(53) NOT NULL
|
||
) ON [PRIMARY]
|
||
GO
|
||
ALTER TABLE dbo.Tmp_TestSetupHardware SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
ALTER TABLE dbo.Tmp_TestSetupHardware ADD CONSTRAINT
|
||
DF_TestSetupHardware_TestSetupId DEFAULT ((0)) FOR TestSetupId
|
||
GO
|
||
SET IDENTITY_INSERT dbo.Tmp_TestSetupHardware ON
|
||
GO
|
||
IF EXISTS(SELECT * FROM dbo.TestSetupHardware)
|
||
EXEC('INSERT INTO dbo.Tmp_TestSetupHardware (TestSetupHardwareId, DASId, TestSetupId, AddOrRemove, 10000)
|
||
SELECT TestSetupHardwareId, DASId, TestSetupId, AddOrRemove FROM dbo.TestSetupHardware WITH (HOLDLOCK TABLOCKX)')
|
||
GO
|
||
SET IDENTITY_INSERT dbo.Tmp_TestSetupHardware OFF
|
||
GO
|
||
DROP TABLE dbo.TestSetupHardware
|
||
GO
|
||
EXECUTE sp_rename N'dbo.Tmp_TestSetupHardware', N'TestSetupHardware', 'OBJECT'
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware ADD CONSTRAINT
|
||
PK_TestSetupHardware PRIMARY KEY CLUSTERED
|
||
(
|
||
TestSetupHardwareId
|
||
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware WITH NOCHECK ADD CONSTRAINT
|
||
FK_TestSetupHardware_DAS FOREIGN KEY
|
||
(
|
||
DASId
|
||
) REFERENCES dbo.DAS
|
||
(
|
||
DASId
|
||
) ON UPDATE NO ACTION
|
||
ON DELETE NO ACTION
|
||
|
||
GO
|
||
ALTER TABLE dbo.TestSetupHardware WITH NOCHECK ADD CONSTRAINT
|
||
FK_TestSetupHardware_TestSetups FOREIGN KEY
|
||
(
|
||
TestSetupId
|
||
) REFERENCES dbo.TestSetups
|
||
(
|
||
TestSetupId
|
||
) ON UPDATE NO ACTION
|
||
ON DELETE NO ACTION
|
||
|
||
GO
|
||
COMMIT
|