summaryrefslogtreecommitdiffstats
path: root/create/postgresql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql')
-rw-r--r--create/postgresql/schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 46f4bf50..651d734b 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -112,7 +112,7 @@ CREATE TABLE actions (
good int4 DEFAULT '0' NOT NULL,
delay int4 DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
- message varchar(255) DEFAULT '' NOT NULL,
+ message text DEFAULT '' NOT NULL,
nextcheck int4 DEFAULT '0' NOT NULL,
PRIMARY KEY (actionid),
FOREIGN KEY (triggerid) REFERENCES triggers,
@@ -130,7 +130,7 @@ CREATE TABLE alerts (
type varchar(10) DEFAULT '' NOT NULL,
sendto varchar(100) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
- message varchar(255) DEFAULT '' NOT NULL,
+ message text DEFAULT '' NOT NULL,
PRIMARY KEY (alertid),
FOREIGN KEY (actionid) REFERENCES actions
);