Attachment #54658 for bug #16573

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





=head2 created_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  default_value: '0000-00-00 00:00:00'
  is_nullable: 0

=head2 allow_add

  },
  "created_on",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    default_value => "0000-00-00 00:00:00",
    is_nullable => 0,
  },
  "allow_add",

);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-08-02 04:25:22
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FoBdYVoFQA19R1PMWqykYA


# You can replace this text with custom content, and it will be preserved on regeneration

Lines 12789-12798 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
12789	$DBversion = '16.06.00.012';	12789	$DBversion = '16.06.00.012';
12790	if ( CheckVersion($DBversion) ) {	12790	if ( CheckVersion($DBversion) ) {
12791	$dbh->do(q{	12791	$dbh->do(q{
12792	ALTER TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;	12792	ALTER IGNORE TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;
12793	});	12793	});
12794		12794
12795	print "Upgrade to $DBversion done (Bug 16573 - Web installer fails to load structure and sample data on MySQL 5.7)\n";	12795	print "Upgrade to $DBversion done (Bug 16573: Web installer fails to load structure and sample data on MySQL 5.7)\n";
12796	SetVersion($DBversion);	12796	SetVersion($DBversion);
12797	}	12797	}
12798		12798
12799	-

Return to bug 16573

Lines 63-71 __PACKAGE__->table("virtualshelves"); Link Here

(-)a/Koha/Schema/Result/Virtualshelve.pm (-6 / +4 lines)
63		63
64	=head2 created_on	64	=head2 created_on
65		65
66	data_type: 'timestamp'	66	data_type: 'datetime'
67	datetime_undef_if_invalid: 1	67	datetime_undef_if_invalid: 1
68	default_value: '0000-00-00 00:00:00'
69	is_nullable: 0	68	is_nullable: 0
70		69
71	=head2 allow_add	70	=head2 allow_add
Lines 113-121 __PACKAGE__->add_columns( Link Here
113	},	112	},
114	"created_on",	113	"created_on",
115	{	114	{
116	data_type => "timestamp",	115	data_type => "datetime",
117	datetime_undef_if_invalid => 1,	116	datetime_undef_if_invalid => 1,
118	default_value => "0000-00-00 00:00:00",
119	is_nullable => 0,	117	is_nullable => 0,
120	},	118	},
121	"allow_add",	119	"allow_add",
Lines 191-198 __PACKAGE__->has_many( Link Here
191	);	189	);
192		190
193		191
194	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-11-05 10:39:28	192	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-08-02 04:25:22
195	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O3y89+0IUoePtcIHAqR+oA	193	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FoBdYVoFQA19R1PMWqykYA
196		194
197		195
198	# You can replace this text with custom content, and it will be preserved on regeneration	196	# You can replace this text with custom content, and it will be preserved on regeneration