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