1-- ======================================================================== 2-- Copyright (C) 2016 Laurent Destailleur <eldy@users.sourceforge.net> 3-- 4-- 5-- LICENSE ================================================================ 6-- 7-- This program is free software; you can redistribute it and/or modify 8-- it under the terms of the GNU General Public License as published by 9-- the Free Software Foundation; either version 3 of the License, or 10-- (at your option) any later version. 11-- 12-- This program is distributed in the hope that it will be useful, 13-- but WITHOUT ANY WARRANTY; without even the implied warranty of 14-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 15-- GNU General Public License for more details. 16-- 17-- You should have received a copy of the GNU General Public License 18-- along with this program. If not, see <https://www.gnu.org/licenses/>. 19-- 20-- ======================================================================== 21 22create table llx_holiday_extrafields 23( 24 rowid integer AUTO_INCREMENT PRIMARY KEY, 25 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 26 fk_object integer NOT NULL, 27 import_key varchar(14) -- import key 28) ENGINE=innodb; 29 30