Add Alapo, Crossing, Kingsmaker, Squatter variants

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 7def7a6..3c70353 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -7,10 +7,12 @@ insert or ignore into Variants (name, description, noProblems) values
   ('Dice', 'Roll the dice', true),
   ('Hidden', 'Unidentified pieces', true),
   ('Hiddenqueen', 'Queen disguised as a pawn', true),
   ('Dice', 'Roll the dice', true),
   ('Hidden', 'Unidentified pieces', true),
   ('Hiddenqueen', 'Queen disguised as a pawn', true),

-  ('Synchrone', 'Play at the same time', true);
+  ('Synchrone1', 'Play at the same time (v1)', true),
+  ('Synchrone2', 'Play at the same time (v2)', true);

 
 insert or ignore into Variants (name, description) values
   ('Absorption', 'Absorb powers'),
 
 insert or ignore into Variants (name, description) values
   ('Absorption', 'Absorb powers'),

+  ('Alapo', 'Geometric Chess'),

   ('Alice', 'Both sides of the mirror'),
   ('Allmate1', 'Mate any piece (v1)'),
   ('Allmate2', 'Mate any piece (v2)'),
   ('Alice', 'Both sides of the mirror'),
   ('Allmate1', 'Mate any piece (v1)'),
   ('Allmate2', 'Mate any piece (v2)'),


@@ -21,6 +23,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'),


@@ -28,6 +31,7 @@ insert or ignore into Variants (name, description) values
   ('Berolina', 'Pawns move diagonally'),
   ('Bicolour', 'Harassed kings'),
   ('Bishopawns', 'Bishop versus pawns'),
   ('Berolina', 'Pawns move diagonally'),
   ('Bicolour', 'Harassed kings'),
   ('Bishopawns', 'Bishop versus pawns'),

+  ('Brotherhood', 'Friendly pieces'),

   ('Cannibal', 'Capture powers'),
   ('Capture', 'Mandatory captures'),
   ('Castle', 'Win by castling long'),
   ('Cannibal', 'Capture powers'),
   ('Capture', 'Mandatory captures'),
   ('Castle', 'Win by castling long'),


@@ -41,14 +45,17 @@ insert or ignore into Variants (name, description) values
   ('Coregal', 'Two royal pieces'),
   ('Coronation', 'Long live the Queen'),
   ('Crazyhouse', 'Captures reborn'),
   ('Coregal', 'Two royal pieces'),
   ('Coronation', 'Long live the Queen'),
   ('Crazyhouse', 'Captures reborn'),

+  ('Crossing', 'Cross the river'),

   ('Cylinder', 'Neverending rows'),
   ('Diamond', 'Rotating board'),
   ('Discoduel', 'Enter the disco'),
   ('Cylinder', 'Neverending rows'),
   ('Diamond', 'Rotating board'),
   ('Discoduel', 'Enter the disco'),

+  ('Dobutsu', 'Let''s catch the Lion!'),

   ('Doublearmy', '64 pieces on the board'),
   ('Doublemove1', 'Double moves (v1)'),
   ('Doublemove2', 'Double moves (v2)'),
   ('Dynamo', 'Push and pull'),
   ('Eightpieces', 'Each piece is unique'),
   ('Doublearmy', '64 pieces on the board'),
   ('Doublemove1', 'Double moves (v1)'),
   ('Doublemove2', 'Double moves (v2)'),
   ('Dynamo', 'Push and pull'),
   ('Eightpieces', 'Each piece is unique'),

+  ('Empire', 'Empire versus Kingdom'),

   ('Enpassant', 'Capture en passant'),
   ('Evolution', 'Faster development'),
   ('Extinction', 'Capture all of a kind'),
   ('Enpassant', 'Capture en passant'),
   ('Evolution', 'Faster development'),
   ('Extinction', 'Capture all of a kind'),


@@ -60,9 +67,13 @@ 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'),
   ('Kinglet', 'Protect your pawns'),

+  ('Kingsmaker', 'Promote into kings'),

   ('Knightmate', 'Mate the knight'),
   ('Knightpawns', 'Knight versus pawns'),
   ('Knightrelay1', 'Move like a knight (v1)'),
   ('Knightmate', 'Mate the knight'),
   ('Knightpawns', 'Knight versus pawns'),
   ('Knightrelay1', 'Move like a knight (v1)'),


@@ -73,16 +84,21 @@ insert or ignore into Variants (name, description) values
   ('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'),
+  ('Maharajah', 'Augmented Queens'),
+  ('Makpong', 'Thai Chess (v2)'),
+  ('Makruk', 'Thai Chess (v1)'),

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

+  ('Minixiangqi', 'Xiangqi 7 x 7'),

   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),
   ('Orda', 'Mongolian Horde (v1)'),
   ('Ordamirror', 'Mongolian Horde (v2)'),
   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),
   ('Orda', 'Mongolian Horde (v1)'),
   ('Ordamirror', 'Mongolian Horde (v2)'),

+  ('Otage', 'Capture and release hostages'),

   ('Pacifist1', 'Convert & support (v1)'),
   ('Pacifist2', 'Convert & support (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)'),


@@ -94,6 +110,7 @@ insert or ignore into Variants (name, description) values
   ('Queenpawns', 'Queen versus pawns'),
   ('Racingkings', 'Kings cross the 8x8 board'),
   ('Rampage', 'Move under cover'),
   ('Queenpawns', 'Queen versus pawns'),
   ('Racingkings', 'Kings cross the 8x8 board'),
   ('Rampage', 'Move under cover'),

+  ('Relayup', 'Upgrade pieces'),

   ('Rifle', 'Shoot pieces'),
   ('Recycle', 'Reuse pieces'),
   ('Rococo', 'Capture on the edge'),
   ('Rifle', 'Shoot pieces'),
   ('Recycle', 'Reuse pieces'),
   ('Rococo', 'Capture on the edge'),


@@ -101,14 +118,17 @@ insert or ignore into Variants (name, description) values
   ('Royalrace', 'Kings cross the 11x11 board'),
   ('Rugby', 'Transform an essay'),
   ('Schess', 'Seirawan-Harper Chess'),
   ('Royalrace', 'Kings cross the 11x11 board'),
   ('Rugby', 'Transform an essay'),
   ('Schess', 'Seirawan-Harper Chess'),

+  ('Screen', 'Free initial setup'),

   ('Shako', 'Non-conformism and utopia'),
   ('Shatranj', 'Ancient rules'),
   ('Shogi', 'Japanese Chess'),
   ('Shako', 'Non-conformism and utopia'),
   ('Shatranj', 'Ancient rules'),
   ('Shogi', 'Japanese Chess'),

-  ('Sittuyin', 'Burmese chess'),
+  ('Sittuyin', 'Burmese Chess'),
+  ('Squatter', 'Squat last rank'),

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

+  ('Synochess', 'Dynasty versus Kingdom'),

   ('Takenmake', 'Prolongated captures'),
   ('Teleport', 'Reposition pieces'),
   ('Tencubed', 'Four new pieces'),
   ('Takenmake', 'Prolongated captures'),
   ('Teleport', 'Reposition pieces'),
   ('Tencubed', 'Four new pieces'),


@@ -119,4 +139,5 @@ insert or ignore into Variants (name, description) values
   ('Vchess', 'Pawns capture backward'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
   ('Vchess', 'Pawns capture backward'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),

+  ('Xiangqi', 'Chinese Chess'),

   ('Zen', 'Reverse captures');
   ('Zen', 'Reverse captures');