1 create table Variants (
2 name varchar primary key,
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');
21 create table Problems (
27 foreign key (variant
) references Variants(name)
29 --PRAGMA foreign_keys = ON;