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