HomePhabricator

Migrate job to abstract schema

Description

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

Details

Provenance
AmmarpadAuthored on Nov 18 2020, 5:50 AM
LadsgroupCommitted on Nov 21 2020, 10:38 PM
Parents
rMW69d7bf0cfe86: Fix un_user_ip index column
Branches
Unknown
Tags
Unknown
ChangeId
I207aefc48c7bcbb5b5362af4b63d9a1383019a6d

Event Timeline