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 16 17CREATE TABLE llx_bom_bom( 18 -- BEGIN MODULEBUILDER FIELDS 19 rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, 20 entity integer DEFAULT 1 NOT NULL, 21 ref varchar(128) NOT NULL, 22 bomtype integer DEFAULT 0, -- 0 for a BOM to manufacture, 1 for a BOM to dismantle 23 label varchar(255), 24 fk_product integer, 25 description text, 26 note_public text, 27 note_private text, 28 fk_warehouse integer, 29 qty double(24,8), 30 efficiency double(24,8) DEFAULT 1, 31 duration double(24,8) DEFAULT NULL, 32 date_creation datetime NOT NULL, 33 date_valid datetime, 34 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 35 fk_user_creat integer NOT NULL, 36 fk_user_modif integer, 37 fk_user_valid integer, 38 import_key varchar(14), 39 model_pdf varchar(255), 40 status integer NOT NULL 41 -- END MODULEBUILDER FIELDS 42) ENGINE=innodb; 43