laravel
2020-11-20 14:10:37 +08:00
CREATE TABLE `oc_product_option` (
`product_option_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`option_id` int(11) NOT NULL,
`value` text NOT NULL,
`required` tinyint(1) NOT NULL,
PRIMARY KEY (`product_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE `oc_product_option_value` (
`product_option_value_id` int(11) NOT NULL AUTO_INCREMENT,
`product_option_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`option_id` int(11) NOT NULL,
`option_value_id` int(11) NOT NULL,
`quantity` int(3) NOT NULL,
`subtract` tinyint(1) NOT NULL,
`price` decimal(15,4) NOT NULL,
`price_prefix` varchar(1) NOT NULL,
`points` int(8) NOT NULL,
`points_prefix` varchar(1) NOT NULL,
`weight` decimal(15,8) NOT NULL,
`weight_prefix` varchar(1) NOT NULL,
PRIMARY KEY (`product_option_value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;