X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=a44a3ab57d1c748cc7d16ccb46eea48e5a7ebe24;hb=a9e1202b681d9d2f814767180183a0b04c58f8ab;hp=51e1a225775084ca203ab2508f37a48f24bc7518;hpb=57078452549f252460d45e91b84c7eea40dd3e9c;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 51e1a225..a44a3ab5 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); @@ -20,6 +21,7 @@ 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'), @@ -31,6 +33,7 @@ insert or ignore into Variants (name, description) values ('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'), @@ -45,6 +48,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'), @@ -55,8 +60,10 @@ insert or ignore into Variants (name, description) values ('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'), + ('Madhouse', 'Rearrange enemy pieces'), ('Madrasi', 'Paralyzed pieces'), ('Magnetic', 'Laws of attraction'), ('Makruk', 'Thai Chess'), @@ -65,10 +72,16 @@ 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'), + ('Pawns', 'Reach the last rank'), ('Perfect', 'Powerful pieces'), + ('Pocketknight', 'Knight in pocket'), ('Racingkings', 'Kings cross the 8x8 board'), + ('Rampage', 'Move under cover'), ('Rifle', 'Shoot pieces'), ('Recycle', 'Reuse pieces'), ('Rococo', 'Capture on the edge'), @@ -81,6 +94,8 @@ 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'),