"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/622465.result" (6 May 2012, 410 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE TABLE t1 (id INT PRIMARY KEY);
    2 CREATE TABLE `t2` LIKE `t1`;
    3 ALTER TABLE `t2` ADD FOREIGN KEY (`id`) REFERENCES `t1`(`id`);
    4 CREATE TABLE `t3` LIKE `t2`;
    5 SHOW CREATE TABLE t3;
    6 Table	Create Table
    7 t3	CREATE TABLE `t3` (
    8   `id` INT NOT NULL,
    9   PRIMARY KEY (`id`) USING BTREE,
   10   CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`id`) REFERENCES `t1` (`id`)
   11 ) ENGINE=InnoDB COLLATE = utf8_general_ci
   12 DROP TABLE t2, t3, t1;