diff options
| author | Mario <mario@mariovavti.com> | 2023-01-13 20:01:05 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2023-01-13 20:01:05 +0000 |
| commit | 2805520d1bcb2640fc079d54f5f230f7b87d1f84 (patch) | |
| tree | 43b3e5bb7c71522d04560015478765a7b763a5fe /install/schema_postgres.sql | |
| parent | f6d940606350eb8685c278af6d87f3a0b8c0f5e5 (diff) | |
| parent | fb7ca18820e7618325dded78a3c3a464dd01b391 (diff) | |
| download | volse-hubzilla-2805520d1bcb2640fc079d54f5f230f7b87d1f84.tar.gz volse-hubzilla-2805520d1bcb2640fc079d54f5f230f7b87d1f84.tar.bz2 volse-hubzilla-2805520d1bcb2640fc079d54f5f230f7b87d1f84.zip | |
Merge remote-tracking branch 'origin/8.0RC'8.0
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 96d0cc33c..6d7fe910b 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); |