Add PostgreSQL schema

1 files changed, 20 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..5faeb74
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,20 @@
+CREATE TABLE accounts (
+	id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
+	username TEXT,
+	password TEXT
+);
+
+CREATE TABLE mailboxes (
+	id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
+	account INTEGER NOT NULL,
+	FOREIGN KEY(account) REFERENCES accounts(id),
+	name TEXT,
+	UNIQUE(account, name)
+);
+
+CREATE TABLE mail (
+	id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
+	mailbox INTEGER NOT NULL,
+	FOREIGN KEY(mailbox) REFERENCES mailboxes(id),
+	data bytea
+);