Parsing schema for file './installer/data/mysql/kohastructure.sql'
Parsing schema for database 'koha_library'
-- Convert schema '' to '':;

BEGIN;

ALTER TABLE account_debit_types CHANGE COLUMN can_be_sold can_be_sold tinyint(1) NOT NULL DEFAULT 0 comment 'boolean flag to denote if this debit type is available at point of sale';

ALTER TABLE account_offsets DROP INDEX account_offsets_ibfk_t;

ALTER TABLE accountlines DROP INDEX accountlines_ibfk_branches,
                         DROP INDEX accountlines_ibfk_borrowers_2,
                         DROP INDEX accountlines_ibfk_debit_type,
                         DROP INDEX accountlines_ibfk_credit_type,
                         ADD INDEX credit_type_code (credit_type_code),
                         ADD INDEX debit_type_code (debit_type_code),
                         ADD INDEX branchcode (branchcode),
                         ADD INDEX manager_id (manager_id);

ALTER TABLE additional_contents DROP FOREIGN KEY additional_contents_borrowernumber_fk,
                                ADD CONSTRAINT borrowernumber_fk FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE authorised_value_categories CHANGE COLUMN category_name category_name varchar(32) NOT NULL DEFAULT '';

ALTER TABLE biblio_metadata DROP FOREIGN KEY biblio_metadata_fk_1,
                            CHANGE COLUMN schema schema varchar(16) NOT NULL,
                            ADD CONSTRAINT record_metadata_fk_1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE categories CHANGE COLUMN password_expiry_days password_expiry_days smallint(6) NULL DEFAULT NULL comment 'number of days after which the patron must reset their password';

ALTER TABLE class_sources ADD INDEX class_source_ibfk_2 (class_split_rule),
                          ADD CONSTRAINT class_source_ibfk_2 FOREIGN KEY (class_split_rule) REFERENCES class_split_rules (class_split_rule);

ALTER TABLE creator_layouts CHANGE COLUMN scale_width scale_width decimal(28, 6) NOT NULL DEFAULT 0.800000,
                            CHANGE COLUMN scale_height scale_height decimal(28, 6) NOT NULL DEFAULT 0.010000;

ALTER TABLE deletedbiblio_metadata DROP FOREIGN KEY deletedbiblio_metadata_fk_1,
                                   CHANGE COLUMN schema schema varchar(16) NOT NULL,
                                   ADD CONSTRAINT deletedrecord_metadata_fk_1 FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE erm_counter_files CHANGE COLUMN date_uploaded date_uploaded timestamp NULL DEFAULT CURRENT_TIMESTAMP comment 'counter file upload date';

ALTER TABLE erm_counter_logs CHANGE COLUMN importdate importdate timestamp NULL DEFAULT CURRENT_TIMESTAMP comment 'counter file import date';

ALTER TABLE erm_eholdings_packages DROP FOREIGN KEY erm_packages_ibfk_1,
                                   DROP INDEX erm_packages_ibfk_1,
                                   ADD INDEX erm_eholdings_packages_ibfk_1 (vendor_id),
                                   ADD CONSTRAINT erm_eholdings_packages_ibfk_1 FOREIGN KEY (vendor_id) REFERENCES aqbooksellers (id) ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE illrequests DROP CONSTRAINT illrequest_id;

ALTER TABLE import_record_matches CHANGE COLUMN chosen chosen tinyint(1) NULL DEFAULT NULL comment 'whether this match has been allowed or denied';

ALTER TABLE language_descriptions DROP INDEX subtag_type_lang;

ALTER TABLE library_groups DROP INDEX parent_id;

ALTER TABLE library_hours DROP FOREIGN KEY library_hours,
                          ADD CONSTRAINT library_hours_ibfk_1 FOREIGN KEY (library_id) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE marc_modification_template_actions CHANGE COLUMN action action enum('delete_field', 'add_field', 'update_field', 'move_field', 'copy_field', 'copy_and_replace_field') NOT NULL;

ALTER TABLE message_transports DROP INDEX message_transports_ibfk_3;

ALTER TABLE messages DROP INDEX manager_id,
                     ADD INDEX messages_ibfk_1 (manager_id);

ALTER TABLE old_reserves DROP INDEX old_desk_id;

ALTER TABLE patron_consent CHANGE COLUMN type type tinytext NULL DEFAULT NULL comment 'consent type, could be custom type',
                           ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE patron_lists CHANGE COLUMN name name varchar(255) character set utf8mb4 collate utf8mb4_general_ci NOT NULL comment 'the list''s name';

ALTER TABLE recalls DROP INDEX borrowernumber,
                    DROP INDEX biblionumber,
                    DROP INDEX itemnumber,
                    DROP INDEX branchcode,
                    ADD INDEX recalls_ibfk_1 (patron_id),
                    ADD INDEX recalls_ibfk_2 (biblio_id),
                    ADD INDEX recalls_ibfk_3 (item_id),
                    ADD INDEX recalls_ibfk_4 (pickup_library_id);

ALTER TABLE repeatable_holidays CHANGE COLUMN branchcode branchcode varchar(10) NOT NULL comment 'foreign key from the branches table, defines which branch this closing is for';

ALTER TABLE search_field CHANGE COLUMN type type enum('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno', 'year', 'callnumber', 'geo_point') NOT NULL comment 'what type of data this holds, relevant when storing it in the search engine';

ALTER TABLE special_holidays CHANGE COLUMN branchcode branchcode varchar(10) NOT NULL comment 'foreign key from the branches table, defines which branch this closing is for';

ALTER TABLE subscription DROP INDEX by_biblionumber,
                         ADD INDEX subscription_ibfk_3 (biblionumber);

ALTER TABLE subscriptionhistory DROP INDEX biblionumber,
                                ADD INDEX subscription_history_ibfk_1 (biblionumber);

ALTER TABLE suggestions DROP INDEX suggestions_budget_id_fk,
                        DROP INDEX suggestions_ibfk_acceptedby,
                        DROP INDEX suggestions_ibfk_rejectedby,
                        ADD INDEX acceptedby (acceptedby),
                        ADD INDEX rejectedby (rejectedby),
                        ADD INDEX budgetid (budgetid);

ALTER TABLE ticket_updates DROP FOREIGN KEY ticket_updates_ibfk_4,
                           DROP INDEX ticket_updates_ibfk_4,
                           ADD INDEX ticket_updates_ibfk_3 (assignee_id),
                           ADD CONSTRAINT ticket_updates_ibfk_3 FOREIGN KEY (assignee_id) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE;


COMMIT;


WARNING!!!
These commands are only suggestions! They are not a replacement for updatedatabase.pl!
Review the database, updatedatabase.pl, and kohastructure.sql before making any changes!