/*
   2 de outubro de 201800:50:06
   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_OF_Cab
	(
	intId int NOT NULL IDENTITY (1, 1),
	strTipoOf varchar(50) NOT NULL,
	dtmDataRegisto datetime NOT NULL,
	strCodCliente varchar(50) NOT NULL,
	strUserRegisto varchar(50) NOT NULL,
	strCidade varchar(50) NOT NULL,
	strNumero varchar(50) NOT NULL,
	intOF int NOT NULL,
	strArtigo varchar(100) NOT NULL,
	fltQtd decimal(16, 4) NOT NULL,
	strUrgencia varchar(50) NOT NULL,
	strObs varchar(150) NOT NULL,
	strTipoEmbalamento varchar(50) NOT NULL,
	strTipoProduto varchar(50) NOT NULL,
	strTipoMatPrima varchar(50) NOT NULL,
	strEtiqueta varchar(50) NOT NULL,
	strOpaco varchar(50) NOT NULL,
	fltLargura decimal(16, 4) NOT NULL,
	fltComp decimal(16, 4) NOT NULL,
	fltEspessura decimal(16, 4) NULL,
	strFole varchar(50) NULL,
	strFole2 varchar(50) NULL,
	strImpressao varchar(50) NOT NULL,
	strUnidade varchar(50) NULL,
	strPala varchar(50) NULL,
	bitPestanas bit NOT NULL,
	bitCabide bit NOT NULL,
	bitEurofuro bit NOT NULL,
	bitVazado bit NOT NULL,
	bitAdesiva bit NOT NULL,
	bitInterior bit NOT NULL,
	bitCanteada bit NOT NULL,
	bitSimples bit NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_Mov_OF_Cab SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_OF_Cab ON
GO
IF EXISTS(SELECT * FROM dbo.Mov_OF_Cab)
	 EXEC('INSERT INTO dbo.Tmp_Mov_OF_Cab (intId, strTipoOf, dtmDataRegisto, strCodCliente, strUserRegisto, strCidade, strNumero, intOF, strArtigo, fltQtd, strUrgencia, strObs, strTipoEmbalamento, strTipoProduto, strTipoMatPrima, strEtiqueta, strOpaco, fltLargura, fltComp, fltEspessura, strFole, strFole2, strImpressao, strUnidade, strPala, bitPestanas, bitCabide, bitEurofuro, bitVazado, bitAdesiva, bitInterior, bitCanteada, bitSimples)
		SELECT intId, strTipoOf, dtmDataRegisto, strCodCliente, strUserRegisto, strCidade, strNumero, intOF, strArtigo, fltQtd, strUrgencia, strObs, strTipoEmbalamento, strTipoProduto, strTipoMatPrima, strEtiqueta, strOpaco, fltLargura, fltComp, fltEspessura, strFole, strFole2, strImpressao, strUnidade, strPala, bitPestanas, bitCabide, bitEurofuro, bitVazado, bitAdesiva, bitInterior, bitCanteada, bitSimples FROM dbo.Mov_OF_Cab WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_OF_Cab OFF
GO
DROP TABLE dbo.Mov_OF_Cab
GO
EXECUTE sp_rename N'dbo.Tmp_Mov_OF_Cab', N'Mov_OF_Cab', 'OBJECT' 
GO
ALTER TABLE dbo.Mov_OF_Cab ADD CONSTRAINT
	PK_Mov_OF_Cab 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_OF_Cab', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Mov_OF_Cab', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Mov_OF_Cab', 'Object', 'CONTROL') as Contr_Per