@@ -, +, @@ --------- --- Koha/Schema/Result/Aqorderdelivery.pm | 75 -------------------------------- installer/data/mysql/kohastructure.sql | 13 ------ installer/data/mysql/updatedatabase.pl | 9 ++++ 3 files changed, 9 insertions(+), 88 deletions(-) delete mode 100644 Koha/Schema/Result/Aqorderdelivery.pm --- a/Koha/Schema/Result/Aqorderdelivery.pm +++ a/Koha/Schema/Result/Aqorderdelivery.pm @@ -1,75 +0,0 @@ -use utf8; -package Koha::Schema::Result::Aqorderdelivery; - -# Created by DBIx::Class::Schema::Loader -# DO NOT MODIFY THE FIRST PART OF THIS FILE - -=head1 NAME - -Koha::Schema::Result::Aqorderdelivery - -=cut - -use strict; -use warnings; - -use base 'DBIx::Class::Core'; - -=head1 TABLE: C - -=cut - -__PACKAGE__->table("aqorderdelivery"); - -=head1 ACCESSORS - -=head2 ordernumber - - data_type: 'date' - datetime_undef_if_invalid: 1 - is_nullable: 1 - -=head2 deliverynumber - - data_type: 'smallint' - default_value: 0 - is_nullable: 0 - -=head2 deliverydate - - data_type: 'varchar' - is_nullable: 1 - size: 18 - -=head2 qtydelivered - - data_type: 'smallint' - is_nullable: 1 - -=head2 deliverycomments - - data_type: 'mediumtext' - is_nullable: 1 - -=cut - -__PACKAGE__->add_columns( - "ordernumber", - { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, - "deliverynumber", - { data_type => "smallint", default_value => 0, is_nullable => 0 }, - "deliverydate", - { data_type => "varchar", is_nullable => 1, size => 18 }, - "qtydelivered", - { data_type => "smallint", is_nullable => 1 }, - "deliverycomments", - { data_type => "mediumtext", is_nullable => 1 }, -); - - -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hS/Ww/p7nHWiHNumkBifiQ - - -# You can replace this text with custom content, and it will be preserved on regeneration -1; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2956,19 +2956,6 @@ CREATE TABLE `aqcontract` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- --- Table structure for table `aqorderdelivery` --- - -DROP TABLE IF EXISTS `aqorderdelivery`; -CREATE TABLE `aqorderdelivery` ( - `ordernumber` date default NULL, - `deliverynumber` smallint(6) NOT NULL default 0, - `deliverydate` varchar(18) default NULL, - `qtydelivered` smallint(6) default NULL, - `deliverycomments` mediumtext -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - --- -- Table structure for table `aqorders` -- --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -8065,6 +8065,15 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.15.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + DROP TABLE aqorderdelivery; + }); + print "Upgrade to $DBversion done (Bug 11928 - remove unused table)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) --