aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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;