Add Pandemonium
[vchess.git] / server / db / populate.sql
CommitLineData
c326e657
BA
1-- Re-run this script after variants are added
2
25c7c036
BA
3insert or ignore into Variants (name, description, noProblems) values
4 ('Apocalypse', 'The end of the world', true),
884f4528 5 ('Chakart', 'Capture the princess', true),
25c7c036 6 ('Dark', 'In the shadow', true),
68971030 7 ('Dice', 'Roll the dice', true),
25c7c036
BA
8 ('Hidden', 'Unidentified pieces', true),
9 ('Hiddenqueen', 'Queen disguised as a pawn', true),
392614a1 10 ('Synchrone1', 'Play at the same time (v1)', true),
9d15c433 11 ('Synchrone2', 'Play at the same time (v2)', true);
25c7c036
BA
12
13insert or ignore into Variants (name, description) values
107dc1bd 14 ('Absorption', 'Absorb powers'),
0f7762c1 15 ('Alapo', 'Geometric Chess'),
dac39588 16 ('Alice', 'Both sides of the mirror'),
9618937e
BA
17 ('Allmate1', 'Mate any piece (v1)'),
18 ('Allmate2', 'Mate any piece (v2)'),
5b958911 19 ('Ambiguous', 'Play opponent''s pieces'),
c583ef1c
BA
20 ('Antiking1', 'Keep antiking in check (v1)'),
21 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 22 ('Antimatter', 'Dangerous collisions'),
c3a86f01 23 ('Arena', 'Middle battle'),
7c05a5f2 24 ('Atarigo', 'First capture wins'),
0fb43db7
BA
25 ('Atomic1', 'Explosive captures (v1)'),
26 ('Atomic2', 'Explosive captures (v2)'),
85ba3fe5
BA
27 ('Avalam1', 'Build towers (v1)'),
28 ('Avalam2', 'Build towers (v2)'),
4258b58c 29 ('Avalanche', 'Pawnfalls'),
6f2f9437 30 ('Ball', 'Score a goal'),
a0224b03 31 ('Balaklava', 'Meet the Mammoth'),
0b0f0335 32 ('Bario', 'A quantum story'),
dac39588 33 ('Baroque', 'Exotic captures'),
9bd6786b 34 ('Benedict', 'Change colors'),
dac39588 35 ('Berolina', 'Pawns move diagonally'),
107dc1bd 36 ('Bicolour', 'Harassed kings'),
737a5daf 37 ('Bishopawns', 'Bishop versus pawns'),
6c00a6e5 38 ('Brotherhood', 'Friendly pieces'),
dfc78263 39 ('Cannibal', 'Capture powers'),
3208c667 40 ('Capablanca', 'Capablanca Chess'),
6b7b2cf7 41 ('Capture', 'Mandatory captures'),
2bb4666e 42 ('Castle', 'Win by castling long'),
af34341d
BA
43 ('Checkered1', 'Shared pieces (v1)'),
44 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 45 ('Checkless', 'No-check mode'),
dac39588 46 ('Chess960', 'Standard rules'),
e3e2cc44 47 ('Circular', 'Run forward'),
0b8bd121 48 ('Clorange', 'A Clockwork Orange'),
801e2870 49 ('Colorbound', 'The colorbound clobberers'),
1006b211 50 ('Convert', 'Convert enemy pieces'),
3f22c2c3 51 ('Coregal', 'Two royal pieces'),
107dc1bd 52 ('Coronation', 'Long live the Queen'),
dac39588 53 ('Crazyhouse', 'Captures reborn'),
0f7762c1 54 ('Crossing', 'Cross the river'),
71ef1664 55 ('Cylinder', 'Neverending rows'),
59e74176 56 ('Diamond', 'Rotating board'),
737a5daf 57 ('Discoduel', 'Enter the disco'),
6c00a6e5 58 ('Dobutsu', 'Let''s catch the Lion!'),
de3f5625 59 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
60 ('Doublemove1', 'Double moves (v1)'),
61 ('Doublemove2', 'Double moves (v2)'),
c7550017 62 ('Dynamo', 'Push and pull'),
90e814b6 63 ('Eightpieces', 'Each piece is unique'),
d2af3400 64 ('Emergo', 'Stacking Checkers variant'),
1e8a8386 65 ('Empire', 'Empire versus Kingdom'),
7d8bf63e 66 ('Enpassant', 'Capture en passant'),
91565c63 67 ('Evolution', 'Faster development'),
dac39588 68 ('Extinction', 'Capture all of a kind'),
d2af3400 69 ('Fanorona', 'Malagasy Draughts'),
107dc1bd 70 ('Football', 'Score a goal'),
0b8bd121 71 ('Forward', 'Moving forward'),
e88d69a8 72 ('Freecapture', 'Capture both colors'),
8fe025db 73 ('Fugue', 'Baroque Music'),
0fb43db7 74 ('Fullcavalry', 'Lancers everywhere'),
e023d747 75 ('Fusion', 'Fusion pieces (v1)'),
d2af3400 76 ('Gomoku', 'Align five stones'),
dac39588 77 ('Grand', 'Big board'),
a97bdbda 78 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 79 ('Gridolina', 'Jump the borders'),
22053c2c 80 ('Hamilton', 'Walk on a graph'),
dbc79ee6 81 ('Hoppelpoppel', 'Knibis and Bisknis'),
f9385686 82 ('Horde', 'A pawns cloud'),
2fac4d67 83 ('Hypnotic', 'Mind control (v1)'),
f0a812b7 84 ('Iceage', 'Ice Age is coming!'),
0b1405c4 85 ('Interweave', 'Interweaved colorbound teams'),
059f0aa2 86 ('Isardam', 'No paralyzed pieces'),
fe887246 87 ('Janggi', 'Korean Chess'),
459edd58 88 ('Joker', 'Replace pieces'),
57078452 89 ('Kinglet', 'Protect your pawns'),
0f7762c1 90 ('Kingsmaker', 'Promote into kings'),
a97bdbda 91 ('Knightmate', 'Mate the knight'),
737a5daf 92 ('Knightpawns', 'Knight versus pawns'),
68e19a44
BA
93 ('Knightrelay1', 'Move like a knight (v1)'),
94 ('Knightrelay2', 'Move like a knight (v2)'),
d2af3400 95 ('Konane', 'Hawaiian Checkers'),
e88d69a8 96 ('Koopa', 'Stun & kick pieces'),
236485b5 97 ('Koth', 'King of the Hill'),
6b7b2cf7 98 ('Losers', 'Get strong at self-mate'),
a9e1202b 99 ('Madhouse', 'Rearrange enemy pieces'),
107dc1bd 100 ('Madrasi', 'Paralyzed pieces'),
dac39588 101 ('Magnetic', 'Laws of attraction'),
6c00a6e5 102 ('Maharajah', 'Augmented Queens'),
dbc79ee6
BA
103 ('Makpong', 'Thai Chess (v2)'),
104 ('Makruk', 'Thai Chess (v1)'),
e90bafa8 105 ('Maxima', 'Occupy the enemy palace'),
2fac4d67 106 ('Mesmer', 'Mind control (v2)'),
e2f204ed 107 ('Minishogi', 'Shogi 5 x 5'),
2c947b3a 108 ('Minixiangqi', 'Xiangqi 7 x 7'),
665eed90 109 ('Monochrome', 'All of the same color'),
5e1bc651 110 ('Monster', 'White move twice'),
3208c667 111 ('Musketeer', 'New fairy pieces'),
472c0c4f 112 ('Omega', 'A wizard in the corner'),
0b8bd121 113 ('Orda', 'Mongolian Horde (v1)'),
e50a8025 114 ('Ordamirror', 'Mongolian Horde (v2)'),
9d15c433 115 ('Otage', 'Capture and release hostages'),
4fcb0c04
BA
116 ('Pacifist1', 'Convert & support (v1)'),
117 ('Pacifist2', 'Convert & support (v2)'),
173f11dc 118 ('Pacosako', 'Dance with the King'),
723262f9 119 ('Pandemonium', 'Noise and confusion'),
0d5335de 120 ('Parachute', 'Landing on the board'),
737a5daf
BA
121 ('Pawnmassacre', 'Pieces upside down'),
122 ('Pawns', 'Reach the last rank (v1)'),
123 ('Pawnsking', 'Reach the last rank (v2)'),
a6836242 124 ('Perfect', 'Powerful pieces'),
a9e1202b 125 ('Pocketknight', 'Knight in pocket'),
eaab401e
BA
126 ('Progressive1', 'Play more and more moves (v1)'),
127 ('Progressive2', 'Play more and more moves (v2)'),
9f88188c 128 ('Queenpawns', 'Queen versus pawns'),
6b7b2cf7 129 ('Racingkings', 'Kings cross the 8x8 board'),
35ff9d1b 130 ('Rampage', 'Move under cover'),
da9e846e 131 ('Relayup', 'Upgrade pieces'),
c3a86f01 132 ('Rifle', 'Shoot pieces'),
78d64531 133 ('Recycle', 'Reuse pieces'),
0b0f0335 134 ('Refusal', 'Do not play that!'),
87f40859 135 ('Rollerball', 'As in the movie'),
e90bafa8 136 ('Rococo', 'Capture on the edge'),
737a5daf 137 ('Rookpawns', 'Rook versus pawns'),
77691911 138 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 139 ('Rugby', 'Transform an essay'),
305ede7e 140 ('Schess', 'Seirawan-Harper Chess'),
39fe711a 141 ('Screen', 'Free initial setup'),
1943de6b 142 ('Selfabsorb', 'Fusion pieces (v2)'),
cd49e617 143 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 144 ('Shatranj', 'Ancient rules'),
cd49e617 145 ('Shogi', 'Japanese Chess'),
73fbcfc8 146 ('Shogun', 'General''s Chess'),
7e107b8f 147 ('Sittuyin', 'Burmese Chess'),
b90120e0 148 ('Spartan', 'Spartan versus Persians'),
4f3a0823
BA
149 ('Squatter1', 'Squat last rank (v1)'),
150 ('Squatter2', 'Squat last rank (v2)'),
6b7b2cf7 151 ('Suicide', 'Lose all pieces'),
31e9e40a 152 ('Suction', 'Attract opposite king'),
964eda04
BA
153 ('Swap', 'Dangerous captures'),
154 ('Switching', 'Exchange pieces'' positions'),
1e8a8386 155 ('Synochess', 'Dynasty versus Kingdom'),
0b1405c4 156 ('Takenmake', 'Prolongated captures'),
107dc1bd 157 ('Teleport', 'Reposition pieces'),
472c0c4f 158 ('Tencubed', 'Four new pieces'),
92240cf0 159 ('Threechecks', 'Give three checks'),
91565c63 160 ('Titan', 'Extra bishops and knights'),
14c35dc6 161 ('Twokings', 'Two kings'),
602d6bef 162 ('Upsidedown', 'Board upside down'),
b2b5a729 163 ('Vchess', 'Pawns capture backward'),
dac39588 164 ('Wildebeest', 'Balanced sliders & leapers'),
1943de6b
BA
165 ('Wormhole1', 'Squares disappear (v1)'),
166 ('Wormhole2', 'Squares disappear (v2)'),
7e107b8f 167 ('Xiangqi', 'Chinese Chess'),
d2af3400 168 ('Yote', 'African Draughts'),
dac39588 169 ('Zen', 'Reverse captures');