1-- ============================================================================
2-- Copyright (C) 2001-2002 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3-- Copyright (C) 2003      Jean-Louis Bergamo   <jlb@j1b.org>
4-- Copyright (C) 2008-2009 Laurent Destailleur  <eldy@users.sourceforge.net>
5-- Copyright (C) 2009      Regis Houssin        <regis.houssin@inodbox.com>
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
22--
23-- Table for constants used to store Dolibarr setup
24--
25
26create table llx_const
27(
28  rowid       integer AUTO_INCREMENT PRIMARY KEY,
29  name        varchar(180) NOT NULL,
30  entity      integer DEFAULT 1 NOT NULL,	-- multi company id
31  value       text NOT NULL, 				-- max 65535 caracteres
32  type        varchar(64) DEFAULT 'string', -- null or 'encrypted' if param has been encrypted
33  visible     tinyint DEFAULT 1 NOT NULL,
34  note        text,
35  tms         timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
36) ENGINE=innodb;
37
38--
39-- List of codes for the field entity
40--
41-- 0 : common constant
42-- 1 : first company constant
43-- 2 : second company constant
44-- 3 : etc...
45--
46