forked from gyaneshwar/MCDA5510_Assignments
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSQLScript.sql
More file actions
70 lines (68 loc) · 11.3 KB
/
Copy pathSQLScript.sql
File metadata and controls
70 lines (68 loc) · 11.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
USE [InClass]
GO
/****** Object: Table [dbo].[Customer] Script Date: 2017-11-01 12:31:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
[ID] [int] IDENTITY(1,1) NOT NULL,
[firstName] [varchar](max) NULL,
[lastName] [varchar](max) NULL,
[addrses1] [varchar](max) NULL,
[city] [varchar](max) NULL,
[province] [varchar](max) NULL,
[country] [varchar](max) NULL,
[postal] [varchar](max) NULL,
[phone] [varchar](max) NULL,
[email] [varchar](max) NULL,
CONSTRAINT [PK_Customer] 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
/****** Object: Table [dbo].[Shipment] Script Date: 2017-11-01 12:31:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Shipment](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Courier] [varchar](50) NULL,
[TrackingNumber] [varchar](50) NULL,
[CustomerID] [int] NULL,
[Status] [varchar](50) NULL,
[ServiceType] [varchar](50) NULL,
[EstShippedDate] [date] NULL,
[DateOrderPlaced] [date] NULL,
CONSTRAINT [PK_PaymentInfo] 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
SET IDENTITY_INSERT [dbo].[Customer] ON
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92724, N' Preeti', N'Padelkar', N'21 Main St', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92725, N'Fatima', N'Parveen', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B4J3G5', N'9023342233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92726, N'Meenal', N'Shah', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92727, N'Funto', N'Akinyemi', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92728, N'Janti', N'Aye', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L 3G5', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92729, N'Sahil', N'Behl', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L 3G4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92730, N'Carlo', N'Carandang', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L 3G4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92731, N'Navjot', N'Kaur', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L 3G4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (92732, N'Zhengyang', N'Ma', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L 3G7', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (93732, N'Prashob', N'Nair', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (93733, N'Nikita', N'Neveditsin', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (93734, N'Nitin ', N'-', N'32 Robie St.', N'Halifax', N'NS', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (93735, N'Maroof', N'Pasha', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
INSERT [dbo].[Customer] ([ID], [firstName], [lastName], [addrses1], [city], [province], [country], [postal], [phone], [email]) VALUES (93736, N'Alya', N'Salman', N'32 Robie St.', N'Halifax', N'Nova Scotia', N'Canada', N'B3L4F4', N'9023322233', N'[email protected]')
SET IDENTITY_INSERT [dbo].[Customer] OFF
SET IDENTITY_INSERT [dbo].[Shipment] ON
INSERT [dbo].[Shipment] ([ID], [Courier], [TrackingNumber], [CustomerID], [Status], [ServiceType], [EstShippedDate], [DateOrderPlaced]) VALUES (2, N'Fedex', N'12221E223232', 93733, N'Not Shipped', N'SameDay', CAST(N'2017-10-09' AS Date), CAST(N'2017-10-10' AS Date))
SET IDENTITY_INSERT [dbo].[Shipment] OFF
ALTER TABLE [dbo].[Shipment] WITH CHECK ADD CONSTRAINT [FK_PaymentInfo_Customer] FOREIGN KEY([CustomerID])
REFERENCES [dbo].[Customer] ([ID])
GO
ALTER TABLE [dbo].[Shipment] CHECK CONSTRAINT [FK_PaymentInfo_Customer]
GO