diff options
| author | Scott Ostler <scottbot9000@gmail.com> | 2010-10-24 20:46:30 -0400 |
|---|---|---|
| committer | Scott Ostler <scottbot9000@gmail.com> | 2010-10-24 20:46:30 -0400 |
| commit | 33955c93ae8050778c75c18756585a59103ea86f (patch) | |
| tree | 3d59aded387fa0782e9eb8e59ea31bc699671148 /db/0-create.psql | |
| parent | 02a0597e39ed337ba4dc0cccddebb4c98c63b5ee (diff) | |
Add initial event logic and merge
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, |