View | Details | Raw Unified | Return to bug 8431
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 301-307 DROP TABLE IF EXISTS `borrower_attributes`; Link Here
301
CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as extended patron attributes linked to patrons/borrowers
301
CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as extended patron attributes linked to patrons/borrowers
302
  `borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines which patron/borrower has this attribute
302
  `borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines which patron/borrower has this attribute
303
  `code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
303
  `code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for
304
  `attribute` varchar(64) default NULL, -- custom patron field value
304
  `attribute` varchar(255) default NULL, -- custom patron field value
305
  `password` varchar(64) default NULL, -- password associated with this field
305
  `password` varchar(64) default NULL, -- password associated with this field
306
  KEY `borrowernumber` (`borrowernumber`),
306
  KEY `borrowernumber` (`borrowernumber`),
307
  KEY `code_attribute` (`code`, `attribute`),
307
  KEY `code_attribute` (`code`, `attribute`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 5556-5561 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5556
    SetVersion($DBversion);
5556
    SetVersion($DBversion);
5557
}
5557
}
5558
5558
5559
$DBversion ="3.09.00.XXX";
5560
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
5561
    $dbh->do("ALTER TABLE  `borrower_attributes` CHANGE  `attribute`  `attribute` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
5562
    print "Upgrade to $DBversion done (Increase the maximum size of a borrower attribute value)\n";
5563
    SetVersion($DBversion);
5564
}
5565
5559
=head1 FUNCTIONS
5566
=head1 FUNCTIONS
5560
5567
5561
=head2 TableExists($table)
5568
=head2 TableExists($table)
5562
- 

Return to bug 8431