<?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 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.35, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.7, 7.2.29 - 7.2.33, 7.3.12 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- 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;
preferences:
246.72 ms | 410 KiB | 341 Q