Attempt to clarify installation instructions a little
[vchess.git] / server / db / populate.sql
CommitLineData
c326e657
BA
1-- Re-run this script after variants are added
2
eaa5ad3e
BA
3insert 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');
25c7c036 14
eaa5ad3e
BA
15insert 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'),
eb2d61de 20 ('Allmate', 'Mate any piece', 11, 'Allmate'),
eaa5ad3e
BA
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'),
10cceb25
BA
27 ('Atomic', 'Explosive captures', 18, 'Atomic Chess'),
28 ('Avalam1', 'Build towers (v1)', 28, 'Avalam1'),
29 ('Avalam2', 'Build towers (v2)', 28, 'Avalam2'),
eaa5ad3e
BA
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'),
eb2d61de 45 ('Checkered', 'Shared pieces', 12, 'Checkered'),
eaa5ad3e 46 ('Checkless', 'No-check mode', 18, 'Checkless'),
eb2d61de 47 ('Chess960', 'Standard rules', -1, 'Chess960'),
eaa5ad3e
BA
48 ('Circular', 'Run forward', 3, 'Circular Chess'),
49 ('Clorange', 'A Clockwork Orange', 20, 'Clockwork Orange'),
eaa5ad3e
BA
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'),
cee75a57 57 ('Cwda', 'New teams', 5, 'Different armies'),
eaa5ad3e
BA
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'),
f20f9639 65 ('Eightpieces', 'Each piece is unique', 7, '8-Pieces'),
eaa5ad3e
BA
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'),
a57faf48 91 ('Karouk', 'Thai Chess (v3)', 22, 'Kar-Ouk'),
eaa5ad3e
BA
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'),
a57faf48 129 ('Pawnsking', 'Reach the last rank (v2)', 0, 'Pawns & King'),
eaa5ad3e
BA
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');