X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=83ba4cc097408b1b9a34c8f40d70fcc4bdcc9df6;hb=5e1bc6519d4c81aeac40aec7390c64c913cbf566;hp=4659704f6fd23e29939b16292f0fae00bc384b6f;hpb=625022fdcf750f0aff8fcd699f7e9b89730e1d10;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 4659704f..83ba4cc0 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -1,21 +1,64 @@ -- Re-run this script after variants are added -insert or ignore into Variants (name,description) values - ('Alice', 'Both sides of the mirror'), - ('Antiking', 'Keep antiking in check'), - ('Atomic', 'Explosive captures'), - ('Baroque', 'Exotic captures'), - ('Berolina', 'Pawns move diagonally'), - ('Checkered', 'Shared pieces'), - ('Chess960', 'Standard rules'), - ('Crazyhouse', 'Captures reborn'), - ('Dark', 'In the shadow'), - ('Extinction', 'Capture all of a kind'), - ('Grand', 'Big board'), - ('Losers', 'Lose all pieces'), - ('Magnetic', 'Laws of attraction'), - ('Marseille', 'Move twice'), - ('Switching', 'Exchange pieces positions'), - ('Upsidedown', 'Head upside down'), - ('Wildebeest', 'Balanced sliders & leapers'), - ('Zen', 'Reverse captures'); +insert or ignore into Variants (name, description, noProblems) values + ('Apocalypse', 'The end of the world', true), + ('Dark', 'In the shadow', 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 + ('Alice', 'Both sides of the mirror'), + ('Allmate1', 'Mate any piece (v1)'), + ('Allmate2', 'Mate any piece (v2)'), + ('Antiking1', 'Keep antiking in check (v1)'), + ('Antiking2', 'Keep antiking in check (v2)'), + ('Antimatter', 'Dangerous collisions'), + ('Arena', 'Middle battle'), + ('Atomic', 'Explosive captures'), + ('Ball', 'Score a goal'), + ('Baroque', 'Exotic captures'), + ('Benedict', 'Change colors'), + ('Berolina', 'Pawns move diagonally'), + ('Cannibal', 'Capture powers'), + ('Capture', 'Mandatory captures'), + ('Checkered', 'Shared pieces'), + ('Checkless', 'No-check mode'), + ('Chess960', 'Standard rules'), + ('Circular', 'Run forward'), + ('Coregal', 'Two royal pieces'), + ('Crazyhouse', 'Captures reborn'), + ('Cylinder', 'Neverending rows'), + ('Doublearmy', '64 pieces on the board'), + ('Dynamo', 'Push and pull'), + ('Eightpieces', 'Each piece is unique'), + ('Enpassant', 'Capture en passant'), + ('Extinction', 'Capture all of a kind'), + ('Grand', 'Big board'), + ('Grasshopper', 'Long jumps over pieces'), + ('Horde', 'A pawns cloud'), + ('Knightmate', 'Mate the knight'), + ('Knightrelay1', 'Move like a knight (v1)'), + ('Knightrelay2', 'Move like a knight (v2)'), + ('Losers', 'Get strong at self-mate'), + ('Magnetic', 'Laws of attraction'), + ('Marseille', 'Double moves'), + ('Monster', 'White move twice'), + ('Orda', 'Mongolian Horde'), + ('Parachute', 'Landing on the board'), + ('Perfect', 'Powerful pieces'), + ('Racingkings', 'Kings cross the 8x8 board'), + ('Rifle', 'Shoot pieces'), + ('Recycle', 'Reuse pieces'), + ('Royalrace', 'Kings cross the 11x11 board'), + ('Rugby', 'Transform an essay'), + ('Schess', 'Seirawan-Harper Chess'), + ('Shatranj', 'Ancient rules'), + ('Suicide', 'Lose all pieces'), + ('Suction', 'Attract opposite king'), + ('Threechecks', 'Give three checks'), + ('Twokings', 'Two kings'), + ('Upsidedown', 'Board upside down'), + ('Wildebeest', 'Balanced sliders & leapers'), + ('Wormhole', 'Squares disappear'), + ('Zen', 'Reverse captures');