diff options
| author | Runxi Yu <me@runxiyu.org> | 2025-09-14 22:28:12 +0800 |
|---|---|---|
| committer | Runxi Yu <me@runxiyu.org> | 2025-09-14 22:28:12 +0800 |
| commit | 01e4fd482ebcc827d3c76c00910529abbf666454 (patch) | |
| tree | 300156b866864a07a0ed7680e6572ae97c20e325 /sql | |
| parent | Update dependencies (diff) | |
| download | forge-01e4fd482ebcc827d3c76c00910529abbf666454.tar.gz forge-01e4fd482ebcc827d3c76c00910529abbf666454.tar.zst forge-01e4fd482ebcc827d3c76c00910529abbf666454.zip | |
Add basic mailing listspre-refactor
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/schema.sql b/sql/schema.sql index 92ae605..7805377 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -36,6 +36,13 @@ CREATE TABLE mailing_list_emails ( content BYTEA NOT NULL ); +CREATE TABLE mailing_list_subscribers ( + id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, + list_id INTEGER NOT NULL REFERENCES mailing_lists(id) ON DELETE CASCADE, + email TEXT NOT NULL, + UNIQUE (list_id, email) +); + CREATE TABLE users ( id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, username TEXT UNIQUE, |