From 0715a254e8bc3a75607a173b0a3c8b5b67a5f4c9 Mon Sep 17 00:00:00 2001
From: Runxi Yu <me@runxiyu.org>
Date: Sun, 12 Jan 2025 17:41:52 +0800
Subject: Add PostgreSQL schema

---
 schema.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

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
+);
-- 
cgit v1.2.3

