dry_run_log.php File Reference

Go to the source code of this file.

Variables
	return ['CREATE TABLE `reference_table`(`tinyint_ref` tinyint(7) NOT NULL AUTO_INCREMENT, `tinyint_without_padding` tinyint(2) NOT NULL DEFAULT 0, `bigint_without_padding` bigint(20) NOT NULL DEFAULT 0, `smallint_without_padding` smallint(5) NOT NULL DEFAULT 0, `integer_without_padding` int(11) NOT NULL DEFAULT 0, `smallint_with_big_padding` smallint(254) NOT NULL DEFAULT 0, `smallint_without_default` smallint(2) NULL, `int_without_unsigned` int(2) NULL, `int_unsigned` int(2) UNSIGNED NULL, `bigint_default_nullable` bigint(2) UNSIGNED NULL DEFAULT 1, `bigint_not_default_not_nullable` bigint(2) UNSIGNED NOT NULL, CONSTRAINT PRIMARY KEY(`tinyint_ref`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `auto_increment_test`(`int_auto_increment_with_nullable` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, `int_disabled_auto_increment` smallint(12) UNSIGNED NULL DEFAULT 0, CONSTRAINT `AUTO_INCREMENT_TEST_INT_AUTO_INCREMENT_WITH_NULLABLE` UNIQUE KEY(`int_auto_increment_with_nullable`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `test_table`(`smallint` smallint(3) NOT NULL AUTO_INCREMENT, `tinyint` tinyint(7) NULL, `bigint` bigint(13) NULL DEFAULT 0, `float` float(12, 4) NULL DEFAULT 0, `double` decimal(14, 6) NULL DEFAULT 11111111.111111, `decimal` decimal(15, 4) NULL DEFAULT 0, `date` date NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `datetime` datetime NULL DEFAULT 0, `longtext` longtext NULL, `mediumtext` mediumtext NULL, `varchar` varchar(254) NULL, `mediumblob` mediumblob NULL, `blob` blob NULL, `boolean` BOOLEAN NULL, CONSTRAINT `TEST_TABLE_SMALLINT_BIGINT` UNIQUE KEY(`smallint`,`bigint`), CONSTRAINT `TEST_TABLE_TINYINT_REFERENCE_TABLE_TINYINT_REF` FOREIGN KEY(`tinyint`) REFERENCES `reference_table`(`tinyint_ref`) ON DELETE NO ACTION, INDEX `TEST_TABLE_TINYINT_BIGINT`(`tinyint`,`bigint`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `patch_list`(`patch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT "Patch Auto Increment", `patch_name` varchar(1024) NOT NULL COMMENT "Patch Class Name", CONSTRAINT PRIMARY KEY(`patch_id`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci COMMENT="List of data/schema patches"']

Variable Documentation

return

return[ 'CREATE TABLE `reference_table`(`tinyint_ref` tinyint(7) NOT NULL AUTO_INCREMENT, `tinyint_without_padding` tinyint(2) NOT NULL DEFAULT 0, `bigint_without_padding` bigint(20) NOT NULL DEFAULT 0, `smallint_without_padding` smallint(5) NOT NULL DEFAULT 0, `integer_without_padding` int(11) NOT NULL DEFAULT 0, `smallint_with_big_padding` smallint(254) NOT NULL DEFAULT 0, `smallint_without_default` smallint(2) NULL, `int_without_unsigned` int(2) NULL, `int_unsigned` int(2) UNSIGNED NULL, `bigint_default_nullable` bigint(2) UNSIGNED NULL DEFAULT 1, `bigint_not_default_not_nullable` bigint(2) UNSIGNED NOT NULL, CONSTRAINT PRIMARY KEY(`tinyint_ref`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `auto_increment_test`(`int_auto_increment_with_nullable` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, `int_disabled_auto_increment` smallint(12) UNSIGNED NULL DEFAULT 0, CONSTRAINT `AUTO_INCREMENT_TEST_INT_AUTO_INCREMENT_WITH_NULLABLE` UNIQUE KEY(`int_auto_increment_with_nullable`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `test_table`(`smallint` smallint(3) NOT NULL AUTO_INCREMENT, `tinyint` tinyint(7) NULL, `bigint` bigint(13) NULL DEFAULT 0, `float` float(12, 4) NULL DEFAULT 0, `double` decimal(14, 6) NULL DEFAULT 11111111.111111, `decimal` decimal(15, 4) NULL DEFAULT 0, `date` date NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `datetime` datetime NULL DEFAULT 0, `longtext` longtext NULL, `mediumtext` mediumtext NULL, `varchar` varchar(254) NULL, `mediumblob` mediumblob NULL, `blob` blob NULL, `boolean` BOOLEAN NULL, CONSTRAINT `TEST_TABLE_SMALLINT_BIGINT` UNIQUE KEY(`smallint`,`bigint`), CONSTRAINT `TEST_TABLE_TINYINT_REFERENCE_TABLE_TINYINT_REF` FOREIGN KEY(`tinyint`) REFERENCES `reference_table`(`tinyint_ref`) ON DELETE NO ACTION, INDEX `TEST_TABLE_TINYINT_BIGINT`(`tinyint`,`bigint`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci CREATE TABLE `patch_list`(`patch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT "Patch Auto Increment", `patch_name` varchar(1024) NOT NULL COMMENT "Patch Class Name", CONSTRAINT PRIMARY KEY(`patch_id`)) ENGINE=innodb DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci COMMENT="List of data/schema patches"']

Copyright © Magento, Inc. All rights reserved. See COPYING.txt for license details.

Definition at line 55 of file dry_run_log.php.