Attempt to clarify installation instructions a little

[vchess.git] / db / create.sql

diff --git a/db/create.sql b/db/create.sql
deleted file mode 100644 (file)
index 321274d..0000000
--- a/db/create.sql
+++ /dev/null
@@ -1,36 +0,0 @@
--- 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,
-       added datetime,
-       variant varchar,
-       fen varchar,
-       instructions text,
-       solution text,
-       foreign key (variant) references Variants(name)
-);
---PRAGMA foreign_keys = ON;