X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=13a4fb8ad78aa755b7f876b75c0322638e55d390;hb=fbc3e6f984492143625e438436f9c0a94e42c713;hp=f9c9a332fff437ada754f0197c42ba942550f7c8;hpb=1006b211894bdc0624e2fd332ac78322bf8ca0ee;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index f9c9a332..13a4fb8a 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -14,6 +14,7 @@ insert or ignore into Variants (name, description) values ('Absorption', 'Absorb powers'), ('Alapo', 'Geometric Chess'), ('Alice', 'Both sides of the mirror'), + ('Align4', 'Align four pawns'), ('Allmate1', 'Mate any piece (v1)'), ('Allmate2', 'Mate any piece (v2)'), ('Ambiguous', 'Play opponent''s pieces'), @@ -36,7 +37,8 @@ insert or ignore into Variants (name, description) values ('Bicolour', 'Harassed kings'), ('Bishopawns', 'Bishop versus pawns'), ('Brotherhood', 'Friendly pieces'), - ('Cannibal', 'Capture powers'), + ('Cannibal1', 'Capture powers (v1)'), + ('Cannibal2', 'Capture powers (v2)'), ('Capablanca', 'Capablanca Chess'), ('Capture', 'Mandatory captures'), ('Castle', 'Win by castling long'), @@ -48,6 +50,7 @@ insert or ignore into Variants (name, description) values ('Clorange', 'A Clockwork Orange'), ('Colorbound', 'The colorbound clobberers'), ('Convert', 'Convert enemy pieces'), + ('Copycat', 'Borrow powers'), ('Coregal', 'Two royal pieces'), ('Coronation', 'Long live the Queen'), ('Crazyhouse', 'Captures reborn'), @@ -86,9 +89,11 @@ insert or ignore into Variants (name, description) values ('Isardam', 'No paralyzed pieces'), ('Janggi', 'Korean Chess'), ('Joker', 'Replace pieces'), + ('Karouk', 'Thai Chess (v3)'), ('Kinglet', 'Protect your pawns'), ('Kingsmaker', 'Promote into kings'), - ('Knightmate', 'Mate the knight'), + ('Knightmate1', 'Mate the knight (v1)'), + ('Knightmate2', 'Mate the knight (v2)'), ('Knightpawns', 'Knight versus pawns'), ('Knightrelay1', 'Move like a knight (v1)'), ('Knightrelay2', 'Move like a knight (v2)'), @@ -106,9 +111,10 @@ insert or ignore into Variants (name, description) values ('Mesmer', 'Mind control (v2)'), ('Minishogi', 'Shogi 5 x 5'), ('Minixiangqi', 'Xiangqi 7 x 7'), - ('Monochrome', 'All of the same color'), + ('Monocolor', 'All of the same color'), ('Monster', 'White move twice'), ('Musketeer', 'New fairy pieces'), + ('Newzealand', 'Kniros and Rosknis'), ('Omega', 'A wizard in the corner'), ('Orda', 'Mongolian Horde (v1)'), ('Ordamirror', 'Mongolian Horde (v2)'), @@ -116,6 +122,7 @@ insert or ignore into Variants (name, description) values ('Pacifist1', 'Convert & support (v1)'), ('Pacifist2', 'Convert & support (v2)'), ('Pacosako', 'Dance with the King'), + ('Pandemonium', 'Noise and confusion'), ('Parachute', 'Landing on the board'), ('Pawnmassacre', 'Pieces upside down'), ('Pawns', 'Reach the last rank (v1)'), @@ -130,7 +137,8 @@ insert or ignore into Variants (name, description) values ('Relayup', 'Upgrade pieces'), ('Rifle', 'Shoot pieces'), ('Recycle', 'Reuse pieces'), - ('Refusal', 'Do not play that!'), + ('Refusal1', 'Do not play that! (v1)'), + ('Refusal2', 'Do not play that! (v2)'), ('Rollerball', 'As in the movie'), ('Rococo', 'Capture on the edge'), ('Rookpawns', 'Rook versus pawns'), @@ -141,19 +149,22 @@ insert or ignore into Variants (name, description) values ('Selfabsorb', 'Fusion pieces (v2)'), ('Shako', 'Non-conformism and utopia'), ('Shatranj', 'Ancient rules'), + ('Shinobi', 'A story of invasion'), ('Shogi', 'Japanese Chess'), ('Shogun', 'General''s Chess'), ('Sittuyin', 'Burmese Chess'), ('Spartan', 'Spartan versus Persians'), ('Squatter1', 'Squat last rank (v1)'), ('Squatter2', 'Squat last rank (v2)'), + ('Stealthbomb', 'Beware the bomb'), ('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'), + ('Teleport1', 'Reposition pieces (v1)'), + ('Teleport2', 'Reposition pieces (v2)'), ('Tencubed', 'Four new pieces'), ('Threechecks', 'Give three checks'), ('Titan', 'Extra bishops and knights'),