aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2022-12-27 10:33:29 +0000
committerMario <mario@mariovavti.com>2022-12-27 10:33:29 +0000
commit3101c6540a3992a95369abefd3bafa3abf36db9e (patch)
tree367ece1200528ae205492f09a9ded0d475a89149 /install/schema_mysql.sql
parentd2d6be73b8428c11c2461961a920ed3e3e656f64 (diff)
downloadvolse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.tar.gz
volse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.tar.bz2
volse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.zip
add workerq to the install schemas
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql16
1 files changed, 15 insertions, 1 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