Some fixes + draft Avalanche

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 208ffba..17fe0d0 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -21,6 +21,7 @@ insert or ignore into Variants (name, description) values
   ('Arena', 'Middle battle'),
   ('Atomic1', 'Explosive captures (v1)'),
   ('Atomic2', 'Explosive captures (v2)'),
   ('Arena', 'Middle battle'),
   ('Atomic1', 'Explosive captures (v1)'),
   ('Atomic2', 'Explosive captures (v2)'),

+  ('Avalanche', 'Pawnfalls'),

   ('Ball', 'Score a goal'),
   ('Balaklava', 'Meet the Mammoth'),
   ('Baroque', 'Exotic captures'),
   ('Ball', 'Score a goal'),
   ('Balaklava', 'Meet the Mammoth'),
   ('Baroque', 'Exotic captures'),


@@ -61,8 +62,11 @@ insert or ignore into Variants (name, description) values
   ('Grasshopper', 'Long jumps over pieces'),
   ('Gridolina', 'Jump the borders'),
   ('Hamilton', 'Walk on a graph'),
   ('Grasshopper', 'Long jumps over pieces'),
   ('Gridolina', 'Jump the borders'),
   ('Hamilton', 'Walk on a graph'),

+  ('Hoppelpoppel', 'Knibis and Bisknis'),

   ('Horde', 'A pawns cloud'),
   ('Interweave', 'Interweaved colorbound teams'),
   ('Horde', 'A pawns cloud'),
   ('Interweave', 'Interweaved colorbound teams'),

+  ('Isardam', 'No paralyzed pieces'),
+  ('Janggi', 'Korean Chess'),

   ('Kinglet', 'Protect your pawns'),
   ('Knightmate', 'Mate the knight'),
   ('Knightpawns', 'Knight versus pawns'),
   ('Kinglet', 'Protect your pawns'),
   ('Knightmate', 'Mate the knight'),
   ('Knightpawns', 'Knight versus pawns'),


@@ -71,11 +75,11 @@ insert or ignore into Variants (name, description) values
   ('Koopa', 'Stun & kick pieces'),
   ('Koth', 'King of the Hill'),
   ('Losers', 'Get strong at self-mate'),
   ('Koopa', 'Stun & kick pieces'),
   ('Koth', 'King of the Hill'),
   ('Losers', 'Get strong at self-mate'),

-  ('Lostqueen', 'Get rid of the queen'),

   ('Madhouse', 'Rearrange enemy pieces'),
   ('Madrasi', 'Paralyzed pieces'),
   ('Magnetic', 'Laws of attraction'),
   ('Madhouse', 'Rearrange enemy pieces'),
   ('Madrasi', 'Paralyzed pieces'),
   ('Magnetic', 'Laws of attraction'),

-  ('Makruk', 'Thai Chess'),
+  ('Makpong', 'Thai Chess (v2)'),
+  ('Makruk', 'Thai Chess (v1)'),

   ('Maxima', 'Occupy the enemy palace'),
   ('Minishogi', 'Shogi 5 x 5'),
   ('Minixiangqi', 'Xiangqi 7 x 7'),
   ('Maxima', 'Occupy the enemy palace'),
   ('Minishogi', 'Shogi 5 x 5'),
   ('Minixiangqi', 'Xiangqi 7 x 7'),


@@ -86,6 +90,7 @@ insert or ignore into Variants (name, description) values
   ('Ordamirror', 'Mongolian Horde (v2)'),
   ('Pacifist1', 'Convert & support (v1)'),
   ('Pacifist2', 'Convert & support (v2)'),
   ('Ordamirror', 'Mongolian Horde (v2)'),
   ('Pacifist1', 'Convert & support (v1)'),
   ('Pacifist2', 'Convert & support (v2)'),

+  ('Pacosako', 'Dance with the King'),

   ('Parachute', 'Landing on the board'),
   ('Pawnmassacre', 'Pieces upside down'),
   ('Pawns', 'Reach the last rank (v1)'),
   ('Parachute', 'Landing on the board'),
   ('Pawnmassacre', 'Pieces upside down'),
   ('Pawns', 'Reach the last rank (v1)'),