Dan Becker's Game Page

Create Tournament Table Data

Purpose: Inserts basic data into tournament database tables.


\n";$createSQL = "INSERT INTO TGameNames (id, name) VALUES(1, 'Commands and Colors: Ancients'),(2, 'CCA EP1: Greeks and Eastern Kingdoms'),(3, 'CCA EP2: Rome and the Barbarians')";$sqlResults = sqlQuery( $createSQL );echo "
Game names inserted successfully.
\n";echo "

\n";$createSQL = "INSERT INTO TCountryNames (id, name) VALUES(1, 'Carthage'),(2, 'Rome'),(3, 'Syracuse')";$sqlResults = sqlQuery( $createSQL );echo "
Country names inserted successfully.
\n";echo "

\n";$createSQL = "INSERT INTO TScenarioNames (id, number, title, battledate, playerCount, idGameNames) VALUES(1, 1, 'The Battle of Akragas', '406 BC', 2 , 1 ),(2, 2, 'Crimissos River', '346 BC', 2 , 1 ),(3, 3, 'Ticinus River', '218 BC', 2 , 1 ),(4, 4, 'Lake Trasimenus', '217 BC', 2 , 1 ),(5, 5, 'Cannae', '216 BC', 2 , 1 ),(6, 6, 'Dertosa', '215 BC', 2 , 1 ),(7, 7, 'Castulo', '211 BC', 2 , 1 ),(8, 8, 'Baecula', '208 BC', 2 , 1 ),(9, 9, 'Ilipa', '206 BC', 2 , 1 ),(10, 10, 'Zama', '202 BC', 2 , 1 ),(11, 11, 'Trebbia', '218 BC', 2 , 1 ),(12, 12, '2nd Battle of Beneventum', '214 BC', 2 , 1 ),(13, 13, 'Metaurus', '207 BC', 2 , 1 )";$sqlResults = sqlQuery( $createSQL );echo "
Scenario names inserted successfully.
\n";echo "

\n";$createSQL = "INSERT INTO TScenarioCountry (id, idGameNames, idScenarioNames, idCountryNames, maxFlags) VALUES(1, 1, 1, 1, 5 ),(2, 1, 1, 3, 5 ),(3, 1, 2, 1, 5 ),(4, 1, 2, 3, 5 ),(5, 1, 3, 1, 6 ),(6, 1, 3, 2, 6 ),(7, 1, 4, 1, 6 ),(8, 1, 4, 2, 6 ),(9, 1, 5, 1, 7 ),(10, 1, 5, 2, 7 ),(11, 1, 6, 1, 6 ),(12, 1, 6, 2, 6 ),(13, 1, 7, 1, 8 ),(14, 1, 7, 2, 8 ),(15, 1, 8, 1, 6 ),(16, 1, 8, 2, 6 ),(17, 1, 9, 1, 6 ),(18, 1, 9, 2, 6 ),(19, 1, 10, 1, 8 ),(20, 1, 10, 2, 8 ),(21, 1, 11, 1, 7 ),(22, 1, 11, 2, 7 ),(23, 1, 12, 1, 7 ),(24, 1, 12, 2, 7 ),(25, 1, 13, 1, 7 ),(26, 1, 13, 2, 7 )";$sqlResults = sqlQuery( $createSQL );echo "
Scenarion Country links inserted successfully.
\n";echo "

\n";$createSQL = "INSERT INTO TPlayerNames (id, name) VALUES(1, 'Dan'),(2, 'Brady'),(3, 'Mike'),(4, 'Nathan'),(5, 'Ed'),(6, 'Mark'),(7, 'Kevin')";$sqlResults = sqlQuery( $createSQL );echo "
Player names inserted successfully.
\n";?>

User menu | Admin menu