rqyV3hK5

1-- MegaPizza DATABASE SCRIPT
2
3-- Deletes Old DataBase
4DROP TABLE IF EXISTS PreviouslyOrdered;
5DROP TABLE IF EXISTS CustomerOrder;
6DROP TABLE IF EXISTS Customer;
7
8
9DROP DATABASE MegaPizza;
10
11-- Creates DataBase
12CREATE DATABASE MegaPizza;
13
14-- Customer TABLE
15CREATE TABLE Customer(
16	[CustomerID]		int NOT NULL PRIMARY KEY,												 	-- Customer ID
17	[FName]				VARCHAR(255),																-- Customer First Name
18	[LName]				VARCHAR(255),																-- Customer Last Name
19	[Address]			VARCHAR(255),																-- Customer Address
20	[Phone]				int,																		-- Customer Phone Number
21	[Status]			VARCHAR(255)																-- Customer Status (Hoax or not)
22);
23
24-- Order Table
25CREATE TABLE CustomerOrder(
26	[OrderID]				int NOT NULL PRIMARY KEY,												-- Order ID
27	[Date]					VARCHAR(255),
28	[Time]					VARCHAR(255),
29	[Type]					VARCHAR(255),
30	[Description]			VARCHAR(255),
31	[TotalAmountDue]		VARCHAR(255),
32	[PaymentMethod]			VARCHAR(255),
33	[OrderStatus]			VARCHAR(255)/*
34	[MenuItemsOrderedID]	int,
35	[EmployeeID]			int,
36		[CustomerID]			int FOREIGN KEY REFERENCES Customer(CustomerID)							-- Order ID Foreign Key	
37	ON UPDATE CASCADE 
38	ON DELETE CASCADE*/							
39);
40
41-- PreviouslyOrdered Table (Used for customer's previously ordered Orders)
42CREATE TABLE PreviouslyOrdered(
43	[ID]						int NOT NULL PRIMARY KEY,											-- PreviouslyOrdered ID
44	[OrderID]					int FOREIGN KEY REFERENCES CustomerOrder([OrderID]),				-- Order ID Foreign Key	
45	[CustomerID]				int FOREIGN KEY REFERENCES Customer([CustomerID])				-- Customer ID Foreign Key	
46);
47
48--Adding Values into Tables
49INSERT INTO Customer (CustomerID,FName,LName, Address, Phone, Status)
50VALUES ('1','Ethan','Moriarty','29 asdatms st','0466166194','Hoax');
51
52SELECT * FROM Customer;