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