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
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
