diff options
author | Evan Prodromou <evan@status.net> | 2009-12-10 14:40:00 -0500 |
---|---|---|
committer | Evan Prodromou <evan@status.net> | 2009-12-10 14:40:00 -0500 |
commit | 344c99df02fb34dcca02f36bee7cb66489742105 (patch) | |
tree | 550903fdc51ab1dfd38bddb6137f7841fe8a4619 /db/08to09_pg.sql | |
parent | a2fb1f5f9dda42b8bac689d3b5bfa86d7660416d (diff) |
remove forward table from PostgreSQL scripts
Diffstat (limited to 'db/08to09_pg.sql')
-rw-r--r-- | db/08to09_pg.sql | 7 |
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) -); - |