CREATE TABLE [dbo].[GLAcctProtections]
(
[AcctProtectionID] [int] NOT NULL IDENTITY(1, 1),
[AcctProtection] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AcctProtectionTypeID] [int] NULL,
[NonProtectedAcctsExpected] [bit] NOT NULL CONSTRAINT [DF_GLAcctProtections_NonProtectedAcctsExpected] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtections] ADD CONSTRAINT [PK_GLAcctProtections] PRIMARY KEY CLUSTERED ([AcctProtectionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAcctProtections] ADD CONSTRAINT [FK_GLAcctProtections_AcctProtectionTypeID_GLAcctProtectionTypes] FOREIGN KEY ([AcctProtectionTypeID]) REFERENCES [dbo].[GLAcctProtectionTypes] ([AcctProtectionTypeID])
GO