add workerq to the install schemas

2 files changed, 29 insertions, 2 deletions

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 80ae20d7b..0f407960d 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1232,7 +1232,7 @@ CREATE TABLE IF NOT EXISTS `verify` (
 
 CREATE TABLE IF NOT EXISTS `vote` (
   `vote_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `vote_guid` varchar(191) NOT NULL, 
+  `vote_guid` varchar(191) NOT NULL,
   `vote_poll` int(11) NOT NULL DEFAULT 0 ,
   `vote_element` int(11) NOT NULL DEFAULT 0 ,
   `vote_result` text NOT NULL,
@@ -1616,3 +1616,17 @@ CREATE TABLE if not exists oauth_jwt (
   subject             VARCHAR(80),
   public_key          VARCHAR(2000)   NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS workerq (
+	workerq_id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
+	workerq_priority smallint,
+	workerq_reservationid varchar(25) DEFAULT NULL,
+	workerq_processtimeout datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
+	workerq_data text,
+	workerq_uuid char(36) NOT NULL DEFAULT '',
+	workerq_cmd varchar(191) NOT NULL DEFAULT '',
+	KEY workerq_priority (workerq_priority),
+	KEY workerq_reservationid (workerq_reservationid),
+	KEY workerq_processtimeout (workerq_uuid),
+	KEY workerq_uuid (workerq_processtimeout)
+) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4
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);