-- Copyright (C) ---Put here your own copyright and developer email---
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 3 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program. If not, see https://www.gnu.org/licenses/.

CREATE TABLE llx_livraisondet (  rowid int(11) NOT NULL AUTO_INCREMENT,  fk_livraison int(11) NOT NULL,  fk_parent_line int(11) DEFAULT NULL,  fk_product int(11) DEFAULT NULL,  label varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,  description text COLLATE utf8_unicode_ci DEFAULT NULL,  vat_src_code varchar(10) COLLATE utf8_unicode_ci DEFAULT '',  tva_tx double(6,3) DEFAULT NULL,  localtax1_tx double(6,3) DEFAULT 0.000,  localtax1_type varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,  localtax2_tx double(6,3) DEFAULT 0.000,  localtax2_type varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,  qty double DEFAULT NULL,  remise_percent double DEFAULT 0,  remise double DEFAULT 0,  fk_remise_except int(11) DEFAULT NULL,  price double DEFAULT NULL,  subprice double(24,8) DEFAULT 0.00000000,  total_ht double(24,8) DEFAULT 0.00000000,  total_tva double(24,8) DEFAULT 0.00000000,  total_localtax1 double(24,8) DEFAULT 0.00000000,  total_localtax2 double(24,8) DEFAULT 0.00000000,  total_ttc double(24,8) DEFAULT 0.00000000,  product_type int(11) DEFAULT 0,  date_start datetime DEFAULT NULL,  date_end datetime DEFAULT NULL,  info_bits int(11) DEFAULT 0,  buy_price_ht double(24,8) DEFAULT 0.00000000,  fk_product_fournisseur_price int(11) DEFAULT NULL,  special_code int(11) DEFAULT 0,  rang int(11) DEFAULT 0,  fk_unit int(11) DEFAULT NULL,  import_key varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,  ref_ext varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,  fk_commandefourndet int(11) DEFAULT NULL,  fk_multicurrency int(11) DEFAULT NULL,  multicurrency_code varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,  multicurrency_subprice double(24,8) DEFAULT 0.00000000,  multicurrency_total_ht double(24,8) DEFAULT 0.00000000,  multicurrency_total_tva double(24,8) DEFAULT 0.00000000,  multicurrency_total_ttc double(24,8) DEFAULT 0.00000000,  PRIMARY KEY (rowid)) ENGINE=InnoDB;