/*
   10 de outubro de 201817:34:33
   User: BETRACE
   Server: DEVSERVER\SQLEVOLUTION
   Database: BeProd_PLAS
   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
CREATE TABLE dbo.Tmp_Mov_Producao_OF
	(
	intId int NOT NULL IDENTITY (1, 1),
	intId_OF int NOT NULL,
	intId_Operacao int NOT NULL,
	strSerieOF varchar(50) NULL,
	bitIniciado bit NULL,
	bitConcluido bit NULL,
	intId_Maquina int NULL,
	strOperador varchar(50) NULL,
	dtmInicioSetup datetime NULL,
	dtmFimSetup datetime NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_Mov_Producao_OF SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_Producao_OF ON
GO
IF EXISTS(SELECT * FROM dbo.Mov_Producao_OF)
	 EXEC('INSERT INTO dbo.Tmp_Mov_Producao_OF (intId, intId_OF, intId_Operacao, bitIniciado, bitConcluido, intId_Maquina, strOperador, dtmInicioSetup, dtmFimSetup)
		SELECT intId, intId_OF, intId_Operacao, bitIniciado, bitConcluido, intId_Maquina, strOperador, dtmInicioSetup, dtmFimSetup FROM dbo.Mov_Producao_OF WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_Producao_OF OFF
GO
DROP TABLE dbo.Mov_Producao_OF
GO
EXECUTE sp_rename N'dbo.Tmp_Mov_Producao_OF', N'Mov_Producao_OF', 'OBJECT' 
GO
ALTER TABLE dbo.Mov_Producao_OF ADD CONSTRAINT
	PK_Mov_Of_Lin PRIMARY KEY CLUSTERED 
	(
	intId
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
select Has_Perms_By_Name(N'dbo.Mov_Producao_OF', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Mov_Producao_OF', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Mov_Producao_OF', 'Object', 'CONTROL') as Contr_Per