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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 1270-1275 CREATE TABLE `itemtypes` ( -- defines the item types Link Here
1270
  itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
1270
  itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
1271
  description mediumtext, -- a plain text explanation of the item type
1271
  description mediumtext, -- a plain text explanation of the item type
1272
  rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued
1272
  rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued
1273
  gstrate decimal(6,4)  default NULL, -- default gst rate to use when ordering this item type
1273
  notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
1274
  notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
1274
  imageurl varchar(200) default NULL, -- URL for the item type icon
1275
  imageurl varchar(200) default NULL, -- URL for the item type icon
1275
  summary text, -- information from the summary field, may include HTML
1276
  summary text, -- information from the summary field, may include HTML
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +10 lines)
Lines 9628-9633 if ( CheckVersion($DBversion) ) { Link Here
9628
    SetVersion($DBversion);
9628
    SetVersion($DBversion);
9629
}
9629
}
9630
9630
9631
$DBversion = '3.19.00.XXX';
9632
if ( CheckVersion($DBversion) ) {
9633
    $dbh->do(q{
9634
        ALTER TABLE itemtypes ADD COLUMN gstrate decimal(6,4) DEFAULT NULL AFTER rentalcharge
9635
    });
9636
    print "Upgrade to $DBversion done (Bug 12993: Add DB field itemtypes.gstrate)\n";
9637
    SetVersion($DBversion);
9638
}
9639
9640
9631
=head1 FUNCTIONS
9641
=head1 FUNCTIONS
9632
9642
9633
=head2 TableExists($table)
9643
=head2 TableExists($table)
9634
- 

Return to bug 12993