USE [TestDB]
GO
/****** Object: Table [dbo].[USR_USER_GROUP] Script Date: 11/11/2008 15:53:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USR_USER_GROUP](
[USER_GROUP_ID] [int] IDENTITY(1,1) NOT NULL,
[USER_GROUP] [varchar](100) NULL,
CONSTRAINT [PK_USR_USER_GROUP] PRIMARY KEY CLUSTERED
(
[USER_GROUP_ID] 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
SET IDENTITY_INSERT [dbo].[USR_USER_GROUP] ON
INSERT [dbo].[USR_USER_GROUP] ([USER_GROUP_ID], [USER_GROUP]) VALUES (1, N'Super')
INSERT [dbo].[USR_USER_GROUP] ([USER_GROUP_ID], [USER_GROUP]) VALUES (2, N'Normal')
SET IDENTITY_INSERT [dbo].[USR_USER_GROUP] OFF
/****** Object: Table [dbo].[USR_USER] Script Date: 11/11/2008 15:53:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USR_USER](
[USER_ID] [int] IDENTITY(1,1) NOT NULL,
[USER_NAME] [varchar](50) NULL,
[EMAIL] [varchar](100) NULL,
[ENTRY_DATE] [datetime] NULL,
[ACTIVE] [bit] NULL,
CONSTRAINT [PK_TBL_USER] PRIMARY KEY CLUSTERED
(
[USER_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[USR_USER] ON
INSERT [dbo].[USR_USER] ([USER_ID], [USER_NAME], [EMAIL], [ENTRY_DATE], [ACTIVE]) VALUES (2, N'Nigel2', N'EMAIL', CAST(0x00009B3E00A58716 AS DateTime), 1)
INSERT [dbo].[USR_USER] ([USER_ID], [USER_NAME], [EMAIL], [ENTRY_DATE], [ACTIVE]) VALUES (3, N'Malcolm', N'EMAIL', CAST(0x00009B3E00A58716 AS DateTime), 0)
1)
SET IDENTITY_INSERT [dbo].[USR_USER] OFF
/****** Object: Table [dbo].[USR_USER_TO_USER_GROUP] Script Date: 11/11/2008 15:53:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[USR_USER_TO_USER_GROUP](
[USER_TO_USER_GROUP_ID] [int] IDENTITY(1,1) NOT NULL,
[USER_ID] [int] NULL,
[USER_GROUP_ID] [int] NULL,
CONSTRAINT [PK_USR_USER_TO_USER_GROUP] PRIMARY KEY CLUSTERED
(
[USER_TO_USER_GROUP_ID] 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 IDENTITY_INSERT [dbo].[USR_USER_TO_USER_GROUP] ON
INSERT [dbo].[USR_USER_TO_USER_GROUP] ([USER_TO_USER_GROUP_ID], [USER_ID], [USER_GROUP_ID]) VALUES (1, 2, 1)
INSERT [dbo].[USR_USER_TO_USER_GROUP] ([USER_TO_USER_GROUP_ID], [USER_ID], [USER_GROUP_ID]) VALUES (2, 3, 2)
SET IDENTITY_INSERT [dbo].[USR_USER_TO_USER_GROUP] OFF
/****** Object: ForeignKey [FK_USR_USER_TO_USER_GROUP_USR_USER] Script Date: 11/11/2008 15:53:45 ******/
ALTER TABLE [dbo].[USR_USER_TO_USER_GROUP] WITH CHECK ADD CONSTRAINT [FK_USR_USER_TO_USER_GROUP_USR_USER] FOREIGN KEY([USER_ID])
REFERENCES [dbo].[USR_USER] ([USER_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[USR_USER_TO_USER_GROUP] CHECK CONSTRAINT [FK_USR_USER_TO_USER_GROUP_USR_USER]
GO
/****** Object: ForeignKey [FK_USR_USER_TO_USER_GROUP_USR_USER_GROUP] Script Date: 11/11/2008 15:53:45 ******/
ALTER TABLE [dbo].[USR_USER_TO_USER_GROUP] WITH CHECK ADD CONSTRAINT [FK_USR_USER_TO_USER_GROUP_USR_USER_GROUP] FOREIGN KEY([USER_GROUP_ID])
REFERENCES [dbo].[USR_USER_GROUP] ([USER_GROUP_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[USR_USER_TO_USER_GROUP] CHECK CONSTRAINT [FK_USR_USER_TO_USER_GROUP_USR_USER_GROUP]
GO