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