diff options
Diffstat (limited to 'sql/schema.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, |