wAUckGC9

1CREATE DEFINER=`root`@`localhost` PROCEDURE `MakeTables`()
2BEGIN
3
4	DROP TABLE IF EXISTS tblPlayer;
5	CREATE TABLE tblPlayer(
6		Username VARCHAR(50) PRIMARY KEY,
7		Password VARCHAR(50) NOT NULL,
8		Wins INT default 0,
9		Loses INT default 0,
10		Admin enum ('loggedOut', 'LoggedIn', 'Playing', 'Locked') default 'LoggedOut'
11		);
12		
13	DROP TABLE IF EXISTS tblGameBoard;
14	CREATE TABLE tblGameBoard(
15		GameboardID VARCHAR(50) PRIMARY KEY,
16		PlayerID VARCHAR(50)
17		);
18		
19	DROP TABLE IF EXISTS tblWall;
20	CREATE TABLE tblWall(
21		GameboardID VARCHAR(50),
22		WallY VARCHAR(50),
23		WallX VARCHAR(50)
24		);
25		
26	DROP TABLE IF EXISTS tblTank;
27	CREATE TABLE tblTank(
28		TankID VARCHAR(50),
29		PlayerID VARCHAR(50),
30		LocationX VARCHAR(50),
31		LocationY VARCHAR(50),
32		GameboardID VARCHAR(50),
33        Primary Key (TankID, PlayerID)
34		);
35		
36	DROP TABLE IF EXISTS tblMissile;
37	CREATE TABLE tblMissile(
38		MissileID VARCHAR(50) PRIMARY KEY,
39		TankID VARCHAR(50),
40		GameboardID VARCHAR(50),
41		Live BIT,
42		Bounce BIT DEFAULT 0,
43		Direction INT,
44		PlayerID VARCHAR(50)
45		);
46	
47END