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