1 files changed, 42 insertions, 0 deletions
diff --git a/src/dbx/sql/000-genesis.sql b/src/dbx/sql/000-genesis.sql
new file mode 100644
index 0000000..c16c6ae
--- /dev/null
+++ b/src/dbx/sql/000-genesis.sql
@@ -0,0 +1,42 @@
+PRAGMA encoding = "UTF-8";
+
+CREATE TABLE migration (
+	id     INTEGER PRIMARY KEY CHECK (id = 1),
+	latest INTEGER
+);
+INSERT INTO migration (id, latest) VALUES (1, -1);
+
+CREATE TABLE mintages_s (
+	country      CHAR(2) NOT NULL COLLATE BINARY
+		CHECK(length(country) = 2),
+	-- Codes correspond to contants in mintages.go
+	type         INTEGER NOT NULL
+		CHECK(type BETWEEN 0 AND 2),
+	year         INTEGER NOT NULL,
+	denomination REAL NOT NULL,
+	mintmark     TEXT,
+	mintage      INTEGER,
+	reference    TEXT
+);
+
+CREATE TABLE mintages_c (
+	country   CHAR(2) NOT NULL COLLATE BINARY
+		CHECK(length(country) = 2),
+	-- Codes correspond to contants in mintages.go
+	type      INTEGER NOT NULL
+		CHECK(type BETWEEN 0 AND 2),
+	year      INTEGER NOT NULL,
+	name      TEXT NOT NULL,
+	number    INTEGER NOT NULL,
+	mintmark  TEXT,
+	mintage   INTEGER,
+	reference TEXT
+);
+
+CREATE TABLE users (
+	email      TEXT COLLATE BINARY,
+	username   TEXT COLLATE BINARY,
+	password   TEXT COLLATE BINARY,
+	adminp     INTEGER,
+	translates TEXT COLLATE BINARY
+);
+\ No newline at end of file