1-- ========================================================================
2-- Copyright (C) 2005     Patrick Rouillon     <patrick.rouillon.net>
3-- Copyright (C) 2005     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-- Defini les types de contact d'un element sert de reference pour
19-- la table llx_element_contact
20--
21-- element est le nom de la table utilisant le type de contact.
22-- i.e. contact, facture, projet, societe (sans le llx_ devant).
23-- Libelle est un texte decrivant le type de contact.
24-- active precise si cette valeur est 'active' ou 'archive'.
25--
26-- ========================================================================
27
28
29create table llx_c_type_contact
30(
31  rowid      	integer     PRIMARY KEY,
32  element       varchar(30) NOT NULL,
33  source        varchar(8)  DEFAULT 'external' NOT NULL,
34  code          varchar(32) NOT NULL,
35  libelle 	    varchar(64)	NOT NULL,
36  active  	    tinyint DEFAULT 1  NOT NULL,
37  module        varchar(32) NULL,
38  position      integer NOT NULL DEFAULT 0
39)ENGINE=innodb;
40