Bug 5937 - Subtle differences in columns between installed db and upgraded db
Summary: Subtle differences in columns between installed db and upgraded db
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Galen Charlton
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-23 15:21 UTC by Marcel de Rooy
Modified: 2013-03-21 13:04 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Marcel de Rooy 2011-03-23 15:21:22 UTC
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