1-- ===========================================================================
2-- Copyright (C) 2003      Rodolphe Quiedeville <rodolphe@quiedeville.org>
3-- Copyright (C) 2012-2014 Laurent Destailleur  <eldy@users.sourceforge.net>
4-- Copyright (C) 2009      Regis Houssin        <regis.houssin@inodbox.com>
5-- Copyright (C) 2010      Juanjo Menent        <jmenent@2byte.es>
6-- Copyright (C) 2018      Charlene Benke		    <charlie@patas-monkey.com>
7--
8-- This program is free software; you can redistribute it and/or modify
9-- it under the terms of the GNU General Public License as published by
10-- the Free Software Foundation; either version 3 of the License, or
11-- (at your option) any later version.
12--
13-- This program is distributed in the hope that it will be useful,
14-- but WITHOUT ANY WARRANTY; without even the implied warranty of
15-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
16-- GNU General Public License for more details.
17--
18-- You should have received a copy of the GNU General Public License
19-- along with this program. If not, see <https://www.gnu.org/licenses/>.
20--
21-- ===========================================================================
22
23create table llx_fichinter_rec
24(
25	rowid				integer AUTO_INCREMENT PRIMARY KEY,
26	titre				varchar(50) NOT NULL,
27	entity				integer DEFAULT 1 NOT NULL,	 -- multi company id
28	fk_soc				integer DEFAULT NULL,
29	datec				datetime,  -- date de creation
30
31	fk_contrat			integer DEFAULT 0,          -- contrat auquel est rattache la fiche
32	fk_user_author		integer,             -- createur
33	fk_projet			integer,             -- projet auquel est associe la facture
34	duree				real,                       -- duree totale de l'intervention
35	description			text,
36	modelpdf			varchar(50),
37	note_private		text,
38	note_public			text,
39
40	frequency			integer,					-- frequency (for example: 3 for every 3 month)
41	unit_frequency		varchar(2) DEFAULT 'm',		-- 'm' for month (date_when must be a day <= 28), 'y' for year, ...
42	date_when			datetime DEFAULT NULL,		-- date for next gen (when an invoice is generated, this field must be updated with next date)
43	date_last_gen		datetime DEFAULT NULL,		-- date for last gen (date with last successfull generation of invoice)
44	nb_gen_done			integer DEFAULT NULL,		-- nb of generation done (when an invoice is generated, this field must incremented)
45	nb_gen_max			integer DEFAULT NULL,		-- maximum number of generation
46	auto_validate		integer NULL DEFAULT NULL	-- statut of the generated intervention
47
48)ENGINE=innodb;
49