X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=147868d98452b56d20318208cd3bcca569705840;hb=f9385686d9434c607cdaa55e41a0425269db0815;hp=52c043cb5efc7dde4688a61cc73cd7d56e3bc2b5;hpb=c7550017d88ff6eb32e2c76a271a7f9edc4a3bf6;p=vchess.git

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 52c043cb..147868d9 100644
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -1,6 +1,13 @@
 -- 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)'),
@@ -22,7 +29,6 @@ insert or ignore into Variants (name,description) values
   ('Coregal', 'Two royal pieces'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
-  ('Dark', 'In the shadow'),
   ('Doublearmy', '64 pieces on the board'),
   ('Dynamo', 'Push and pull'),
   ('Eightpieces', 'Each piece is unique'),
@@ -30,8 +36,7 @@ insert or ignore into Variants (name,description) values
   ('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)'),
@@ -50,7 +55,6 @@ insert or ignore into Variants (name,description) values
   ('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'),