Typo
[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'),
dac39588 22 ('Atomic', 'Explosive captures'),
6f2f9437 23 ('Ball', 'Score a goal'),
a0224b03 24 ('Balaklava', 'Meet the Mammoth'),
dac39588 25 ('Baroque', 'Exotic captures'),
9bd6786b 26 ('Benedict', 'Change colors'),
dac39588 27 ('Berolina', 'Pawns move diagonally'),
107dc1bd 28 ('Bicolour', 'Harassed kings'),
dfc78263 29 ('Cannibal', 'Capture powers'),
6b7b2cf7 30 ('Capture', 'Mandatory captures'),
af34341d
BA
31 ('Checkered1', 'Shared pieces (v1)'),
32 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 33 ('Checkless', 'No-check mode'),
dac39588 34 ('Chess960', 'Standard rules'),
e3e2cc44 35 ('Circular', 'Run forward'),
0b8bd121 36 ('Clorange', 'A Clockwork Orange'),
801e2870 37 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 38 ('Coregal', 'Two royal pieces'),
107dc1bd 39 ('Coronation', 'Long live the Queen'),
dac39588 40 ('Crazyhouse', 'Captures reborn'),
71ef1664 41 ('Cylinder', 'Neverending rows'),
59e74176 42 ('Diamond', 'Rotating board'),
de3f5625 43 ('Doublearmy', '64 pieces on the board'),
b406466b
BA
44 ('Doublemove1', 'Double moves (v1)'),
45 ('Doublemove2', 'Double moves (v2)'),
0b8bd121 46 ('Doubleorda', 'Mongolian Horde (v2)'),
c7550017 47 ('Dynamo', 'Push and pull'),
90e814b6 48 ('Eightpieces', 'Each piece is unique'),
7d8bf63e 49 ('Enpassant', 'Capture en passant'),
dac39588 50 ('Extinction', 'Capture all of a kind'),
107dc1bd 51 ('Football', 'Score a goal'),
0b8bd121 52 ('Forward', 'Moving forward'),
e88d69a8 53 ('Freecapture', 'Capture both colors'),
dac39588 54 ('Grand', 'Big board'),
a97bdbda 55 ('Grasshopper', 'Long jumps over pieces'),
107dc1bd 56 ('Gridolina', 'Jump the borders'),
22053c2c 57 ('Hamilton', 'Walk on a graph'),
f9385686 58 ('Horde', 'A pawns cloud'),
0b1405c4 59 ('Interweave', 'Interweaved colorbound teams'),
57078452 60 ('Kinglet', 'Protect your pawns'),
a97bdbda 61 ('Knightmate', 'Mate the knight'),
68e19a44
BA
62 ('Knightrelay1', 'Move like a knight (v1)'),
63 ('Knightrelay2', 'Move like a knight (v2)'),
e88d69a8 64 ('Koopa', 'Stun & kick pieces'),
236485b5 65 ('Koth', 'King of the Hill'),
6b7b2cf7 66 ('Losers', 'Get strong at self-mate'),
107dc1bd 67 ('Madrasi', 'Paralyzed pieces'),
dac39588 68 ('Magnetic', 'Laws of attraction'),
cd49e617 69 ('Makruk', 'Thai Chess'),
e90bafa8 70 ('Maxima', 'Occupy the enemy palace'),
e2f204ed 71 ('Minishogi', 'Shogi 5 x 5'),
665eed90 72 ('Monochrome', 'All of the same color'),
5e1bc651 73 ('Monster', 'White move twice'),
472c0c4f 74 ('Omega', 'A wizard in the corner'),
0b8bd121 75 ('Orda', 'Mongolian Horde (v1)'),
4fcb0c04
BA
76 ('Pacifist1', 'Convert & support (v1)'),
77 ('Pacifist2', 'Convert & support (v2)'),
0d5335de 78 ('Parachute', 'Landing on the board'),
964eda04 79 ('Pawns', 'Reach the last rank'),
a6836242 80 ('Perfect', 'Powerful pieces'),
6b7b2cf7 81 ('Racingkings', 'Kings cross the 8x8 board'),
35ff9d1b 82 ('Rampage', 'Move under cover'),
c3a86f01 83 ('Rifle', 'Shoot pieces'),
78d64531 84 ('Recycle', 'Reuse pieces'),
e90bafa8 85 ('Rococo', 'Capture on the edge'),
77691911 86 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 87 ('Rugby', 'Transform an essay'),
305ede7e 88 ('Schess', 'Seirawan-Harper Chess'),
cd49e617 89 ('Shako', 'Non-conformism and utopia'),
a4eca0dc 90 ('Shatranj', 'Ancient rules'),
cd49e617 91 ('Shogi', 'Japanese Chess'),
b406466b 92 ('Sittuyin', 'Burmese chess'),
6b7b2cf7 93 ('Suicide', 'Lose all pieces'),
31e9e40a 94 ('Suction', 'Attract opposite king'),
964eda04
BA
95 ('Swap', 'Dangerous captures'),
96 ('Switching', 'Exchange pieces'' positions'),
0b1405c4 97 ('Takenmake', 'Prolongated captures'),
107dc1bd 98 ('Teleport', 'Reposition pieces'),
472c0c4f 99 ('Tencubed', 'Four new pieces'),
92240cf0 100 ('Threechecks', 'Give three checks'),
14c35dc6 101 ('Twokings', 'Two kings'),
602d6bef 102 ('Upsidedown', 'Board upside down'),
dac39588 103 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 104 ('Wormhole', 'Squares disappear'),
dac39588 105 ('Zen', 'Reverse captures');