1 files changed, 13 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index e1526873..6fe43a7c 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -631,6 +631,19 @@ CREATE TABLE escalations (
 CREATE UNIQUE INDEX escalations_name on escalations (name);
 
 --
+-- Table structure for table 'escalation_rules'
+--
+
+CREATE TABLE escalation_rules (
+  ruleid		serial,
+  escalationid		int4		DEFAULT '0' NOT NULL,
+  level			int4		DEFAULT '0' NOT NULL,
+  actiontype		int4		DEFAULT '0' NOT NULL,
+  PRIMARY KEY (ruleid),
+  FOREIGN KEY (escalationid) REFERENCES escalations
+);
+
+--
 -- Table structure for table 'hosts_templates'
 --