diff options
| author | Mario <mario@mariovavti.com> | 2022-12-27 10:33:29 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2022-12-27 10:33:29 +0000 |
| commit | 3101c6540a3992a95369abefd3bafa3abf36db9e (patch) | |
| tree | 367ece1200528ae205492f09a9ded0d475a89149 /install | |
| parent | d2d6be73b8428c11c2461961a920ed3e3e656f64 (diff) | |
| download | volse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.tar.gz volse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.tar.bz2 volse-hubzilla-3101c6540a3992a95369abefd3bafa3abf36db9e.zip | |
add workerq to the install schemas
Diffstat (limited to 'install')
| -rw-r--r-- | install/schema_mysql.sql | 16 | ||||
| -rw-r--r-- | install/schema_postgres.sql | 15 |
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); |