remove inverse_timestamp wherever it is found and disable wfInvertTimestamp()
[lhc/web/wiklou.git] / maintenance / updaters.inc
index 4d0c9d5..d2d326c 100644 (file)
@@ -359,14 +359,13 @@ function do_schema_restructuring() {
                        rev_user_text varchar(255) binary NOT NULL default '',
                        rev_timestamp char(14) binary NOT NULL default '',
                        rev_minor_edit tinyint(1) unsigned NOT NULL default '0',
-                       inverse_timestamp char(14) binary NOT NULL default '',
   
                        PRIMARY KEY rev_page_id (rev_page, rev_id),
                        UNIQUE INDEX rev_id (rev_id),
                        INDEX rev_timestamp (rev_timestamp),
-                       INDEX page_timestamp (rev_page,inverse_timestamp),
-                       INDEX user_timestamp (rev_user,inverse_timestamp),
-                       INDEX usertext_timestamp (rev_user_text,inverse_timestamp)
+                       INDEX page_timestamp (rev_page,rev_timestamp),
+                       INDEX user_timestamp (rev_user,rev_timestamp),
+                       INDEX usertext_timestamp (rev_user_text,rev_timestamp)
                        )", $fname );
 
                echo "......Locking tables.\n";
@@ -377,16 +376,15 @@ function do_schema_restructuring() {
 
                echo "......Moving text from cur.\n";
                $wgDatabase->query( "INSERT INTO $old (old_namespace, old_title, old_text, old_comment, old_user, old_user_text,
-                               old_timestamp, old_minor_edit, old_flags, inverse_timestamp)
-                       SELECT cur_namespace, cur_title, cur_text, cur_comment, cur_user, cur_user_text, cur_timestamp, cur_minor_edit,
-                               '', inverse_timestamp
+                               old_timestamp, old_minor_edit, old_flags, rev_timestamp)
+                       SELECT cur_namespace, cur_title, cur_text, cur_comment, cur_user, cur_user_text, cur_timestamp, cur_minor_edit,''
                        FROM $cur", $fname );
 
                echo "......Setting up revision table.\n";
                $wgDatabase->query( "INSERT INTO $revision (rev_id, rev_page, rev_comment, rev_user, rev_user_text, rev_timestamp,
-                               inverse_timestamp, rev_minor_edit)
+                               rev_minor_edit)
                        SELECT old_id, cur_id, old_comment, old_user, old_user_text,
-                               old_timestamp, $old.inverse_timestamp, old_minor_edit
+                               old_timestamp, old_minor_edit
                        FROM $old,$cur WHERE old_namespace=cur_namespace AND old_title=cur_title", $fname );
 
                echo "......Setting up page table.\n";