aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorEdmund von der Burg <evdb@mysociety.org>2011-04-04 15:52:50 +0100
committerEdmund von der Burg <evdb@mysociety.org>2011-04-04 15:52:50 +0100
commit077ae9423faf5445b560bdb98299eee77bb551df (patch)
treee910416d33b73003f73e085d59e731b7d41a66fa
parent5013f3bb184862c90c27ea52b782489ecc2d0511 (diff)
removed unneeded modifications
-rw-r--r--db/schema_0001-add_sessions_and_users_and_dbic_fields.sql15
1 files changed, 0 insertions, 15 deletions
diff --git a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
index 315cf2fda..6d67a259e 100644
--- a/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
+++ b/db/schema_0001-add_sessions_and_users_and_dbic_fields.sql
@@ -18,20 +18,5 @@ create table users (
password text not null default ''
);
--- add PK to contacts table
-ALTER TABLE contacts
- ADD COLUMN id SERIAL PRIMARY KEY;
-
-AlTER TABLE contacts_history
- ADD COLUMN contact_id integer;
-
-update contacts_history
- set contact_id = (
- select id
- from contacts
- where contacts_history.category = contacts.category
- and contacts_history.area_id = contacts.area_id
- );
-
-- rollback;
commit;