X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=51dae3fecdf398708fe72f55a9afc9435426e7b9;hb=236485b53993f2adfd588022e2899a39491fc825;hp=33d5d2e03da1e1c4327488c9776a7eae39e3c068;hpb=602d6befd30793111d3fda6e733f73e08d8b7a30;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 33d5d2e0..51dae3fe 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -1,21 +1,83 @@ -- Re-run this script after variants are added -insert or ignore into Variants (name,description) values +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'), - ('Antiking', 'Keep antiking in check'), + ('Allmate1', 'Mate any piece (v1)'), + ('Allmate2', 'Mate any piece (v2)'), + ('Ambiguous', 'Play opponent''s pieces'), + ('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'), - ('Checkered', 'Shared pieces'), + ('Cannibal', 'Capture powers'), + ('Capture', 'Mandatory captures'), + ('Checkered1', 'Shared pieces (v1)'), + ('Checkered2', 'Shared pieces (v2)'), + ('Checkless', 'No-check mode'), ('Chess960', 'Standard rules'), + ('Circular', 'Run forward'), + ('Colorbound', 'The colorbound clobberers'), + ('Coregal', 'Two royal pieces'), ('Crazyhouse', 'Captures reborn'), - ('Dark', 'In the shadow'), + ('Cylinder', 'Neverending rows'), + ('Diamond', 'Rotating board'), + ('Doublearmy', '64 pieces on the board'), + ('Doublemove1', 'Double moves (v1)'), + ('Doublemove2', 'Double moves (v2)'), + ('Dynamo', 'Push and pull'), + ('Eightpieces', 'Each piece is unique'), + ('Enpassant', 'Capture en passant'), ('Extinction', 'Capture all of a kind'), ('Grand', 'Big board'), - ('Losers', 'Lose all pieces'), + ('Grasshopper', 'Long jumps over pieces'), + ('Hamilton', 'Walk on a graph'), + ('Horde', 'A pawns cloud'), + ('Interweave', 'Interweaved colorbound teams'), + ('Knightmate', 'Mate the knight'), + ('Knightrelay1', 'Move like a knight (v1)'), + ('Knightrelay2', 'Move like a knight (v2)'), + ('Koth', 'King of the Hill'), + ('Losers', 'Get strong at self-mate'), ('Magnetic', 'Laws of attraction'), - ('Marseille', 'Move twice'), - ('Switching', 'Exchange pieces positions'), + ('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'), + ('Parachute', 'Landing on the board'), + ('Perfect', 'Powerful pieces'), + ('Racingkings', 'Kings cross the 8x8 board'), + ('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'), + ('Takenmake', 'Prolongated captures'), + ('Tencubed', 'Four new pieces'), + ('Threechecks', 'Give three checks'), + ('Twokings', 'Two kings'), ('Upsidedown', 'Board upside down'), ('Wildebeest', 'Balanced sliders & leapers'), + ('Wormhole', 'Squares disappear'), ('Zen', 'Reverse captures');