1-- Copyright (C) ---Put here your own copyright and developer email--- 2-- 3-- This program is free software: you can redistribute it and/or modify 4-- it under the terms of the GNU General Public License as published by 5-- the Free Software Foundation, either version 3 of the License, or 6-- (at your option) any later version. 7-- 8-- This program is distributed in the hope that it will be useful, 9-- but WITHOUT ANY WARRANTY; without even the implied warranty of 10-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 11-- GNU General Public License for more details. 12-- 13-- You should have received a copy of the GNU General Public License 14-- along with this program. If not, see https://www.gnu.org/licenses/. 15 16CREATE TABLE llx_bom_bomline( 17 -- BEGIN MODULEBUILDER FIELDS 18 rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, 19 fk_bom integer NOT NULL, 20 fk_product integer NOT NULL, 21 fk_bom_child integer NULL, 22 description text, 23 import_key varchar(14), 24 qty double(24,8) NOT NULL, 25 qty_frozen smallint DEFAULT 0, 26 disable_stock_change smallint DEFAULT 0, 27 efficiency double(24,8) NOT NULL DEFAULT 1, 28 position integer NOT NULL DEFAULT 0 29 -- END MODULEBUILDER FIELDS 30) ENGINE=innodb; 31