- Created by Adam Darwin, last modified on Mar 07, 2022
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 6 Next »
Fix 'Alert' table schema
alter table alert modify column message longtext; alter table alert modify column advanced_options longtext;
Fix 'DatabaseChangeLog' table
update databasechangelog set md5sum=null;
Fix auto increment in all tables
MySQL Workbench has a bug
https://bugs.mysql.com/bug.php?id=96231
that causes auto increment to be missing on all tables
To fix it, run the SQL commands below
SET FOREIGN_KEY_CHECKS = 0; update databasechangelog set md5sum=null; alter table `activation_code` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `agent` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `alert` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `application` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `application_attribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `attribute_definition` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `authentication_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `authorization_code` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `certificate_activation_code` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `certificate_authority` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `certificate_request` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `certificate_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `challenge_code` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `configuration` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `connection_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `customization_config` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `customization_template` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `data_cache` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `database_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `deepnet_authenticator` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `dna_auth_session` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `domain` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `dualshield_system` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `enum_value` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `fail_thru_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `history` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `i18n_message` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `identity_source` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `image` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `image_repository` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `internal_user_attribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `ip2location_db3` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `ip2location_db3_ipv6` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `jvmobservation` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `ldap_server_connection` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `license_group` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `log` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `log_field` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `log_filter` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `logon_procedure` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `logon_step` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `message` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `message_body` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `message_gateway` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `message_template` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `message_template_item` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `network` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `policy_category` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `product` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `product_attribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `push_notification_gateway` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `qna` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `question` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `radius_attribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `radius_client` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `radius_profile` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `radius_proxy` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `radius_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `realm` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `report` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `report_data` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `report_result` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `repository` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `role` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `serial_generator` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `server_certificate` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `server_job` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `site_stamp` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `spattribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `sso_federation` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `sso_identity_provider` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `sso_server` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `sso_service_provider` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `store` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `store_folder` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `store_item` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `system_binary_data` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `system_job` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `systicket` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `task` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `tbl_custom_application` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `tbl_policy` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `tbl_user` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `temp_pass` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `token` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `token_assignment` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `token_attribute` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `token_auth_session` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `token_session` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `unit` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `user_certificate` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `user_configuration` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `user_device` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `user_registration_session` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `user_secure_cookie` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; alter table `usergroup` modify column `id` bigint(20) NOT NULL AUTO_INCREMENT; SET FOREIGN_KEY_CHECKS = 1;
- No labels