/****** Object:  Table [dbo].[tblTablePermissions]    Script Date: 03/26/2012 19:12:22 *****
	Table Designed by IT Impact Inc
	All rights reserved
	AccessExperts.net
*/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblTablePermissions](
	[TableID] [int] IDENTITY(1,1) NOT NULL,
	[TABLE_NAME] [sysname] NOT NULL,
	[ACCESS_NAME] [varchar](50) NULL,
	[DontLink] [bit] NOT NULL,
	[TABLE_SCHEMA] [sysname] NOT NULL,
	[UpdateEmployee] [bit] NOT NULL,
	[DeleteEmployee] [bit] NOT NULL,
	[InsertEmployee] [bit] NOT NULL,
	[SelectClient] [bit] NOT NULL,
	[InsertClient] [bit] NOT NULL,
	[DeleteClient] [bit] NOT NULL,
	[UpdateClient] [bit] NOT NULL,
 CONSTRAINT [PK_tblTablePermissions] PRIMARY KEY CLUSTERED 
(
	[TableID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblTablePermissions_DontLink]  DEFAULT ((0)) FOR [DontLink]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblTablePermissions_TABLE_SCHEMA]  DEFAULT ('dbo') FOR [TABLE_SCHEMA]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_Select]  DEFAULT ((0)) FOR [UpdateEmployee]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_DeleteEmployee]  DEFAULT ((0)) FOR [DeleteEmployee]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_InsertEmployee]  DEFAULT ((0)) FOR [InsertEmployee]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_SelectClient]  DEFAULT ((0)) FOR [SelectClient]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_InsertClient]  DEFAULT ((0)) FOR [InsertClient]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_DeleteClient]  DEFAULT ((0)) FOR [DeleteClient]
GO

ALTER TABLE [dbo].[tblTablePermissions] ADD  CONSTRAINT [DF_tblAudit_UpdateClient]  DEFAULT ((0)) FOR [UpdateClient]
GO