--- database should be in this folder, and named 'vchess.sqlite'
+-- Database should be in this folder, and named 'vchess.sqlite'
create table Variants (
name varchar primary key,
description text
);
-insert into Variants values
- ('Checkered', 'Shared pieces'),
- ('Zen', 'Reverse captures'),
- ('Atomic', 'Explosive captures'),
- ('Chess960', 'Standard rules'),
- ('Antiking', 'Keep antiking in check'),
- ('Magnetic', 'Laws of attraction'),
- ('Alice', 'Both sides of the mirror'),
- ('Grand', 'Big board'),
- ('Wildebeest', 'Balanced sliders & leapers'),
- ('Loser', 'Lose all pieces'),
- ('Crazyhouse', 'Captures reborn'),
- ('Switching', 'Exchange pieces positions'),
- ('Extinction', 'Capture all of a kind'),
- ('Marseille', 'Move twice'),
- ('Upsidedown', 'Walking on the hands'),
- ('Dark', 'In the shadow'),
- ('Berolina', 'Pawns move diagonally'),
- ('Ultima', 'Exotic captures');
create table Problems (
num integer primary key,
solution text,
foreign key (variant) references Variants(name)
);
---PRAGMA foreign_keys = ON;
+
+PRAGMA foreign_keys = ON;