commit 9935e8d449f0f7a5b1be268702547e57ef97711e
from: Oliver Lowe <o@olowe.co>
date: Mon Mar 21 09:09:07 2022 UTC

Use TEXT as primary keys

I think it will be ok

commit - cdf835fcb0a9ff17d0b43725731257d301d12a23
commit + 9935e8d449f0f7a5b1be268702547e57ef97711e
blob - 66a6cf42578c33eb747bad892eebd22861f8c3a3
blob + b656ad90a2b3865d566c4cb05d7deb1e224efb2c
--- init.sql
+++ init.sql
@@ -1,25 +1,21 @@
 CREATE TABLE accounts (
-	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	name TEXT NOT NULL,
-	username TEXT UNIQUE NOT NULL,
-	password TEXT NOT NULL
+	username TEXT PRIMARY KEY,
+	password TEXT NOT NULL,
+	name TEXT NOT NULL
 );
 
 CREATE TABLE domains (
-	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	account_id INTEGER NOT NULL,
-	domain VARCHAR(255) UNIQUE NOT NULL
+	domain TEXT PRIMARY KEY,
+	account TEXT NOT NULL
 );
 
 CREATE TABLE mailboxes (
-	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	address VARCHAR(255) UNIQUE NOT NULL,
-	password VARCHAR(255) NOT NULL,
-	domain_id INTEGER NOT NULL
+	address TEXT PRIMARY KEY,
+	password TEXT NOT NULL,
+	domain TEXT NOT NULL
 );
 
 CREATE TABLE aliases (
-	id INTEGER PRIMARY KEY AUTOINCREMENT,
-	recipient VARCHAR(255) UNIQUE NOT NULL,
-	destination VARCHAR(255) NOT NULL
+	recipient TEXT PRIMARY KEY,
+	destination TEXT NOT NULL
 );