1-- ======================================================================== 2-- Copyright (C) 2001-2002,2004 Rodolphe Quiedeville <rodolphe@quiedeville.org> 3-- Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net> 4-- Copyright (C) 2012 Florian Henry <florian.henry@open-concept.pro> 5-- 6-- This program is free software; you can redistribute it and/or modify 7-- it under the terms of the GNU General Public License as published by 8-- the Free Software Foundation; either version 3 of the License, or 9-- (at your option) any later version. 10-- 11-- This program is distributed in the hope that it will be useful, 12-- but WITHOUT ANY WARRANTY; without even the implied warranty of 13-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 14-- GNU General Public License for more details. 15-- 16-- You should have received a copy of the GNU General Public License 17-- along with this program. If not, see <https://www.gnu.org/licenses/>. 18-- 19-- ======================================================================== 20 21create table llx_c_actioncomm 22( 23 id integer PRIMARY KEY, 24 code varchar(50) NOT NULL, 25 type varchar(50) DEFAULT 'system' NOT NULL, 26 libelle varchar(48) NOT NULL, 27 module varchar(50) DEFAULT NULL, 28 active tinyint DEFAULT 1 NOT NULL, 29 todo tinyint, -- deprecated 30 color varchar(9), 31 picto varchar(48), 32 position integer NOT NULL DEFAULT 0 33)ENGINE=innodb; 34