| 1 | create table Variants ( |
| 2 | name varchar primary key, |
| 3 | description text |
| 4 | ); |
| 5 | insert into Variants values |
| 6 | ('Checkered', 'Shared pieces'), |
| 7 | ('Zen', 'Reverse captures'), |
| 8 | ('Atomic', 'Explosive captures'), |
| 9 | ('Chess960', 'Standard rules'), |
| 10 | ('Antiking', 'Keep antiking in check'), |
| 11 | ('Magnetic', 'Laws of attraction'), |
| 12 | ('Alice', 'Both sides of the mirror'), |
| 13 | ('Grand', 'Big board'), |
| 14 | ('Wildebeest', 'Balanced sliders & leapers'), |
| 15 | ('Loser', 'Lose all pieces'), |
| 16 | ('Crazyhouse', 'Captures reborn'), |
| 17 | ('Switching', 'Exchange pieces positions'), |
| 18 | ('Extinction', 'Capture all of a kind'), |
| 19 | ('Ultima', 'Exotic captures'); |
| 20 | |
| 21 | create table Problems ( |
| 22 | added datetime, |
| 23 | variant varchar, |
| 24 | fen varchar, |
| 25 | instructions text, |
| 26 | solution text, |
| 27 | foreign key (variant) references Variants(name) |
| 28 | ); |
| 29 | --PRAGMA foreign_keys = ON; |