1-- =================================================================== 2-- Copyright (C) 2011-2012 Regis Houssin <regis.houssin@inodbox.com> 3-- Copyright (C) 2011-2012 Laurent Destailleur <eldy@users.sourceforge.net> 4-- 5-- This program is free software; you can redistribute it and/or modify 6-- it under the terms of the GNU General Public License as published by 7-- the Free Software Foundation; either version 3 of the License, or 8-- (at your option) any later version. 9-- 10-- This program is distributed in the hope that it will be useful, 11-- but WITHOUT ANY WARRANTY; without even the implied warranty of 12-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13-- GNU General Public License for more details. 14-- 15-- You should have received a copy of the GNU General Public License 16-- along with this program. If not, see <https://www.gnu.org/licenses/>. 17-- 18-- =================================================================== 19 20create table llx_extrafields 21( 22 rowid integer AUTO_INCREMENT PRIMARY KEY, 23 name varchar(64) NOT NULL, -- name of field into extrafields tables 24 entity integer DEFAULT 1 NOT NULL, -- multi company id 25 elementtype varchar(64) NOT NULL DEFAULT 'member', -- for which element this extra fields is for 26 label varchar(255) NOT NULL, -- label to show for attribute 27 type varchar(8), 28 size varchar(8) DEFAULT NULL, 29 fieldcomputed text, 30 fielddefault varchar(255), 31 fieldunique integer DEFAULT 0, 32 fieldrequired integer DEFAULT 0, 33 perms varchar(255), -- not used yet 34 enabled varchar(255), 35 pos integer DEFAULT 0, 36 alwayseditable integer DEFAULT 0, -- 1 if field can be edited whatever is element status 37 param text, -- extra parameters to define possible values of field 38 list varchar(255) DEFAULT '1', -- visibility of field. 0=Never visible, 1=Visible on list and forms, 2=Visible on list only. Using a negative value means field is not shown by default on list but can be selected for viewing 39 printable integer DEFAULT 0, -- is the extrafield output on documents 40 totalizable boolean DEFAULT FALSE, -- is extrafield totalizable on list 41 langs varchar(64), -- example: fileofmymodule@mymodule 42 help text, -- to store help tooltip 43 fk_user_author integer, -- user making creation 44 fk_user_modif integer, -- user making last change 45 datec datetime, -- date de creation 46 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP -- last modification date 47)ENGINE=innodb; 48