/*Brian Goodacre*/
USE parkinggarage;

DROP TABLE parkingSpaces;

CREATE TABLE parkingSpaces (
	parkingSpaceID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	char_handicap INT(1) DEFAULT 0,
	
	currentReservationID INT(10),
	
	time20110101_0000 INT(10),
	time20110101_0015 INT(10),
	time20110101_0030 INT(10),
	time20110101_0045 INT(10),
	time20110101_0100 INT(10),
	time20110101_0115 INT(10),
	time20110101_0130 INT(10),
	time20110101_0145 INT(10),
	time20110101_0200 INT(10),
	time20110101_0215 INT(10),
	time20110101_0230 INT(10),
	time20110101_0245 INT(10)
);

INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
/*
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
INSERT INTO parkingspaces (char_handicap) VALUES (0);
*/

