diff options
| author | Scott Ostler <scottbot9000@gmail.com> | 2010-12-03 18:00:43 -0500 |
|---|---|---|
| committer | Scott Ostler <scottbot9000@gmail.com> | 2010-12-03 18:00:43 -0500 |
| commit | 4ccea08b8edbd3440f23cee2730a62d4013dc6e0 (patch) | |
| tree | 4ec5b32b9719c9fbdc629b06f324f43a1c0a9f62 /db | |
| parent | 13541b84837c8f360e2ae825d81ae489691b9e14 (diff) | |
| parent | 59af476f7d0c29319931102f05b7b6da63c5ee54 (diff) | |
Merge branch 'master' of ssh://dump.fm/pichat/repo
Diffstat (limited to 'db')
| -rw-r--r-- | db/0-create.psql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/db/0-create.psql b/db/0-create.psql index 4fa8536..762bc3a 100644 --- a/db/0-create.psql +++ b/db/0-create.psql @@ -137,11 +137,11 @@ 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() +CREATE TABLE direct_messages ( + dm_id SERIAL PRIMARY KEY, + message_id integer NOT NULL REFERENCES messages, + author_id integer NOT NULL REFERENCES users, + recip_id integer NOT NULL REFERENCES users ); -- dont add this yet |
