iEghxgez

1BEGIN TRANSACTION;
2CREATE TABLE IF NOT EXISTS "Solution" (
3	"SolutionID"	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
4	"Solution"	VARCHAR NOT NULL,
5	"Solved"	INT NOT NULL,
6	"Unsolved"	INT NOT NULL
7);
8CREATE TABLE IF NOT EXISTS "Language" (
9	"Language"	VARCHAR NOT NULL,
10	"Regex"	VARCHAR NOT NULL,
11	"COUNT"	INT NOT NULL,
12	PRIMARY KEY("Language")
13);
14CREATE TABLE IF NOT EXISTS "Type" (
15	"TypeID"	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
16	"Language"	VARCHAR NOT NULL,
17	"SolutionID"	INTEGER,
18	"TypeName"	VARCHAR NOT NULL,
19	"COUNT"	INT NOT NULL
20);
21CREATE TABLE IF NOT EXISTS "Errors" (
22	"ErrorID"	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
23	"TypeID"	INTEGER NOT NULL,
24	"File"	VARCHAR,
25	"Line"	INT,
26	"MSG"	VARCHAR,
27	"Time"	DATETIME,
28	"COUNT"	INT NOT NULL
29);
30COMMIT;