diff options
Diffstat (limited to 'maintenance/archives')
5 files changed, 16 insertions, 9 deletions
diff --git a/maintenance/archives/patch-drop-page_counter.sql b/maintenance/archives/patch-drop-page_counter.sql new file mode 100644 index 00000000..1d8e701b --- /dev/null +++ b/maintenance/archives/patch-drop-page_counter.sql @@ -0,0 +1,2 @@ +-- field is deprecated and no longer updated as of 1.25 +ALTER TABLE /*_*/page DROP COLUMN page_counter; diff --git a/maintenance/archives/patch-drop-ss_total_views.sql b/maintenance/archives/patch-drop-ss_total_views.sql new file mode 100644 index 00000000..00591939 --- /dev/null +++ b/maintenance/archives/patch-drop-ss_total_views.sql @@ -0,0 +1,2 @@ +-- field is deprecated and no longer updated as of 1.24 +ALTER TABLE /*_*/site_stats DROP COLUMN ss_total_views;
\ No newline at end of file diff --git a/maintenance/archives/patch-editsummary-length.sql b/maintenance/archives/patch-editsummary-length.sql new file mode 100644 index 00000000..c8ac1adf --- /dev/null +++ b/maintenance/archives/patch-editsummary-length.sql @@ -0,0 +1,11 @@ +ALTER TABLE /*_*/revision MODIFY rev_comment varbinary(767) NOT NULL; +ALTER TABLE /*_*/archive MODIFY ar_comment varbinary(767) NOT NULL; +ALTER TABLE /*_*/image MODIFY img_description varbinary(767) NOT NULL; +ALTER TABLE /*_*/oldimage MODIFY oi_description varbinary(767) NOT NULL; +ALTER TABLE /*_*/filearchive MODIFY fa_description varbinary(767); +ALTER TABLE /*_*/filearchive MODIFY fa_deleted_reason varbinary(767) default ''; +ALTER TABLE /*_*/recentchanges MODIFY rc_comment varbinary(767) NOT NULL default ''; +ALTER TABLE /*_*/logging MODIFY log_comment varbinary(767) NOT NULL default ''; +ALTER TABLE /*_*/ipblocks MODIFY ipb_reason varbinary(767) NOT NULL; +ALTER TABLE /*_*/protected_titles MODIFY pt_reason varbinary(767); + diff --git a/maintenance/archives/patch-hitcounter.sql b/maintenance/archives/patch-hitcounter.sql deleted file mode 100644 index 2d698f68..00000000 --- a/maintenance/archives/patch-hitcounter.sql +++ /dev/null @@ -1,9 +0,0 @@ --- --- hitcounter table is used to buffer page hits before they are periodically --- counted and added to the cur_counter column in the cur table. --- December 2003 --- - -CREATE TABLE /*$wgDBprefix*/hitcounter ( - hc_id INTEGER UNSIGNED NOT NULL -) ENGINE=MEMORY MAX_ROWS=25000; diff --git a/maintenance/archives/patch-user-newtalk-userid-unsigned.sql b/maintenance/archives/patch-user-newtalk-userid-unsigned.sql new file mode 100644 index 00000000..a83e03b9 --- /dev/null +++ b/maintenance/archives/patch-user-newtalk-userid-unsigned.sql @@ -0,0 +1 @@ +ALTER TABLE /*_*/user_newtalk MODIFY user_id int unsigned NOT NULL default 0; |