Fix the 'empty news bug'
[vchess.git] / server / db / populate.sql
CommitLineData
c326e657
BA
1-- Re-run this script after variants are added
2
8d7e2786 3insert or ignore into Variants (name,description) values
dac39588 4 ('Alice', 'Both sides of the mirror'),
9618937e
BA
5 ('Allmate1', 'Mate any piece (v1)'),
6 ('Allmate2', 'Mate any piece (v2)'),
c583ef1c
BA
7 ('Antiking1', 'Keep antiking in check (v1)'),
8 ('Antiking2', 'Keep antiking in check (v2)'),
8b405c81 9 ('Antimatter', 'Dangerous collisions'),
c3a86f01 10 ('Arena', 'Middle battle'),
dac39588
BA
11 ('Atomic', 'Explosive captures'),
12 ('Baroque', 'Exotic captures'),
9bd6786b 13 ('Benedict', 'Change colors'),
dac39588 14 ('Berolina', 'Pawns move diagonally'),
dfc78263 15 ('Cannibal', 'Capture powers'),
6b7b2cf7 16 ('Capture', 'Mandatory captures'),
dac39588
BA
17 ('Checkered', 'Shared pieces'),
18 ('Chess960', 'Standard rules'),
e3e2cc44 19 ('Circular', 'Run forward'),
dac39588 20 ('Crazyhouse', 'Captures reborn'),
71ef1664 21 ('Cylinder', 'Neverending rows'),
dac39588 22 ('Dark', 'In the shadow'),
90e814b6 23 ('Eightpieces', 'Each piece is unique'),
7d8bf63e 24 ('Enpassant', 'Capture en passant'),
dac39588
BA
25 ('Extinction', 'Capture all of a kind'),
26 ('Grand', 'Big board'),
a97bdbda 27 ('Grasshopper', 'Long jumps over pieces'),
241bf8f2 28 ('Hidden', 'Unidentified pieces'),
a97bdbda
BA
29 ('Hiddenqueen', 'Queen disguised as a pawn'),
30 ('Knightmate', 'Mate the knight'),
68e19a44
BA
31 ('Knightrelay1', 'Move like a knight (v1)'),
32 ('Knightrelay2', 'Move like a knight (v2)'),
6b7b2cf7 33 ('Losers', 'Get strong at self-mate'),
dac39588
BA
34 ('Magnetic', 'Laws of attraction'),
35 ('Marseille', 'Move twice'),
a6836242 36 ('Perfect', 'Powerful pieces'),
6b7b2cf7 37 ('Racingkings', 'Kings cross the 8x8 board'),
c3a86f01 38 ('Rifle', 'Shoot pieces'),
78d64531 39 ('Recycle', 'Reuse pieces'),
77691911 40 ('Royalrace', 'Kings cross the 11x11 board'),
95f8376c 41 ('Rugby', 'Transform an essay'),
a4eca0dc 42 ('Shatranj', 'Ancient rules'),
6b7b2cf7 43 ('Suicide', 'Lose all pieces'),
31e9e40a 44 ('Suction', 'Attract opposite king'),
92240cf0 45 ('Threechecks', 'Give three checks'),
602d6bef 46 ('Upsidedown', 'Board upside down'),
dac39588 47 ('Wildebeest', 'Balanced sliders & leapers'),
c3a86f01 48 ('Wormhole', 'Squares disappear'),
dac39588 49 ('Zen', 'Reverse captures');