Add Castle Chess

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

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 21f7c7a..13d6594 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -2,12 +2,15 @@
 
 insert or ignore into Variants (name, description, noProblems) values
   ('Apocalypse', 'The end of the world', true),
 
 insert or ignore into Variants (name, description, noProblems) values
   ('Apocalypse', 'The end of the world', true),

+  ('Chakart', 'Capture the princess', true),

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

+  ('Dice', 'Roll the dice', 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
   ('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)'),


@@ -18,21 +21,28 @@ insert or ignore into Variants (name, description) values
   ('Arena', 'Middle battle'),
   ('Atomic', 'Explosive captures'),
   ('Ball', 'Score a goal'),
   ('Arena', 'Middle battle'),
   ('Atomic', 'Explosive captures'),
   ('Ball', 'Score a goal'),

+  ('Balaklava', 'Meet the Mammoth'),

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

+  ('Bicolour', 'Harassed kings'),
+  ('Bishopawns', 'Bishop versus pawns'),

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

+  ('Castle', 'Win by castling long'),

   ('Checkered1', 'Shared pieces (v1)'),
   ('Checkered2', 'Shared pieces (v2)'),
   ('Checkless', 'No-check mode'),
   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),
   ('Checkered1', 'Shared pieces (v1)'),
   ('Checkered2', 'Shared pieces (v2)'),
   ('Checkless', 'No-check mode'),
   ('Chess960', 'Standard rules'),
   ('Circular', 'Run forward'),

+  ('Clorange', 'A Clockwork Orange'),

   ('Colorbound', 'The colorbound clobberers'),
   ('Coregal', 'Two royal pieces'),
   ('Colorbound', 'The colorbound clobberers'),
   ('Coregal', 'Two royal pieces'),

+  ('Coronation', 'Long live the Queen'),

   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Diamond', 'Rotating board'),
   ('Crazyhouse', 'Captures reborn'),
   ('Cylinder', 'Neverending rows'),
   ('Diamond', 'Rotating board'),

+  ('Discoduel', 'Enter the disco'),

   ('Doublearmy', '64 pieces on the board'),
   ('Doublemove1', 'Double moves (v1)'),
   ('Doublemove2', 'Double moves (v2)'),
   ('Doublearmy', '64 pieces on the board'),
   ('Doublemove1', 'Double moves (v1)'),
   ('Doublemove2', 'Double moves (v2)'),


@@ -40,15 +50,25 @@ insert or ignore into Variants (name, description) values
   ('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'),
+  ('Forward', 'Moving forward'),
+  ('Freecapture', 'Capture both colors'),

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

+  ('Gridolina', 'Jump the borders'),

   ('Hamilton', 'Walk on a graph'),
   ('Horde', 'A pawns cloud'),
   ('Interweave', 'Interweaved colorbound teams'),
   ('Hamilton', 'Walk on a graph'),
   ('Horde', 'A pawns cloud'),
   ('Interweave', 'Interweaved colorbound teams'),

+  ('Kinglet', 'Protect your pawns'),

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

+  ('Knightpawns', 'Knight versus pawns'),

   ('Knightrelay1', 'Move like a knight (v1)'),
   ('Knightrelay2', 'Move like a knight (v2)'),
   ('Knightrelay1', 'Move like a knight (v1)'),
   ('Knightrelay2', 'Move like a knight (v2)'),

+  ('Koopa', 'Stun & kick pieces'),
+  ('Koth', 'King of the Hill'),

   ('Losers', 'Get strong at self-mate'),
   ('Losers', 'Get strong at self-mate'),

+  ('Madhouse', 'Rearrange enemy pieces'),
+  ('Madrasi', 'Paralyzed pieces'),

   ('Magnetic', 'Laws of attraction'),
   ('Makruk', 'Thai Chess'),
   ('Maxima', 'Occupy the enemy palace'),
   ('Magnetic', 'Laws of attraction'),
   ('Makruk', 'Thai Chess'),
   ('Maxima', 'Occupy the enemy palace'),


@@ -56,13 +76,25 @@ insert or ignore into Variants (name, description) values
   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),
   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),

-  ('Orda', 'Mongolian Horde'),
+  ('Orda', 'Mongolian Horde (v1)'),
+  ('Ordamirror', 'Mongolian Horde (v2)'),
+  ('Pacifist1', 'Convert & support (v1)'),
+  ('Pacifist2', 'Convert & support (v2)'),

   ('Parachute', 'Landing on the board'),
   ('Parachute', 'Landing on the board'),

+  ('Pawnmassacre', 'Pieces upside down'),
+  ('Pawns', 'Reach the last rank (v1)'),
+  ('Pawnsking', 'Reach the last rank (v2)'),

   ('Perfect', 'Powerful pieces'),
   ('Perfect', 'Powerful pieces'),

+  ('Pocketknight', 'Knight in pocket'),
+  ('Progressive1', 'Play more and more moves (v1)'),
+  ('Progressive2', 'Play more and more moves (v2)'),
+  ('Queenpawns', 'Queen versus pawns'),

   ('Racingkings', 'Kings cross the 8x8 board'),
   ('Racingkings', 'Kings cross the 8x8 board'),

+  ('Rampage', 'Move under cover'),

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

+  ('Rookpawns', 'Rook versus pawns'),

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


@@ -72,11 +104,15 @@ insert or ignore into Variants (name, description) values
   ('Sittuyin', 'Burmese chess'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Sittuyin', 'Burmese chess'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),

+  ('Swap', 'Dangerous captures'),
+  ('Switching', 'Exchange pieces'' positions'),

   ('Takenmake', 'Prolongated captures'),
   ('Takenmake', 'Prolongated captures'),

+  ('Teleport', 'Reposition pieces'),

   ('Tencubed', 'Four new pieces'),
   ('Threechecks', 'Give three checks'),
   ('Twokings', 'Two kings'),
   ('Upsidedown', 'Board upside down'),
   ('Tencubed', 'Four new pieces'),
   ('Threechecks', 'Give three checks'),
   ('Twokings', 'Two kings'),
   ('Upsidedown', 'Board upside down'),

+  ('Vchess', 'Pawns capture backward'),

   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
   ('Zen', 'Reverse captures');
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
   ('Zen', 'Reverse captures');