CREATE TABLE [dbo].[Roles]
(
[roleID] [int] NOT NULL IDENTITY(1, 1),
[roleName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[showProbTree] [int] NULL CONSTRAINT [DF__Roles__showProbT__2A4B4B5E] DEFAULT ((1)),
[isAgent] [int] NULL CONSTRAINT [DF__Roles__isAgent__2B3F6F97] DEFAULT ((0)),
[defaultSecurityGroup] [int] NULL CONSTRAINT [DF__Roles__defaultSe__2C3393D0] DEFAULT ((0)),
[isAdmin] [int] NULL CONSTRAINT [DF__Roles__isAdmin__2D27B809] DEFAULT ((0)),
[joinSession] [int] NULL CONSTRAINT [DF__Roles__joinSessi__2E1BDC42] DEFAULT ((0)),
[allowSecLevelChange] [int] NULL CONSTRAINT [DF__Roles__allowSecL__2F10007B] DEFAULT ((1)),
[isActive] [int] NOT NULL CONSTRAINT [DF__Roles__isActive__300424B4] DEFAULT ((1)),
[onDeck] [int] NOT NULL CONSTRAINT [DF__Roles__onDeck__30F848ED] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Roles] ADD CONSTRAINT [pk_roles] PRIMARY KEY CLUSTERED ([roleID]) ON [PRIMARY]
GO
[dbo].[Roles]
