X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=563477200101308cad28c57e5b6a47ccc9cb13da;hb=b21e0e3a8f4af5c04b39c034d13bbb4e1e2abf18;hp=5322ce99621a3ab28baebfbb8718795d708e456e;hpb=e023d74715d327ebd7623079cb778b0def0a1464;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 5322ce99..56347720 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'), @@ -21,8 +22,11 @@ insert or ignore into Variants (name, description) values ('Antiking2', 'Keep antiking in check (v2)'), ('Antimatter', 'Dangerous collisions'), ('Arena', 'Middle battle'), + ('Atarigo', 'First capture wins'), ('Atomic1', 'Explosive captures (v1)'), ('Atomic2', 'Explosive captures (v2)'), + ('Avalam1', 'Build towers (v1)'), + ('Avalam2', 'Build towers (v2)'), ('Avalanche', 'Pawnfalls'), ('Ball', 'Score a goal'), ('Balaklava', 'Meet the Mammoth'), @@ -44,6 +48,8 @@ insert or ignore into Variants (name, description) values ('Circular', 'Run forward'), ('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'), @@ -57,16 +63,19 @@ insert or ignore into Variants (name, description) values ('Doublemove2', 'Double moves (v2)'), ('Dynamo', 'Push and pull'), ('Eightpieces', 'Each piece is unique'), + ('Emergo', 'Stacking Checkers variant'), ('Empire', 'Empire versus Kingdom'), ('Enpassant', 'Capture en passant'), ('Evolution', 'Faster development'), ('Extinction', 'Capture all of a kind'), + ('Fanorona', 'Malagasy Draughts'), ('Football', 'Score a goal'), ('Forward', 'Moving forward'), ('Freecapture', 'Capture both colors'), ('Fugue', 'Baroque Music'), ('Fullcavalry', 'Lancers everywhere'), ('Fusion', 'Fusion pieces (v1)'), + ('Gomoku', 'Align five stones'), ('Grand', 'Big board'), ('Grasshopper', 'Long jumps over pieces'), ('Gridolina', 'Jump the borders'), @@ -74,16 +83,19 @@ insert or ignore into Variants (name, description) values ('Hoppelpoppel', 'Knibis and Bisknis'), ('Horde', 'A pawns cloud'), ('Hypnotic', 'Mind control (v1)'), + ('Iceage', 'Ice Age is coming!'), ('Interweave', 'Interweaved colorbound teams'), ('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'), ('Knightpawns', 'Knight versus pawns'), ('Knightrelay1', 'Move like a knight (v1)'), ('Knightrelay2', 'Move like a knight (v2)'), + ('Konane', 'Hawaiian Checkers'), ('Koopa', 'Stun & kick pieces'), ('Koth', 'King of the Hill'), ('Losers', 'Get strong at self-mate'), @@ -107,6 +119,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)'), @@ -121,7 +134,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'), @@ -129,7 +143,7 @@ insert or ignore into Variants (name, description) values ('Rugby', 'Transform an essay'), ('Schess', 'Seirawan-Harper Chess'), ('Screen', 'Free initial setup'), - ('Selfabsorption', 'Fusion pieces (v2)'), + ('Selfabsorb', 'Fusion pieces (v2)'), ('Shako', 'Non-conformism and utopia'), ('Shatranj', 'Ancient rules'), ('Shogi', 'Japanese Chess'), @@ -152,6 +166,8 @@ insert or ignore into Variants (name, description) values ('Upsidedown', 'Board upside down'), ('Vchess', 'Pawns capture backward'), ('Wildebeest', 'Balanced sliders & leapers'), - ('Wormhole', 'Squares disappear'), + ('Wormhole1', 'Squares disappear (v1)'), + ('Wormhole2', 'Squares disappear (v2)'), ('Xiangqi', 'Chinese Chess'), + ('Yote', 'African Draughts'), ('Zen', 'Reverse captures');