Add Horde variant + fix typos

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 1895777..147868d 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -1,6 +1,13 @@
 -- Re-run this script after variants are added
 
 -- Re-run this script after variants are added
 

-insert or ignore into Variants (name,description) values
+insert or ignore into Variants (name, description, noProblems) values
+  ('Apocalypse', 'The end of the world', true),
+  ('Dark', 'In the shadow', true),
+  ('Hidden', 'Unidentified pieces', true),
+  ('Hiddenqueen', 'Queen disguised as a pawn', true),
+  ('Synchrone', 'Play at the same time', true);
+
+insert or ignore into Variants (name, description) values

   ('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)'),


@@ -22,21 +29,21 @@ insert or ignore into Variants (name,description) values
   ('Coregal', 'Two royal pieces'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Coregal', 'Two royal pieces'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),

-  ('Dark', 'In the shadow'),

   ('Doublearmy', '64 pieces on the board'),
   ('Doublearmy', '64 pieces on the board'),

+  ('Dynamo', 'Push and pull'),

   ('Eightpieces', 'Each piece is unique'),
   ('Enpassant', 'Capture en passant'),
   ('Extinction', 'Capture all of a kind'),
   ('Grand', 'Big board'),
   ('Grasshopper', 'Long jumps over pieces'),
   ('Eightpieces', 'Each piece is unique'),
   ('Enpassant', 'Capture en passant'),
   ('Extinction', 'Capture all of a kind'),
   ('Grand', 'Big board'),
   ('Grasshopper', 'Long jumps over pieces'),

-  ('Hidden', 'Unidentified pieces'),
-  ('Hiddenqueen', 'Queen disguised as a pawn'),
+  ('Horde', 'A pawns cloud'),

   ('Knightmate', 'Mate the knight'),
   ('Knightrelay1', 'Move like a knight (v1)'),
   ('Knightrelay2', 'Move like a knight (v2)'),
   ('Losers', 'Get strong at self-mate'),
   ('Magnetic', 'Laws of attraction'),
   ('Marseille', 'Move twice'),
   ('Knightmate', 'Mate the knight'),
   ('Knightrelay1', 'Move like a knight (v1)'),
   ('Knightrelay2', 'Move like a knight (v2)'),
   ('Losers', 'Get strong at self-mate'),
   ('Magnetic', 'Laws of attraction'),
   ('Marseille', 'Move twice'),

+  ('Orda', 'Mongolian Horde'),

   ('Parachute', 'Landing on the board'),
   ('Perfect', 'Powerful pieces'),
   ('Racingkings', 'Kings cross the 8x8 board'),
   ('Parachute', 'Landing on the board'),
   ('Perfect', 'Powerful pieces'),
   ('Racingkings', 'Kings cross the 8x8 board'),


@@ -48,7 +55,6 @@ insert or ignore into Variants (name,description) values
   ('Shatranj', 'Ancient rules'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Shatranj', 'Ancient rules'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),

-  ('Synchrone', 'Play at the same time'),

   ('Threechecks', 'Give three checks'),
   ('Twokings', 'Two kings'),
   ('Upsidedown', 'Board upside down'),
   ('Threechecks', 'Give three checks'),
   ('Twokings', 'Two kings'),
   ('Upsidedown', 'Board upside down'),