Migrate job to abstract schema

Postgres:
 - Drop deafault from job_id
 - Add default to job_cmd
 - Change job_namespace datatype to INTEGER
 - Drop  job_cmd_namespace_title index
 - Add job_cmd index on the same fields as MySQL
 - Rename index job_timestamp_idx

MySQL:
 - Change job_title datatype to VARBINARY
 - Change job_timestamp datatype to BINARY (mwtimestamp)
 - Change job_token_timestamp datatype to BINARY (mwtimestamp)

Bug: T230428
Bug: T164898
Bug: T42626
Change-Id: I207aefc48c7bcbb5b5362af4b63d9a1383019a6d

1 files changed, 25 insertions, 0 deletions

diff --git a/maintenance/sqlite/tables-generated.sql b/maintenance/sqlite/tables-generated.sql
index c5718032de1f..cd33b4c18cf1 100644
--- a/maintenance/sqlite/tables-generated.sql
+++ b/maintenance/sqlite/tables-generated.sql
@@ -488,3 +488,28 @@ CREATE TABLE /*_*/page_props (
 CREATE UNIQUE INDEX pp_propname_page ON /*_*/page_props (pp_propname, pp_page);
 
 CREATE UNIQUE INDEX pp_propname_sortkey_page ON /*_*/page_props (pp_propname, pp_sortkey, pp_page);
+
+
+CREATE TABLE /*_*/job (
+  job_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+  job_cmd BLOB DEFAULT '' NOT NULL, job_namespace INTEGER NOT NULL,
+  job_title BLOB NOT NULL, job_timestamp BLOB DEFAULT NULL,
+  job_params BLOB NOT NULL, job_random INTEGER UNSIGNED DEFAULT 0 NOT NULL,
+  job_attempts INTEGER UNSIGNED DEFAULT 0 NOT NULL,
+  job_token BLOB DEFAULT '' NOT NULL,
+  job_token_timestamp BLOB DEFAULT NULL,
+  job_sha1 BLOB DEFAULT '' NOT NULL
+);
+
+CREATE INDEX job_sha1 ON /*_*/job (job_sha1);
+
+CREATE INDEX job_cmd_token ON /*_*/job (job_cmd, job_token, job_random);
+
+CREATE INDEX job_cmd_token_id ON /*_*/job (job_cmd, job_token, job_id);
+
+CREATE INDEX job_cmd ON /*_*/job (
+  job_cmd, job_namespace, job_title,
+  job_params
+);
+
+CREATE INDEX job_timestamp ON /*_*/job (job_timestamp);