X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=56571e5613f2100a50c02e3a6bfecc3ee254157d;hb=6c00a6e55209930057bcf040cf444f40e7d47030;hp=17fe0d0fcee0659ed82e9efa779d0aeb7b50f60c;hpb=4258b58c6aff86ce69ebfbcd40d704836df27ac9;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 17fe0d0f..56571e56 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'), @@ -29,6 +30,7 @@ insert or ignore into Variants (name, description) values ('Berolina', 'Pawns move diagonally'), ('Bicolour', 'Harassed kings'), ('Bishopawns', 'Bishop versus pawns'), + ('Brotherhood', 'Friendly pieces'), ('Cannibal', 'Capture powers'), ('Capture', 'Mandatory captures'), ('Castle', 'Win by castling long'), @@ -45,6 +47,7 @@ insert or ignore into Variants (name, description) values ('Cylinder', 'Neverending rows'), ('Diamond', 'Rotating board'), ('Discoduel', 'Enter the disco'), + ('Dobutsu', 'Let''s catch the Lion!'), ('Doublearmy', '64 pieces on the board'), ('Doublemove1', 'Double moves (v1)'), ('Doublemove2', 'Double moves (v2)'), @@ -78,6 +81,7 @@ insert or ignore into Variants (name, description) values ('Madhouse', 'Rearrange enemy pieces'), ('Madrasi', 'Paralyzed pieces'), ('Magnetic', 'Laws of attraction'), + ('Maharajah', 'Augmented Queens'), ('Makpong', 'Thai Chess (v2)'), ('Makruk', 'Thai Chess (v1)'), ('Maxima', 'Occupy the enemy palace'), @@ -88,6 +92,7 @@ insert or ignore into Variants (name, description) values ('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'), @@ -109,6 +114,7 @@ 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'),