mirror of
https://framagit.org/hubzilla/core.git
synced 2026-06-21 00:52:33 -04:00
56 lines
1.5 KiB
PHP
56 lines
1.5 KiB
PHP
<?php
|
|
|
|
namespace Zotlabs\Update;
|
|
|
|
class _1254 {
|
|
|
|
function run() {
|
|
|
|
dbq("START TRANSACTION");
|
|
|
|
if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
|
|
$r1 = dbq("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,
|
|
PRIMARY KEY (workerq_id))"
|
|
);
|
|
|
|
$r2 = dbq("CREATE INDEX idx_workerq_priority ON workerq (workerq_priority)");
|
|
$r3 = dbq("CREATE INDEX idx_workerq_reservationid ON workerq (workerq_reservationid)");
|
|
$r4 = dbq("CREATE INDEX idx_workerq_processtimeout ON workerq (workerq_processtimeout)");
|
|
$r5 = dbq("CREATE INDEX idx_workerq_uuid ON workerq (workerq_uuid)");
|
|
|
|
$r = ($r1 && $r2 && $r3 && $r4 && $r5);
|
|
}
|
|
else {
|
|
$r = dbq("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 '',
|
|
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"
|
|
);
|
|
}
|
|
|
|
if($r) {
|
|
dbq("COMMIT");
|
|
return UPDATE_SUCCESS;
|
|
}
|
|
|
|
q("ROLLBACK");
|
|
return UPDATE_FAILED;
|
|
|
|
}
|
|
|
|
}
|