Update TODO
[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),
5 ('Dark', 'In the shadow', true),
6 ('Hidden', 'Unidentified pieces', true),
7 ('Hiddenqueen', 'Queen disguised as a pawn', true),
8 ('Synchrone', 'Play at the same time', true);
9
10insert or ignore into Variants (name, description) values
dac39588 11 ('Alice', 'Both sides of the mirror'),
9618937e
BA
12 ('Allmate1', 'Mate any piece (v1)'),
13 ('Allmate2', 'Mate any piece (v2)'),
5b958911 14 ('Ambiguous', 'Play opponent''s pieces'),
c583ef1c
BA
15 ('Antiking1', 'Keep antiking in check (v1)'),
16 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 17 ('Antimatter', 'Dangerous collisions'),
c3a86f01 18 ('Arena', 'Middle battle'),
dac39588 19 ('Atomic', 'Explosive captures'),
6f2f9437 20 ('Ball', 'Score a goal'),
dac39588 21 ('Baroque', 'Exotic captures'),
9bd6786b 22 ('Benedict', 'Change colors'),
dac39588 23 ('Berolina', 'Pawns move diagonally'),
dfc78263 24 ('Cannibal', 'Capture powers'),
6b7b2cf7 25 ('Capture', 'Mandatory captures'),
af34341d
BA
26 ('Checkered1', 'Shared pieces (v1)'),
27 ('Checkered2', 'Shared pieces (v2)'),
0d5335de 28 ('Checkless', 'No-check mode'),
dac39588 29 ('Chess960', 'Standard rules'),
e3e2cc44 30 ('Circular', 'Run forward'),
801e2870 31 ('Colorbound', 'The colorbound clobberers'),
3f22c2c3 32 ('Coregal', 'Two royal pieces'),
dac39588 33 ('Crazyhouse', 'Captures reborn'),
71ef1664 34 ('Cylinder', 'Neverending rows'),
de3f5625 35 ('Doublearmy', '64 pieces on the board'),
c7550017 36 ('Dynamo', 'Push and pull'),
90e814b6 37 ('Eightpieces', 'Each piece is unique'),
7d8bf63e 38 ('Enpassant', 'Capture en passant'),
dac39588
BA
39 ('Extinction', 'Capture all of a kind'),
40 ('Grand', 'Big board'),
a97bdbda 41 ('Grasshopper', 'Long jumps over pieces'),
f9385686 42 ('Horde', 'A pawns cloud'),
0b1405c4 43 ('Interweave', 'Interweaved colorbound teams'),
a97bdbda 44 ('Knightmate', 'Mate the knight'),
68e19a44
BA
45 ('Knightrelay1', 'Move like a knight (v1)'),
46 ('Knightrelay2', 'Move like a knight (v2)'),
6b7b2cf7 47 ('Losers', 'Get strong at self-mate'),
dac39588 48 ('Magnetic', 'Laws of attraction'),
5e1bc651 49 ('Marseille', 'Double moves'),
e90bafa8 50 ('Maxima', 'Occupy the enemy palace'),
5e1bc651 51 ('Monster', 'White move twice'),
472c0c4f 52 ('Omega', 'A wizard in the corner'),
c7550017 53 ('Orda', 'Mongolian Horde'),
0d5335de 54 ('Parachute', 'Landing on the board'),
a6836242 55 ('Perfect', 'Powerful pieces'),
6b7b2cf7 56 ('Racingkings', 'Kings cross the 8x8 board'),
c3a86f01 57 ('Rifle', 'Shoot pieces'),
78d64531 58 ('Recycle', 'Reuse pieces'),
e90bafa8 59 ('Rococo', 'Capture on the edge'),
77691911 60 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 61 ('Rugby', 'Transform an essay'),
305ede7e 62 ('Schess', 'Seirawan-Harper Chess'),
a4eca0dc 63 ('Shatranj', 'Ancient rules'),
6b7b2cf7 64 ('Suicide', 'Lose all pieces'),
31e9e40a 65 ('Suction', 'Attract opposite king'),
0b1405c4 66 ('Takenmake', 'Prolongated captures'),
472c0c4f 67 ('Tencubed', 'Four new pieces'),
92240cf0 68 ('Threechecks', 'Give three checks'),
14c35dc6 69 ('Twokings', 'Two kings'),
602d6bef 70 ('Upsidedown', 'Board upside down'),
dac39588 71 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 72 ('Wormhole', 'Squares disappear'),
dac39588 73 ('Zen', 'Reverse captures');