X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=21f7c7a85bfe8a6dd9b993ed59c0c4321b8ec734;hb=59e74176f5e2e828ce0b81c2ead6f8cdb0654f69;hp=52c043cb5efc7dde4688a61cc73cd7d56e3bc2b5;hpb=c7550017d88ff6eb32e2c76a271a7f9edc4a3bf6;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 52c043cb..21f7c7a8 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -1,9 +1,17 @@ -- 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'), ('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'), @@ -15,42 +23,57 @@ insert or ignore into Variants (name,description) values ('Berolina', 'Pawns move diagonally'), ('Cannibal', 'Capture powers'), ('Capture', 'Mandatory captures'), - ('Checkered', 'Shared pieces'), + ('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'), ('Cylinder', 'Neverending rows'), - ('Dark', 'In the shadow'), + ('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'), ('Grasshopper', 'Long jumps over pieces'), - ('Hidden', 'Unidentified pieces'), - ('Hiddenqueen', 'Queen disguised as a pawn'), + ('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)'), ('Losers', 'Get strong at self-mate'), ('Magnetic', 'Laws of attraction'), - ('Marseille', 'Move twice'), + ('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'), - ('Synchrone', 'Play at the same time'), + ('Takenmake', 'Prolongated captures'), + ('Tencubed', 'Four new pieces'), ('Threechecks', 'Give three checks'), ('Twokings', 'Two kings'), ('Upsidedown', 'Board upside down'),