1-- ============================================================================ 2-- Copyright (C) 2016 Marcos García <marcosgdf@gmail.com> 3-- Copyright (C) 2020 Laurent Destailleur <eldy@users.sourceforge.net> 4-- 5-- This program is free software; you can redistribute it and/or modify 6-- it under the terms of the GNU General Public License as published by 7-- the Free Software Foundation; either version 3 of the License, or 8-- (at your option) any later version. 9-- 10-- This program is distributed in the hope that it will be useful, 11-- but WITHOUT ANY WARRANTY; without even the implied warranty of 12-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13-- GNU General Public License for more details. 14-- 15-- You should have received a copy of the GNU General Public License 16-- along with this program. If not, see <https://www.gnu.org/licenses/>. 17-- 18-- Table to store links between a parent product and its variant products. 19-- ============================================================================ 20 21CREATE TABLE llx_product_attribute_combination 22( 23 rowid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, 24 fk_product_parent INTEGER NOT NULL, -- id of product id that is parent product 25 fk_product_child INTEGER NOT NULL, -- id of product id that is variant (child) product 26 variation_price DOUBLE(24,8) NOT NULL, 27 variation_price_percentage INTEGER NULL, 28 variation_weight REAL NOT NULL, 29 variation_ref_ext VARCHAR(255) NULL, 30 entity INTEGER DEFAULT 1 NOT NULL 31)ENGINE=innodb; 32