X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=be0f09bccc971f6acc7b41300e20c7a9b36216bc;hb=2fac4d67083700a1f1e85ed8662c176c24cdea6b;hp=7def7a625ffd3d52d9a019cde87df7947518737e;hpb=0fb43db7c2858201e8410670b90f95ad8b138964;p=vchess.git

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 7def7a62..be0f09bc 100644
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -7,10 +7,12 @@ insert or ignore into Variants (name, description, noProblems) values
   ('Dice', 'Roll the dice', true),
   ('Hidden', 'Unidentified pieces', true),
   ('Hiddenqueen', 'Queen disguised as a pawn', true),
-  ('Synchrone', 'Play at the same time', true);
+  ('Synchrone1', 'Play at the same time (v1)', true),
+  ('Synchrone2', 'Play at the same time (v2)', true);
 
 insert or ignore into Variants (name, description) values
   ('Absorption', 'Absorb powers'),
+  ('Alapo', 'Geometric Chess'),
   ('Alice', 'Both sides of the mirror'),
   ('Allmate1', 'Mate any piece (v1)'),
   ('Allmate2', 'Mate any piece (v2)'),
@@ -21,6 +23,7 @@ insert or ignore into Variants (name, description) values
   ('Arena', 'Middle battle'),
   ('Atomic1', 'Explosive captures (v1)'),
   ('Atomic2', 'Explosive captures (v2)'),
+  ('Avalanche', 'Pawnfalls'),
   ('Ball', 'Score a goal'),
   ('Balaklava', 'Meet the Mammoth'),
   ('Baroque', 'Exotic captures'),
@@ -28,6 +31,7 @@ insert or ignore into Variants (name, description) values
   ('Berolina', 'Pawns move diagonally'),
   ('Bicolour', 'Harassed kings'),
   ('Bishopawns', 'Bishop versus pawns'),
+  ('Brotherhood', 'Friendly pieces'),
   ('Cannibal', 'Capture powers'),
   ('Capture', 'Mandatory captures'),
   ('Castle', 'Win by castling long'),
@@ -41,14 +45,17 @@ insert or ignore into Variants (name, description) values
   ('Coregal', 'Two royal pieces'),
   ('Coronation', 'Long live the Queen'),
   ('Crazyhouse', 'Captures reborn'),
+  ('Crossing', 'Cross the river'),
   ('Cylinder', 'Neverending rows'),
   ('Diamond', 'Rotating board'),
   ('Discoduel', 'Enter the disco'),
+  ('Dobutsu', 'Let''s catch the Lion!'),
   ('Doublearmy', '64 pieces on the board'),
   ('Doublemove1', 'Double moves (v1)'),
   ('Doublemove2', 'Double moves (v2)'),
   ('Dynamo', 'Push and pull'),
   ('Eightpieces', 'Each piece is unique'),
+  ('Empire', 'Empire versus Kingdom'),
   ('Enpassant', 'Capture en passant'),
   ('Evolution', 'Faster development'),
   ('Extinction', 'Capture all of a kind'),
@@ -60,9 +67,14 @@ insert or ignore into Variants (name, description) values
   ('Grasshopper', 'Long jumps over pieces'),
   ('Gridolina', 'Jump the borders'),
   ('Hamilton', 'Walk on a graph'),
+  ('Hoppelpoppel', 'Knibis and Bisknis'),
   ('Horde', 'A pawns cloud'),
+  ('Hypnotic', 'Mind control (v1)'),
   ('Interweave', 'Interweaved colorbound teams'),
+  ('Isardam', 'No paralyzed pieces'),
+  ('Janggi', 'Korean Chess'),
   ('Kinglet', 'Protect your pawns'),
+  ('Kingsmaker', 'Promote into kings'),
   ('Knightmate', 'Mate the knight'),
   ('Knightpawns', 'Knight versus pawns'),
   ('Knightrelay1', 'Move like a knight (v1)'),
@@ -73,16 +85,22 @@ insert or ignore into Variants (name, description) values
   ('Madhouse', 'Rearrange enemy pieces'),
   ('Madrasi', 'Paralyzed pieces'),
   ('Magnetic', 'Laws of attraction'),
-  ('Makruk', 'Thai Chess'),
+  ('Maharajah', 'Augmented Queens'),
+  ('Makpong', 'Thai Chess (v2)'),
+  ('Makruk', 'Thai Chess (v1)'),
   ('Maxima', 'Occupy the enemy palace'),
+  ('Mesmer', 'Mind control (v2)'),
   ('Minishogi', 'Shogi 5 x 5'),
+  ('Minixiangqi', 'Xiangqi 7 x 7'),
   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),
   ('Orda', 'Mongolian Horde (v1)'),
   ('Ordamirror', 'Mongolian Horde (v2)'),
+  ('Otage', 'Capture and release hostages'),
   ('Pacifist1', 'Convert & support (v1)'),
   ('Pacifist2', 'Convert & support (v2)'),
+  ('Pacosako', 'Dance with the King'),
   ('Parachute', 'Landing on the board'),
   ('Pawnmassacre', 'Pieces upside down'),
   ('Pawns', 'Reach the last rank (v1)'),
@@ -94,6 +112,7 @@ insert or ignore into Variants (name, description) values
   ('Queenpawns', 'Queen versus pawns'),
   ('Racingkings', 'Kings cross the 8x8 board'),
   ('Rampage', 'Move under cover'),
+  ('Relayup', 'Upgrade pieces'),
   ('Rifle', 'Shoot pieces'),
   ('Recycle', 'Reuse pieces'),
   ('Rococo', 'Capture on the edge'),
@@ -101,14 +120,17 @@ insert or ignore into Variants (name, description) values
   ('Royalrace', 'Kings cross the 11x11 board'),
   ('Rugby', 'Transform an essay'),
   ('Schess', 'Seirawan-Harper Chess'),
+  ('Screen', 'Free initial setup'),
   ('Shako', 'Non-conformism and utopia'),
   ('Shatranj', 'Ancient rules'),
   ('Shogi', 'Japanese Chess'),
-  ('Sittuyin', 'Burmese chess'),
+  ('Sittuyin', 'Burmese Chess'),
+  ('Squatter', 'Squat last rank'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Swap', 'Dangerous captures'),
   ('Switching', 'Exchange pieces'' positions'),
+  ('Synochess', 'Dynasty versus Kingdom'),
   ('Takenmake', 'Prolongated captures'),
   ('Teleport', 'Reposition pieces'),
   ('Tencubed', 'Four new pieces'),
@@ -119,4 +141,5 @@ insert or ignore into Variants (name, description) values
   ('Vchess', 'Pawns capture backward'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
+  ('Xiangqi', 'Chinese Chess'),
   ('Zen', 'Reverse captures');