USE [moviescope]
GO
/****** Object:  Table [dbo].[Comments]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Comments](
	[commentId] [int] IDENTITY(1,1) NOT NULL,
	[userId] [int] NULL,
	[comment] [nvarchar](max) NULL,
	[time] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CustomerLogin]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CustomerLogin](
	[Username] [varchar](50) NOT NULL,
	[FirstName] [varchar](100) NULL,
	[LastName] [varchar](100) NULL,
	[Add1] [varchar](100) NULL,
	[Add2] [varchar](100) NULL,
	[City] [varchar](70) NULL,
	[State] [varchar](70) NULL,
	[Phoneno] [varchar](15) NULL,
	[email] [varchar](100) NOT NULL,
	[customerNumber] [int] NOT NULL,
	[password] [varchar](40) NOT NULL,
	[question_id] [smallint] NULL,
	[answer] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[email] 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].[Movie_Details]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Movie_Details](
	[srno] [int] IDENTITY(1,1) NOT NULL,
	[movie_title] [nvarchar](50) NULL,
	[movie_director] [nvarchar](50) NULL,
	[movie_stars] [nvarchar](max) NULL,
	[movie_budget] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Offices]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Offices](
	[officeCode] [varchar](10) NOT NULL,
	[city] [varchar](50) NOT NULL,
	[phone] [varchar](50) NOT NULL,
	[addressLine1] [varchar](50) NOT NULL,
	[addressLine2] [varchar](50) NULL,
	[state] [varchar](50) NULL,
	[country] [varchar](50) NOT NULL,
	[postalCode] [varchar](15) NOT NULL,
	[territory] [varchar](10) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[officeCode] 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].[OrderDetails]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderDetails](
	[orderNumber] [int] NOT NULL,
	[productCode] [varchar](15) NOT NULL,
	[productDesc] [varchar](100) NOT NULL,
	[quantityOrdered] [int] NOT NULL,
	[priceEach] [decimal](18, 2) NOT NULL,
	[orderLineNumber] [smallint] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[orderNumber] ASC,
	[productCode] 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].[OrderDetails1]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderDetails1](
	[orderId] [int] IDENTITY(1,1) NOT NULL,
	[orderNumber] [varchar](15) NOT NULL,
	[productCode] [varchar](15) NOT NULL,
	[productDesc] [varchar](100) NOT NULL,
	[quantityOrdered] [int] NOT NULL,
	[priceEach] [decimal](18, 2) NOT NULL,
	[orderLineNumber] [smallint] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Orders]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Orders](
	[orderNumber] [int] IDENTITY(1,1) NOT NULL,
	[orderDate] [datetime] NOT NULL,
	[requiredDate] [datetime] NOT NULL,
	[shippedDate] [datetime] NULL,
	[status] [varchar](15) NOT NULL,
	[comments] [text] NULL,
	[customerNumber] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[orderNumber] 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
/****** Object:  Table [dbo].[Orders1]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Orders1](
	[orderId] [int] IDENTITY(1,1) NOT NULL,
	[orderNumber] [varchar](20) NOT NULL,
	[orderDate] [datetime] NOT NULL,
	[requiredDate] [datetime] NOT NULL,
	[shippedDate] [datetime] NULL,
	[status] [varchar](15) NOT NULL,
	[comments] [text] NULL,
	[customerNumber] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[orderNumber] 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
/****** Object:  Table [dbo].[tblContact]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblContact](
	[Contact_id] [int] IDENTITY(1,1) NOT NULL,
	[Contact_name] [nvarchar](50) NULL,
	[Contact_msg] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[User_Login]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User_Login](
	[Uid] [int] IDENTITY(1,1) NOT NULL,
	[Uname] [nvarchar](50) NULL,
	[Upwd] [nvarchar](50) NULL,
	[isAdmin] [bit] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[User_Profile]    Script Date: 20-Dec-17 11:53:09 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User_Profile](
	[Uid] [int] NOT NULL,
	[username] [nvarchar](50) NULL,
	[firstname] [nvarchar](50) NULL,
	[lastname] [nvarchar](50) NULL,
	[email] [nvarchar](50) NULL,
	[gender] [nvarchar](50) NULL,
	[dateofbirth] [nvarchar](50) NOT NULL,
	[age] [int] NULL,
	[address] [nvarchar](max) NULL,
	[contactnumber] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Comments] ON 

INSERT [dbo].[Comments] ([commentId], [userId], [comment], [time]) VALUES (1, 1, N'Hello, Moviescope users', CAST(N'2014-09-06T14:26:38.670' AS DateTime))
INSERT [dbo].[Comments] ([commentId], [userId], [comment], [time]) VALUES (2, 2, N'Hi sam', CAST(N'2014-09-06T14:27:22.100' AS DateTime))
SET IDENTITY_INSERT [dbo].[Comments] OFF
INSERT [dbo].[CustomerLogin] ([Username], [FirstName], [LastName], [Add1], [Add2], [City], [State], [Phoneno], [email], [customerNumber], [password], [question_id], [answer]) VALUES (N'my user', N'AA', N'BB', N'a', N'b', N'c', N'd', N'34', N'aa@gg.com', 1, N'47bce5c74f589f4867dbd57e9ca9f808', 1, N'yellow')
INSERT [dbo].[CustomerLogin] ([Username], [FirstName], [LastName], [Add1], [Add2], [City], [State], [Phoneno], [email], [customerNumber], [password], [question_id], [answer]) VALUES (N'ss', N's', N'sa', N'a', N'ad', N'c', N's', N'454', N'adfr', 2, N'9f6e6800cfae7749eb6c486619254b9c', 1, N'orange')
INSERT [dbo].[CustomerLogin] ([Username], [FirstName], [LastName], [Add1], [Add2], [City], [State], [Phoneno], [email], [customerNumber], [password], [question_id], [answer]) VALUES (N'admin', N'Admin', N'Admin', N'a', N'a', N'', N'', N'', N'admin@gmail.com', 3, N'0a14de5a76e5e14758b04c209f266726', 1, N'white')
INSERT [dbo].[CustomerLogin] ([Username], [FirstName], [LastName], [Add1], [Add2], [City], [State], [Phoneno], [email], [customerNumber], [password], [question_id], [answer]) VALUES (N'guest', N'guest', N'guest', N'', N'', N'', N'', N'', N'guest@gmail.com', 4, N'084e0343a0486ff05530df6c705c8bb4', 1, N'yellow')
SET IDENTITY_INSERT [dbo].[Movie_Details] ON 

INSERT [dbo].[Movie_Details] ([srno], [movie_title], [movie_director], [movie_stars], [movie_budget]) VALUES (1, N'Tron Legacy', N'Joseph Kosinski', N'Jeff Bridges, Garrett Hedlund', N'$170 million')
INSERT [dbo].[Movie_Details] ([srno], [movie_title], [movie_director], [movie_stars], [movie_budget]) VALUES (2, N'The Vampire Diaries', N'Marcos Siega', N'Nina Dobrev', N'$100 million')
INSERT [dbo].[Movie_Details] ([srno], [movie_title], [movie_director], [movie_stars], [movie_budget]) VALUES (3, N'Tangled', N'Nathan Greno, Byron Howard', N'Mandy Moore', N'$260 million')
INSERT [dbo].[Movie_Details] ([srno], [movie_title], [movie_director], [movie_stars], [movie_budget]) VALUES (4, N'X Men', N'Bryan Singer', N'Patrick Stewart, Hugh Jackman', N'$75 million')
SET IDENTITY_INSERT [dbo].[Movie_Details] OFF
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'001', N'San Francisco', N'+1 650 219 4782', N'100 Market Street', N'Suite 300', N'CA', N'USA', N'94080', N'NA')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'2', N'Boston', N'+1 215 837 0825', N'1550 Court Place', N'Suite 102', N'MA', N'USA', N'2107', N'NA')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'3', N'NYC', N'+1 212 555 3000', N'523 East 53rd Street', N'apt. 5A', N'NY', N'USA', N'10022', N'NA')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'4', N'Paris', N'+33 14 723 4404', N'43 Rue Jouffroy D''abbans', N'NULL', N'NULL', N'France', N'75017', N'EMEA')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'5', N'Tokyo', N'+81 33 224 5000', N'4-1 Kioicho', N'NULL', N'Chiyoda-Ku', N'Japan', N'102-8578', N'Japan')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'6', N'Sydney', N'+61 2 9264 2451', N'5-11 Wentworth Avenue', N'Floor #2', N'NULL', N'Australia', N'NSW 2010', N'APAC')
INSERT [dbo].[Offices] ([officeCode], [city], [phone], [addressLine1], [addressLine2], [state], [country], [postalCode], [territory]) VALUES (N'7', N'London', N'+44 20 7877 2041', N'25 Old Broad Street', N'Level 7', N'NULL', N'UK', N'EC2N 1HN', N'EMEA')
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (1, N'ITEM 1', N'ITEM1 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (1, N'ITEM 2', N'ITEM2 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (2, N'ITEM 1', N'ITEM1 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (2, N'ITEM 2', N'ITEM2 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (4, N'P001', N' Product Desc', 80, CAST(67.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (4, N'P002', N' Product Desc1', 10, CAST(147.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (4, N'P003', N' Product Desc3', 10, CAST(147.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (5, N'ITEM 1', N'ITEM1 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails] ([orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (5, N'ITEM 2', N'ITEM2 Desc', 120, CAST(280.00 AS Decimal(18, 2)), 1)
SET IDENTITY_INSERT [dbo].[OrderDetails1] ON 

INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (1, N'ORD-001', N'P00-1', N'ITEM 1', 10, CAST(125.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (2, N'ORD-001', N'P00-1', N'ITEM 1', 10, CAST(125.00 AS Decimal(18, 2)), 1)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (3, N'ORD-002', N'P00-3', N'ITEM 3', 20, CAST(50.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (4, N'ORD-002', N'P00-2', N'ITEM 2', 60, CAST(150.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (5, N'ORD-003', N'P00-1', N'ITEM 3', 20, CAST(50.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (6, N'ORD-003', N'P00-3', N'ITEM 2', 60, CAST(150.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (7, N'ORD-004', N'P00-1', N'ITEM 3', 20, CAST(50.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (8, N'ORD-004', N'P00-3', N'ITEM 2', 60, CAST(150.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (9, N'ORD-005', N'P00-4', N'ITEM 4', 20, CAST(50.00 AS Decimal(18, 2)), 2)
INSERT [dbo].[OrderDetails1] ([orderId], [orderNumber], [productCode], [productDesc], [quantityOrdered], [priceEach], [orderLineNumber]) VALUES (10, N'ORD-005', N'P00-5', N'ITEM 5', 60, CAST(150.00 AS Decimal(18, 2)), 2)
SET IDENTITY_INSERT [dbo].[OrderDetails1] OFF
SET IDENTITY_INSERT [dbo].[Orders] ON 

INSERT [dbo].[Orders] ([orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (1, CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-15T00:00:00.000' AS DateTime), CAST(N'2017-11-10T00:00:00.000' AS DateTime), N'Shipped', N'Handle with care.', 1)
INSERT [dbo].[Orders] ([orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (2, CAST(N'2017-11-02T00:00:00.000' AS DateTime), CAST(N'2017-11-16T00:00:00.000' AS DateTime), CAST(N'2017-11-12T00:00:00.000' AS DateTime), N'Shipped', N'Handle with care.', 1)
INSERT [dbo].[Orders] ([orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (3, CAST(N'2017-11-03T00:00:00.000' AS DateTime), CAST(N'2017-12-31T00:00:00.000' AS DateTime), NULL, N'In Process', N'Handle with care.', 1)
INSERT [dbo].[Orders] ([orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (4, CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-05T00:00:00.000' AS DateTime), NULL, N'In Process', N'Handle with Care', 4)
INSERT [dbo].[Orders] ([orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (5, CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-05T00:00:00.000' AS DateTime), NULL, N'In Process', N'Handle with Care', 4)
SET IDENTITY_INSERT [dbo].[Orders] OFF
SET IDENTITY_INSERT [dbo].[Orders1] ON 

INSERT [dbo].[Orders1] ([orderId], [orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (1, N'ORD-001', CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), N'Processing', N'Handle with Care', 1)
INSERT [dbo].[Orders1] ([orderId], [orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (2, N'ORD-002', CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), N'Processing', N'Handle with Care', 1)
INSERT [dbo].[Orders1] ([orderId], [orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (3, N'ORD-003', CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), N'Processing', N'Handle with Care', 4)
INSERT [dbo].[Orders1] ([orderId], [orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (4, N'ORD-004', CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), N'Processing', N'Handle with Care', 4)
INSERT [dbo].[Orders1] ([orderId], [orderNumber], [orderDate], [requiredDate], [shippedDate], [status], [comments], [customerNumber]) VALUES (5, N'ORD-005', CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), N'Processing', N'Handle with Care', 4)
SET IDENTITY_INSERT [dbo].[Orders1] OFF
SET IDENTITY_INSERT [dbo].[tblContact] ON 

INSERT [dbo].[tblContact] ([Contact_id], [Contact_name], [Contact_msg]) VALUES (1, N'nag', N'<script>alert("This website has been hacked")</script>')
SET IDENTITY_INSERT [dbo].[tblContact] OFF
SET IDENTITY_INSERT [dbo].[User_Login] ON 

INSERT [dbo].[User_Login] ([Uid], [Uname], [Upwd], [isAdmin]) VALUES (1, N'sam', N'test', 1)
INSERT [dbo].[User_Login] ([Uid], [Uname], [Upwd], [isAdmin]) VALUES (6, N'steve', N'test', 1)
SET IDENTITY_INSERT [dbo].[User_Login] OFF
INSERT [dbo].[User_Profile] ([Uid], [username], [firstname], [lastname], [email], [gender], [dateofbirth], [age], [address], [contactnumber]) VALUES (1, N'sam', N'sam', N'houston', N'sam@moviescope.com', N'male', N'10-10-1975', 38, N'Washington DC', N'1-202-501-4455')
INSERT [dbo].[User_Profile] ([Uid], [username], [firstname], [lastname], [email], [gender], [dateofbirth], [age], [address], [contactnumber]) VALUES (2, N'john', N'john', N'smith', N'john@moviescope.com', N'male', N'15-12-1968', 45, N'New York ', N'1-202-505-1235')
INSERT [dbo].[User_Profile] ([Uid], [username], [firstname], [lastname], [email], [gender], [dateofbirth], [age], [address], [contactnumber]) VALUES (3, N'kety', N'kety', N'perry', N'kety@moviescope.com', N'female', N'06-01-1980', 33, N'Mexico city', N'1-202-502-2431')
INSERT [dbo].[User_Profile] ([Uid], [username], [firstname], [lastname], [email], [gender], [dateofbirth], [age], [address], [contactnumber]) VALUES (4, N'steve', N'steve', N'jobs', N'steve@moviescope.com', N'male', N'20-05-1983', 30, N'DownTown', N'1-202-509-8421')
INSERT [dbo].[User_Profile] ([Uid], [username], [firstname], [lastname], [email], [gender], [dateofbirth], [age], [address], [contactnumber]) VALUES (5, N'lee', N'lee', N'bret', N'lee@moviescope.com', N'male', N'09-08-1988', 25, N'Albuquarque', N'1-202-506-3691')
