X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=c28bd561ce369a937220586e352f9ed9aa16c3bc;hb=c326e657d451c90220edbaa6f09fcb991350524c;hp=aa2f3ae13451c530770dceb2b48e58af1ac9bdb3;hpb=da06a6eb0237123ce43fdb01cb06246b8b57f5e5;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
index aa2f3ae1..c28bd561 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -1,24 +1,12 @@
+-- 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'),
-	('Ultima', 'Exotic captures');
 
 create table Problems (
+	num integer primary key,
 	added datetime,
 	variant varchar,
 	fen varchar,
@@ -26,4 +14,5 @@ create table Problems (
 	solution text,
 	foreign key (variant) references Variants(name)
 );
---PRAGMA foreign_keys = ON;
+
+PRAGMA foreign_keys = ON;