[Koha-bugs] [Bug 17306] Update scripts fail with Mysql 5.7
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Sep 16 15:41:28 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17306
--- Comment #3 from Rodrigo Santellan <rsantellan at gmail.com> ---
Created attachment 55618
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=55618&action=edit
Changes of update22to30
diff --git a/installer/data/mysql/update22to30.pl
b/installer/data/mysql/update22to30.pl
index f10ace9..f2010e1 100755
--- a/installer/data/mysql/update22to30.pl
+++ b/installer/data/mysql/update22to30.pl
@@ -53,10 +53,10 @@ my $DBversion = "3.00.00.000";
action_logs => "(
`timestamp` TIMESTAMP NOT NULL ,
`user` INT( 11 ) NOT NULL default '0' ,
- `module` TEXT default '',
- `action` TEXT default '' ,
+ `module` TEXT default NULL,
+ `action` TEXT default NULL ,
`object` INT(11) NULL ,
- `info` TEXT default '' ,
+ `info` TEXT default NULL ,
PRIMARY KEY ( `timestamp` , `user` )
)",
letter => "(
@@ -132,7 +132,7 @@ my $DBversion = "3.00.00.000";
labelid int(11) NOT NULL auto_increment,
batch_id varchar(10) NOT NULL default '1',
itemnumber varchar(100) NOT NULL default '',
- timestamp timestamp(14) NOT NULL,
+ timestamp timestamp NOT NULL,
PRIMARY KEY (labelid)
)",
@@ -214,7 +214,7 @@ my $DBversion = "3.00.00.000";
);
my %requirefields = (
- subscription => { 'letter' => 'varchar(20) NULL', 'distributedto' =>
'text NULL', 'firstacquidate'=>'date default NULL','irregularity'=>'TEXT NULL
default \'\'','numberpattern'=>'TINYINT(3) NULL default 0', 'callnumber'=>'text
NU
+ subscription => { 'letter' => 'varchar(20) NULL', 'distributedto' =>
'text NULL', 'firstacquidate'=>'date default NULL','irregularity'=>'TEXT NULL
default NULL','numberpattern'=>'TINYINT(3) NULL default 0', 'callnumber'=>'text
NU
itemtypes => { 'imageurl' => 'varchar(200) NULL'},
aqbookfund => { 'branchcode' => 'varchar(4) NULL'},
aqbudget => { 'branchcode' => 'varchar(4) NULL'},
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list