1-- Copyright (C) 2019 Laurent Destailleur <eldy@users.sourceforge.net> 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 http://www.gnu.org/licenses/. 15 16 17CREATE TABLE llx_mrp_mo( 18 -- BEGIN MODULEBUILDER FIELDS 19 rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, 20 ref varchar(128) DEFAULT '(PROV)' NOT NULL, 21 entity integer DEFAULT 1 NOT NULL, 22 label varchar(255), 23 qty real NOT NULL, 24 fk_warehouse integer, 25 fk_soc integer, 26 note_public text, 27 note_private text, 28 date_creation datetime NOT NULL, 29 date_valid datetime NULL, 30 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 31 fk_user_creat integer NOT NULL, 32 fk_user_modif integer, 33 fk_user_valid integer, 34 import_key varchar(14), 35 model_pdf varchar(255), 36 status integer NOT NULL, 37 fk_product integer NOT NULL, 38 date_start_planned datetime, 39 date_end_planned datetime, 40 fk_bom integer, 41 fk_project integer 42 -- END MODULEBUILDER FIELDS 43) ENGINE=innodb;