ALTER TABLE diag ADD COLUMN premodifier character varying(255); ALTER TABLE diag ADD COLUMN postmodifier character varying(255); UPDATE diag SET premodifier = location WHERE locate_str_after_diag = false; UPDATE diag SET postmodifier = location WHERE locate_str_after_diag = true; ALTER TABLE diag DROP location; ALTER TABLE diag DROP locate_str_after_diag; UPDATE db_version SET db_version = '1.07';