User talk:Pramodgahtori86

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_ANSWER_MASTER]    Script Date: 04/15/2011 18:29:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_ANSWER_MASTER](	[QUESTION_ID] [bigint] NOT NULL,	[ANSWER_ID] [bigint] NOT NULL,	[ANSWER_TEXT] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[USER_ID] [bigint] NOT NULL,	[COMMENT_DATE] [datetime] NOT NULL,	[STATUS] [bit] NULL, CONSTRAINT [PK_FORUM_ANSWER_MASTER] PRIMARY KEY CLUSTERED ( [ANSWER_ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]

GO USE [TRAI_FORUM] GO ALTER TABLE [dbo].[FORUM_ANSWER_MASTER] WITH CHECK ADD  CONSTRAINT [FK_FORUM_ANSWER_MASTER] FOREIGN KEY([QUESTION_ID]) REFERENCES [dbo].[FORUM_QUESTION_MASTER] ([QUESTION_ID]) GO ALTER TABLE [dbo].[FORUM_ANSWER_MASTER] WITH CHECK ADD  CONSTRAINT [FK_FORUM_ANSWER_MASTER1] FOREIGN KEY([USER_ID]) REFERENCES [dbo].[FORUM_USER_MASTER] ([USER_ID])

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_FORUMTBL]    Script Date: 04/15/2011 18:31:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_FORUMTBL](	[FORUM_ID] [bigint] NOT NULL,	[FORUM_TITLE] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[Group_ID] [bigint] NOT NULL,	[DESCRIPTION] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,	[STATUS] [bit] NOT NULL, CONSTRAINT [PK_FORUM_FORUMTBL] PRIMARY KEY CLUSTERED ( [FORUM_ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]

GO USE [TRAI_FORUM] GO ALTER TABLE [dbo].[FORUM_FORUMTBL] WITH CHECK ADD  CONSTRAINT [FK_FORUM_FORUMTBL] FOREIGN KEY([Group_ID]) REFERENCES [dbo].[FORUM_GROUP] ([Group_ID])

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_GROUP]    Script Date: 04/15/2011 18:31:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_GROUP](	[Group_ID] [bigint] NOT NULL,	[Group_Name] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[Status] [bit] NOT NULL, CONSTRAINT [PK_FORUM_GROUP] PRIMARY KEY CLUSTERED ( [Group_ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_QUESTION_MASTER]    Script Date: 04/15/2011 18:31:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_QUESTION_MASTER](	[QUESTION_ID] [bigint] NOT NULL,	[QUESTION_TITLE] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[FORUM_ID] [bigint] NOT NULL,	[BODY] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,	[USER_ID] [bigint] NOT NULL,	[CREATED_DATE] [datetime] NOT NULL,	[STATUS] [bit] NOT NULL, CONSTRAINT [PK_FORUM_QUESTION_MASTER] PRIMARY KEY CLUSTERED ( [QUESTION_ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]

GO USE [TRAI_FORUM] GO ALTER TABLE [dbo].[FORUM_QUESTION_MASTER] WITH CHECK ADD  CONSTRAINT [FK_FORUM_QUESTION_MASTER] FOREIGN KEY([FORUM_ID]) REFERENCES [dbo].[FORUM_FORUMTBL] ([FORUM_ID])

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_QUESTION_VIEW_COUNT]    Script Date: 04/15/2011 18:31:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_QUESTION_VIEW_COUNT](	[FORUM_ID] [bigint] NOT NULL,	[QUESTION_ID] [bigint] NOT NULL ) ON [PRIMARY]

GO USE [TRAI_FORUM] GO ALTER TABLE [dbo].[FORUM_QUESTION_VIEW_COUNT] WITH CHECK ADD  CONSTRAINT [FK_FORUM_QUESTION_VIEW_COUNT] FOREIGN KEY([QUESTION_ID]) REFERENCES [dbo].[FORUM_QUESTION_MASTER] ([QUESTION_ID]) GO ALTER TABLE [dbo].[FORUM_QUESTION_VIEW_COUNT] WITH CHECK ADD  CONSTRAINT [FK_FORUM_QUESTION_VIEW_COUNT1] FOREIGN KEY([FORUM_ID]) REFERENCES [dbo].[FORUM_FORUMTBL] ([FORUM_ID])

USE [TRAI_FORUM] GO /****** Object: Table [dbo].[FORUM_USER_MASTER]    Script Date: 04/15/2011 18:32:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FORUM_USER_MASTER](	[USER_ID] [bigint] NOT NULL,	[USER_NAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,	[FIRST_NAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,	[LAST_NAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,	[EMAIL] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[PASSWORD] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[REGISTRATION_DATE] [datetime] NOT NULL,	[ACTIVATIONCODE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,	[STATUS] [bit] NOT NULL, CONSTRAINT [PK_FORUM_USER_MASTER] PRIMARY KEY CLUSTERED ( [USER_ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]