1 -- database should be in this folder, and named 'vchess.sqlite'
3 create table Variants (
4 name varchar primary key,
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');
23 create table Problems (
24 num
integer primary key,
30 foreign key (variant
) references Variants(name)
32 --PRAGMA foreign_keys = ON;