Commit | Line | Data |
---|---|---|
86c9843c BA |
1 | -- database should be in this folder, and named 'vchess.sqlite' |
2 | ||
da06a6eb BA |
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'), | |
388e4c40 BA |
21 | ('Marseille', 'Move twice'), |
22 | ('Upsidedown', 'Walking on the hands'), | |
23 | ('Dark', 'In the shadow'), | |
24 | ('Berolina', 'Pawns move diagonally'), | |
da06a6eb BA |
25 | ('Ultima', 'Exotic captures'); |
26 | ||
27 | create table Problems ( | |
643479f8 | 28 | num integer primary key, |
da06a6eb BA |
29 | added datetime, |
30 | variant varchar, | |
31 | fen varchar, | |
32 | instructions text, | |
33 | solution text, | |
34 | foreign key (variant) references Variants(name) | |
35 | ); | |
36 | --PRAGMA foreign_keys = ON; |