1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
|
<?php
/**
* @package MediaWiki
* @subpackage Maintenance
*/
/** */
$wgNewTables = array(
# table patch file (in maintenance/archives)
array( 'linkscc', 'patch-linkscc.sql' ),
array( 'hitcounter', 'patch-hitcounter.sql' ),
array( 'querycache', 'patch-querycache.sql' ),
array( 'objectcache', 'patch-objectcache.sql' ),
array( 'categorylinks', 'patch-categorylinks.sql' ),
array( 'logging', 'patch-logging.sql' ),
array( 'user_rights', 'patch-user_rights.sql' ),
);
$wgNewFields = array(
# table field patch file (in maintenance/archives)
array( 'ipblocks', 'ipb_id', 'patch-ipblocks.sql' ),
array( 'ipblocks', 'ipb_expiry', 'patch-ipb_expiry.sql' ),
array( 'recentchanges', 'rc_type', 'patch-rc_type.sql' ),
array( 'recentchanges', 'rc_ip', 'patch-rc_ip.sql' ),
array( 'recentchanges', 'rc_id', 'patch-rc_id.sql' ),
array( 'recentchanges', 'rc_patrolled', 'patch-rc-patrol.sql' ),
array( 'user', 'user_real_name', 'patch-user-realname.sql' ),
array( 'user', 'user_token', 'patch-user_token.sql' ),
);
function add_table( $name, $patch ) {
global $wgDatabase;
if ( $wgDatabase->tableExists( $name ) ) {
echo "...$name table already exists.\n";
} else {
echo "Creating $name table...";
dbsource( "maintenance/archives/$patch", $wgDatabase );
echo "ok\n";
}
}
function add_field( $table, $field, $patch ) {
global $wgDatabase;
if ( $wgDatabase->fieldExists( $table, $field ) ) {
echo "...have $field field in $table table.\n";
} else {
echo "Adding $field field to table $table...";
dbsource( "maintenance/archives/$patch" , $wgDatabase );
echo "ok\n";
}
}
function do_revision_updates() {
global $wgSoftwareRevision;
if ( $wgSoftwareRevision < 1001 ) {
update_passwords();
}
}
function update_passwords() {
global $wgDatabase;
$fname = "Update script: update_passwords()";
print "\nIt appears that you need to update the user passwords in your\n" .
"database. If you have already done this (if you've run this update\n" .
"script once before, for example), doing so again will make all your\n" .
"user accounts inaccessible, so be sure you only do this once.\n" .
"Update user passwords? (yes/no)";
$resp = readconsole();
if ( ! ( "Y" == $resp{0} || "y" == $resp{0} ) ) { return; }
$sql = "SELECT user_id,user_password FROM user";
$source = $wgDatabase->query( $sql, $fname );
while ( $row = $wgDatabase->fetchObject( $source ) ) {
$id = $row->user_id;
$oldpass = $row->user_password;
$newpass = md5( "{$id}-{$oldpass}" );
$sql = "UPDATE user SET user_password='{$newpass}' " .
"WHERE user_id={$id}";
$wgDatabase->query( $sql, $fname );
}
}
function do_interwiki_update() {
# Check that interwiki table exists; if it doesn't source it
global $wgDatabase;
if( $wgDatabase->tableExists( "interwiki" ) ) {
echo "...already have interwiki table\n";
return true;
}
echo "Creating interwiki table: ";
dbsource( "maintenance/archives/patch-interwiki.sql" );
echo "ok\n";
echo "Adding default interwiki definitions: ";
dbsource( "maintenance/interwiki.sql" );
echo "ok\n";
}
function do_index_update() {
# Check that proper indexes are in place
global $wgDatabase;
$meta = $wgDatabase->fieldInfo( "recentchanges", "rc_timestamp" );
if( $meta->multiple_key == 0 ) {
echo "Updating indexes to 20031107: ";
dbsource( "maintenance/archives/patch-indexes.sql" );
echo "ok\n";
return true;
}
echo "...indexes seem up to 20031107 standards\n";
return false;
}
function do_linkscc_1_3_update() {
// Update linkscc table to 1.3 schema if necessary
global $wgDatabase, $wgVersion;
if( ( strpos( "1.3", $wgVersion ) === 0 ) && $wgDatabase->tableExists( "linkscc" )
&& $wgDatabase->fieldExists( "linkscc", "lcc_title" ) ) {
echo "Altering lcc_title field from linkscc table... ";
dbsource( "maintenance/archives/patch-linkscc-1.3.sql", $wgDatabase );
echo "ok\n";
} else {
echo "...linkscc is up to date, or does not exist. Good.\n";
}
}
function do_image_name_unique_update() {
global $wgDatabase;
if( $wgDatabase->indexExists( 'image', 'PRIMARY' ) ) {
echo "...image primary key already set.\n";
} else {
echo "Making img_name the primary key... ";
dbsource( "maintenance/archives/patch-image_name_primary.sql", $wgDatabase );
echo "ok\n";
}
}
?>
|
