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