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

(-)a/Koha/Schema/Result/Aqorderdelivery.pm (-75 lines)
Lines 1-75 Link Here
1
use utf8;
2
package Koha::Schema::Result::Aqorderdelivery;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::Aqorderdelivery
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<aqorderdelivery>
19
20
=cut
21
22
__PACKAGE__->table("aqorderdelivery");
23
24
=head1 ACCESSORS
25
26
=head2 ordernumber
27
28
  data_type: 'date'
29
  datetime_undef_if_invalid: 1
30
  is_nullable: 1
31
32
=head2 deliverynumber
33
34
  data_type: 'smallint'
35
  default_value: 0
36
  is_nullable: 0
37
38
=head2 deliverydate
39
40
  data_type: 'varchar'
41
  is_nullable: 1
42
  size: 18
43
44
=head2 qtydelivered
45
46
  data_type: 'smallint'
47
  is_nullable: 1
48
49
=head2 deliverycomments
50
51
  data_type: 'mediumtext'
52
  is_nullable: 1
53
54
=cut
55
56
__PACKAGE__->add_columns(
57
  "ordernumber",
58
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
59
  "deliverynumber",
60
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
61
  "deliverydate",
62
  { data_type => "varchar", is_nullable => 1, size => 18 },
63
  "qtydelivered",
64
  { data_type => "smallint", is_nullable => 1 },
65
  "deliverycomments",
66
  { data_type => "mediumtext", is_nullable => 1 },
67
);
68
69
70
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
71
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hS/Ww/p7nHWiHNumkBifiQ
72
73
74
# You can replace this text with custom content, and it will be preserved on regeneration
75
1;
(-)a/installer/data/mysql/kohastructure.sql (-13 lines)
Lines 2956-2974 CREATE TABLE `aqcontract` ( Link Here
2956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2957
2957
2958
--
2958
--
2959
-- Table structure for table `aqorderdelivery`
2960
--
2961
2962
DROP TABLE IF EXISTS `aqorderdelivery`;
2963
CREATE TABLE `aqorderdelivery` (
2964
  `ordernumber` date default NULL,
2965
  `deliverynumber` smallint(6) NOT NULL default 0,
2966
  `deliverydate` varchar(18) default NULL,
2967
  `qtydelivered` smallint(6) default NULL,
2968
  `deliverycomments` mediumtext
2969
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2970
2971
--
2972
-- Table structure for table `aqorders`
2959
-- Table structure for table `aqorders`
2973
--
2960
--
2974
2961
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
Lines 8065-8070 if ( CheckVersion($DBversion) ) { Link Here
8065
    SetVersion($DBversion);
8065
    SetVersion($DBversion);
8066
}
8066
}
8067
8067
8068
$DBversion = "3.15.00.XXX";
8069
if ( CheckVersion($DBversion) ) {
8070
    $dbh->do(q{
8071
        DROP TABLE aqorderdelivery;
8072
    });
8073
    print "Upgrade to $DBversion done (Bug 11928 - remove unused table)\n";
8074
    SetVersion($DBversion);
8075
}
8076
8068
=head1 FUNCTIONS
8077
=head1 FUNCTIONS
8069
8078
8070
=head2 TableExists($table)
8079
=head2 TableExists($table)
8071
- 

Return to bug 11928