From 344c99df02fb34dcca02f36bee7cb66489742105 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Thu, 10 Dec 2009 14:40:00 -0500 Subject: remove forward table from PostgreSQL scripts --- db/08to09_pg.sql | 7 ------- 1 file changed, 7 deletions(-) (limited to 'db/08to09_pg.sql') 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) -); - -- cgit v1.2.3-54-g00ecf