X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=c496d59efe9923157fe30adfc809de57c4caedb4;hb=10cceb25109739fa39b9b968be2707dee1d25a07;hp=6f67cc11ee2fe0743cc55f43c9060ee8c11dd5ca;hpb=a57faf48c575029ecbba41de0f87bfe11d8c4e4b;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 6f67cc11..c496d59e 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -17,18 +17,16 @@ insert or ignore into Variants (name, description, groupe, display) values ('Alapo', 'Geometric Chess', 27, 'Alapo'), ('Alice', 'Both sides of the mirror', 31, 'Alice Chess'), ('Align4', 'Align four pawns', 31, 'Align4'), - ('Allmate1', 'Mate any piece (v1)', 11, 'Allmate1'), - ('Allmate2', 'Mate any piece (v2)', 11, 'Allmate2'), + ('Allmate', 'Mate any piece', 11, 'Allmate'), ('Ambiguous', 'Play opponent''s pieces', 29, 'Ambiguous'), ('Antiking1', 'Keep antiking in check (v1)', 9, 'Anti-King 1'), ('Antiking2', 'Keep antiking in check (v2)', 9, 'Anti-King 2'), ('Antimatter', 'Dangerous collisions', 18, 'Antimatter'), ('Arena', 'Middle battle', 1, 'Arena'), ('Atarigo', 'First capture wins', 28, 'Atari-Go'), - ('Atomic1', 'Explosive captures (v1)', 18, 'Atomic 1'), - ('Atomic2', 'Explosive captures (v2)', 18, 'Atomic 2'), - ('Avalam1', 'Build towers (v1)', 28, 'Avalam 1'), - ('Avalam2', 'Build towers (v2)', 28, 'Avalam 2'), + ('Atomic', 'Explosive captures', 18, 'Atomic Chess'), + ('Avalam1', 'Build towers (v1)', 28, 'Avalam1'), + ('Avalam2', 'Build towers (v2)', 28, 'Avalam2'), ('Avalanche', 'Pawnfalls', 24, 'Avalanche'), ('Ball', 'Score a goal', 6, 'Ball'), ('Balaklava', 'Meet the Mammoth', 15, 'Balaklava'), @@ -44,13 +42,11 @@ insert or ignore into Variants (name, description, groupe, display) values ('Capablanca', 'Capablanca Chess', 7, 'Capablanca Chess'), ('Capture', 'Mandatory captures', 1, 'Capture'), ('Castle', 'Win by castling long', 27, 'Castle'), - ('Checkered1', 'Shared pieces (v1)', 12, 'Checkered 1'), - ('Checkered2', 'Shared pieces (v2)', 12, 'Checkered 2'), + ('Checkered', 'Shared pieces', 12, 'Checkered'), ('Checkless', 'No-check mode', 18, 'Checkless'), - ('Chess', 'Standard rules', -1, 'Chess'), + ('Chess960', 'Standard rules', -1, 'Chess960'), ('Circular', 'Run forward', 3, 'Circular Chess'), ('Clorange', 'A Clockwork Orange', 20, 'Clockwork Orange'), - ('Colorbound', 'The colorbound clobberers', 5, 'Colorbound Clobberers'), ('Convert', 'Convert enemy pieces', 12, 'Convert'), ('Copycat', 'Borrow powers', 30, 'Copycat'), ('Coregal', 'Two royal pieces', 9, 'Coregal'), @@ -58,6 +54,7 @@ insert or ignore into Variants (name, description, groupe, display) values ('Crazyhouse', 'Captures reborn', 20, 'Crazyhouse'), ('Crossing', 'Cross the river', 27, 'Crossing'), ('Cylinder', 'Neverending rows', 3, 'Cylindrical Chess'), + ('Cwda', 'New teams', 5, 'Different armies'), ('Diamond', 'Rotating board', 4, 'Diamond'), ('Discoduel', 'Enter the disco', 0, 'Disco Duel'), ('Dobutsu', 'Let''s catch the Lion!', 0, 'Dobutsu'), @@ -65,7 +62,7 @@ insert or ignore into Variants (name, description, groupe, display) values ('Doublemove1', 'Double moves (v1)', 24, 'Doublemove 1'), ('Doublemove2', 'Double moves (v2)', 24, 'Doublemove 2'), ('Dynamo', 'Push and pull', 11, 'Dynamo'), - ('Eightpieces', 'Each piece is unique', 7, '8 pieces'), + ('Eightpieces', 'Each piece is unique', 7, '8-Pieces'), ('Emergo', 'Stacking Checkers variant', 28, 'Emergo'), ('Empire', 'Empire versus Kingdom', 5, 'Empire Chess'), ('Enpassant', 'Capture en passant', 10, 'En-passant'),