diff options
Diffstat (limited to 'test')
-rw-r--r-- | test/classes/plugin/export/PMA_ExportSql_test.php | 23 |
1 files changed, 16 insertions, 7 deletions
diff --git a/test/classes/plugin/export/PMA_ExportSql_test.php b/test/classes/plugin/export/PMA_ExportSql_test.php index 1b724c0e22..ab0f02190f 100644 --- a/test/classes/plugin/export/PMA_ExportSql_test.php +++ b/test/classes/plugin/export/PMA_ExportSql_test.php @@ -1222,12 +1222,21 @@ class PMA_ExportSql_Test extends PHPUnit_Framework_TestCase $row = array( '', "CREATE TABLE `table` (\n" . - "`id` INT NOT NULL AUTO_INCREMENT,\n" . - "username VARCHAR(64) NULL,\n" . - "`password` VARCHAR(256) DEFAULT '123456',\n" . - "CONSTRAINT pk_id PRIMARY KEY (`id`),\n" . - "UNIQUE (username)\n" . - ")" + "`payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,\n" . + "`customer_id` smallint(5) unsigned NOT NULL,\n" . + "`staff_id` tinyint(3) unsigned NOT NULL,\n" . + "`rental_id` int(11) DEFAULT NULL,\n" . + "`amount` decimal(5,2) NOT NULL,\n" . + "`payment_date` datetime NOT NULL,\n" . + "`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n" . + "PRIMARY KEY (`payment_id`),\n" . + "KEY `idx_fk_staff_id` (`staff_id`),\n" . + "KEY `idx_fk_customer_id` (`customer_id`),\n" . + "KEY `fk_payment_rental` (`rental_id`),\n" . + "CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE,\n" . + "CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE,\n" . + "CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE\n" . + ") ENGINE=InnoDB AUTO_INCREMENT=16050 DEFAULT CHARSET=utf8\n" ); $dbi->expects($this->once()) @@ -1298,7 +1307,7 @@ class PMA_ExportSql_Test extends PHPUnit_Framework_TestCase ); $this->assertContains( - 'ALTER TABLE "db"."table"' . "\n", + 'ALTER TABLE "table"', $GLOBALS['sql_drop_foreign_keys'] ); |