SQLize | PHPize | SQLtest

CREATE TABLE Customers (Custnum INTEGER NOT NULL, Custname VARCHAR(25), Custaddress VARCHAR(75), Custphonenum VARCHAR(25), PaymentID INTEGER, CONSTRAINT Customers_PK PRIMARY KEY (Custnum)); CREATE TABLE Restaurants (Restnum INTEGER NOT NULL, Restname VARCHAR(75), Restaddress VARCHAR(75), Restphonenum VARCHAR(75), Cuisine VARCHAR(75), RestPaymentID INTEGER, CONSTRAINT Restaurants_PK PRIMARY KEY (Restnum)); CREATE TABLE Driver (Drivernum INTEGER NOT NULL, Drivername VARCHAR(25), Driverphonenum VARCHAR(25), LicenseplateNo VARCHAR(25), Licensenum VARCHAR(25), DriverpaymentID INTEGER, CONSTRAINT Driver_PK PRIMARY KEY (Drivernum)); CREATE TABLE Orders (Ordernum INTEGER NOT NULL, Driverstatus VARCHAR(25), OrderTime VARCHAR(25), Status VARCHAR(25), CONSTRAINT Orders_PK PRIMARY KEY (Ordernum)); INSERT INTO Customers (Custnum, Custname, Custaddress, Custphonenum, PaymentID) VALUES (1, "April ludgate", '123 S 55 Ave, Omaha, NE 68132', '402-553-4397', 23456), (2, 'April Ludgate', '123 S 55 Ave, Omaha, NE 68132', '402-553-4397', 23456), (3, 'Leslie Knope', '4387 Waffles Drive, Pawnee IN, 46011', '234-432-5437', 98754), (4, 'Ron Swanson', '987 Bacon Avenue, Pawnee, IN, 46011', '456-987-3265', 234789), (5, 'Andy Dwyer', '2468 The Pit, Pawnee, IN 46011', NULL, 12390), (6, NULL, NULL, NULL, NULL); INSERT INTO Restaurants (Restnum, Restname, Restaddress, Restphonenum, Cuisine, RestPaymentID) VALUES (1, 'Paunch Burger', '6872 Lard Lane, Pawnee, IN, 46011', '678-893-1568', 'Fast food', 4826), (2, 'Paunch Burger', '6872 Lard Lane, Pawnee, IN, 46011', '678-893-1568', 'Fast food', 4826), (3, "JJ's Diner", '23428 Main St. Pawnee, IN, 46011', '456-987-3185', 'Breakfast', 78623), (4, "Mulligan's", '6876 Classy Rd., Indianapolis, IN 46077', '786-235-4826', 'Steakhouse', 48623), (5, "JJ's Diner", '23428 Main St. Pawnee, IN 46011', '436-987-3185', 'Breakast', 78623), (6, NULL, NULL, NULL, NULL, NULL); INSERT INTO Driver (Drivernum, Drivername, Driverphonenum, LicenseplateNo, Licensenum, DriverPaymentID) VALUES (1, 'Henry Roth', '(286) 937-2250', 'IUC989', 'CO4790049', 444862), (2, 'Charity Osborne', '(815) 605-0336', 'REW222', 'D89973937', 959227), (3, 'Fritz Macias', '(943) 893-6193', 'XUA177', 'U06119817', 718371), (4, 'Brenden Hill', '(513) 284-9064', 'IOL455', 'X22173227', 334452), (5, 'Henry Roth', '(286) 937-2250', 'IUC989', 'CO4790049', 444862), (6, 'Leah Peters', '(909) 477-8843', 'AJA879', 'V44276914', 603268); INSERT INTO Orders (Ordernum, Driverstatus, OrderTime, Status) VALUES (1, 'Active', '9/30/2020 6:44', 'Out'), (2, 'Active', '9/30/2020 10:44', 'Placed'), (3, 'Active', '9/30/2020 10:54', 'Fulfilled'), (4, 'Active', '9/30/2020 10:46', 'Placed'), (5, 'Active', '9/30/2020 11:44', 'Cancelled'), (6, 'Inactive', NULL, NULL); SELECT * FROM Driver ORDER BY Drivername;