← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb.result

  • Committer: Brian Aker
  • Date: 2009-08-18 07:19:56 UTC
  • mfrom: (1116.1.3 stewart)
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090818071956-nfpoe9rp3i7p50kx
Merge my branch from Stewart into one branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb.result
2752
2752
t1      CREATE TABLE `t1` (
2753
2753
  `id` int NOT NULL AUTO_INCREMENT,
2754
2754
  PRIMARY KEY (`id`)
2755
 
) ENGINE=InnoDB AUTO_INCREMENT=349
 
2755
) ENGINE=InnoDB
2756
2756
CREATE TABLE t2 (id int PRIMARY KEY) ENGINE=InnoDB;
2757
2757
INSERT INTO t2 VALUES(42),(347),(348);
2758
2758
ALTER TABLE t1 ADD CONSTRAINT t1_t2 FOREIGN KEY (id) REFERENCES t2(id);
2762
2762
  `id` int NOT NULL AUTO_INCREMENT,
2763
2763
  PRIMARY KEY (`id`),
2764
2764
  CONSTRAINT `t1_t2` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)
2765
 
) ENGINE=InnoDB AUTO_INCREMENT=349
 
2765
) ENGINE=InnoDB
2766
2766
DROP TABLE t1,t2;
2767
2767
DROP TABLE IF EXISTS t1;
2768
2768
Warnings: