ALTER TABLE zz_system_options RENAME COLUMN system_optionid TO id;
ALTER TABLE zz_searchparams RENAME COLUMN searchparamid TO id;
ALTER TABLE zz_report_fields RENAME COLUMN zz_report_fields_id TO id;
ALTER TABLE zz_table_security RENAME COLUMN table_securityid TO id;
ALTER TABLE zz_record_security RENAME COLUMN record_securityid TO id;
ALTER TABLE zz_rp_dependencies RENAME COLUMN rp_dependency_id TO id;
ALTER TABLE zz_db_login_velocity RENAME COLUMN login_velocityid TO id;

ALTER TABLE zz_system_options_rh RENAME COLUMN system_optionid TO id;
ALTER TABLE zz_searchparams_rh RENAME COLUMN searchparamid TO id;
ALTER TABLE zz_report_fields_rh RENAME COLUMN zz_report_fields_id TO id;
ALTER TABLE zz_table_security_rh RENAME COLUMN table_securityid TO id;
ALTER TABLE zz_record_security_rh RENAME COLUMN record_securityid TO id;
ALTER TABLE zz_rp_dependencies_rh RENAME COLUMN rp_dependency_id TO id;
ALTER TABLE zz_db_login_velocity_rh RENAME COLUMN login_velocityid TO id;

DROP TRIGGER zz_system_optionssystem_optionidt;
DROP TRIGGER zz_searchparamssearchparamidt;
DROP TRIGGER zz_report_fieldszz_report_fields_idt;
DROP TRIGGER zz_table_securitytable_securityidt;
DROP TRIGGER zz_record_securityrecord_securityidt;
DROP TRIGGER zz_rp_dependenciesrp_dependency_idt;
DROP TRIGGER zz_db_login_velocitylogin_velocityidt;