From b1832d2663e4e4ee277ed7c045eca15c8c40d21d Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Wed, 17 Jan 2007 13:12:18 +0000 Subject: [PATCH] pretty up the timestamps in 1.4->1.5 schema conversion. unix timestamp... sucks? --- maintenance/updaters.inc | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 72e00bf8e7..2596951214 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -321,7 +321,7 @@ function do_schema_restructuring() { echo "...page table already exists.\n"; } else { echo "...converting from cur/old to page/revision/text DB structure.\n"; flush(); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......checking for duplicate entries.\n"; flush(); list ($cur, $old, $page, $revision, $text) = $wgDatabase->tableNamesN( 'cur', 'old', 'page', 'revision', 'text' ); @@ -330,7 +330,7 @@ function do_schema_restructuring() { FROM $cur GROUP BY cur_title, cur_namespace HAVING c>1", $fname ); if ( $wgDatabase->numRows( $rows ) > 0 ) { - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Found duplicate entries\n"; echo ( sprintf( " %-60s %3s %5s\n", 'Title', 'NS', 'Count' ) ); while ( $row = $wgDatabase->fetchObject( $rows ) ) { @@ -378,12 +378,12 @@ function do_schema_restructuring() { } $sql = "DELETE FROM $cur WHERE cur_id IN ( " . join( ',', $deleteId ) . ')'; $rows = $wgDatabase->query( $sql, $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Deleted ".$wgDatabase->affectedRows()." records.\n"; } - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Creating tables.\n"; $wgDatabase->query("CREATE TABLE $page ( page_id int(8) unsigned NOT NULL auto_increment, @@ -421,15 +421,15 @@ function do_schema_restructuring() { INDEX usertext_timestamp (rev_user_text,rev_timestamp) ) TYPE=InnoDB", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Locking tables.\n"; $wgDatabase->query( "LOCK TABLES $page WRITE, $revision WRITE, $old WRITE, $cur WRITE", $fname ); $maxold = intval( $wgDatabase->selectField( 'old', 'max(old_id)', '', $fname ) ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......maxold is {$maxold}\n"; - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); global $wgLegacySchemaConversion; if( $wgLegacySchemaConversion ) { // Create HistoryBlobCurStub entries. @@ -449,7 +449,7 @@ function do_schema_restructuring() { SELECT cur_namespace, cur_title, $cur_text, cur_comment, cur_user, cur_user_text, cur_timestamp, cur_minor_edit, $cur_flags FROM $cur", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Setting up revision table.\n"; $wgDatabase->query( "INSERT INTO $revision (rev_id, rev_page, rev_comment, rev_user, rev_user_text, rev_timestamp, rev_minor_edit) @@ -457,7 +457,7 @@ function do_schema_restructuring() { old_timestamp, old_minor_edit FROM $old,$cur WHERE old_namespace=cur_namespace AND old_title=cur_title", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Setting up page table.\n"; $wgDatabase->query( "INSERT INTO $page (page_id, page_namespace, page_title, page_restrictions, page_counter, page_is_redirect, page_is_new, page_random, page_touched, page_latest, page_len) @@ -466,15 +466,15 @@ function do_schema_restructuring() { FROM $cur,$revision WHERE cur_id=rev_page AND rev_timestamp=cur_timestamp AND rev_id > {$maxold}", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Unlocking tables.\n"; $wgDatabase->query( "UNLOCK TABLES", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "......Renaming old.\n"; $wgDatabase->query( "ALTER TABLE $old RENAME TO $text", $fname ); - echo wfTimestamp(); + echo wfTimestamp( TS_DB ); echo "...done.\n"; } } -- 2.20.1