diff options
Diffstat (limited to 'db/0-create.psql')
| -rw-r--r-- | db/0-create.psql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index d2d4bfc..4fa8536 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -137,6 +137,13 @@ CREATE TABLE invalid_feed_images ( CREATE INDEX invalid_feed_images_idx ON invalid_feed_images (image_url); +CREATE TABLE events ( + event_id SERIAL PRIMARY KEY, + name text NOT NULL, + author integer NOT NULL REFERENCES, + created_on timestamp NOT NULL DEFAULT now() +); + -- dont add this yet CREATE TABLE avatars ( avatar_id SERIAL PRIMARY KEY, |