summaryrefslogtreecommitdiffhomepage
path: root/src/dbx/sql/000-genesis.sql
blob: c16c6ae66e525fe6c82af5e6e2ac2b16850b49d1 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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
);