http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5937 Bug #: 5937 Summary: Subtle differences in columns between installed db and upgraded db Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Database AssignedTo: gmcharlt@gmail.com ReportedBy: m.de.rooy@rijksmuseum.nl QAContact: koha-bugs@lists.koha-community.org Mainly differences in NULL or NOT NULL; and UNI vs MUL indexes. 52c52 < aqbasketgroups.billingplace varchar(10) YES ---

aqbasketgroups.billingplace varchar(10) NO 106c106 < aqbudgets.budget_amount decimal(28,6) YES 0.000000

aqbudgets.budget_amount decimal(28,6) NO 0.000000 116c116 < aqbudgets.budget_period_id int(11) YES

aqbudgets.budget_period_id int(11) YES MUL 200c200 < auth_subfield_structure.frameworkcode varchar(10) NO

auth_subfield_structure.frameworkcode varchar(10) YES 556c556 < default_circ_rules.holdallowed int(1) YES

default_circ_rules.holdallowed tinyint(1) YES 631c631 < deletedborrowers.cardnumber varchar(16) NO MUL

deletedborrowers.cardnumber varchar(16) YES MUL 660c660 < deletedborrowers.privacy int(11) NO 1

deletedborrowers.privacy int(11) YES 710c710 < deleteditems.stocknumber varchar(32) YES MUL

deleteditems.stocknumber varchar(32) YES UNI 807c815 < issues.itemnumber int(11) YES MUL

issues.itemnumber int(11) YES UNI 989c997 < message_attributes.message_name varchar(40) NO UNI

message_attributes.message_name varchar(40) YES UNI 1352c1391 < suggestions.suggesteddate date NO 0000-00-00

suggestions.suggesteddate date YES

-- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.