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