1-- Copyright (C) 2017 Laurent Destailleur  <eldy@users.sourceforge.net>
2--
3-- This program is free software: you can redistribute it and/or modify
4-- it under the terms of the GNU General Public License as published by
5-- the Free Software Foundation, either version 3 of the License, or
6-- (at your option) any later version.
7--
8-- This program is distributed in the hope that it will be useful,
9-- but WITHOUT ANY WARRANTY; without even the implied warranty of
10-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
11-- GNU General Public License for more details.
12--
13-- You should have received a copy of the GNU General Public License
14-- along with this program.  If not, see https://www.gnu.org/licenses/.
15
16
17CREATE TABLE llx_actioncomm_reminder(
18	-- BEGIN MODULEBUILDER FIELDS
19	rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,
20	dateremind datetime NOT NULL,
21	typeremind varchar(32) NOT NULL,
22	fk_user integer NOT NULL,
23	offsetvalue integer NOT NULL,
24	offsetunit varchar(1) NOT NULL,
25	status integer NOT NULL DEFAULT 0,
26	lasterror varchar(128) NULL,
27	entity integer NOT NULL DEFAULT 1,
28	fk_actioncomm integer NOT NULL,
29	fk_email_template integer
30
31	-- END MODULEBUILDER FIELDS
32) ENGINE=innodb;
33