Attachment #2017 for bug #4331

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




  PRIMARY KEY  (`ordernumber`),
  KEY `basketno` (`basketno`),
  KEY `biblionumber` (`biblionumber`),
  KEY `budget_id` (`budget_id`),
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Table structure for table `aqorders_items`
--

Lines 3548-3553 if (C4::Context->preference('Version') < TransformToNum($DBversion)){ Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+7 lines)
3548	SetVersion ($DBversion);	3548	SetVersion ($DBversion);
3549	}	3549	}
3550		3550
		3551	$DBversion = '3.01.00.128';
		3552	if (C4::Context->preference('Version') < TransformToNum($DBversion)){
		3553	$dbh->do('CREATE INDEX budget_id ON aqorders (budget_id );');
		3554	print "Upgrade to $DBversion done (bug 4331: index orders by budget_id)\n";
		3555	SetVersion ($DBversion);
		3556	}
		3557
3551	=item DropAllForeignKeys($table)	3558	=item DropAllForeignKeys($table)
3552		3559
3553	Drop all foreign keys of the table $table	3560	Drop all foreign keys of the table $table

Lines 10-16 Link Here

(-)a/kohaversion.pl (-2 / +1 lines)
10	use strict;	10	use strict;
11		11
12	sub kohaversion {	12	sub kohaversion {
13	our $VERSION = '3.01.00.127';	13	our $VERSION = '3.01.00.128';
14	# version needs to be set this way	14	# version needs to be set this way
15	# so that it can be picked up by Makefile.PL	15	# so that it can be picked up by Makefile.PL
16	# during install	16	# during install
17	-

Return to bug 4331

Lines 2522-2531 CREATE TABLE `aqorders` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
2522	PRIMARY KEY (`ordernumber`),	2522	PRIMARY KEY (`ordernumber`),
2523	KEY `basketno` (`basketno`),	2523	KEY `basketno` (`basketno`),
2524	KEY `biblionumber` (`biblionumber`),	2524	KEY `biblionumber` (`biblionumber`),
		2525	KEY `budget_id` (`budget_id`),
2525	CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,	2526	CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
2526	CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE	2527	CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE
2527	) ENGINE=InnoDB DEFAULT CHARSET=utf8;	2528	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2528		2529
		2530
2529	--	2531	--
2530	-- Table structure for table `aqorders_items`	2532	-- Table structure for table `aqorders_items`
2531	--	2533	--