← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/foreign_key.result

  • Committer: Olaf van der Spek
  • Date: 2011-08-04 08:13:04 UTC
  • mfrom: (2384 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2385.
  • Revision ID: olafvdspek@gmail.com-20110804081304-rlejjpvoos17bjdf
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/foreign_key.result
22
22
  `product_category` INT NOT NULL,
23
23
  `product_id` INT NOT NULL,
24
24
  `customer_id` INT NOT NULL,
25
 
  PRIMARY KEY (`no`),
26
 
  KEY `product_category` (`product_category`,`product_id`),
27
 
  KEY `customer_id` (`customer_id`),
 
25
  PRIMARY KEY (`no`) USING BTREE,
 
26
  KEY `product_category` (`product_category`,`product_id`) USING BTREE,
 
27
  KEY `customer_id` (`customer_id`) USING BTREE,
28
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
30
) ENGINE=InnoDB COLLATE = utf8_general_ci