3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php define('DB_PREFIX', ''); echo $sql = " CREATE TABLE `" . DB_PREFIX . "category_option` ( `option_id` int(10) NOT NULL auto_increment, `status` int(1) default '0', `sort_order` int(10) default '0', PRIMARY KEY (`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `" . DB_PREFIX . "category_option_description` ( `option_id` int(10) NOT NULL, `language_id` int(10) NOT NULL, `name` varchar(127) NOT NULL, PRIMARY KEY (`option_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `" . DB_PREFIX . "category_option_to_category` ( `option_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, PRIMARY KEY (`category_id`,`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `" . DB_PREFIX . "category_option_value` ( `value_id` int(10) NOT NULL auto_increment, `option_id` int(10) default '0', `sort_order` int(10) default '0', PRIMARY KEY (`value_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `" . DB_PREFIX . "category_option_value_description` ( `value_id` int(10) NOT NULL, `language_id` int(10) NOT NULL, `option_id` int(10) NOT NULL, `name` varchar(127) NOT NULL, PRIMARY KEY (`value_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `" . DB_PREFIX . "product_to_value` ( `product_id` int(11) NOT NULL, `value_id` int(11) NOT NULL, `option_id` int(11) NOT NULL, PRIMARY KEY (`product_id`,`value_id`,`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; ";
Output for 4.3.0 - 7.1.0
CREATE TABLE `category_option` ( `option_id` int(10) NOT NULL auto_increment, `status` int(1) default '0', `sort_order` int(10) default '0', PRIMARY KEY (`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `category_option_description` ( `option_id` int(10) NOT NULL, `language_id` int(10) NOT NULL, `name` varchar(127) NOT NULL, PRIMARY KEY (`option_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `category_option_to_category` ( `option_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, PRIMARY KEY (`category_id`,`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `category_option_value` ( `value_id` int(10) NOT NULL auto_increment, `option_id` int(10) default '0', `sort_order` int(10) default '0', PRIMARY KEY (`value_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `category_option_value_description` ( `value_id` int(10) NOT NULL, `language_id` int(10) NOT NULL, `option_id` int(10) NOT NULL, `name` varchar(127) NOT NULL, PRIMARY KEY (`value_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE `product_to_value` ( `product_id` int(11) NOT NULL, `value_id` int(11) NOT NULL, `option_id` int(11) NOT NULL, PRIMARY KEY (`product_id`,`value_id`,`option_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;