/*    ==Scripting Parameters==

    Source Server Version : SQL Server 2017 (14.0.1000)
    Source Database Engine Edition : Microsoft SQL Server Express Edition
    Source Database Engine Type : Standalone SQL Server

    Target Server Version : SQL Server 2017
    Target Database Engine Edition : Microsoft SQL Server Standard Edition
    Target Database Engine Type : Standalone SQL Server
*/
USE [UserDB]
GO
/****** Object:  Table [dbo].[cart]    Script Date: 06-09-2018 10:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cart](
	[userID] [int] NOT NULL,
	[ProductId] [int] NULL,
 CONSTRAINT [PK_cart] PRIMARY KEY CLUSTERED
(
	[userID] 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
/****** Object:  Table [dbo].[ForgotPassword]    Script Date: 06-09-2018 10:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ForgotPassword](
	[UserId] [int] NOT NULL,
	[ActivationCode] [varchar](100) NOT NULL,
PRIMARY KEY CLUSTERED
(
	[UserId] 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
/****** Object:  Table [dbo].[LoginCredentials]    Script Date: 06-09-2018 10:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginCredentials](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Username] [nvarchar](100) NULL,
	[Password] [nvarchar](100) NULL,
	[email] [nvarchar](100) NULL,
	[logindate] [datetime] NULL,
	[EmailActivated] [bit] NULL,
PRIMARY KEY CLUSTERED
(
	[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
/****** Object:  Table [dbo].[UserActivation]    Script Date: 06-09-2018 10:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserActivation](
	[UserId] [int] NOT NULL,
	[ActivationCode] [varchar](100) NOT NULL,
PRIMARY KEY CLUSTERED
(
	[UserId] 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
/****** Object:  Table [dbo].[UserInfo]    Script Date: 06-09-2018 10:07:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserInfo](
	[Id] [int] NOT NULL,
	[phone] [bigint] NULL,
	[FirstName] [nvarchar](50) NULL,
	[LastName] [nvarchar](50) NULL,
	[Photo] [varbinary](max) NULL,
	[Address1] [nvarchar](50) NULL,
	[Address2] [nvarchar](50) NULL,
	[City] [nvarchar](50) NULL,
	[State] [nvarchar](50) NULL,
	[Zip] [nvarchar](50) NULL,
	[Country] [nvarchar](50) NULL,
 CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED
(
	[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] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[ForgotPassword] ([UserId], [ActivationCode]) VALUES (1, N'69de1860-6dd0-45b6-9743-168a29857b42')
SET IDENTITY_INSERT [dbo].[LoginCredentials] ON

INSERT [dbo].[LoginCredentials] ([Id], [Username], [Password], [email], [logindate], [EmailActivated]) VALUES (1, N'sai', N'sai', N'saiteja310@gmail.com', CAST(N'2018-08-24T17:54:13.980' AS DateTime), 1)
INSERT [dbo].[LoginCredentials] ([Id], [Username], [Password], [email], [logindate], [EmailActivated]) VALUES (2, N'teja', N'teja', N'saiteja137@gmail.com', CAST(N'2018-08-18T15:00:18.070' AS DateTime), 0)
INSERT [dbo].[LoginCredentials] ([Id], [Username], [Password], [email], [logindate], [EmailActivated]) VALUES (5, N'saiteja310', N'Saibaba@2543', N'literallyforcoc@gmail.com', CAST(N'2018-08-22T18:25:13.517' AS DateTime), 1)
INSERT [dbo].[LoginCredentials] ([Id], [Username], [Password], [email], [logindate], [EmailActivated]) VALUES (6, N'sravya', N'Password@1234', N'a3NyYXZ5YW1hbGlrYUBnbWFpbC5jb20=', CAST(N'2018-08-24T17:40:41.990' AS DateTime), 0)
INSERT [dbo].[LoginCredentials] ([Id], [Username], [Password], [email], [logindate], [EmailActivated]) VALUES (7, N'shiva
', N'Ss3#shviasai
', N'saishiva99@gmail.com', CAST(N'2018-09-04T17:06:18.397' AS DateTime), 0)
SET IDENTITY_INSERT [dbo].[LoginCredentials] OFF
INSERT [dbo].[UserActivation] ([UserId], [ActivationCode]) VALUES (7, N'06f4cb00-da6d-4bc7-a363-6d299547e781')
ALTER TABLE [dbo].[cart]  WITH CHECK ADD FOREIGN KEY([userID])
REFERENCES [dbo].[LoginCredentials] ([Id])
GO
ALTER TABLE [dbo].[ForgotPassword]  WITH CHECK ADD FOREIGN KEY([UserId])
REFERENCES [dbo].[LoginCredentials] ([Id])
GO
ALTER TABLE [dbo].[UserActivation]  WITH CHECK ADD FOREIGN KEY([UserId])
REFERENCES [dbo].[LoginCredentials] ([Id])
GO
ALTER TABLE [dbo].[UserInfo]  WITH CHECK ADD FOREIGN KEY([Id])
REFERENCES [dbo].[LoginCredentials] ([Id])
GO