GO
/****** Object:  Table [dbo].[Customer]    Script Date: 10/6/2019 5:54:21 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Customer](
	[CustomerID] [int] NOT NULL,
	[FirstName] [char](50) NOT NULL,
	[LastName] [char](50) NOT NULL,
	[HomePhone] [char](20) NULL,
	[Address] [char](50) NULL,
	[State] [char](2) NULL,
	[City] [char](30) NULL,
	[PostalCode] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[CustomerID] 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
/****** Object:  Table [dbo].[Customer2]    Script Date: 10/6/2019 5:54:21 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Customer2](
	[CustomerID] [int] NOT NULL,
	[FirstName] [char](50) NOT NULL,
	[LastName] [char](50) NOT NULL,
	[HomePhone] [char](20) NULL,
	[Address] [char](50) NULL,
	[State] [char](2) NULL,
	[City] [char](30) NULL,
	[PostalCode] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[CustomerID] 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
/****** Object:  Table [dbo].[Orders]    Script Date: 10/6/2019 5:54:21 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Orders](
	[OrderID] [int] NOT NULL,
	[CustomerID] [int] NOT NULL,
	[PlanID] [char](10) NOT NULL,
	[OrderDate] [datetime] NOT NULL,
	[CancelationDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[OrderID] 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
/****** Object:  Table [dbo].[ServicePlans]    Script Date: 10/6/2019 5:54:21 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[ServicePlans](
	[PlanID] [char](10) NOT NULL,
	[PlanName] [char](50) NOT NULL,
	[PlanDescription] [char](50) NOT NULL,
	[PlanPrice] [money] NOT NULL,
	[DiscountedPrice] [money] NULL,
PRIMARY KEY CLUSTERED 
(
	[PlanID] 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
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (1, N'John                                              ', N'Dentins                                           ', N'(808) 897-4321      ', N' 2211 22nd Ave N                                  ', N'GA', N'Atlanta                       ', 98718)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (2, N'Sam                                               ', N'Elliot                                            ', N'(719) 898-2134      ', N'1601 Center loop                                  ', N'FL', N'Tampa                         ', 98982)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (3, N'Adam                                              ', N'Williams                                          ', N'(898) 321-2234      ', N'3890-A Cherry loop                                ', N'ND', N'Fargo                         ', 58729)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (4, N'Jacob                                             ', N'Lincoln                                           ', NULL, N'2609 40th Ave S                                   ', N'OK', N'Tulsa                         ', 36711)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (5, N'Timothy                                           ', N'Coney                                             ', N'(202) 827-4331      ', N'1900 3rd St. N                                    ', N'OR', N'Salem                         ', 44812)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (6, N'Jill                                              ', N'Stephens                                          ', N'(813) 215-5551      ', N'1544 33rd Ave E                                   ', N'FL', N'Miami                         ', 98911)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (7, N'Tina                                              ', N'West                                              ', N'(813) 565-4984      ', N'1000 45th Ave N                                   ', N'FL', N'Miami                         ', 98911)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (8, N'Shawn                                             ', N'Leaven                                            ', N'(813) 248-8854      ', N'1908 22nd Ave S                                   ', N'FL', N'Miami                         ', 98912)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (9, N'Jackie                                            ', N'Justin                                            ', NULL, N'1800 4rd St. N                                    ', N'FL', N'Miami                         ', 98902)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (10, N'Lilly                                             ', N'Ward                                              ', N'(813) 244-5522      ', N'1010 33rd Ave N                                   ', N'FL', N'Miami                         ', 98909)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (12, N'Larry                                             ', N'Carr                                              ', N'(808) 423-7894      ', N'114 - C 45th Ave N                                ', N'HI', N'Honolulu                      ', 96818)
GO
INSERT [dbo].[Customer] ([CustomerID], [FirstName], [LastName], [HomePhone], [Address], [State], [City], [PostalCode]) VALUES (13, N'Lisa                                              ', N'Glenn                                             ', N'(808) 421-7515      ', N'1542 33rd Ave N                                   ', N'HI', N'Honolulu                      ', 96818)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (1, 1, N'D1002     ', CAST(N'1999-11-11 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (2, 10, N'D1002     ', CAST(N'1998-03-15 00:00:00.000' AS DateTime), CAST(N'2001-03-30 00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (3, 10, N'D1003     ', CAST(N'1998-03-15 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (4, 10, N'D2202     ', CAST(N'2001-01-01 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (5, 2, N'W1001     ', CAST(N'2001-03-15 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (6, 2, N'L2003     ', CAST(N'2001-03-15 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (7, 2, N'I1001     ', CAST(N'2001-03-20 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (8, 3, N'L2002     ', CAST(N'2000-07-10 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (9, 3, N'L2001     ', CAST(N'2000-07-10 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (10, 4, N'L2004     ', CAST(N'2001-02-15 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (11, 7, N'L2004     ', CAST(N'2001-05-14 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (12, 6, N'D1002     ', CAST(N'2000-11-04 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (13, 6, N'D1101     ', CAST(N'2000-11-04 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (14, 5, N'I1001     ', CAST(N'1999-06-06 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (15, 8, N'I1001     ', CAST(N'1999-03-14 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (16, 6, N'I1001     ', CAST(N'2000-11-04 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (17, 7, N'L2001     ', CAST(N'2001-05-13 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (18, 4, N'L2001     ', CAST(N'2001-02-15 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (19, 8, N'L2001     ', CAST(N'1999-03-17 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (20, 8, N'L2002     ', CAST(N'1999-03-17 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[Orders] ([OrderID], [CustomerID], [PlanID], [OrderDate], [CancelationDate]) VALUES (21, 9, N'L2003     ', CAST(N'2000-06-11 00:00:00.000' AS DateTime), NULL)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'D1002     ', N'Digital Cable                                     ', N'Digital cable plan                                ', 40.0000, 35.0000)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'D1003     ', N'Digital Phone                                     ', N'Cell phone                                        ', 40.0000, 35.0000)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'D1101     ', N'Data IP Services A                                ', N'Plan A Data/IP services                           ', 100.0000, 85.0000)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'D2202     ', N'Data IP Services B                                ', N'Plan B Data/IP services                           ', 150.0000, 125.0000)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'E1001     ', N'Email                                             ', N'Premium e-mail                                    ', 9.9900, 6.9900)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'I1001     ', N'Internet                                          ', N'Internet/email                                    ', 19.9900, 16.9900)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'L2001     ', N'Local Phone                                       ', N'In state calling                                  ', 39.0000, 29.9900)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'L2002     ', N'Long Distance A                                   ', N'Plan A Out of state per/min                       ', 0.1200, 0.1100)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'L2003     ', N'Long Distance B                                   ', N'Plan B Out of state per/min                       ', 0.0900, 0.0800)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'L2004     ', N'Long Distance C                                   ', N'Plan C Out of state per/min                       ', 0.1000, 0.0900)
GO
INSERT [dbo].[ServicePlans] ([PlanID], [PlanName], [PlanDescription], [PlanPrice], [DiscountedPrice]) VALUES (N'W1001     ', N'Web Hosting                                       ', N'hosting, site creation                            ', 19.9900, 16.9900)
GO