X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=be0f09bccc971f6acc7b41300e20c7a9b36216bc;hb=2fac4d67083700a1f1e85ed8662c176c24cdea6b;hp=e1156e5d29b5c5ea45816e9c8a847ed6ae021bde;hpb=39fe711a185ee73c907f3d61ddd459a33f40696b;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index e1156e5d..be0f09bc 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -7,10 +7,12 @@ 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'), + ('Alapo', 'Geometric Chess'), ('Alice', 'Both sides of the mirror'), ('Allmate1', 'Mate any piece (v1)'), ('Allmate2', 'Mate any piece (v2)'), @@ -29,6 +31,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'), @@ -42,9 +45,11 @@ insert or ignore into Variants (name, description) values ('Coregal', 'Two royal pieces'), ('Coronation', 'Long live the Queen'), ('Crazyhouse', 'Captures reborn'), + ('Crossing', 'Cross the river'), ('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)'), @@ -64,10 +69,12 @@ insert or ignore into Variants (name, description) values ('Hamilton', 'Walk on a graph'), ('Hoppelpoppel', 'Knibis and Bisknis'), ('Horde', 'A pawns cloud'), + ('Hypnotic', 'Mind control (v1)'), ('Interweave', 'Interweaved colorbound teams'), ('Isardam', 'No paralyzed pieces'), ('Janggi', 'Korean Chess'), ('Kinglet', 'Protect your pawns'), + ('Kingsmaker', 'Promote into kings'), ('Knightmate', 'Mate the knight'), ('Knightpawns', 'Knight versus pawns'), ('Knightrelay1', 'Move like a knight (v1)'), @@ -78,9 +85,11 @@ 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'), + ('Mesmer', 'Mind control (v2)'), ('Minishogi', 'Shogi 5 x 5'), ('Minixiangqi', 'Xiangqi 7 x 7'), ('Monochrome', 'All of the same color'), @@ -88,6 +97,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'), @@ -102,6 +112,7 @@ insert or ignore into Variants (name, description) values ('Queenpawns', 'Queen versus pawns'), ('Racingkings', 'Kings cross the 8x8 board'), ('Rampage', 'Move under cover'), + ('Relayup', 'Upgrade pieces'), ('Rifle', 'Shoot pieces'), ('Recycle', 'Reuse pieces'), ('Rococo', 'Capture on the edge'), @@ -114,6 +125,7 @@ insert or ignore into Variants (name, description) values ('Shatranj', 'Ancient rules'), ('Shogi', 'Japanese Chess'), ('Sittuyin', 'Burmese Chess'), + ('Squatter', 'Squat last rank'), ('Suicide', 'Lose all pieces'), ('Suction', 'Attract opposite king'), ('Swap', 'Dangerous captures'),