/*
   Tuesday, August 02, 20111:55:39 PM
   User: sa
   Server: (local)\VPOS
   Database: FnbDatafile
   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.Customize_StaffComm
	(
	id uniqueidentifier NOT NULL ROWGUIDCOL,
	StaffCode varchar(20) NULL,
	CardNo varchar(20) NULL,
	Name varchar(100) NULL,
	RefTrsNo varchar(50) NULL,
	TopupValue numeric(18, 2) NULL,
	PValue numeric(18, 2) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Customize_StaffComm ADD CONSTRAINT
	DF_Customize_StaffComm_id DEFAULT (newid()) FOR id
GO
ALTER TABLE dbo.Customize_StaffComm ADD CONSTRAINT
	DF_Customize_StaffComm_TopupValue DEFAULT 0 FOR TopupValue
GO
ALTER TABLE dbo.Customize_StaffComm ADD CONSTRAINT
	DF_Customize_StaffComm_PValue DEFAULT 0 FOR PValue
GO
ALTER TABLE dbo.Customize_StaffComm ADD CONSTRAINT
	PK_Customize_StaffComm PRIMARY KEY CLUSTERED 
	(
	id
	) 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.Customize_StaffComm', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Customize_StaffComm', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Customize_StaffComm', 'Object', 'CONTROL') as Contr_Per 


ALTER TABLE dbo.Customize_StaffComm ADD
	TrsDate datetime NULL
GO