Small fixes
[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),
10 ('Synchrone', 'Play at the same time', true);
11
12insert or ignore into Variants (name, description) values
107dc1bd 13 ('Absorption', 'Absorb powers'),
dac39588 14 ('Alice', 'Both sides of the mirror'),
9618937e
BA
15 ('Allmate1', 'Mate any piece (v1)'),
16 ('Allmate2', 'Mate any piece (v2)'),
5b958911 17 ('Ambiguous', 'Play opponent''s pieces'),
c583ef1c
BA
18 ('Antiking1', 'Keep antiking in check (v1)'),
19 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 20 ('Antimatter', 'Dangerous collisions'),
c3a86f01 21 ('Arena', 'Middle battle'),
0fb43db7
BA
22 ('Atomic1', 'Explosive captures (v1)'),
23 ('Atomic2', 'Explosive captures (v2)'),
4258b58c 24 ('Avalanche', 'Pawnfalls'),
6f2f9437 25 ('Ball', 'Score a goal'),
a0224b03 26 ('Balaklava', 'Meet the Mammoth'),
dac39588 27 ('Baroque', 'Exotic captures'),
9bd6786b 28 ('Benedict', 'Change colors'),
dac39588 29 ('Berolina', 'Pawns move diagonally'),
107dc1bd 30 ('Bicolour', 'Harassed kings'),
737a5daf 31 ('Bishopawns', 'Bishop versus pawns'),
dfc78263 32 ('Cannibal', 'Capture powers'),
6b7b2cf7 33 ('Capture', 'Mandatory captures'),
2bb4666e 34 ('Castle', 'Win by castling long'),
af34341d
BA
35 ('Checkered1', 'Shared pieces (v1)'),
36 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 37 ('Checkless', 'No-check mode'),
dac39588 38 ('Chess960', 'Standard rules'),
e3e2cc44 39 ('Circular', 'Run forward'),
0b8bd121 40 ('Clorange', 'A Clockwork Orange'),
801e2870 41 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 42 ('Coregal', 'Two royal pieces'),
107dc1bd 43 ('Coronation', 'Long live the Queen'),
dac39588 44 ('Crazyhouse', 'Captures reborn'),
71ef1664 45 ('Cylinder', 'Neverending rows'),
59e74176 46 ('Diamond', 'Rotating board'),
737a5daf 47 ('Discoduel', 'Enter the disco'),
de3f5625 48 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
49 ('Doublemove1', 'Double moves (v1)'),
50 ('Doublemove2', 'Double moves (v2)'),
c7550017 51 ('Dynamo', 'Push and pull'),
90e814b6 52 ('Eightpieces', 'Each piece is unique'),
1e8a8386 53 ('Empire', 'Empire versus Kingdom'),
7d8bf63e 54 ('Enpassant', 'Capture en passant'),
91565c63 55 ('Evolution', 'Faster development'),
dac39588 56 ('Extinction', 'Capture all of a kind'),
107dc1bd 57 ('Football', 'Score a goal'),
0b8bd121 58 ('Forward', 'Moving forward'),
e88d69a8 59 ('Freecapture', 'Capture both colors'),
0fb43db7 60 ('Fullcavalry', 'Lancers everywhere'),
dac39588 61 ('Grand', 'Big board'),
a97bdbda 62 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 63 ('Gridolina', 'Jump the borders'),
22053c2c 64 ('Hamilton', 'Walk on a graph'),
dbc79ee6 65 ('Hoppelpoppel', 'Knibis and Bisknis'),
f9385686 66 ('Horde', 'A pawns cloud'),
0b1405c4 67 ('Interweave', 'Interweaved colorbound teams'),
059f0aa2 68 ('Isardam', 'No paralyzed pieces'),
fe887246 69 ('Janggi', 'Korean Chess'),
57078452 70 ('Kinglet', 'Protect your pawns'),
a97bdbda 71 ('Knightmate', 'Mate the knight'),
737a5daf 72 ('Knightpawns', 'Knight versus pawns'),
68e19a44
BA
73 ('Knightrelay1', 'Move like a knight (v1)'),
74 ('Knightrelay2', 'Move like a knight (v2)'),
e88d69a8 75 ('Koopa', 'Stun & kick pieces'),
236485b5 76 ('Koth', 'King of the Hill'),
6b7b2cf7 77 ('Losers', 'Get strong at self-mate'),
a9e1202b 78 ('Madhouse', 'Rearrange enemy pieces'),
107dc1bd 79 ('Madrasi', 'Paralyzed pieces'),
dac39588 80 ('Magnetic', 'Laws of attraction'),
dbc79ee6
BA
81 ('Makpong', 'Thai Chess (v2)'),
82 ('Makruk', 'Thai Chess (v1)'),
e90bafa8 83 ('Maxima', 'Occupy the enemy palace'),
e2f204ed 84 ('Minishogi', 'Shogi 5 x 5'),
2c947b3a 85 ('Minixiangqi', 'Xiangqi 7 x 7'),
665eed90 86 ('Monochrome', 'All of the same color'),
5e1bc651 87 ('Monster', 'White move twice'),
472c0c4f 88 ('Omega', 'A wizard in the corner'),
0b8bd121 89 ('Orda', 'Mongolian Horde (v1)'),
e50a8025 90 ('Ordamirror', 'Mongolian Horde (v2)'),
4fcb0c04
BA
91 ('Pacifist1', 'Convert & support (v1)'),
92 ('Pacifist2', 'Convert & support (v2)'),
173f11dc 93 ('Pacosako', 'Dance with the King'),
0d5335de 94 ('Parachute', 'Landing on the board'),
737a5daf
BA
95 ('Pawnmassacre', 'Pieces upside down'),
96 ('Pawns', 'Reach the last rank (v1)'),
97 ('Pawnsking', 'Reach the last rank (v2)'),
a6836242 98 ('Perfect', 'Powerful pieces'),
a9e1202b 99 ('Pocketknight', 'Knight in pocket'),
eaab401e
BA
100 ('Progressive1', 'Play more and more moves (v1)'),
101 ('Progressive2', 'Play more and more moves (v2)'),
9f88188c 102 ('Queenpawns', 'Queen versus pawns'),
6b7b2cf7 103 ('Racingkings', 'Kings cross the 8x8 board'),
35ff9d1b 104 ('Rampage', 'Move under cover'),
c3a86f01 105 ('Rifle', 'Shoot pieces'),
78d64531 106 ('Recycle', 'Reuse pieces'),
e90bafa8 107 ('Rococo', 'Capture on the edge'),
737a5daf 108 ('Rookpawns', 'Rook versus pawns'),
77691911 109 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 110 ('Rugby', 'Transform an essay'),
305ede7e 111 ('Schess', 'Seirawan-Harper Chess'),
39fe711a 112 ('Screen', 'Free initial setup'),
cd49e617 113 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 114 ('Shatranj', 'Ancient rules'),
cd49e617 115 ('Shogi', 'Japanese Chess'),
7e107b8f 116 ('Sittuyin', 'Burmese Chess'),
6b7b2cf7 117 ('Suicide', 'Lose all pieces'),
31e9e40a 118 ('Suction', 'Attract opposite king'),
964eda04
BA
119 ('Swap', 'Dangerous captures'),
120 ('Switching', 'Exchange pieces'' positions'),
1e8a8386 121 ('Synochess', 'Dynasty versus Kingdom'),
0b1405c4 122 ('Takenmake', 'Prolongated captures'),
107dc1bd 123 ('Teleport', 'Reposition pieces'),
472c0c4f 124 ('Tencubed', 'Four new pieces'),
92240cf0 125 ('Threechecks', 'Give three checks'),
91565c63 126 ('Titan', 'Extra bishops and knights'),
14c35dc6 127 ('Twokings', 'Two kings'),
602d6bef 128 ('Upsidedown', 'Board upside down'),
b2b5a729 129 ('Vchess', 'Pawns capture backward'),
dac39588 130 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 131 ('Wormhole', 'Squares disappear'),
7e107b8f 132 ('Xiangqi', 'Chinese Chess'),
dac39588 133 ('Zen', 'Reverse captures');