diff options
-rw-r--r-- | db/schema_0001-add_sessions_and_users_and_dbic_fields.sql | 15 |
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; |