/*
   2 de outubro de 201802:07:23
   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
ALTER TABLE dbo.Mov_Producao
	DROP CONSTRAINT DF_Mov_Producao_fltQtdQuebra
GO
ALTER TABLE dbo.Mov_Producao
	DROP CONSTRAINT DF_Mov_Producao_fltQuebraKg
GO
ALTER TABLE dbo.Mov_Producao
	DROP CONSTRAINT DF_Mov_Producao_fltQuebraCm
GO
ALTER TABLE dbo.Mov_Producao
	DROP CONSTRAINT DF_Mov_Producao_fltQuebraBobine
GO
CREATE TABLE dbo.Tmp_Mov_Producao
	(
	intId int NOT NULL IDENTITY (1, 1),
	intId_OF int NOT NULL,
	intId_Operacao int NOT NULL,
	strOperador varchar(50) NOT NULL,
	intId_Maquina int NOT NULL,
	fltQtdProduzida decimal(16, 4) NOT NULL,
	fltQtdQuebra decimal(16, 4) NOT NULL,
	dtmDataMomento datetime NULL,
	dtmDataInicio datetime NOT NULL,
	dtmDataFim datetime NULL,
	fltKg decimal(16, 4) NULL,
	fltCm decimal(16, 4) NULL,
	intBobine int NULL,
	fltQuebraKg decimal(16, 4) NULL,
	fltQuebraCm decimal(16, 4) NULL,
	fltQuebraBobine decimal(16, 4) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_Mov_Producao SET (LOCK_ESCALATION = TABLE)
GO
ALTER TABLE dbo.Tmp_Mov_Producao ADD CONSTRAINT
	DF_Mov_Producao_fltQtdQuebra DEFAULT ((0)) FOR fltQtdQuebra
GO
ALTER TABLE dbo.Tmp_Mov_Producao ADD CONSTRAINT
	DF_Mov_Producao_fltQuebraKg DEFAULT ((0)) FOR fltQuebraKg
GO
ALTER TABLE dbo.Tmp_Mov_Producao ADD CONSTRAINT
	DF_Mov_Producao_fltQuebraCm DEFAULT ((0)) FOR fltQuebraCm
GO
ALTER TABLE dbo.Tmp_Mov_Producao ADD CONSTRAINT
	DF_Mov_Producao_fltQuebraBobine DEFAULT ((0)) FOR fltQuebraBobine
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_Producao ON
GO
IF EXISTS(SELECT * FROM dbo.Mov_Producao)
	 EXEC('INSERT INTO dbo.Tmp_Mov_Producao (intId, intId_OF, intId_Operacao, strOperador, intId_Maquina, fltQtdProduzida, fltQtdQuebra, dtmDataMomento, dtmDataInicio, dtmDataFim, fltKg, fltCm, intBobine, fltQuebraKg, fltQuebraCm, fltQuebraBobine)
		SELECT intId, intId_OF, intId_Operacao, CONVERT(varchar(50), intId_Operador), intId_Maquina, fltQtdProduzida, fltQtdQuebra, dtmDataMomento, dtmDataInicio, dtmDataFim, fltKg, fltCm, intBobine, fltQuebraKg, fltQuebraCm, fltQuebraBobine FROM dbo.Mov_Producao WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_Producao OFF
GO
DROP TABLE dbo.Mov_Producao
GO
EXECUTE sp_rename N'dbo.Tmp_Mov_Producao', N'Mov_Producao', 'OBJECT' 
GO
ALTER TABLE dbo.Mov_Producao ADD CONSTRAINT
	PK_Mov_Producao 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', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Mov_Producao', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Mov_Producao', 'Object', 'CONTROL') as Contr_Per