Koha Database Audit Warning - After Upgrade from 21.11 to 25.05
Hi Friends, Recently I upgraded my koha from 21.11 to 25.05 in Ubuntu 22.04. After having upgraded koha, I looked at About Koha, under Database Audit , I found the following commands. Please advise me how to handle this. It looks there are some issues with database tables structure. Your insights would be appreciated. Thanks Database audit Warning! These commands are only suggestions. They are not a replacement for the database update scripts run during installations and updates. Review the database, the atomic update files and the table definitions in kohastructure.sql before running any of the commands below: Explain -- Convert schema '' to '':; BEGIN; 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 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 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 import_record_matches CHANGE COLUMN chosen chosen tinyint(1) NULL DEFAULT NULL comment 'whether this match has been allowed or denied'; 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 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 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 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; *Dr. Yesan Sellan, * *MLISc., PGDLAN, BCS., UGC-NET., PhD* *(Strategic | Learner | Achiever | Responsibility | Intellection)* Assistant Professor, PG and Research Department of Library and Information Science Bishop Heber College, Puthur PO, Trichy - 620017, INDIA Mobile: 91-9972348251 https://bhc.irins.org/profile/364928 https://orcid.org/0000-0002-0501-5661 https://www.linkedin.com/in/dr-yesan-sellan-01230336/ -----------------------------------------------IMPORTANT------------------------------------------------------------------------- This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you
participants (1)
-
Dr. Yesan Sellan (BHC-DLIS)