1.1.x-1.5transition.sql

# Schema migration from 1.1x -> 1.5

UPDATE calls SET parent_type = 'Accounts' WHERE parent_type = 'Account';
UPDATE calls SET parent_type = 'Opportunities' WHERE parent_type = 'Opportunity';
UPDATE calls SET parent_type = 'Cases' WHERE parent_type = 'Case';

UPDATE emails SET parent_type = 'Accounts' WHERE parent_type = 'Account';
UPDATE emails SET parent_type = 'Opportunities' WHERE parent_type = 'Opportunity';
UPDATE emails SET parent_type = 'Cases' WHERE parent_type = 'Case';

UPDATE meetings SET parent_type = 'Accounts' WHERE parent_type = 'Account';
UPDATE meetings SET parent_type = 'Opportunities' WHERE parent_type = 'Opportunity';
UPDATE meetings SET parent_type = 'Cases' WHERE parent_type = 'Case';

UPDATE notes SET parent_type = 'Accounts' WHERE parent_type = 'Account';
UPDATE notes SET parent_type = 'Opportunities' WHERE parent_type = 'Opportunity';
UPDATE notes SET parent_type = 'Cases' WHERE parent_type = 'Case';

UPDATE tasks SET parent_type = 'Accounts' WHERE parent_type = 'Account';
UPDATE tasks SET parent_type = 'Opportunities' WHERE parent_type = 'Opportunity';
UPDATE tasks SET parent_type = 'Cases' WHERE parent_type = 'Case';

ALTER TABLE notes ADD filename VARCHAR(255) AFTER description;

ALTER TABLE users DROP theme;
ALTER TABLE users DROP language;
ALTER TABLE users ADD user_preferences TEXT AFTER address_postalcode;

UPDATE users SET status = 'Active' WHERE status != 'Inactive' OR status IS NULL;

ALTER TABLE users ADD user_hash CHAR(32) DEFAULT NULL AFTER user_password;

ALTER TABLE contacts CHANGE title title VARCHAR(40) DEFAULT NULL;