X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=5322ce99621a3ab28baebfbb8718795d708e456e;hb=e023d74715d327ebd7623079cb778b0def0a1464;hp=fc814642d1727bcb4ce2b512726c90335a153198;hpb=da9e846e41622111a4f877742dc0b35406635b5c;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index fc814642..5322ce99 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -12,6 +12,7 @@ insert or ignore into Variants (name, description, noProblems) values 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)'), @@ -25,6 +26,7 @@ insert or ignore into Variants (name, description) values ('Avalanche', 'Pawnfalls'), ('Ball', 'Score a goal'), ('Balaklava', 'Meet the Mammoth'), + ('Bario', 'A quantum story'), ('Baroque', 'Exotic captures'), ('Benedict', 'Change colors'), ('Berolina', 'Pawns move diagonally'), @@ -32,6 +34,7 @@ insert or ignore into Variants (name, description) values ('Bishopawns', 'Bishop versus pawns'), ('Brotherhood', 'Friendly pieces'), ('Cannibal', 'Capture powers'), + ('Capablanca', 'Capablanca Chess'), ('Capture', 'Mandatory captures'), ('Castle', 'Win by castling long'), ('Checkered1', 'Shared pieces (v1)'), @@ -44,6 +47,7 @@ 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'), @@ -60,17 +64,22 @@ insert or ignore into Variants (name, description) values ('Football', 'Score a goal'), ('Forward', 'Moving forward'), ('Freecapture', 'Capture both colors'), + ('Fugue', 'Baroque Music'), ('Fullcavalry', 'Lancers everywhere'), + ('Fusion', 'Fusion pieces (v1)'), ('Grand', 'Big board'), ('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'), + ('Joker', 'Replace pieces'), ('Kinglet', 'Protect your pawns'), + ('Kingsmaker', 'Promote into kings'), ('Knightmate', 'Mate the knight'), ('Knightpawns', 'Knight versus pawns'), ('Knightrelay1', 'Move like a knight (v1)'), @@ -85,10 +94,12 @@ insert or ignore into Variants (name, description) values ('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'), + ('Musketeer', 'New fairy pieces'), ('Omega', 'A wizard in the corner'), ('Orda', 'Mongolian Horde (v1)'), ('Ordamirror', 'Mongolian Horde (v2)'), @@ -110,16 +121,23 @@ insert or ignore into Variants (name, description) values ('Relayup', 'Upgrade pieces'), ('Rifle', 'Shoot pieces'), ('Recycle', 'Reuse pieces'), + ('Refusal', 'Do not play that!'), + ('Rollerball', 'As in the movie'), ('Rococo', 'Capture on the edge'), ('Rookpawns', 'Rook versus pawns'), ('Royalrace', 'Kings cross the 11x11 board'), ('Rugby', 'Transform an essay'), ('Schess', 'Seirawan-Harper Chess'), ('Screen', 'Free initial setup'), + ('Selfabsorption', 'Fusion pieces (v2)'), ('Shako', 'Non-conformism and utopia'), ('Shatranj', 'Ancient rules'), ('Shogi', 'Japanese Chess'), + ('Shogun', 'General''s Chess'), ('Sittuyin', 'Burmese Chess'), + ('Spartan', 'Spartan versus Persians'), + ('Squatter1', 'Squat last rank (v1)'), + ('Squatter2', 'Squat last rank (v2)'), ('Suicide', 'Lose all pieces'), ('Suction', 'Attract opposite king'), ('Swap', 'Dangerous captures'),