← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/foreign_key.result

  • Committer: Mark Atwood
  • Date: 2011-07-18 21:41:28 UTC
  • mfrom: (2363.1.5 drizzle-trunk)
  • Revision ID: me@mark.atwood.name-20110718214128-tj8my4mqt62dslxn
merge lp:~brianaker/drizzle/798940

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