1-- ============================================================================ 2-- Copyright (C) 2001-2004 Rodolphe Quiedeville <rodolphe@quiedeville.org> 3-- Copyright (C) 2008 Laurent Destailleur <eldy@users.sourceforge.net> 4-- Copyright (C) 2005-2010 Regis Houssin <regis.houssin@inodbox.com> 5-- Copyright (C) 2020 Open-Dsi <support@open-dsi.fr> 6-- 7-- This program is free software; you can redistribute it and/or modify 8-- it under the terms of the GNU General Public License as published by 9-- the Free Software Foundation; either version 3 of the License, or 10-- (at your option) any later version. 11-- 12-- This program is distributed in the hope that it will be useful, 13-- but WITHOUT ANY WARRANTY; without even the implied warranty of 14-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 15-- GNU General Public License for more details. 16-- 17-- You should have received a copy of the GNU General Public License 18-- along with this program. If not, see <https://www.gnu.org/licenses/>. 19-- 20-- ============================================================================ 21 22create table llx_socpeople 23( 24 rowid integer AUTO_INCREMENT PRIMARY KEY, 25 datec datetime, 26 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 27 fk_soc integer, -- lien vers la societe 28 entity integer DEFAULT 1 NOT NULL, -- multi company id 29 ref_ext varchar(255), -- reference into an external system (not used by dolibarr) 30 civility varchar(6), 31 lastname varchar(50), 32 firstname varchar(50), 33 address varchar(255), 34 zip varchar(25), 35 town varchar(255), 36 fk_departement integer, 37 fk_pays integer DEFAULT 0, 38 birthday date, 39 poste varchar(255), 40 phone varchar(30), 41 phone_perso varchar(30), 42 phone_mobile varchar(30), 43 fax varchar(30), 44 email varchar(255), 45 46 socialnetworks text DEFAULT NULL, -- json with socialnetworks 47 jabberid varchar(255), 48 skype varchar(255), 49 twitter varchar(255), -- 50 facebook varchar(255), -- 51 linkedin varchar(255), -- 52 instagram varchar(255), -- 53 snapchat varchar(255), -- 54 googleplus varchar(255), -- 55 youtube varchar(255), -- 56 whatsapp varchar(255), -- 57 58 photo varchar(255), 59 no_email smallint NOT NULL DEFAULT 0, -- deprecated. Use table llx_mailing_unsubscribe instead 60 priv smallint NOT NULL DEFAULT 0, 61 fk_prospectcontactlevel varchar(12), -- prospect level (in llx_c_prospectcontactlevel) 62 fk_stcommcontact integer DEFAULT 0 NOT NULL, -- commercial statut 63 fk_user_creat integer DEFAULT 0, -- user qui a creel'enregistrement 64 fk_user_modif integer, 65 note_private text, 66 note_public text, 67 default_lang varchar(6), 68 canvas varchar(32), -- type of canvas if used (null by default) 69 import_key varchar(14), 70 statut tinyint DEFAULT 1 NOT NULL 71)ENGINE=innodb; 72