1-- ============================================================================ 2-- Copyright (C) 2014 Cédric GROSS <c.gross@kreiz-it.fr> 3-- Copyright (C) 2016 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-- This table is dedicated to store detail (lots/serial) of a stock 19-- ============================================================================ 20 21CREATE TABLE llx_product_batch ( 22 rowid integer AUTO_INCREMENT PRIMARY KEY, 23 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 24 fk_product_stock integer NOT NULL, 25 eatby datetime DEFAULT NULL, -- deprecated. should not be used here but should be stored into a table llx_product_lot 26 sellby datetime DEFAULT NULL, -- deprecated. should not be used here but should be stored into a table llx_product_lot 27 batch varchar(128) NOT NULL, 28 qty double NOT NULL DEFAULT 0, 29 import_key varchar(14) DEFAULT NULL 30) ENGINE=innodb; 31 32