resources/sql/patches/daemontaskarchive.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / daemontaskarchive.sql

at recaptime-dev/main 13 lines 485 B view raw

wrap content

epriestley Move completed tasks to an "archive" table and delete them in the GC 13y ago

5903ed65

 1CREATE TABLE {$NAMESPACE}_worker.worker_archivetask (
 2  id INT UNSIGNED PRIMARY KEY,
 3  taskClass VARCHAR(255) NOT NULL COLLATE utf8_bin,
 4  leaseOwner VARCHAR(255) COLLATE utf8_bin,
 5  leaseExpires INT UNSIGNED,
 6  failureCount INT UNSIGNED NOT NULL,
 7  dataID INT UNSIGNED NOT NULL,
 8  result INT UNSIGNED NOT NULL,
 9  duration BIGINT UNSIGNED NOT NULL,
10  dateCreated INT UNSIGNED NOT NULL,
11  dateModified INT UNSIGNED NOT NULL,
12  key(dateCreated)
13) ENGINE=InnoDB, COLLATE utf8_general_ci;