Implemented and tested DarkChess. Berolina, Upsidedown should be OK. Marseille: TODO

[vchess.git] / db / create.sql

diff --git a/db/create.sql b/db/create.sql
index aa2f3ae..321274d 100644 (file)
--- a/db/create.sql
+++ b/db/create.sql
@@ -1,3 +1,5 @@
+-- database should be in this folder, and named 'vchess.sqlite'
+
 create table Variants (
        name varchar primary key,
        description text
@@ -16,9 +18,14 @@ insert into Variants values
        ('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,
        added datetime,
        variant varchar,
        fen varchar,