| Index: trunk/phase3/maintenance/oracle/archives/patch-job_timestamp_index.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +CREATE INDEX &mw_prefix.job_i02 ON &mw_prefix.job (job_timestamp); |
| | 5 | + |
| Property changes on: trunk/phase3/maintenance/oracle/archives/patch-job_timestamp_index.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |
| Index: trunk/phase3/maintenance/oracle/archives/patch-job_timestamp_field.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +ALTER TABLE &mw_prefix.job ADD job_timestamp TIMESTAMP(6) WITH TIME ZONE NULL; |
| | 5 | + |
| Property changes on: trunk/phase3/maintenance/oracle/archives/patch-job_timestamp_field.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |
| Index: trunk/phase3/maintenance/oracle/archives/patch-us_chunk_inx_field.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +define mw_prefix='{$wgDBprefix}'; |
| | 3 | + |
| | 4 | +ALTER TABLE &mw_prefix.uploadstash ADD us_chunk_inx NUMBER; |
| | 5 | + |
| Property changes on: trunk/phase3/maintenance/oracle/archives/patch-us_chunk_inx_field.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |
| Index: trunk/phase3/maintenance/oracle/tables.sql |
| — | — | @@ -375,6 +375,7 @@ |
| 376 | 376 | us_source_type VARCHAR2(50), |
| 377 | 377 | us_timestamp TIMESTAMP(6) WITH TIME ZONE, |
| 378 | 378 | us_status VARCHAR2(50) NOT NULL, |
| | 379 | + us_chunk_inx NUMBER, |
| 379 | 380 | us_size NUMBER NOT NULL, |
| 380 | 381 | us_sha1 VARCHAR2(32) NOT NULL, |
| 381 | 382 | us_mime VARCHAR2(255), |
| — | — | @@ -518,10 +519,12 @@ |
| 519 | 520 | job_cmd VARCHAR2(60) NOT NULL, |
| 520 | 521 | job_namespace NUMBER DEFAULT 0 NOT NULL, |
| 521 | 522 | job_title VARCHAR2(255) NOT NULL, |
| | 523 | + job_timestamp TIMESTAMP(6) WITH TIME ZONE NULL, |
| 522 | 524 | job_params CLOB NOT NULL |
| 523 | 525 | ); |
| 524 | 526 | ALTER TABLE &mw_prefix.job ADD CONSTRAINT &mw_prefix.job_pk PRIMARY KEY (job_id); |
| 525 | 527 | CREATE INDEX &mw_prefix.job_i01 ON &mw_prefix.job (job_cmd, job_namespace, job_title); |
| | 528 | +CREATE INDEX &mw_prefix.job_i02 ON &mw_prefix.job (job_timestamp); |
| 526 | 529 | |
| 527 | 530 | CREATE TABLE &mw_prefix.querycache_info ( |
| 528 | 531 | qci_type VARCHAR2(32) NOT NULL, |
| Index: trunk/phase3/includes/installer/DatabaseUpdater.php |
| — | — | @@ -465,9 +465,9 @@ |
| 466 | 466 | */ |
| 467 | 467 | protected function addIndex( $table, $index, $patch, $fullpath = false ) { |
| 468 | 468 | if ( $this->db->indexExists( $table, $index, __METHOD__ ) ) { |
| 469 | | - $this->output( "...$index key already set on $table table.\n" ); |
| | 469 | + $this->output( "...index $index already set on $table table.\n" ); |
| 470 | 470 | } else { |
| 471 | | - $this->output( "Adding $index key to table $table... " ); |
| | 471 | + $this->output( "Adding index $index to table $table... " ); |
| 472 | 472 | $this->applyPatch( $patch, $fullpath ); |
| 473 | 473 | $this->output( "done.\n" ); |
| 474 | 474 | } |
| Index: trunk/phase3/includes/installer/OracleUpdater.php |
| — | — | @@ -49,6 +49,9 @@ |
| 50 | 50 | array( 'doRemoveNotNullEmptyDefaults2' ), |
| 51 | 51 | array( 'addIndex', 'page', 'i03', 'patch-page_redirect_namespace_len.sql' ), |
| 52 | 52 | array( 'modifyField', 'user', 'ug_group', 'patch-ug_group-length-increase.sql' ), |
| | 53 | + array( 'addField', 'uploadstash', 'us_chunk_inx', 'patch-us_chunk_inx_field.sql' ), |
| | 54 | + array( 'addField', 'job', 'job_timestamp', 'patch-job_timestamp_field.sql' ), |
| | 55 | + array( 'addIndex', 'job', 'i02', 'patch-job_timestamp_index.sql' ), |
| 53 | 56 | |
| 54 | 57 | // KEEP THIS AT THE BOTTOM!! |
| 55 | 58 | array( 'doRebuildDuplicateFunction' ), |