Hello Rainer,
This is from the install phoenix 1.0.7.14
DROP TABLE IF EXISTS products_attributes;
CREATE TABLE products_attributes (
products_attributes_id int NOT NULL auto_increment,
products_id int NOT NULL,
options_id int NOT NULL,
options_values_id int NOT NULL,
options_values_price decimal(15,4) NOT NULL,
price_prefix char(1) NOT NULL,
PRIMARY KEY (products_attributes_id),
KEY idx_products_attributes_products_id (products_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
and
DROP TABLE IF EXISTS products_options;
CREATE TABLE products_options (
products_options_id int NOT NULL default '0',
language_id int NOT NULL default '1',
products_options_name varchar(255) NOT NULL default '',
sort_order int(3),
PRIMARY KEY (products_options_id,language_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
the sort order appears to not be on the right table.
