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