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