X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=13d6594e26c99a8d7fd81efc9866ae85750f7b27;hp=49419674ebecac19458b95686b74daaad34f37a3;hb=2bb4666e276e837add0958554a11b38f7f4d9357;hpb=a0224b03c91dd83a6e133378b85591a1a64e427b diff --git a/server/db/populate.sql b/server/db/populate.sql index 49419674..13d6594e 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -4,6 +4,7 @@ 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); @@ -25,19 +26,23 @@ insert or ignore into Variants (name, description) values ('Benedict', 'Change colors'), ('Berolina', 'Pawns move diagonally'), ('Bicolour', 'Harassed kings'), + ('Bishopawns', 'Bishop versus pawns'), ('Cannibal', 'Capture powers'), ('Capture', 'Mandatory captures'), + ('Castle', 'Win by castling long'), ('Checkered1', 'Shared pieces (v1)'), ('Checkered2', 'Shared pieces (v2)'), ('Checkless', 'No-check mode'), ('Chess960', 'Standard rules'), ('Circular', 'Run forward'), + ('Clorange', 'A Clockwork Orange'), ('Colorbound', 'The colorbound clobberers'), ('Coregal', 'Two royal pieces'), ('Coronation', 'Long live the Queen'), ('Crazyhouse', 'Captures reborn'), ('Cylinder', 'Neverending rows'), ('Diamond', 'Rotating board'), + ('Discoduel', 'Enter the disco'), ('Doublearmy', '64 pieces on the board'), ('Doublemove1', 'Double moves (v1)'), ('Doublemove2', 'Double moves (v2)'), @@ -46,6 +51,8 @@ insert or ignore into Variants (name, description) values ('Enpassant', 'Capture en passant'), ('Extinction', 'Capture all of a kind'), ('Football', 'Score a goal'), + ('Forward', 'Moving forward'), + ('Freecapture', 'Capture both colors'), ('Grand', 'Big board'), ('Grasshopper', 'Long jumps over pieces'), ('Gridolina', 'Jump the borders'), @@ -54,10 +61,13 @@ insert or ignore into Variants (name, description) values ('Interweave', 'Interweaved colorbound teams'), ('Kinglet', 'Protect your pawns'), ('Knightmate', 'Mate the knight'), + ('Knightpawns', 'Knight versus pawns'), ('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'), + ('Madhouse', 'Rearrange enemy pieces'), ('Madrasi', 'Paralyzed pieces'), ('Magnetic', 'Laws of attraction'), ('Makruk', 'Thai Chess'), @@ -66,13 +76,25 @@ insert or ignore into Variants (name, description) values ('Monochrome', 'All of the same color'), ('Monster', 'White move twice'), ('Omega', 'A wizard in the corner'), - ('Orda', 'Mongolian Horde'), + ('Orda', 'Mongolian Horde (v1)'), + ('Ordamirror', 'Mongolian Horde (v2)'), + ('Pacifist1', 'Convert & support (v1)'), + ('Pacifist2', 'Convert & support (v2)'), ('Parachute', 'Landing on the board'), + ('Pawnmassacre', 'Pieces upside down'), + ('Pawns', 'Reach the last rank (v1)'), + ('Pawnsking', 'Reach the last rank (v2)'), ('Perfect', 'Powerful pieces'), + ('Pocketknight', 'Knight in pocket'), + ('Progressive1', 'Play more and more moves (v1)'), + ('Progressive2', 'Play more and more moves (v2)'), + ('Queenpawns', 'Queen versus pawns'), ('Racingkings', 'Kings cross the 8x8 board'), + ('Rampage', 'Move under cover'), ('Rifle', 'Shoot pieces'), ('Recycle', 'Reuse pieces'), ('Rococo', 'Capture on the edge'), + ('Rookpawns', 'Rook versus pawns'), ('Royalrace', 'Kings cross the 11x11 board'), ('Rugby', 'Transform an essay'), ('Schess', 'Seirawan-Harper Chess'), @@ -82,12 +104,15 @@ insert or ignore into Variants (name, description) values ('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'), ('Upsidedown', 'Board upside down'), + ('Vchess', 'Pawns capture backward'), ('Wildebeest', 'Balanced sliders & leapers'), ('Wormhole', 'Squares disappear'), ('Zen', 'Reverse captures');