Purpose: Use this page to create tournament database tables.
\n";$createSQL = "CREATE TABLE TCountryNames ( id int(8) NOT NULL auto_increment, name varchar(255) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Country names created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TGameNames ( id int(8) NOT NULL auto_increment, name varchar(255) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Game names created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TPlayerNames ( id int(8) NOT NULL auto_increment, name varchar(255) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Player names created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TPlays ( id int(8) NOT NULL auto_increment, played datetime NOT NULL default '0000-00-00 00:00:00', idGameNames int(8) NOT NULL default '0', idScenarioNames int(8) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Plays created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TScenarioCountry ( id int(8) NOT NULL auto_increment, idGameNames int(8) NOT NULL default '0', idScenarioNames int(8) NOT NULL default '0', idCountryNames int(8) NOT NULL default '0', maxFlags int(8) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Scenario-Country created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TScenarioNames ( id int(8) NOT NULL auto_increment, number varchar(255) NOT NULL default '', title varchar(255) NOT NULL default '', battledate varchar(255) NOT NULL default '', playerCount int(8) NOT NULL default '0', idGameNames int(8) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Scenario names created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TScores ( id int(8) NOT NULL auto_increment, idPlays int(8) NOT NULL default '0', idPlayerNames int(8) NOT NULL default '0', idCountryNames int(8) NOT NULL default '0', score int(8) NOT NULL default '0', margin DECIMAL(8,2) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Scores names created successfully.
\n";echo "
\n";$createSQL = "CREATE TABLE TComments ( id int(8) NOT NULL auto_increment, idPlays int(8) NOT NULL default '0', idPlayerNames int(8) NOT NULL default '0', created datetime NOT NULL default '0000-00-00 00:00:00', text varchar(255) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM";$sqlResults = sqlQuery( $createSQL );echo "
Scores names created successfully.
\n";?>