X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=2959557140724112dc5991b7006e576830665f13;hp=e9cf921ff21687e532e2c72ac167e19641fcd82f;hb=e88d69a8735e334b681cdad380af53e2ff574d1f;hpb=b406466b0f0ce67451f1718053e5f5691d6507fb diff --git a/server/db/populate.sql b/server/db/populate.sql index e9cf921f..29595571 100644 --- 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), + ('Chakart', 'Capture the princess', 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 + ('Absorption', 'Absorb powers'), ('Alice', 'Both sides of the mirror'), ('Allmate1', 'Mate any piece (v1)'), ('Allmate2', 'Mate any piece (v2)'), @@ -18,9 +21,11 @@ insert or ignore into Variants (name, description) values ('Arena', 'Middle battle'), ('Atomic', 'Explosive captures'), ('Ball', 'Score a goal'), + ('Balaklava', 'Meet the Mammoth'), ('Baroque', 'Exotic captures'), ('Benedict', 'Change colors'), ('Berolina', 'Pawns move diagonally'), + ('Bicolour', 'Harassed kings'), ('Cannibal', 'Capture powers'), ('Capture', 'Mandatory captures'), ('Checkered1', 'Shared pieces (v1)'), @@ -30,8 +35,10 @@ insert or ignore into Variants (name, description) values ('Circular', 'Run forward'), ('Colorbound', 'The colorbound clobberers'), ('Coregal', 'Two royal pieces'), + ('Coronation', 'Long live the Queen'), ('Crazyhouse', 'Captures reborn'), ('Cylinder', 'Neverending rows'), + ('Diamond', 'Rotating board'), ('Doublearmy', '64 pieces on the board'), ('Doublemove1', 'Double moves (v1)'), ('Doublemove2', 'Double moves (v2)'), @@ -39,33 +46,53 @@ insert or ignore into Variants (name, description) values ('Eightpieces', 'Each piece is unique'), ('Enpassant', 'Capture en passant'), ('Extinction', 'Capture all of a kind'), + ('Football', 'Score a goal'), + ('Freecapture', 'Capture both colors'), ('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'), + ('Kinglet', 'Protect your pawns'), ('Knightmate', 'Mate the knight'), ('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'), + ('Madrasi', 'Paralyzed pieces'), ('Magnetic', 'Laws of attraction'), + ('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'), + ('Pacifist1', 'Convert & support (v1)'), + ('Pacifist2', 'Convert & support (v2)'), ('Parachute', 'Landing on the board'), + ('Pawns', 'Reach the last rank'), ('Perfect', 'Powerful pieces'), ('Racingkings', 'Kings cross the 8x8 board'), + ('Rampage', 'Move under cover'), ('Rifle', 'Shoot 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'), + ('Shogi', 'Japanese Chess'), ('Sittuyin', 'Burmese chess'), ('Suicide', 'Lose all pieces'), ('Suction', 'Attract opposite king'), + ('Swap', 'Dangerous captures'), + ('Switching', 'Exchange pieces'' positions'), ('Takenmake', 'Prolongated captures'), + ('Teleport', 'Reposition pieces'), ('Tencubed', 'Four new pieces'), ('Threechecks', 'Give three checks'), ('Twokings', 'Two kings'),