I've run the migration scripts from #149 to #158 using MySQL Workbench and got the error codes below:
#149 ALTER TABLE ca_objects ADD COLUMN deaccession_disposal_sdatetime decimal(30,20) null Error Code: 1060. Duplicate column name 'deaccession_disposal_sdatetime'
#150 DROP index i_index_field_num ON ca_sql_search_word_index Error Code: 1091. Can't DROP 'i_index_field_num'; check that column/key exists
#151 ALTER TABLE ca_sql_search_word_index ADD column field_container_id int unsigned null Error Code: 1060. Duplicate column name 'field_container_id'
#152 ALTER TABLE ca_search_log MODIFY ip_addr VARCHAR(39) 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0
#152 ALTER TABLE ca_download_log MODIFY ip_addr VARCHAR(39) 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0
#152 ALTER TABLE ca_items_x_tags MODIFY ip_addr VARCHAR(39) 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0
#152 INSERT IGNORE INTO ca_schema_updates (version_num, datetime) VALUES (152, unix_timestamp()) 0 row(s) affected, 1 warning(s): 1062 Duplicate entry '152' for key 'ca_schema_updates.u_version_num'
#153 ALTER TABLE ca_search_indexing_queue ADD COLUMN started_on int unsigned null Error Code: 1060. Duplicate column name 'started_on'
#154 create table ca_metadata_alert_rules ( rule_id int unsigned not null AUTO_INCREMENT, table_num tinyint unsigned not null, code varchar(20) not null, settings longtext not null, user_id int unsigned null references ca_users(user_id), primary key (rule_id), index i_table_num (table_num) ) engine=innodb CHARACTER SET utf8 COLLATE utf8_general_ci Error Code: 1050. Table 'ca_metadata_alert_rules' already exists
#155 ALTER TABLE ca_items_x_tags ADD COLUMN rank int unsigned not null default 0 Error Code: 1060. Duplicate column name 'rank'
#156 create table ca_history_tracking_current_values ( tracking_id int unsigned not null AUTO_INCREMENT, policy varchar(50) not null, /* Row this history tracking policy current value is bound to (Aka. the "subject") / table_num tinyint unsigned not null, type_id int unsigned null, row_id int unsigned not null, / Row that is current value for this history tracking policy / current_table_num tinyint unsigned null, current_type_id int unsigned null, current_row_id int unsigned null, / Row that establishes current value. Eg. the relationship that links location (current value) to object (subject) / / This may be the same as the target. The current value can always be derived from this tracked row. / tracked_table_num tinyint unsigned null, tracked_type_id int unsigned null, tracked_row_id int unsigned null, is_future int unsigned null, primary key (tracking_id), index i_policy (policy), index i_row_id (row_id), / Only one current value per subject per policy */ unique index u_all (row_id, table_num, policy, type_id), index i_current (current_row_id, current_table_num, current_type_id), index i_tracked (tracked_row_id, tracked_table_num, tracked_type_id), index i_is_future (is_future) ) engine=innodb CHARACTER SET utf8 COLLATE utf8_general_ci Error Code: 1050. Table 'ca_history_tracking_current_values' already exists
#156 UPDATE ca_change_log SET unit_id = MD5(log_id) WHERE unit_id IS NULL 0 row(s) affected Rows matched: 0 Changed: 0 Warnings: 0
#157 CREATE INDEX i_log_plus on ca_change_log_subjects (log_id, subject_table_num, subject_row_id) Error Code: 1061. Duplicate key name 'i_log_plus'
#158 create table ca_persistent_cache ( cache_key char(32) not null primary key, cache_value longblob not null, created_on int unsigned not null, updated_on int unsigned not null, namespace varchar(100) not null default '', KEY i_namespace (namespace), KEY i_updated_on (updated_on) ) engine=innodb CHARACTER SET utf8 COLLATE utf8_general_ci Error Code: 1050. Table 'ca_persistent_cache' already exists
