From 33955c93ae8050778c75c18756585a59103ea86f Mon Sep 17 00:00:00 2001 From: Scott Ostler Date: Sun, 24 Oct 2010 20:46:30 -0400 Subject: Add initial event logic and merge --- db/0-create.psql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'db') 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, -- cgit v1.2.3-70-g09d2