← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/r/foreign_key.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/foreign_key.result
18
18
show create table product_order;
19
19
Table   Create Table
20
20
product_order   CREATE TABLE `product_order` (
21
 
  `no` int NOT NULL AUTO_INCREMENT,
22
 
  `product_category` int NOT NULL,
23
 
  `product_id` int NOT NULL,
24
 
  `customer_id` int NOT NULL,
 
21
  `no` INT NOT NULL AUTO_INCREMENT,
 
22
  `product_category` INT NOT NULL,
 
23
  `product_id` INT NOT NULL,
 
24
  `customer_id` INT NOT NULL,
25
25
  PRIMARY KEY (`no`),
26
26
  KEY `product_category` (`product_category`,`product_id`),
27
27
  KEY `customer_id` (`customer_id`),
28
 
  CONSTRAINT `product_order_ibfk_1` FOREIGN KEY (`product_category`, `product_id`) REFERENCES `product` (`category`, `id`) ON UPDATE CASCADE,
 
28
  CONSTRAINT `product_order_ibfk_1` FOREIGN KEY (`product_category`, `product_id`) REFERENCES `product` (`category`, `id`) ON UPDATE CASCADE ON DELETE RESTRICT,
29
29
  CONSTRAINT `product_order_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
30
 
) ENGINE=InnoDB
 
30
) ENGINE=InnoDB COLLATE = utf8_general_ci
31
31
drop table product_order, customer, product;
32
32
drop table if exists t_34455;
33
33
create table t_34455 (