1-- =================================================================== 2-- Copyright (C) 2004 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-- =================================================================== 18 19CREATE TABLE llx_partnership( 20 rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, 21 ref varchar(128) DEFAULT '(PROV)' NOT NULL, 22 status smallint NOT NULL DEFAULT '0', 23 fk_soc integer, 24 fk_member integer, 25 date_partnership_start date NOT NULL, 26 date_partnership_end date NULL, 27 entity integer DEFAULT 1 NOT NULL, -- multi company id, 0 = all 28 reason_decline_or_cancel text NULL, 29 date_creation datetime NOT NULL, 30 fk_user_creat integer NOT NULL, 31 tms timestamp, 32 fk_user_modif integer, 33 note_private text, 34 note_public text, 35 last_main_doc varchar(255), 36 count_last_url_check_error integer DEFAULT '0', 37 last_check_backlink datetime NULL, 38 import_key varchar(14), 39 model_pdf varchar(255) 40) ENGINE=innodb;