Some fixes, problems logic now functional
[vchess.git] / db / create.sql
CommitLineData
86c9843c
BA
1-- database should be in this folder, and named 'vchess.sqlite'
2
da06a6eb
BA
3create table Variants (
4 name varchar primary key,
5 description text
6);
7insert 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
23create 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;