| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -519,9 +519,11 @@ |
| 520 | 520 | job_cmd TEXT NOT NULL, |
| 521 | 521 | job_namespace SMALLINT NOT NULL, |
| 522 | 522 | job_title TEXT NOT NULL, |
| | 523 | + job_timestamp TIMESTAMPTZ, |
| 523 | 524 | job_params TEXT NOT NULL |
| 524 | 525 | ); |
| 525 | 526 | CREATE INDEX job_cmd_namespace_title ON job (job_cmd, job_namespace, job_title); |
| | 527 | +CREATE INDEX job_timestamp_idx ON job (job_timestamp); |
| 526 | 528 | |
| 527 | 529 | -- Tsearch2 2 stuff. Will fail if we don't have proper access to the tsearch2 tables |
| 528 | 530 | -- Version 8.3 or higher only. Previous versions would need another parmeter for to_tsvector. |
| Index: trunk/phase3/includes/installer/PostgresUpdater.php |
| — | — | @@ -117,6 +117,7 @@ |
| 118 | 118 | array( 'addPgField', 'revision', 'rev_sha1', "TEXT NOT NULL DEFAULT ''" ), |
| 119 | 119 | array( 'addPgField', 'archive', 'ar_sha1', "TEXT NOT NULL DEFAULT ''" ), |
| 120 | 120 | array( 'addPgField', 'uploadstash', 'us_chunk_inx', "INTEGER NULL" ), |
| | 121 | + array( 'addPgField', 'job', 'job_timestamp', "TIMESTAMPTZ" ), |
| 121 | 122 | |
| 122 | 123 | # type changes |
| 123 | 124 | array( 'changeField', 'archive', 'ar_deleted', 'smallint', '' ), |
| — | — | @@ -184,6 +185,7 @@ |
| 185 | 186 | array( 'addPgIndex', 'logging', 'logging_user_type_time', '(log_user, log_type, log_timestamp)' ), |
| 186 | 187 | array( 'addPgIndex', 'logging', 'logging_page_id_time', '(log_page,log_timestamp)' ), |
| 187 | 188 | array( 'addPgIndex', 'iwlinks', 'iwl_prefix_title_from', '(iwl_prefix, iwl_title, iwl_from)' ), |
| | 189 | + array( 'addPgIndex', 'job', 'job_timestamp_idx', '(job_timestamp)' ), |
| 188 | 190 | |
| 189 | 191 | array( 'checkOiNameConstraint' ), |
| 190 | 192 | array( 'checkPageDeletedTrigger' ), |