1--
2-- Copyright (C) 2013	Jean-François Ferry	<jfefe@aternatik.fr>
3--
4-- This program is free software: you can redistribute it and/or modify
5-- it under the terms of the GNU General Public License as published by
6-- the Free Software Foundation, either version 3 of the License, or
7-- (at your option) any later version.
8--
9-- This program is distributed in the hope that it will be useful,
10-- but WITHOUT ANY WARRANTY; without even the implied warranty of
11-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12-- GNU General Public License for more details.
13--
14-- You should have received a copy of the GNU General Public License
15-- along with this program.  If not, see <https://www.gnu.org/licenses/>.
16-- ============================================================================
17-- Table used to link an element actioncomm with a resource or user (llx_resource or llx_user)
18-- ============================================================================
19
20CREATE TABLE llx_element_resources
21(
22  rowid           integer AUTO_INCREMENT PRIMARY KEY,
23  element_id	  integer,
24  element_type    varchar(64),
25  resource_id     integer,			-- id of resource or id of user
26  resource_type	  varchar(64),		-- resource or user
27  busy			  integer,
28  mandatory		  integer,
29  duree				real,               -- total duration of using ressource
30  fk_user_create  integer,
31  tms             timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
32)ENGINE=innodb;
33