USE [grant]
GO

/****** Object:  Table [dbo].[Conference]    Script Date: 03/04/2014 09:11:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Conference](

	[DateRegistered] [datetime] NOT NULL,
	[ConfYear] [int] NULL,
	[ConfMonth] [int] NULL,
	[ConfName] [varchar](300) NULL,
	
	[UserFirstName] [varchar](50) NULL,
	[UserLastName] [varchar](50) NULL,
	[UserName] [varchar](50) NULL,	
	
	[UserEmail_1] [varchar](50) NULL,
	[UserEmail_2] [varchar](50) NULL,
	[UserEmail] [varchar](50) NULL,
	
	[UserPhone_1] [varchar](50) NULL,
	[UserPhone_2] [varchar](50) NULL,
	[UserPhone] [varchar](50) NULL,
	
	[UserOrganization] [varchar](150) NULL,
	[UserTitle] [varchar](100) NULL,

	[UserAddress_1] [varchar](100) NULL,
	[UserAddress_2] [varchar](100) NULL,
	[UserAddress_3] [varchar](100) NULL,
	[UserAddress] [varchar](200) NULL,
	
	[PaymentCat] [varchar](100) NULL,
	[PaymentAmount] [numeric](18, 0) NULL,
	[Payment] [varchar](100) NULL,
	
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Conference] ADD  CONSTRAINT [DF_Conference_DateRegistered]  DEFAULT (getdate()) FOR [DateRegistered]
GO




USE [grant]
GO

/****** Object:  Table [dbo].[PaperForReview]    Script Date: 03/04/2014 11:55:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaperForReview](

	[ConfYear] [int] NULL,
	[ConfMonth] [int] NULL,
	[ConfName] [varchar](300) NULL,
	
	[DateofSubmission] [datetime] NULL,
	[ListofAuthors] [varchar](200) NOT NULL,
	[ListofOrganization] [varchar](100) NULL,
	[PaperTitle] [varchar](300) NOT NULL,	
	[PaperLink][varchar](300) NULL,	
	[PaperGroupNo] [int] null,
	[PaperGroup][varchar](200) NULL,	
	[PaperSession][varchar](200) NULL,	
		
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PaperForReview] ADD  CONSTRAINT [DF_PaperForReview_DateofSubmission]  DEFAULT (getdate()) FOR [DateofSubmission]
GO



USE [grant]
GO

/****** Object:  Table [dbo].[Presentation]    Script Date: 03/28/2014 12:52:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Presentation](
	[ConfYear] [int] NULL,
	[ConfMonth] [int] NULL,
	[ConfName] [varchar](300) NULL,
	[DateofSubmission] [datetime] NULL,
	[ListofAuthors] [varchar](200) NOT NULL,
	[ListofOrganization] [varchar](150) NULL,
	[PaperTitle] [varchar](300) NOT NULL,
	[PaperLink] [varchar](300) NULL,
	[PaperGroupNo] [int] NULL,
	[PaperGroupName] [varchar](200) NULL,
	[PaperSession] [varchar](200) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Presentation] ADD  CONSTRAINT [DF_Presentation_DateofSubmission]  DEFAULT (getdate()) FOR [DateofSubmission]
GO