1-- ======================================================================== 2-- Copyright (C) 2021 Laurent Destailleur <eldy@users.sourceforge.net> 3-- 4-- This program is free software; you can redistribute it and/or modify 5-- it under the terms of the GNU General Public License as published by 6-- the Free Software Foundation; either version 3 of the License, or 7-- (at your option) any later version. 8-- 9-- This program is distributed in the hope that it will be useful, 10-- but WITHOUT ANY WARRANTY; without even the implied warranty of 11-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12-- GNU General Public License for more details. 13-- 14-- You should have received a copy of the GNU General Public License 15-- along with this program. If not, see <https://www.gnu.org/licenses/>. 16-- 17-- Defini les types de contact d'un element sert de reference pour 18-- la table llx_element_contact 19-- 20-- element est le nom de la table utilisant le type de contact. 21-- i.e. contact, facture, projet, societe (sans le llx_ devant). 22-- Libelle est un texte decrivant le type de contact. 23-- active precise si cette valeur est 'active' ou 'archive'. 24-- 25-- ======================================================================== 26 27create table llx_c_partnership_type 28( 29 rowid integer AUTO_INCREMENT PRIMARY KEY, 30 entity integer DEFAULT 1 NOT NULL, 31 code varchar(32) NOT NULL, 32 label varchar(64) NOT NULL, 33 active tinyint DEFAULT 1 NOT NULL 34)ENGINE=innodb; 35 36