1-- Copyright (C) 2016	Laurent Destailleur	<eldy@users.sourceforge.net>
2--
3-- This program is free software: you can redistribute it and/or modify
4-- it under the terms of the GNU General Public License as published by
5-- the Free Software Foundation, either version 3 of the License, or
6-- (at your option) any later version.
7--
8-- This program is distributed in the hope that it will be useful,
9-- but WITHOUT ANY WARRANTY; without even the implied warranty of
10-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
11-- GNU General Public License for more details.
12--
13-- You should have received a copy of the GNU General Public License
14-- along with this program.  If not, see https://www.gnu.org/licenses/.
15--
16-- Table to store accounts of thirdparties on external websites (like on stripe field site = 'stripe')
17-- or on local website (fk_website).
18
19CREATE TABLE llx_societe_account(
20	-- BEGIN MODULEBUILDER FIELDS
21	rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,
22	entity	integer DEFAULT 1,
23	login             varchar(128) NOT NULL,
24	pass_encoding     varchar(24),
25	pass_crypted      varchar(128),
26	pass_temp         varchar(128),			    -- temporary password when asked for forget password
27	fk_soc integer,
28	fk_website        integer,					-- id of local web site
29	site              varchar(128),				-- name of external web site
30	site_account      varchar(128),				-- a key to identify the account on external web site
31	key_account       varchar(128),				-- the id of third party in external web site (for site_account if site_account defined)
32	note_private      text,
33	date_last_login   datetime,
34	date_previous_login datetime,
35	date_creation datetime NOT NULL,
36	tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
37	fk_user_creat integer NOT NULL,
38	fk_user_modif integer,
39	import_key varchar(14),
40	status integer
41	-- END MODULEBUILDER FIELDS
42) ENGINE=innodb;
43