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

(-)a/installer/data/mysql/atomicupdate/bug_11006-DROP_COLUMN_totalamount.sql (+1 lines)
Line 0 Link Here
1
ALTER TABLE aqorders DROP COLUMN totalamount;
(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 3030-3036 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3030
  `quantity` smallint(6) default NULL, -- the quantity ordered
3030
  `quantity` smallint(6) default NULL, -- the quantity ordered
3031
  `currency` varchar(3) default NULL, -- the currency used for the purchase
3031
  `currency` varchar(3) default NULL, -- the currency used for the purchase
3032
  `listprice` decimal(28,6) default NULL, -- the vendor price for this line item
3032
  `listprice` decimal(28,6) default NULL, -- the vendor price for this line item
3033
  `totalamount` decimal(28,6) default NULL, -- not used? always NULL
3034
  `datereceived` date default NULL, -- the date this order was received
3033
  `datereceived` date default NULL, -- the date this order was received
3035
  invoiceid int(11) default NULL, -- id of invoice
3034
  invoiceid int(11) default NULL, -- id of invoice
3036
  `freight` decimal(28,6) default NULL, -- shipping costs (not used)
3035
  `freight` decimal(28,6) default NULL, -- shipping costs (not used)
(-)a/t/db_dependent/Acquisition.t (-4 lines)
Lines 331-337 my @expectedfields = qw( Link Here
331
  quantity
331
  quantity
332
  currency
332
  currency
333
  listprice
333
  listprice
334
  totalamount
335
  datereceived
334
  datereceived
336
  invoiceid
335
  invoiceid
337
  freight
336
  freight
Lines 482-488 my @base_expectedfields = qw( Link Here
482
  budget_expend
481
  budget_expend
483
  rrp
482
  rrp
484
  cn_sort
483
  cn_sort
485
  totalamount
486
  lccn
484
  lccn
487
  sort1
485
  sort1
488
  volume
486
  volume
Lines 603-609 ok( Link Here
603
  sort2_authcat
601
  sort2_authcat
604
  rrp
602
  rrp
605
  unitprice
603
  unitprice
606
  totalamount
607
  sort1
604
  sort1
608
  ordernumber
605
  ordernumber
609
  datecreated
606
  datecreated
610
- 

Return to bug 11006