1 files changed, 12 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index fc9ef9b9..2a7b43ca 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -612,4 +612,16 @@ CREATE TABLE trends (
   FOREIGN KEY (itemid) REFERENCES items
 );
 
+--
+-- Table structure for table 'escalations'
+--
+
+CREATE TABLE escalations (
+  escalationid		serial		DEFAULT '0' NOT NULL,
+  name			varchar(64)	DEFAULT '0' NOT NULL,
+  PRIMARY KEY (escalationid)
+);
+
+CREATE UNIQUE INDEX escalations_name on escalations (name);
+
 VACUUM ANALYZE;