Some fixes, add basic preview logic for new problem
[vchess.git] / db / create.sql
CommitLineData
da06a6eb
BA
1create table Variants (
2 name varchar primary key,
3 description text
4);
5insert 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
21create 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;