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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 642-648 CREATE TABLE `deletedbiblioitems` ( Link Here
642
DROP TABLE IF EXISTS `deletedborrowers`;
642
DROP TABLE IF EXISTS `deletedborrowers`;
643
CREATE TABLE `deletedborrowers` (
643
CREATE TABLE `deletedborrowers` (
644
  `borrowernumber` int(11) NOT NULL default 0,
644
  `borrowernumber` int(11) NOT NULL default 0,
645
  `cardnumber` varchar(9) NOT NULL default '',
645
  `cardnumber` varchar(16) NOT NULL default '',
646
  `surname` mediumtext NOT NULL,
646
  `surname` mediumtext NOT NULL,
647
  `firstname` text,
647
  `firstname` text,
648
  `title` mediumtext,
648
  `title` mediumtext,
Lines 703-708 CREATE TABLE `deletedborrowers` ( Link Here
703
  `altcontactcountry` text default NULL,
703
  `altcontactcountry` text default NULL,
704
  `altcontactphone` varchar(50) default NULL,
704
  `altcontactphone` varchar(50) default NULL,
705
  `smsalertnumber` varchar(50) default NULL,
705
  `smsalertnumber` varchar(50) default NULL,
706
  `privacy` integer(11) DEFAULT '1' NOT NULL,
706
  KEY `borrowernumber` (`borrowernumber`),
707
  KEY `borrowernumber` (`borrowernumber`),
707
  KEY `cardnumber` (`cardnumber`)
708
  KEY `cardnumber` (`cardnumber`)
708
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
709
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (+9 lines)
Lines 3876-3881 VALUES Link Here
3876
    SetVersion ($DBversion);
3876
    SetVersion ($DBversion);
3877
};
3877
};
3878
3878
3879
$DBversion = '3.03.00.XXX';
3880
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
3881
    $dbh->do("ALTER TABLE deletedborrowers ADD `privacy` int(11) AFTER smsalertnumber;");
3882
    $dbh->do("ALTER TABLE deletedborrowers CHANGE `cardnumber` `cardnumber` varchar(16);");
3883
    print "Upgrade to $DBversion done (Fix differences between borrowers and deletedborrowers)\n";
3884
    SetVersion ($DBversion);
3885
}
3886
3887
3879
=head1 FUNCTIONS
3888
=head1 FUNCTIONS
3880
3889
3881
=head2 DropAllForeignKeys($table)
3890
=head2 DropAllForeignKeys($table)
(-)a/kohaversion.pl (-2 / +1 lines)
Lines 16-22 the kohaversion is divided in 4 parts : Link Here
16
use strict;
16
use strict;
17
17
18
sub kohaversion {
18
sub kohaversion {
19
    our $VERSION = '3.03.00.004';
19
    our $VERSION = '3.03.00.XXX';
20
    # version needs to be set this way
20
    # version needs to be set this way
21
    # so that it can be picked up by Makefile.PL
21
    # so that it can be picked up by Makefile.PL
22
    # during install
22
    # during install
23
- 

Return to bug 5423