Some fixes, draw lines on board, add 7 variants

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 4060a44..a3eb282 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -1,40 +1,89 @@
 -- 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
+  ('Absorption', 'Absorb powers'),

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

-  ('Antiking', 'Keep antiking in check'),
+  ('Ambiguous', 'Play opponent''s pieces'),
+  ('Antiking1', 'Keep antiking in check (v1)'),
+  ('Antiking2', 'Keep antiking in check (v2)'),

   ('Antimatter', 'Dangerous collisions'),
   ('Arena', 'Middle battle'),
   ('Atomic', 'Explosive captures'),
   ('Antimatter', 'Dangerous collisions'),
   ('Arena', 'Middle battle'),
   ('Atomic', 'Explosive captures'),

+  ('Ball', 'Score a goal'),

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

-  ('Checkered', 'Shared pieces'),
+  ('Bicolour', 'Harassed kings'),
+  ('Cannibal', 'Capture powers'),
+  ('Capture', 'Mandatory captures'),
+  ('Checkered1', 'Shared pieces (v1)'),
+  ('Checkered2', 'Shared pieces (v2)'),
+  ('Checkless', 'No-check mode'),

   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),
   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),

+  ('Colorbound', 'The colorbound clobberers'),
+  ('Coregal', 'Two royal pieces'),
+  ('Coronation', 'Long live the Queen'),

   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),

-  ('Dark', 'In the shadow'),
+  ('Diamond', 'Rotating board'),
+  ('Doublearmy', '64 pieces on the board'),
+  ('Doublemove1', 'Double moves (v1)'),
+  ('Doublemove2', 'Double moves (v2)'),
+  ('Dynamo', 'Push and pull'),

   ('Eightpieces', 'Each piece is unique'),
   ('Enpassant', 'Capture en passant'),
   ('Extinction', 'Capture all of a kind'),
   ('Eightpieces', 'Each piece is unique'),
   ('Enpassant', 'Capture en passant'),
   ('Extinction', 'Capture all of a kind'),

+  ('Football', 'Score a goal'),

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

-  ('Hidden', 'Unidentified pieces'),
-  ('Hiddenqueen', 'Queen disguised as a pawn'),
+  ('Gridolina', 'Jump the borders'),
+  ('Hamilton', 'Walk on a graph'),
+  ('Horde', 'A pawns cloud'),
+  ('Interweave', 'Interweaved colorbound teams'),

   ('Knightmate', 'Mate the knight'),
   ('Knightmate', 'Mate the knight'),

-  ('Knightrelay', 'The knight transfers its powers'),
-  ('Losers', 'Lose all pieces'),
+  ('Knightrelay1', 'Move like a knight (v1)'),
+  ('Knightrelay2', 'Move like a knight (v2)'),
+  ('Koth', 'King of the Hill'),
+  ('Losers', 'Get strong at self-mate'),
+  ('Madrasi', 'Paralyzed pieces'),

   ('Magnetic', 'Laws of attraction'),
   ('Magnetic', 'Laws of attraction'),

-  ('Marseille', 'Move twice'),
+  ('Makruk', 'Thai Chess'),
+  ('Maxima', 'Occupy the enemy palace'),
+  ('Minishogi', 'Shogi 5 x 5'),
+  ('Monochrome', 'All of the same color'),
+  ('Monster', 'White move twice'),
+  ('Omega', 'A wizard in the corner'),
+  ('Orda', 'Mongolian Horde'),
+  ('Parachute', 'Landing on the board'),
+  ('Perfect', 'Powerful pieces'),
+  ('Racingkings', 'Kings cross the 8x8 board'),

   ('Rifle', 'Shoot pieces'),
   ('Rifle', 'Shoot pieces'),

-  ('Royalrace', 'Kings cross the board'),

   ('Recycle', 'Reuse pieces'),
   ('Recycle', 'Reuse pieces'),

+  ('Rococo', 'Capture on the edge'),
+  ('Royalrace', 'Kings cross the 11x11 board'),
+  ('Rugby', 'Transform an essay'),
+  ('Schess', 'Seirawan-Harper Chess'),
+  ('Shako', 'Non-conformism and utopia'),

   ('Shatranj', 'Ancient rules'),
   ('Shatranj', 'Ancient rules'),

+  ('Shogi', 'Japanese Chess'),
+  ('Sittuyin', 'Burmese chess'),
+  ('Suicide', 'Lose all pieces'),

   ('Suction', 'Attract opposite king'),
   ('Suction', 'Attract opposite king'),

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

   ('Threechecks', 'Give three checks'),
   ('Threechecks', 'Give three checks'),

+  ('Twokings', 'Two kings'),

   ('Upsidedown', 'Board upside down'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
   ('Upsidedown', 'Board upside down'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),