Fix non-augmenting self absorptions
[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'),
0fb43db7
BA
24 ('Atomic1', 'Explosive captures (v1)'),
25 ('Atomic2', 'Explosive captures (v2)'),
4258b58c 26 ('Avalanche', 'Pawnfalls'),
6f2f9437 27 ('Ball', 'Score a goal'),
a0224b03 28 ('Balaklava', 'Meet the Mammoth'),
0b0f0335 29 ('Bario', 'A quantum story'),
dac39588 30 ('Baroque', 'Exotic captures'),
9bd6786b 31 ('Benedict', 'Change colors'),
dac39588 32 ('Berolina', 'Pawns move diagonally'),
107dc1bd 33 ('Bicolour', 'Harassed kings'),
737a5daf 34 ('Bishopawns', 'Bishop versus pawns'),
6c00a6e5 35 ('Brotherhood', 'Friendly pieces'),
dfc78263 36 ('Cannibal', 'Capture powers'),
3208c667 37 ('Capablanca', 'Capablanca Chess'),
6b7b2cf7 38 ('Capture', 'Mandatory captures'),
2bb4666e 39 ('Castle', 'Win by castling long'),
af34341d
BA
40 ('Checkered1', 'Shared pieces (v1)'),
41 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 42 ('Checkless', 'No-check mode'),
dac39588 43 ('Chess960', 'Standard rules'),
e3e2cc44 44 ('Circular', 'Run forward'),
0b8bd121 45 ('Clorange', 'A Clockwork Orange'),
801e2870 46 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 47 ('Coregal', 'Two royal pieces'),
107dc1bd 48 ('Coronation', 'Long live the Queen'),
dac39588 49 ('Crazyhouse', 'Captures reborn'),
0f7762c1 50 ('Crossing', 'Cross the river'),
71ef1664 51 ('Cylinder', 'Neverending rows'),
59e74176 52 ('Diamond', 'Rotating board'),
737a5daf 53 ('Discoduel', 'Enter the disco'),
6c00a6e5 54 ('Dobutsu', 'Let''s catch the Lion!'),
de3f5625 55 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
56 ('Doublemove1', 'Double moves (v1)'),
57 ('Doublemove2', 'Double moves (v2)'),
c7550017 58 ('Dynamo', 'Push and pull'),
90e814b6 59 ('Eightpieces', 'Each piece is unique'),
1e8a8386 60 ('Empire', 'Empire versus Kingdom'),
7d8bf63e 61 ('Enpassant', 'Capture en passant'),
91565c63 62 ('Evolution', 'Faster development'),
dac39588 63 ('Extinction', 'Capture all of a kind'),
107dc1bd 64 ('Football', 'Score a goal'),
0b8bd121 65 ('Forward', 'Moving forward'),
e88d69a8 66 ('Freecapture', 'Capture both colors'),
8fe025db 67 ('Fugue', 'Baroque Music'),
0fb43db7 68 ('Fullcavalry', 'Lancers everywhere'),
e023d747 69 ('Fusion', 'Fusion pieces (v1)'),
dac39588 70 ('Grand', 'Big board'),
a97bdbda 71 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 72 ('Gridolina', 'Jump the borders'),
22053c2c 73 ('Hamilton', 'Walk on a graph'),
dbc79ee6 74 ('Hoppelpoppel', 'Knibis and Bisknis'),
f9385686 75 ('Horde', 'A pawns cloud'),
2fac4d67 76 ('Hypnotic', 'Mind control (v1)'),
0b1405c4 77 ('Interweave', 'Interweaved colorbound teams'),
059f0aa2 78 ('Isardam', 'No paralyzed pieces'),
fe887246 79 ('Janggi', 'Korean Chess'),
459edd58 80 ('Joker', 'Replace pieces'),
57078452 81 ('Kinglet', 'Protect your pawns'),
0f7762c1 82 ('Kingsmaker', 'Promote into kings'),
a97bdbda 83 ('Knightmate', 'Mate the knight'),
737a5daf 84 ('Knightpawns', 'Knight versus pawns'),
68e19a44
BA
85 ('Knightrelay1', 'Move like a knight (v1)'),
86 ('Knightrelay2', 'Move like a knight (v2)'),
e88d69a8 87 ('Koopa', 'Stun & kick pieces'),
236485b5 88 ('Koth', 'King of the Hill'),
6b7b2cf7 89 ('Losers', 'Get strong at self-mate'),
a9e1202b 90 ('Madhouse', 'Rearrange enemy pieces'),
107dc1bd 91 ('Madrasi', 'Paralyzed pieces'),
dac39588 92 ('Magnetic', 'Laws of attraction'),
6c00a6e5 93 ('Maharajah', 'Augmented Queens'),
dbc79ee6
BA
94 ('Makpong', 'Thai Chess (v2)'),
95 ('Makruk', 'Thai Chess (v1)'),
e90bafa8 96 ('Maxima', 'Occupy the enemy palace'),
2fac4d67 97 ('Mesmer', 'Mind control (v2)'),
e2f204ed 98 ('Minishogi', 'Shogi 5 x 5'),
2c947b3a 99 ('Minixiangqi', 'Xiangqi 7 x 7'),
665eed90 100 ('Monochrome', 'All of the same color'),
5e1bc651 101 ('Monster', 'White move twice'),
3208c667 102 ('Musketeer', 'New fairy pieces'),
472c0c4f 103 ('Omega', 'A wizard in the corner'),
0b8bd121 104 ('Orda', 'Mongolian Horde (v1)'),
e50a8025 105 ('Ordamirror', 'Mongolian Horde (v2)'),
9d15c433 106 ('Otage', 'Capture and release hostages'),
4fcb0c04
BA
107 ('Pacifist1', 'Convert & support (v1)'),
108 ('Pacifist2', 'Convert & support (v2)'),
173f11dc 109 ('Pacosako', 'Dance with the King'),
0d5335de 110 ('Parachute', 'Landing on the board'),
737a5daf
BA
111 ('Pawnmassacre', 'Pieces upside down'),
112 ('Pawns', 'Reach the last rank (v1)'),
113 ('Pawnsking', 'Reach the last rank (v2)'),
a6836242 114 ('Perfect', 'Powerful pieces'),
a9e1202b 115 ('Pocketknight', 'Knight in pocket'),
eaab401e
BA
116 ('Progressive1', 'Play more and more moves (v1)'),
117 ('Progressive2', 'Play more and more moves (v2)'),
9f88188c 118 ('Queenpawns', 'Queen versus pawns'),
6b7b2cf7 119 ('Racingkings', 'Kings cross the 8x8 board'),
35ff9d1b 120 ('Rampage', 'Move under cover'),
da9e846e 121 ('Relayup', 'Upgrade pieces'),
c3a86f01 122 ('Rifle', 'Shoot pieces'),
78d64531 123 ('Recycle', 'Reuse pieces'),
0b0f0335 124 ('Refusal', 'Do not play that!'),
87f40859 125 ('Rollerball', 'As in the movie'),
e90bafa8 126 ('Rococo', 'Capture on the edge'),
737a5daf 127 ('Rookpawns', 'Rook versus pawns'),
77691911 128 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 129 ('Rugby', 'Transform an essay'),
305ede7e 130 ('Schess', 'Seirawan-Harper Chess'),
39fe711a 131 ('Screen', 'Free initial setup'),
e023d747 132 ('Selfabsorption', 'Fusion pieces (v2)'),
cd49e617 133 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 134 ('Shatranj', 'Ancient rules'),
cd49e617 135 ('Shogi', 'Japanese Chess'),
73fbcfc8 136 ('Shogun', 'General''s Chess'),
7e107b8f 137 ('Sittuyin', 'Burmese Chess'),
b90120e0 138 ('Spartan', 'Spartan versus Persians'),
4f3a0823
BA
139 ('Squatter1', 'Squat last rank (v1)'),
140 ('Squatter2', 'Squat last rank (v2)'),
6b7b2cf7 141 ('Suicide', 'Lose all pieces'),
31e9e40a 142 ('Suction', 'Attract opposite king'),
964eda04
BA
143 ('Swap', 'Dangerous captures'),
144 ('Switching', 'Exchange pieces'' positions'),
1e8a8386 145 ('Synochess', 'Dynasty versus Kingdom'),
0b1405c4 146 ('Takenmake', 'Prolongated captures'),
107dc1bd 147 ('Teleport', 'Reposition pieces'),
472c0c4f 148 ('Tencubed', 'Four new pieces'),
92240cf0 149 ('Threechecks', 'Give three checks'),
91565c63 150 ('Titan', 'Extra bishops and knights'),
14c35dc6 151 ('Twokings', 'Two kings'),
602d6bef 152 ('Upsidedown', 'Board upside down'),
b2b5a729 153 ('Vchess', 'Pawns capture backward'),
dac39588 154 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 155 ('Wormhole', 'Squares disappear'),
7e107b8f 156 ('Xiangqi', 'Chinese Chess'),
dac39588 157 ('Zen', 'Reverse captures');