https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17306 --- Comment #3 from Rodrigo Santellan <rsantellan@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.