WGU C170 IMPORTANT SQL CODES

WGU C170 IMPORTANT SQL CODES CREATE TABLE Customer ( Customer_ID INT NOT NULL AUTO_INCREMENT, First_Name VARCHAR(25) NOT NULL, Last_Name VARCHAR(25) NOT NULL, Street_Address VARCHAR(25) NOT NULL, Apt VARCHAR(12), City VARCHAR(25) NOT NULL, State VARCHAR(2) NOT NULL, Zip_Code VARCHAR(5) NOT NULL, Home_Phone VARCHAR(12), Mobile_Phone VARCHAR(12), Other_Phone VARCHAR(12), PRIMARY KEY(Customer_ID) ); CREATE TABLE Donut ( Donut_ID INT UNSIGNED NOT NULL UNIQUE, Donut_Name VARCHAR(255), Donut_Description VARCHAR(255), Unit_Price DECIMAL(5,2), PRIMARY KEY (Donut_ID) ); CREATE TABLE Orders ( Order_ID INT UNSIGNED NOT NULL, Customer_ID INT NOT NULL, Order_Date DATETIME NOT NULL, Special_Notes VARCHAR(255), PRIMARY KEY (Order_ID) ); ALTER TABLE Orders ADD INDEX checks (Customer_ID), ADD CONSTRAINT checks FOREIGN KEY (Customer_ID) REFERENCES Customer (Customer_ID); CREATE TABLE OrderAssignment ( Order_ID INT UNSIGNED NOT NULL, Donut_ID INT UNSIGNED NOT NULL, Quanity INT ); ALTER TABLE OrderAssignment ADD INDEX CheckOrder (Order_ID), ADD CONSTRAINT CheckOrder FOREIGN KEY (Order_I