column_removal.php File Reference

Go to the source code of this file.

Variables
	return ['auto_increment_test'=> 'CREATE TABLE `auto_increment_test`(`int_auto_increment_with_nullable` int(12) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `AUTO_INCREMENT_TEST_INT_AUTO_INCREMENT_WITH_NULLABLE`(`int_auto_increment_with_nullable`)) ENGINE=InnoDB DEFAULT CHARSET=utf8', 'reference_table'=> '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\', `integer_without_padding` int(11) NOT NULL DEFAULT \ '0\', `smallint_with_big_padding` smallint(254) NOT NULL DEFAULT \ '0\', `smallint_without_default` smallint(2) DEFAULT NULL, `int_without_unsigned` int(2) DEFAULT NULL, `int_unsigned` int(2) unsigned DEFAULT NULL, `bigint_default_nullable` bigint(2) unsigned DEFAULT \ '1\', `bigint_not_default_not_nullable` bigint(2) unsigned NOT NULL, PRIMARY KEY(`tinyint_ref`)) ENGINE=InnoDB DEFAULT CHARSET=utf8', 'test_table'=> 'CREATE TABLE `test_table`(`smallint` smallint(3) NOT NULL AUTO_INCREMENT, `tinyint` tinyint(7) DEFAULT NULL, `bigint` bigint(13) DEFAULT \ '0\', `float` float(12, 10) DEFAULT \ '0.0000000000\', `double` double(245, 10) DEFAULT \ '11111111.1111110000\', `decimal` decimal(15, 4) DEFAULT \ '0.0000\', `date` date DEFAULT NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `datetime` datetime DEFAULT \ '0000-00-00 00:00:00\', `longtext` longtext, `mediumtext` mediumtext, `varchar` varchar(254) DEFAULT NULL, `blob` blob, `boolean` tinyint(1) DEFAULT NULL, `varbinary_rename` varbinary(255) DEFAULT \ '10101\', UNIQUE KEY `TEST_TABLE_SMALLINT_BIGINT`(`smallint`,`bigint`), KEY `TEST_TABLE_TINYINT_BIGINT`(`tinyint`,`bigint`), CONSTRAINT `TEST_TABLE_TINYINT_REFERENCE_TABLE_TINYINT_REF` FOREIGN KEY(`tinyint`) REFERENCES `reference_table`(`tinyint_ref`) ON DELETE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=utf8',]

Variable Documentation

return

return[ 'auto_increment_test'=> 'CREATE TABLE `auto_increment_test`( `int_auto_increment_with_nullable` int(12) unsigned NOT NULL AUTO_INCREMENT, UNIQUE KEY `AUTO_INCREMENT_TEST_INT_AUTO_INCREMENT_WITH_NULLABLE`(`int_auto_increment_with_nullable`)) ENGINE=InnoDB DEFAULT CHARSET=utf8', 'reference_table'=> '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\', `integer_without_padding` int(11) NOT NULL DEFAULT \ '0\', `smallint_with_big_padding` smallint(254) NOT NULL DEFAULT \ '0\', `smallint_without_default` smallint(2) DEFAULT NULL, `int_without_unsigned` int(2) DEFAULT NULL, `int_unsigned` int(2) unsigned DEFAULT NULL, `bigint_default_nullable` bigint(2) unsigned DEFAULT \ '1\', `bigint_not_default_not_nullable` bigint(2) unsigned NOT NULL, PRIMARY KEY(`tinyint_ref`)) ENGINE=InnoDB DEFAULT CHARSET=utf8', 'test_table'=> 'CREATE TABLE `test_table`( `smallint` smallint(3) NOT NULL AUTO_INCREMENT, `tinyint` tinyint(7) DEFAULT NULL, `bigint` bigint(13) DEFAULT \ '0\', `float` float(12, 10) DEFAULT \ '0.0000000000\', `double` double(245, 10) DEFAULT \ '11111111.1111110000\', `decimal` decimal(15, 4) DEFAULT \ '0.0000\', `date` date DEFAULT NULL, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `datetime` datetime DEFAULT \ '0000-00-00 00:00:00\', `longtext` longtext, `mediumtext` mediumtext, `varchar` varchar(254) DEFAULT NULL, `blob` blob, `boolean` tinyint(1) DEFAULT NULL, `varbinary_rename` varbinary(255) DEFAULT \ '10101\', UNIQUE KEY `TEST_TABLE_SMALLINT_BIGINT`(`smallint`,`bigint`), KEY `TEST_TABLE_TINYINT_BIGINT`(`tinyint`,`bigint`), CONSTRAINT `TEST_TABLE_TINYINT_REFERENCE_TABLE_TINYINT_REF` FOREIGN KEY(`tinyint`) REFERENCES `reference_table`(`tinyint_ref`) ON DELETE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=utf8',]

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

Definition at line 45 of file column_removal.php.