1-- =================================================================== 2-- Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org> 3-- Copyright (C) 2009-2014 Laurent Destailleur <eldy@users.sourceforge.net> 4-- Copyright (C) 2010 Juanjo Menent <jmenent@2byte.es> 5-- Copyright (C) 2010-2012 Regis Houssin <regis.houssin@inodbox.com> 6-- Copyright (C) 2012 Cédric Salvador <csalvador@gpcsolutions.fr> 7-- Copyright (C) 2016-2018 Charlene Benke <charlie@patas-monkey.com> 8-- 9-- This program is free software; you can redistribute it and/or modify 10-- it under the terms of the GNU General Public License as published by 11-- the Free Software Foundation; either version 3 of the License, or 12-- (at your option) any later version. 13-- 14-- This program is distributed in the hope that it will be useful, 15-- but WITHOUT ANY WARRANTY; without even the implied warranty of 16-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 17-- GNU General Public License for more details. 18-- 19-- You should have received a copy of the GNU General Public License 20-- along with this program. If not, see <https://www.gnu.org/licenses/>. 21-- 22-- =================================================================== 23 24create table llx_fichinterdet_rec 25( 26 rowid integer AUTO_INCREMENT PRIMARY KEY, 27 fk_fichinter integer NOT NULL, 28 date datetime, -- date de la ligne d'intervention 29 description text, -- description de la ligne d'intervention 30 duree integer, -- duree de la ligne d'intervention 31 rang integer DEFAULT 0, -- ordre affichage sur la fiche 32 total_ht DOUBLE(24, 8) NULL DEFAULT NULL, 33 subprice DOUBLE(24, 8) NULL DEFAULT NULL, 34 fk_parent_line integer NULL DEFAULT NULL, 35 fk_product integer NULL DEFAULT NULL, 36 label varchar(255) NULL DEFAULT NULL, 37 tva_tx DOUBLE(6, 3) NULL DEFAULT NULL, 38 localtax1_tx DOUBLE(6, 3) NULL DEFAULT 0, 39 localtax1_type VARCHAR(1) NULL DEFAULT NULL, 40 localtax2_tx DOUBLE(6, 3) NULL DEFAULT 0, 41 localtax2_type VARCHAR(1) NULL DEFAULT NULL, 42 qty double NULL DEFAULT NULL, 43 remise_percent double NULL DEFAULT 0, 44 remise double NULL DEFAULT 0, 45 fk_remise_except integer NULL DEFAULT NULL, 46 price DOUBLE(24, 8) NULL DEFAULT NULL, 47 total_tva DOUBLE(24, 8) NULL DEFAULT NULL, 48 total_localtax1 DOUBLE(24, 8) NULL DEFAULT 0, 49 total_localtax2 DOUBLE(24, 8) NULL DEFAULT 0, 50 total_ttc DOUBLE(24, 8) NULL DEFAULT NULL, 51 product_type INTEGER NULL DEFAULT 0, 52 date_start datetime NULL DEFAULT NULL, 53 date_end datetime NULL DEFAULT NULL, 54 info_bits INTEGER NULL DEFAULT 0, 55 buy_price_ht DOUBLE(24, 8) NULL DEFAULT 0, 56 fk_product_fournisseur_price integer NULL DEFAULT NULL, 57 fk_code_ventilation integer NOT NULL DEFAULT 0, 58 fk_export_commpta integer NOT NULL DEFAULT 0, 59 special_code integer UNSIGNED NULL DEFAULT 0, 60 fk_unit integer NULL DEFAULT NULL, 61 import_key varchar(14) NULL DEFAULT NULL 62 63)ENGINE=innodb; 64