/*
   domingo, 21 de Março de 201023:27:29
   User: sa
   Server: ELEANOR\ELEANOR
   Database: BeProd_JCL
   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.M03_MovimentosProducao
	(
	IntIdMovimento int NOT NULL IDENTITY (1, 1),
	StrCodMaquina nvarchar(50) NOT NULL,
	StrCodDesenho nvarchar(50) NOT NULL,
	StrSSCC nvarchar(50) NOT NULL,
	DtmInicio datetime NULL,
	DtmFim datetime NULL,
	BitConcluido bit NULL,
	BitCancelado bit NULL,
	StrUser nvarchar(50) NOT NULL,
	DtmDataRegisto datetime NOT NULL,
	StrUserAlteracao nvarchar(50) NULL,
	DtmDataAlteracao datetime NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.M03_MovimentosProducao ADD CONSTRAINT
	PK_M03_MovimentosProducao PRIMARY KEY CLUSTERED 
	(
	IntIdMovimento
	) 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.M03_MovimentosProducao', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.M03_MovimentosProducao', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.M03_MovimentosProducao', 'Object', 'CONTROL') as Contr_Per