summaryrefslogtreecommitdiff
path: root/db/08to09_pg.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2009-12-10 14:40:00 -0500
committerEvan Prodromou <evan@status.net>2009-12-10 14:40:00 -0500
commit344c99df02fb34dcca02f36bee7cb66489742105 (patch)
tree550903fdc51ab1dfd38bddb6137f7841fe8a4619 /db/08to09_pg.sql
parenta2fb1f5f9dda42b8bac689d3b5bfa86d7660416d (diff)
remove forward table from PostgreSQL scripts
Diffstat (limited to 'db/08to09_pg.sql')
-rw-r--r--db/08to09_pg.sql7
1 files changed, 0 insertions, 7 deletions
diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql
index 4f8281bc3..1df8c249b 100644
--- a/db/08to09_pg.sql
+++ b/db/08to09_pg.sql
@@ -80,10 +80,3 @@ ALTER TABLE profile ADD COLUMN lon decimal(10,7) /*comment 'longitude'*/;
ALTER TABLE profile ADD COLUMN location_id integer /* comment 'location id if possible'*/;
ALTER TABLE profile ADD COLUMN location_ns integer /* comment 'namespace for location'*/;
-CREATE TABLE forward (
- profile_id integer not null /*comment 'profile who forwarded the notice'*/ references profile (id),
- notice_id integer not null /*comment 'notice they forwarded'*/ references notice (id),
- created timestamp not null /*comment 'date this record was created'*/ DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (profile_id, notice_id)
-);
-