703297aed74bb4b91b54315a8d6ccb78f438ab79
[vchess.git] / server / db / populate.sql
1 -- Re-run this script after variants are added
2
3 insert or ignore into Variants (name, description, noProblems) values
4 ('Apocalypse', 'The end of the world', true),
5 ('Chakart', 'Capture the princess', true),
6 ('Dark', 'In the shadow', true),
7 ('Dice', 'Roll the dice', true),
8 ('Hidden', 'Unidentified pieces', true),
9 ('Hiddenqueen', 'Queen disguised as a pawn', true),
10 ('Synchrone', 'Play at the same time', true);
11
12 insert or ignore into Variants (name, description) values
13 ('Absorption', 'Absorb powers'),
14 ('Alice', 'Both sides of the mirror'),
15 ('Allmate1', 'Mate any piece (v1)'),
16 ('Allmate2', 'Mate any piece (v2)'),
17 ('Ambiguous', 'Play opponent''s pieces'),
18 ('Antiking1', 'Keep antiking in check (v1)'),
19 ('Antiking2', 'Keep antiking in check (v2)'),
20 ('Antimatter', 'Dangerous collisions'),
21 ('Arena', 'Middle battle'),
22 ('Atomic', 'Explosive captures'),
23 ('Ball', 'Score a goal'),
24 ('Balaklava', 'Meet the Mammoth'),
25 ('Baroque', 'Exotic captures'),
26 ('Benedict', 'Change colors'),
27 ('Berolina', 'Pawns move diagonally'),
28 ('Bicolour', 'Harassed kings'),
29 ('Cannibal', 'Capture powers'),
30 ('Capture', 'Mandatory captures'),
31 ('Checkered1', 'Shared pieces (v1)'),
32 ('Checkered2', 'Shared pieces (v2)'),
33 ('Checkless', 'No-check mode'),
34 ('Chess960', 'Standard rules'),
35 ('Circular', 'Run forward'),
36 ('Clorange', 'A Clockwork Orange'),
37 ('Colorbound', 'The colorbound clobberers'),
38 ('Coregal', 'Two royal pieces'),
39 ('Coronation', 'Long live the Queen'),
40 ('Crazyhouse', 'Captures reborn'),
41 ('Cylinder', 'Neverending rows'),
42 ('Diamond', 'Rotating board'),
43 ('Doublearmy', '64 pieces on the board'),
44 ('Doublemove1', 'Double moves (v1)'),
45 ('Doublemove2', 'Double moves (v2)'),
46 ('Doubleorda', 'Mongolian Horde (v2)'),
47 ('Dynamo', 'Push and pull'),
48 ('Eightpieces', 'Each piece is unique'),
49 ('Enpassant', 'Capture en passant'),
50 ('Extinction', 'Capture all of a kind'),
51 ('Football', 'Score a goal'),
52 ('Forward', 'Moving forward'),
53 ('Freecapture', 'Capture both colors'),
54 ('Grand', 'Big board'),
55 ('Grasshopper', 'Long jumps over pieces'),
56 ('Gridolina', 'Jump the borders'),
57 ('Hamilton', 'Walk on a graph'),
58 ('Horde', 'A pawns cloud'),
59 ('Interweave', 'Interweaved colorbound teams'),
60 ('Kinglet', 'Protect your pawns'),
61 ('Knightmate', 'Mate the knight'),
62 ('Knightrelay1', 'Move like a knight (v1)'),
63 ('Knightrelay2', 'Move like a knight (v2)'),
64 ('Koopa', 'Stun & kick pieces'),
65 ('Koth', 'King of the Hill'),
66 ('Losers', 'Get strong at self-mate'),
67 ('Madrasi', 'Paralyzed pieces'),
68 ('Magnetic', 'Laws of attraction'),
69 ('Makruk', 'Thai Chess'),
70 ('Maxima', 'Occupy the enemy palace'),
71 ('Minishogi', 'Shogi 5 x 5'),
72 ('Monochrome', 'All of the same color'),
73 ('Monster', 'White move twice'),
74 ('Omega', 'A wizard in the corner'),
75 ('Orda', 'Mongolian Horde (v1)'),
76 ('Pacifist1', 'Convert & support (v1)'),
77 ('Pacifist2', 'Convert & support (v2)'),
78 ('Parachute', 'Landing on the board'),
79 ('Pawns', 'Reach the last rank'),
80 ('Perfect', 'Powerful pieces'),
81 ('Racingkings', 'Kings cross the 8x8 board'),
82 ('Rampage', 'Move under cover'),
83 ('Rifle', 'Shoot pieces'),
84 ('Recycle', 'Reuse pieces'),
85 ('Rococo', 'Capture on the edge'),
86 ('Royalrace', 'Kings cross the 11x11 board'),
87 ('Rugby', 'Transform an essay'),
88 ('Schess', 'Seirawan-Harper Chess'),
89 ('Shako', 'Non-conformism and utopia'),
90 ('Shatranj', 'Ancient rules'),
91 ('Shogi', 'Japanese Chess'),
92 ('Sittuyin', 'Burmese chess'),
93 ('Suicide', 'Lose all pieces'),
94 ('Suction', 'Attract opposite king'),
95 ('Swap', 'Dangerous captures'),
96 ('Switching', 'Exchange pieces'' positions'),
97 ('Takenmake', 'Prolongated captures'),
98 ('Teleport', 'Reposition pieces'),
99 ('Tencubed', 'Four new pieces'),
100 ('Threechecks', 'Give three checks'),
101 ('Twokings', 'Two kings'),
102 ('Upsidedown', 'Board upside down'),
103 ('Wildebeest', 'Balanced sliders & leapers'),
104 ('Wormhole', 'Squares disappear'),
105 ('Zen', 'Reverse captures');