add workerq to the install schemas

1 files changed, 14 insertions, 1 deletions

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 96d0cc33c..5a97ebca1 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1652,4 +1652,17 @@ CREATE TABLE oauth_jwt (
   public_key          VARCHAR(2000)   NOT NULL
 );
 
-
+CREATE TABLE IF NOT EXISTS workerq (
+	workerq_id bigserial NOT NULL,
+	workerq_priority smallint,
+	workerq_reservationid varchar(25) DEFAULT NULL,
+	workerq_processtimeout timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
+	workerq_data text,
+	workerq_uuid UUID NOT NULL,
+	workerq_cmd text NOT NULL DEFAULT '',
+	PRIMARY KEY (workerq_id)
+)
+CREATE INDEX idx_workerq_priority ON workerq (workerq_priority);
+CREATE INDEX idx_workerq_reservationid ON workerq (workerq_reservationid);
+CREATE INDEX idx_workerq_processtimeout ON workerq (workerq_processtimeout);
+CREATE INDEX idx_workerq_uuid ON workerq (workerq_uuid);