Forgot to update database

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 4060a44..72ded70 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -4,16 +4,21 @@ 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)'),

-  ('Antiking', 'Keep antiking in check'),
+  ('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'),

+  ('Cannibal', 'Capture powers'),
+  ('Capture', 'Mandatory captures'),

   ('Checkered', 'Shared pieces'),
   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),
   ('Checkered', 'Shared pieces'),
   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),

+  ('Coregal', 'Two royal pieces'),

   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Dark', 'In the shadow'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Dark', 'In the shadow'),


@@ -25,16 +30,24 @@ insert or ignore into Variants (name,description) values
   ('Hidden', 'Unidentified pieces'),
   ('Hiddenqueen', 'Queen disguised as a pawn'),
   ('Knightmate', 'Mate the knight'),
   ('Hidden', 'Unidentified pieces'),
   ('Hiddenqueen', 'Queen disguised as a pawn'),
   ('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)'),
+  ('Losers', 'Get strong at self-mate'),

   ('Magnetic', 'Laws of attraction'),
   ('Marseille', 'Move twice'),
   ('Magnetic', 'Laws of attraction'),
   ('Marseille', 'Move twice'),

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

+  ('Royalrace', 'Kings cross the 11x11 board'),
+  ('Rugby', 'Transform an essay'),
+  ('Schess', 'Seirawan-Harper Chess'),

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

+  ('Suicide', 'Lose all pieces'),

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

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

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