Purpose: Use this page to create database tables.
\n";$createSQL = "CREATE TABLE Plays ( playid INT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT, date DATE NOT NULL, game VARCHAR( 64 ) NOT NULL, players INT( 2 ) NOT NULL, PRIMARY KEY ( playid ), UNIQUE ID ( playid ) )";$sqlResults = sqlQuery( $createSQL );echo "
Play table created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE Scores ( scoreid INT( 6 ) UNSIGNED NOT NULL AUTO_INCREMENT, playid INT( 6 ) NOT NULL, player VARCHAR( 64 ) NOT NULL, points INT( 2 ) NOT NULL, PRIMARY KEY ( scoreid ), UNIQUE ID ( scoreid ) )";$sqlResults = sqlQuery( $createSQL );echo "
Score table created successfully.
\n";?>