<?php
require ('dbPDO.php');
$db->query("CREATE TABLE IF NOT EXISTS bookCustomers (custID int NOT NULL AUTO_INCREMENT, fname varchar(20) NOT NULL, lname varchar(20) NOT NULL, email varchar(50) NOT NULL, street varchar(25) NOT NULL, city varchar(30) NOT NULL, state varchar(2) NOT NULL, zip varchar(5) DEFAULT '', salt BINARY(8), PRIMARY KEY (custID));");
$db->query("INSERT INTO bookCustomers (fname, lname, email, street, city, state, zip, salt) VALUES ('Test','User','example@example.com','1234 Example Ave','Exampleham','WA','98225', unhex('9BA1FA1CE496CF63'));");
$db->query("CREATE TABLE IF NOT EXISTS bookorders (orderID INT NOT NULL AUTO_INCREMENT, custID int(6) NOT NULL, orderdate int(11) NOT NULL, PRIMARY KEY (orderID))");
$db->query("CREATE TABLE IF NOT EXISTS bookorderitems (orderID INT NOT NULL, ISBN varchar(15) NOT NULL, qty int(4) NOT NULL, price double(6,2) NOT NULL, PRIMARY KEY (orderID, ISBN))");
$db->query('CREATE TABLE IF NOT EXISTS bookuuidcustomers (uuid binary(16), custID int NULL, PRIMARY KEY (uuid, custID));');
$db->query('CREATE TABLE IF NOT EXISTS bookcustomerviews (viewID INT NOT NULL AUTO_INCREMENT, uuid BINARY(16) NOT NULL, time INT NOT NULL, ISBN varchar(15) NOT NULL, PRIMARY KEY (viewID), INDEX (uuid));');
$db->query('CREATE TABLE IF NOT EXISTS bookuuidcart (uuid BINARY(16) NOT NULL, ISBN varchar(15) NOT NULL, quantity INT NOT NULL, PRIMARY KEY (uuid, ISBN));');
$db->query('CREATE TABLE IF NOT EXISTS bookpwhash (password BINARY(64) NOT NULL, PRIMARY KEY (password));');
$db->query("INSERT INTO bookpwhash (password) VALUES (unhex('CD7FBD241D19235B935FACC426F9E354836409BD8ADDCF028223F9F3D6EFA749293F6CDDC4990E39CF3A33AC1C77035377E88E426FFAEFAC5548C6668C31C510'))");
echo "TABLE CREATED SUCESSFULLY!";
?>