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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 563-569 CREATE TABLE `currency` ( Link Here
563
  `currency` varchar(10) NOT NULL default '',
563
  `currency` varchar(10) NOT NULL default '',
564
  `symbol` varchar(5) default NULL,
564
  `symbol` varchar(5) default NULL,
565
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
565
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
566
  `rate` float(7,5) default NULL,
566
  `rate` float(15,5) default NULL,
567
  `active` tinyint(1) default NULL,
567
  `active` tinyint(1) default NULL,
568
  PRIMARY KEY  (`currency`)
568
  PRIMARY KEY  (`currency`)
569
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
569
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (+8 lines)
Lines 3876-3881 VALUES Link Here
3876
    SetVersion ($DBversion);
3876
    SetVersion ($DBversion);
3877
};
3877
};
3878
3878
3879
$DBversion = '3.03.00.00X';
3880
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
3881
    $dbh->do("ALTER TABLE  `currency` CHANGE `rate` `rate` FLOAT( 15, 5 ) NULL DEFAULT NULL;");
3882
    print "Upgrade to $DBversion done (Enable currency rates >= 100)\n";
3883
    SetVersion ($DBversion);
3884
}
3885
3886
3879
=head1 FUNCTIONS
3887
=head1 FUNCTIONS
3880
3888
3881
=head2 DropAllForeignKeys($table)
3889
=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.0X.XX.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 4160