Attachment #34161 for bug #11008

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

Lines 3055-3061 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
3055	`cancellationreason` text default NULL, -- reason of cancellation	3055	`cancellationreason` text default NULL, -- reason of cancellation
3056	`order_internalnote` mediumtext, -- notes related to this order line, made for staff	3056	`order_internalnote` mediumtext, -- notes related to this order line, made for staff
3057	`order_vendornote` mediumtext, -- notes related to this order line, made for vendor	3057	`order_vendornote` mediumtext, -- notes related to this order line, made for vendor
3058	`supplierreference` mediumtext, -- not used? always NULL
3059	`purchaseordernumber` mediumtext, -- not used? always NULL	3058	`purchaseordernumber` mediumtext, -- not used? always NULL
3060	`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)	3059	`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno)
3061	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified	3060	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified

Lines 9531-9536 if( CheckVersion($DBversion) ){ Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+9 lines)
9531	$dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueLostValue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')");	9531	$dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueLostValue', 'Set the LOST value of an item to n when the item has been overdue for more than defaultlongoverduedays days.', 'integer')");
9532	$dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueDays', 'Set the LOST value of an item when the item has been overdue for more than n days.', 'integer')");	9532	$dbh->do("INSERT INTO systempreferences (variable, explanation, type) VALUES('DefaultLongOverdueDays', 'Set the LOST value of an item when the item has been overdue for more than n days.', 'integer')");
9533	print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";	9533	print "Upgrade to $DBversion done (Bug 8337: System preferences for longoverdue cron)\n";
		9534	}
		9535
		9536	$DBversion = "3.17.00.XXX";
		9537	if ( CheckVersion($DBversion) ) {
		9538	$dbh->do(q\|
		9539	ALTER TABLE aqorders DROP COLUMN supplierreference;
		9540	\|);
		9541
		9542	print "Upgrade to $DBversion done (Bug 11008 - DROP column aqorders.supplierreference)\n";
9534	SetVersion($DBversion);	9543	SetVersion($DBversion);
9535	}	9544	}
9536		9545




  unitprice
  quantityreceived
  datecancellationprinted
  supplierreference
  purchaseordernumber
  basketno
  timestamp

  biblioitemnumber
  datereceived
  orderstatus
  supplierreference
  agerestriction
  budget_branchcode
  gstrate

  creationdate
  datereceived
  orderstatus
  supplierreference
  isbn
  copyrightdate
  gstrate
- 

Return to bug 11008

Lines 339-345 my @expectedfields = qw( Link Here

(-)a/t/db_dependent/Acquisition.t (-4 lines)
339	unitprice	339	unitprice
340	quantityreceived	340	quantityreceived
341	datecancellationprinted	341	datecancellationprinted
342	supplierreference
343	purchaseordernumber	342	purchaseordernumber
344	basketno	343	basketno
345	timestamp	344	timestamp
Lines 457-463 my @base_expectedfields = qw( Link Here
457	biblioitemnumber	456	biblioitemnumber
458	datereceived	457	datereceived
459	orderstatus	458	orderstatus
460	supplierreference
461	agerestriction	459	agerestriction
462	budget_branchcode	460	budget_branchcode
463	gstrate	461	gstrate
Lines 578-584 ok( Link Here
578	creationdate	576	creationdate
579	datereceived	577	datereceived
580	orderstatus	578	orderstatus
581	supplierreference
582	isbn	579	isbn
583	copyrightdate	580	copyrightdate
584	gstrate	581	gstrate
585	-