Add last 2 variants in DB - still small bugs - will fix tomorrow

[vchess.git] / server / db / populate.sql

diff --git a/server/db/populate.sql b/server/db/populate.sql
index b6d0bf7..122224d 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -26,6 +26,7 @@ insert or ignore into Variants (name, description) values
   ('Avalanche', 'Pawnfalls'),
   ('Ball', 'Score a goal'),
   ('Balaklava', 'Meet the Mammoth'),
   ('Avalanche', 'Pawnfalls'),
   ('Ball', 'Score a goal'),
   ('Balaklava', 'Meet the Mammoth'),

+  ('Bario', 'A quantum story'),

   ('Baroque', 'Exotic captures'),
   ('Benedict', 'Change colors'),
   ('Berolina', 'Pawns move diagonally'),
   ('Baroque', 'Exotic captures'),
   ('Benedict', 'Change colors'),
   ('Berolina', 'Pawns move diagonally'),


@@ -63,6 +64,7 @@ insert or ignore into Variants (name, description) values
   ('Football', 'Score a goal'),
   ('Forward', 'Moving forward'),
   ('Freecapture', 'Capture both colors'),
   ('Football', 'Score a goal'),
   ('Forward', 'Moving forward'),
   ('Freecapture', 'Capture both colors'),

+  ('Fugue', 'Baroque Music'),

   ('Fullcavalry', 'Lancers everywhere'),
   ('Grand', 'Big board'),
   ('Grasshopper', 'Long jumps over pieces'),
   ('Fullcavalry', 'Lancers everywhere'),
   ('Grand', 'Big board'),
   ('Grasshopper', 'Long jumps over pieces'),


@@ -74,6 +76,7 @@ insert or ignore into Variants (name, description) values
   ('Interweave', 'Interweaved colorbound teams'),
   ('Isardam', 'No paralyzed pieces'),
   ('Janggi', 'Korean Chess'),
   ('Interweave', 'Interweaved colorbound teams'),
   ('Isardam', 'No paralyzed pieces'),
   ('Janggi', 'Korean Chess'),

+  ('Joker', 'Replace pieces'),

   ('Kinglet', 'Protect your pawns'),
   ('Kingsmaker', 'Promote into kings'),
   ('Knightmate', 'Mate the knight'),
   ('Kinglet', 'Protect your pawns'),
   ('Kingsmaker', 'Promote into kings'),
   ('Knightmate', 'Mate the knight'),


@@ -117,6 +120,8 @@ insert or ignore into Variants (name, description) values
   ('Relayup', 'Upgrade pieces'),
   ('Rifle', 'Shoot pieces'),
   ('Recycle', 'Reuse pieces'),
   ('Relayup', 'Upgrade pieces'),
   ('Rifle', 'Shoot pieces'),
   ('Recycle', 'Reuse pieces'),

+  ('Refusal', 'Do not play that!'),
+  ('Rollerball', 'As in the movie'),

   ('Rococo', 'Capture on the edge'),
   ('Rookpawns', 'Rook versus pawns'),
   ('Royalrace', 'Kings cross the 11x11 board'),
   ('Rococo', 'Capture on the edge'),
   ('Rookpawns', 'Rook versus pawns'),
   ('Royalrace', 'Kings cross the 11x11 board'),


@@ -126,8 +131,11 @@ insert or ignore into Variants (name, description) values
   ('Shako', 'Non-conformism and utopia'),
   ('Shatranj', 'Ancient rules'),
   ('Shogi', 'Japanese Chess'),
   ('Shako', 'Non-conformism and utopia'),
   ('Shatranj', 'Ancient rules'),
   ('Shogi', 'Japanese Chess'),

+  ('Shogun', 'General''s Chess'),

   ('Sittuyin', 'Burmese Chess'),
   ('Sittuyin', 'Burmese Chess'),

-  ('Squatter', 'Squat last rank'),
+  ('Spartan', 'Spartan versus Persians'),
+  ('Squatter1', 'Squat last rank (v1)'),
+  ('Squatter2', 'Squat last rank (v2)'),

   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Swap', 'Dangerous captures'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Swap', 'Dangerous captures'),