server/db/populate.sql

   1 -- Re-run this script after variants are added
   2
   3 insert or ignore into Variants (name, description, noProblems, groupe, display) values
   4   ('Apocalypse', 'The end of the world', true, 13, 'Apocalypse'),
   5   ('Chakart', 'Capture the princess', true, 14, 'Chakart'),
   6   ('Dark', 'In the shadow', true, 13, 'Dark Chess'),
   7   ('Dice', 'Roll the dice', true, 14, 'Dice Chess'),
   8   ('Hidden', 'Unidentified pieces', true, 13, 'Strate-Go'),
   9   ('Hiddenqueen', 'Queen disguised as a pawn', true, 13, 'Hidden Queen'),
  10   ('Stealthbomb1', 'Beware the bomb (v1)', true, 13, 'Stealth Bomb 1'),
  11   ('Stealthbomb2', 'Beware the bomb (v2)', true, 13, 'Stealth Bomb 2'),
  12   ('Synchrone1', 'Play at the same time (v1)', true, 13, 'Synchrone 1'),
  13   ('Synchrone2', 'Play at the same time (v2)', true, 13, 'Synchrone 2');
  14
  15 insert or ignore into Variants (name, description, groupe, display) values
  16   ('Absorption', 'Absorb powers', 2, 'Absorption'),
  17   ('Alapo', 'Geometric Chess', 27, 'Alapo'),
  18   ('Alice', 'Both sides of the mirror', 31, 'Alice Chess'),
  19   ('Align4', 'Align four pawns', 31, 'Align4'),
  20   ('Allmate', 'Mate any piece', 11, 'Allmate'),
  21   ('Ambiguous', 'Play opponent''s pieces', 29, 'Ambiguous'),
  22   ('Antiking1', 'Keep antiking in check (v1)', 9, 'Anti-King 1'),
  23   ('Antiking2', 'Keep antiking in check (v2)', 9, 'Anti-King 2'),
  24   ('Antimatter', 'Dangerous collisions', 18, 'Antimatter'),
  25   ('Arena', 'Middle battle', 1, 'Arena'),
  26   ('Atarigo', 'First capture wins', 28, 'Atari-Go'),
  27   ('Atomic', 'Explosive captures', 18, 'Atomic Chess'),
  28   ('Avalam1', 'Build towers (v1)', 28, 'Avalam1'),
  29   ('Avalam2', 'Build towers (v2)', 28, 'Avalam2'),
  30   ('Avalanche', 'Pawnfalls', 24, 'Avalanche'),
  31   ('Ball', 'Score a goal', 6, 'Ball'),
  32   ('Balaklava', 'Meet the Mammoth', 15, 'Balaklava'),
  33   ('Bario', 'A quantum story', 31, 'Bario'),
  34   ('Baroque', 'Exotic captures', 11, 'Baroque'),
  35   ('Benedict', 'Change colors', 12, 'Benedict'),
  36   ('Berolina', 'Pawns move diagonally', 4, 'Berolina'),
  37   ('Bicolour', 'Harassed kings', 31, 'Bicolour'),
  38   ('Bishopawns', 'Bishop versus pawns', 0, 'Bishop-Pawns'),
  39   ('Brotherhood', 'Friendly pieces', 18, 'Brotherhood'),
  40   ('Cannibal1', 'Capture powers (v1)', 2, 'Cannibal 1'),
  41   ('Cannibal2', 'Capture powers (v2)', 2, 'Cannibal 2'),
  42   ('Capablanca', 'Capablanca Chess', 7, 'Capablanca Chess'),
  43   ('Capture', 'Mandatory captures', 1, 'Capture'),
  44   ('Castle', 'Win by castling long', 27, 'Castle'),
  45   ('Checkered', 'Shared pieces', 12, 'Checkered'),
  46   ('Checkless', 'No-check mode', 18, 'Checkless'),
  47   ('Chess960', 'Standard rules', -1, 'Chess960'),
  48   ('Circular', 'Run forward', 3, 'Circular Chess'),
  49   ('Clorange', 'A Clockwork Orange', 20, 'Clockwork Orange'),
  50   ('Convert', 'Convert enemy pieces', 12, 'Convert'),
  51   ('Copycat', 'Borrow powers', 30, 'Copycat'),
  52   ('Coregal', 'Two royal pieces', 9, 'Coregal'),
  53   ('Coronation', 'Long live the Queen', 17, 'Coronation'),
  54   ('Crazyhouse', 'Captures reborn', 20, 'Crazyhouse'),
  55   ('Crossing', 'Cross the river', 27, 'Crossing'),
  56   ('Cylinder', 'Neverending rows', 3, 'Cylindrical Chess'),
  57   ('Cwda', 'New teams', 5, 'Different armies'),
  58   ('Diamond', 'Rotating board', 4, 'Diamond'),
  59   ('Discoduel', 'Enter the disco', 0, 'Disco Duel'),
  60   ('Dobutsu', 'Let''s catch the Lion!', 0, 'Dobutsu'),
  61   ('Doublearmy', '64 pieces on the board', 16, 'Double Army'),
  62   ('Doublemove1', 'Double moves (v1)', 24, 'Doublemove 1'),
  63   ('Doublemove2', 'Double moves (v2)', 24, 'Doublemove 2'),
  64   ('Dynamo', 'Push and pull', 11, 'Dynamo'),
  65   ('Eightpieces', 'Each piece is unique', 7, '8-Pieces'),
  66   ('Emergo', 'Stacking Checkers variant', 28, 'Emergo'),
  67   ('Empire', 'Empire versus Kingdom', 5, 'Empire Chess'),
  68   ('Enpassant', 'Capture en passant', 10, 'En-passant'),
  69   ('Evolution', 'Faster development', 31, 'Evolution'),
  70   ('Extinction', 'Capture all of a kind', 27, 'Extinction'),
  71   ('Fanorona', 'Malagasy Draughts', 28, 'Fanorona'),
  72   ('Football', 'Score a goal', 6, 'Football'),
  73   ('Forward', 'Moving forward', 31, 'Forward'),
  74   ('Freecapture', 'Capture both colors', 17, 'Free Capture'),
  75   ('Fugue', 'Baroque Music', 11, 'Fugue'),
  76   ('Fullcavalry', 'Lancers everywhere', 7, 'Full Cavalry'),
  77   ('Fusion', 'Fusion pieces (v1)', 31, 'Fusion Chess'),
  78   ('Gomoku', 'Align five stones', 28, 'Gomoku'),
  79   ('Grand', 'Big board', 7, 'Grand Chess'),
  80   ('Grasshopper', 'Long jumps over pieces', 7, 'Grasshopper'),
  81   ('Gridolina', 'Jump the borders', 31, 'Gridolina'),
  82   ('Hamilton', 'Walk on a graph', 31, 'Hamilton'),
  83   ('Hoppelpoppel', 'Knibis and Bisknis', 7, 'Hoppel-Poppel'),
  84   ('Horde', 'A pawns cloud', 5, 'Horde'),
  85   ('Hypnotic', 'Mind control (v1)', 21, 'Hypnotic'),
  86   ('Iceage', 'Ice Age is coming!', 31, 'Ice Age'),
  87   ('Interweave', 'Interweaved colorbound teams', 11, 'Interweave'),
  88   ('Isardam', 'No paralyzed pieces', 21, 'Isardam'),
  89   ('Janggi', 'Korean Chess', 22, 'Janggi'),
  90   ('Joker', 'Replace pieces', 26, 'Joker'),
  91   ('Karouk', 'Thai Chess (v3)', 22, 'Kar-Ouk'),
  92   ('Kinglet', 'Protect your pawns', 27, 'Kinglet'),
  93   ('Kingsmaker', 'Promote into kings', 31, 'Kingsmaker'),
  94   ('Knightmate1', 'Mate the knight (v1)', 15, 'Knightmate 1'),
  95   ('Knightmate2', 'Mate the knight (v2)', 15, 'Knightmate 2'),
  96   ('Knightpawns', 'Knight versus pawns', 0, 'Knight-Pawns'),
  97   ('Knightrelay1', 'Move like a knight (v1)', 15, 'Knightrelay 1'),
  98   ('Knightrelay2', 'Move like a knight (v2)', 15, 'Knightrelay 2'),
  99   ('Konane', 'Hawaiian Checkers', 28, 'Konane'),
 100   ('Koopa', 'Stun & kick pieces', 21, 'Koopa'),
 101   ('Koth', 'King of the Hill', 27, 'King of the Hill'),
 102   ('Losers', 'Get strong at self-mate', 1, 'Losers'),
 103   ('Madhouse', 'Rearrange enemy pieces', 20, 'Madhouse'),
 104   ('Madrasi', 'Paralyzed pieces', 21, 'Madrasi'),
 105   ('Magnetic', 'Laws of attraction', 31, 'Magnetic'),
 106   ('Maharajah', 'Augmented Queens', 25, 'Maharajah'),
 107   ('Makpong', 'Thai Chess (v2)', 22, 'Makpong'),
 108   ('Makruk', 'Thai Chess (v1)', 22, 'Makruk'),
 109   ('Maxima', 'Occupy the enemy palace', 11, 'Maxima'),
 110   ('Mesmer', 'Mind control (v2)', 21, 'Mesmer'),
 111   ('Minishogi', 'Shogi 5 x 5', 22, 'Minishogi'),
 112   ('Minixiangqi', 'Xiangqi 7 x 7', 22, 'Minixiangqi'),
 113   ('Monocolor', 'All of the same color', 1, 'Monocolor'),
 114   ('Monster', 'White move twice', 25, 'Monster'),
 115   ('Musketeer', 'New fairy pieces', 8, 'Musketeer Chess'),
 116   ('Newzealand', 'Kniros and Rosknis', 7, 'New-Zealand Chess'),
 117   ('Omega', 'A wizard in the corner', 7, 'Omega'),
 118   ('Orda', 'Mongolian Horde (v1)', 5, 'Orda'),
 119   ('Ordamirror', 'Mongolian Horde (v2)', 7, 'Orda Mirror'),
 120   ('Otage', 'Capture and release hostages', 12, 'Otage'),
 121   ('Pacifist1', 'Convert & support (v1)', 12, 'Pacifist 1'),
 122   ('Pacifist2', 'Convert & support (v2)', 12, 'Pacifist 2'),
 123   ('Pacosako', 'Dance with the King', 12, 'Paco-Sako'),
 124   ('Pandemonium1', 'Noise and confusion (v1)', 20, 'Pandemonium 1'),
 125   ('Pandemonium2', 'Noise and confusion (v2)', 20, 'Pandemonium 2'),
 126   ('Parachute', 'Landing on the board', 19, 'Parachute'),
 127   ('Pawnmassacre', 'Pieces upside down', 16, 'Pawn Massacre'),
 128   ('Pawns', 'Reach the last rank (v1)', 0, 'Pawns'),
 129   ('Pawnsking', 'Reach the last rank (v2)', 0, 'Pawns & King'),
 130   ('Perfect', 'Powerful pieces', 7, 'Perfect Chess'),
 131   ('Pocketknight', 'Knight in pocket', 17, 'Pocket Knight'),
 132   ('Progressive1', 'Play more and more moves (v1)', 24, 'Progressive 1'),
 133   ('Progressive2', 'Play more and more moves (v2)', 24, 'Progressive 2'),
 134   ('Queenpawns', 'Queen versus pawns', 0, 'Queen-Pawns'),
 135   ('Racingkings', 'Kings cross the 8x8 board', 23, 'Racing Kings'),
 136   ('Rampage', 'Move under cover', 20, 'Rampage'),
 137   ('Relayup', 'Upgrade pieces', 30, 'Relay-up'),
 138   ('Rifle', 'Shoot pieces', 10, 'Rifle Chess'),
 139   ('Recycle', 'Reuse pieces', 20, 'Recycle Chess'),
 140   ('Refusal1', 'Do not play that! (v1)', 29, 'Refusal 1'),
 141   ('Refusal2', 'Do not play that! (v2)', 29, 'Refusal 2'),
 142   ('Rollerball', 'As in the movie', 31, 'Rollerball'),
 143   ('Rococo', 'Capture on the edge', 11, 'Rococo'),
 144   ('Rookpawns', 'Rook versus pawns', 0, 'Rook-Pawns'),
 145   ('Royalrace', 'Kings cross the 11x11 board', 23, 'Royal Race'),
 146   ('Rugby', 'Transform an essay', 6, 'Rugby'),
 147   ('Schess', 'Seirawan-Harper Chess', 8, 'Seirawan-Harper Chess'),
 148   ('Screen', 'Free initial setup', 19, 'Screen Chess'),
 149   ('Selfabsorb', 'Fusion pieces (v2)', 31, 'Self-Absorption'),
 150   ('Shako', 'Non-conformism and utopia', 7, 'Shako'),
 151   ('Shatranj', 'Ancient rules', 22, 'Shatranj'),
 152   ('Shinobi', 'A story of invasion', 5, 'Shinobi'),
 153   ('Shogi', 'Japanese Chess', 22, 'Shogi'),
 154   ('Shogun', 'General''s Chess', 20, 'Shogun'),
 155   ('Sittuyin', 'Burmese Chess', 22, 'Sittuyin'),
 156   ('Spartan', 'Spartan versus Persians', 5, 'Spartan Chess'),
 157   ('Squatter1', 'Squat last rank (v1)', 27, 'Squatter 1'),
 158   ('Squatter2', 'Squat last rank (v2)', 27, 'Squatter 2'),
 159   ('Suicide', 'Lose all pieces', 1, 'Suicide'),
 160   ('Suction', 'Attract opposite king', 26, 'Suction'),
 161   ('Swap', 'Dangerous captures', 26, 'Swap'),
 162   ('Switching', 'Exchange pieces'' positions', 26, 'Switching'),
 163   ('Synochess', 'Dynasty versus Kingdom', 5, 'Synochess'),
 164   ('Takenmake', 'Prolongated captures', 31, 'Take and make'),
 165   ('Teleport1', 'Reposition pieces (v1)', 20, 'Teleport 1'),
 166   ('Teleport2', 'Reposition pieces (v2)', 20, 'Teleport 2'),
 167   ('Tencubed', 'Four new pieces', 7, 'Tencubed'),
 168   ('Threechecks', 'Give three checks', 27, 'Three Checks'),
 169   ('Titan', 'Extra bishops and knights', 8, 'Titan Chess'),
 170   ('Twokings', 'Two kings', 9, 'Two Kings'),
 171   ('Upsidedown', 'Board upside down', 16, 'Upside-down'),
 172   ('Vchess', 'Pawns capture backward', 4, 'Victor Chess'),
 173   ('Wildebeest', 'Balanced sliders & leapers', 7, 'Wildebeest'),
 174   ('Wormhole1', 'Squares disappear (v1)', 31, 'Wormhole 1'),
 175   ('Wormhole2', 'Squares disappear (v2)', 31, 'Wormhole 2'),
 176   ('Xiangqi', 'Chinese Chess', 22, 'Xiangqi'),
 177   ('Yote', 'African Draughts', 28, 'Yote'),
 178   ('Zen', 'Reverse captures', 10, 'Zen Chess');