X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fpopulate.sql;h=147868d98452b56d20318208cd3bcca569705840;hb=f9385686d9434c607cdaa55e41a0425269db0815;hp=1895777339e1a0bd9f27e93c2ffec2c90d5991a8;hpb=0d5335de5c94d780e03ac0aa3279b731c69455cc;p=vchess.git diff --git a/server/db/populate.sql b/server/db/populate.sql index 18957773..147868d9 100644 --- a/server/db/populate.sql +++ b/server/db/populate.sql @@ -1,6 +1,13 @@ -- Re-run this script after variants are added -insert or ignore into Variants (name,description) values +insert or ignore into Variants (name, description, noProblems) values + ('Apocalypse', 'The end of the world', true), + ('Dark', 'In the shadow', true), + ('Hidden', 'Unidentified pieces', true), + ('Hiddenqueen', 'Queen disguised as a pawn', true), + ('Synchrone', 'Play at the same time', true); + +insert or ignore into Variants (name, description) values ('Alice', 'Both sides of the mirror'), ('Allmate1', 'Mate any piece (v1)'), ('Allmate2', 'Mate any piece (v2)'), @@ -22,21 +29,21 @@ insert or ignore into Variants (name,description) values ('Coregal', 'Two royal pieces'), ('Crazyhouse', 'Captures reborn'), ('Cylinder', 'Neverending rows'), - ('Dark', 'In the shadow'), ('Doublearmy', '64 pieces on the board'), + ('Dynamo', 'Push and pull'), ('Eightpieces', 'Each piece is unique'), ('Enpassant', 'Capture en passant'), ('Extinction', 'Capture all of a kind'), ('Grand', 'Big board'), ('Grasshopper', 'Long jumps over pieces'), - ('Hidden', 'Unidentified pieces'), - ('Hiddenqueen', 'Queen disguised as a pawn'), + ('Horde', 'A pawns cloud'), ('Knightmate', 'Mate the knight'), ('Knightrelay1', 'Move like a knight (v1)'), ('Knightrelay2', 'Move like a knight (v2)'), ('Losers', 'Get strong at self-mate'), ('Magnetic', 'Laws of attraction'), ('Marseille', 'Move twice'), + ('Orda', 'Mongolian Horde'), ('Parachute', 'Landing on the board'), ('Perfect', 'Powerful pieces'), ('Racingkings', 'Kings cross the 8x8 board'), @@ -48,7 +55,6 @@ insert or ignore into Variants (name,description) values ('Shatranj', 'Ancient rules'), ('Suicide', 'Lose all pieces'), ('Suction', 'Attract opposite king'), - ('Synchrone', 'Play at the same time'), ('Threechecks', 'Give three checks'), ('Twokings', 'Two kings'), ('Upsidedown', 'Board upside down'),