From 0715a254e8bc3a75607a173b0a3c8b5b67a5f4c9 Mon Sep 17 00:00:00 2001 From: Runxi Yu 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 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