1-- =================================================================== 2-- Copyright (C) 2007 Laurent Destailleur <eldy@users.sourceforge.net> 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-- =================================================================== 18 19CREATE TABLE llx_blockedlog 20( 21 rowid integer AUTO_INCREMENT PRIMARY KEY, 22 entity integer DEFAULT 1 NOT NULL, 23 date_creation datetime, 24 tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 25 action varchar(50), 26 amounts double(24,8) NOT NULL, 27 element varchar(50), 28 fk_user integer, 29 user_fullname varchar(255), 30 fk_object integer, 31 ref_object varchar(255), 32 date_object datetime, 33 signature varchar(100) NOT NULL, 34 signature_line varchar(100) NOT NULL, 35 object_data mediumtext, 36 object_version varchar(32) DEFAULT '', 37 certified integer 38) ENGINE=innodb; 39 40