X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=88a9003f0f02d29dd4db2e0d4600ecdb26416547;hb=9d15c433c207a2c3bb548d095939c3e08b4038fd;hp=7def7a625ffd3d52d9a019cde87df7947518737e;hpb=0fb43db7c2858201e8410670b90f95ad8b138964;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 7def7a62..88a9003f 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -7,7 +7,8 @@ insert or ignore into Variants (name, description, noProblems) values ('Dice', 'Roll the dice', true), ('Hidden', 'Unidentified pieces', true), ('Hiddenqueen', 'Queen disguised as a pawn', true), - ('Synchrone', 'Play at the same time', true); + ('Synchrone1', 'Play at the same time (v1)', true); + ('Synchrone2', 'Play at the same time (v2)', true); insert or ignore into Variants (name, description) values ('Absorption', 'Absorb powers'), @@ -21,6 +22,7 @@ insert or ignore into Variants (name, description) values ('Arena', 'Middle battle'), ('Atomic1', 'Explosive captures (v1)'), ('Atomic2', 'Explosive captures (v2)'), + ('Avalanche', 'Pawnfalls'), ('Ball', 'Score a goal'), ('Balaklava', 'Meet the Mammoth'), ('Baroque', 'Exotic captures'), @@ -49,6 +51,7 @@ insert or ignore into Variants (name, description) values ('Doublemove2', 'Double moves (v2)'), ('Dynamo', 'Push and pull'), ('Eightpieces', 'Each piece is unique'), + ('Empire', 'Empire versus Kingdom'), ('Enpassant', 'Capture en passant'), ('Evolution', 'Faster development'), ('Extinction', 'Capture all of a kind'), @@ -60,8 +63,11 @@ insert or ignore into Variants (name, description) values ('Grasshopper', 'Long jumps over pieces'), ('Gridolina', 'Jump the borders'), ('Hamilton', 'Walk on a graph'), + ('Hoppelpoppel', 'Knibis and Bisknis'), ('Horde', 'A pawns cloud'), ('Interweave', 'Interweaved colorbound teams'), + ('Isardam', 'No paralyzed pieces'), + ('Janggi', 'Korean Chess'), ('Kinglet', 'Protect your pawns'), ('Knightmate', 'Mate the knight'), ('Knightpawns', 'Knight versus pawns'), @@ -73,16 +79,20 @@ insert or ignore into Variants (name, description) values ('Madhouse', 'Rearrange enemy pieces'), ('Madrasi', 'Paralyzed pieces'), ('Magnetic', 'Laws of attraction'), - ('Makruk', 'Thai Chess'), + ('Makpong', 'Thai Chess (v2)'), + ('Makruk', 'Thai Chess (v1)'), ('Maxima', 'Occupy the enemy palace'), ('Minishogi', 'Shogi 5 x 5'), + ('Minixiangqi', 'Xiangqi 7 x 7'), ('Monochrome', 'All of the same color'), ('Monster', 'White move twice'), ('Omega', 'A wizard in the corner'), ('Orda', 'Mongolian Horde (v1)'), ('Ordamirror', 'Mongolian Horde (v2)'), + ('Otage', 'Capture and release hostages'), ('Pacifist1', 'Convert & support (v1)'), ('Pacifist2', 'Convert & support (v2)'), + ('Pacosako', 'Dance with the King'), ('Parachute', 'Landing on the board'), ('Pawnmassacre', 'Pieces upside down'), ('Pawns', 'Reach the last rank (v1)'), @@ -101,14 +111,16 @@ insert or ignore into Variants (name, description) values ('Royalrace', 'Kings cross the 11x11 board'), ('Rugby', 'Transform an essay'), ('Schess', 'Seirawan-Harper Chess'), + ('Screen', 'Free initial setup'), ('Shako', 'Non-conformism and utopia'), ('Shatranj', 'Ancient rules'), ('Shogi', 'Japanese Chess'), - ('Sittuyin', 'Burmese chess'), + ('Sittuyin', 'Burmese Chess'), ('Suicide', 'Lose all pieces'), ('Suction', 'Attract opposite king'), ('Swap', 'Dangerous captures'), ('Switching', 'Exchange pieces'' positions'), + ('Synochess', 'Dynasty versus Kingdom'), ('Takenmake', 'Prolongated captures'), ('Teleport', 'Reposition pieces'), ('Tencubed', 'Four new pieces'), @@ -119,4 +131,5 @@ insert or ignore into Variants (name, description) values ('Vchess', 'Pawns capture backward'), ('Wildebeest', 'Balanced sliders & leapers'), ('Wormhole', 'Squares disappear'), + ('Xiangqi', 'Chinese Chess'), ('Zen', 'Reverse captures');