Wiki:Changes to database

From Vermont Area Group of Unix Enthusiasts

Jump to: navigation, search

These are modifications to the MediaWiki's default installation data.

Page renames and namespaces

I had a few pages that needed to be moved and some namespaces to start. Rather than using moveBatch.php or namespaceDupes.php, I issued the following SQL commands. 

  UPDATE mw_page
  SET page_title = 'Wiki:Changes_to_database'
  WHERE page_title = 'Changes_to_Wiki_database' AND page_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_page
  SET page_title = 'Wiki:Changes_to_database'
  WHERE page_title = 'Changes_to_Wiki_database' AND page_namespace = 1;
  
  Query OK, 1 row affected (0.01 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_page
  SET page_title = 'Wiki:LocalSettings.php'
  WHERE page_title = 'LocalSettings.php' AND page_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_page
  SET page_title = 'Wiki:LocalSettings.php'
  WHERE page_title = 'LocalSettings.php' AND page_namespace = 1;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_page
  SET page_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE page_title = 'Changes_to_Monobook_skin' AND page_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_page
  SET page_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE page_title = 'Changes_to_Monobook_skin' AND page_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_page
  SET page_title = REPLACE(page_title, 'Wiki:', ''), page_namespace = 100
  WHERE page_title LIKE 'Wiki:%' AND page_namespace = 0;
  
  Query OK, 11 rows affected (0.03 sec)
  Rows matched: 11  Changed: 11  Warnings: 0
  
  UPDATE mw_page
  SET page_title = REPLACE(page_title, 'Wiki:', ''), page_namespace = 101
  WHERE page_title LIKE 'Wiki:%' AND page_namespace = 1;
  
  Query OK, 2 rows affected (0.00 sec)
  Rows matched: 2  Changed: 2  Warnings: 0
  
  UPDATE mw_page
  SET page_title = REPLACE(page_title, 'RPM:', ''), page_namespace = 110
  WHERE page_title LIKE 'RPM:%' AND page_namespace = 0;
  
  Query OK, 3 rows affected (0.00 sec)
  Rows matched: 3  Changed: 3  Warnings: 0
  
  UPDATE mw_page
  SET page_title = REPLACE(page_title, 'RPM:', ''), page_namespace = 111
  WHERE page_title LIKE 'RPM:%' AND page_namespace = 1;
  
  Query OK, 1 row affected (0.01 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:Changes_to_database'
  WHERE rc_title = 'Changes_to_Wiki_database' AND rc_namespace = 0;
  
  Query OK, 4 rows affected (0.00 sec)
  Rows matched: 4  Changed: 4  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:Changes_to_database'
  WHERE rc_title = 'Changes_to_Wiki_database' AND rc_namespace = 1;
  
  Query OK, 2 rows affected (0.00 sec)
  Rows matched: 2  Changed: 2  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:LocalSettings.php'
  WHERE rc_title = 'LocalSettings.php' AND rc_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:LocalSettings.php'
  WHERE rc_title = 'LocalSettings.php' AND rc_namespace = 1;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE rc_title = 'Changes_to_Monobook_skin' AND rc_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE rc_title = 'Changes_to_Monobook_skin' AND rc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = REPLACE(rc_title, 'Wiki:', ''), rc_namespace = 100
  WHERE rc_title LIKE 'Wiki:%' AND rc_namespace = 0;
  
  Query OK, 24 rows affected (0.01 sec)
  Rows matched: 24  Changed: 24  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = REPLACE(rc_title, 'Wiki:', ''), rc_namespace = 101
  WHERE rc_title LIKE 'Wiki:%' AND rc_namespace = 1;
  
  Query OK, 3 rows affected (0.00 sec)
  Rows matched: 3  Changed: 3  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = REPLACE(rc_title, 'RPM:', ''), rc_namespace = 110
  WHERE rc_title LIKE 'RPM:%' AND rc_namespace = 0;
  
  Query OK, 11 rows affected (0.01 sec)
  Rows matched: 11  Changed: 11  Warnings: 0
  
  UPDATE mw_recentchanges
  SET rc_title = REPLACE(rc_title, 'RPM:', ''), rc_namespace = 111
  WHERE rc_title LIKE 'RPM:%' AND rc_namespace = 1;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:Changes_to_database'
  WHERE pl_title = 'Changes_to_Wiki_database' AND pl_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:Changes_to_database'
  WHERE pl_title = 'Changes_to_Wiki_database' AND pl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:LocalSettings.php'
  WHERE pl_title = 'LocalSettings.php' AND pl_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:LocalSettings.php'
  WHERE pl_title = 'LocalSettings.php' AND pl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE pl_title = 'Changes_to_Monobook_skin' AND pl_namespace = 0;
  
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE pl_title = 'Changes_to_Monobook_skin' AND pl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = REPLACE(pl_title, 'Wiki:', ''), pl_namespace = 100
  WHERE pl_title LIKE 'Wiki:%' AND pl_namespace = 0;
  
  Query OK, 13 rows affected (0.01 sec)
  Rows matched: 13  Changed: 13  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = REPLACE(pl_title, 'Wiki:', ''), pl_namespace = 101
  WHERE pl_title LIKE 'Wiki:%' AND pl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = REPLACE(pl_title, 'RPM:', ''), pl_namespace = 110
  WHERE pl_title LIKE 'RPM:%' AND pl_namespace = 0;
  
  Query OK, 4 rows affected (0.00 sec)
  Rows matched: 4  Changed: 4  Warnings: 0
  
  UPDATE mw_pagelinks
  SET pl_title = REPLACE(pl_title, 'RPM:', ''), pl_namespace = 111
  WHERE pl_title LIKE 'RPM:%' AND pl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:Changes_to_database'
  WHERE pt_title = 'Changes_to_Wiki_database' AND pt_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:Changes_to_database'
  WHERE pt_title = 'Changes_to_Wiki_database' AND pt_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:LocalSettings.php'
  WHERE pt_title = 'LocalSettings.php' AND pt_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:LocalSettings.php'
  WHERE pt_title = 'LocalSettings.php' AND pt_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE pt_title = 'Changes_to_Monobook_skin' AND pt_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE pt_title = 'Changes_to_Monobook_skin' AND pt_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = REPLACE(pt_title, 'Wiki:', ''), pt_namespace = 100
  WHERE pt_title LIKE 'Wiki:%' AND pt_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = REPLACE(pt_title, 'Wiki:', ''), pt_namespace = 101
  WHERE pt_title LIKE 'Wiki:%' AND pt_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = REPLACE(pt_title, 'RPM:', ''), pt_namespace = 110
  WHERE pt_title LIKE 'RPM:%' AND pt_namespace = 0;
  
  Query OK, 0 rows affected (0.01 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_protected_titles
  SET pt_title = REPLACE(pt_title, 'RPM:', ''), pt_namespace = 111
  WHERE pt_title LIKE 'RPM:%' AND pt_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:Changes_to_database'
  WHERE qc_title = 'Changes_to_Wiki_database' AND qc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:Changes_to_database'
  WHERE qc_title = 'Changes_to_Wiki_database' AND qc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:LocalSettings.php'
  WHERE qc_title = 'LocalSettings.php' AND qc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:LocalSettings.php'
  WHERE qc_title = 'LocalSettings.php' AND qc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE qc_title = 'Changes_to_Monobook_skin' AND qc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE qc_title = 'Changes_to_Monobook_skin' AND qc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = REPLACE(qc_title, 'Wiki:', ''), qc_namespace = 100
  WHERE qc_title LIKE 'Wiki:%' AND qc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = REPLACE(qc_title, 'Wiki:', ''), qc_namespace = 101
  WHERE qc_title LIKE 'Wiki:%' AND qc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = REPLACE(qc_title, 'RPM:', ''), qc_namespace = 110
  WHERE qc_title LIKE 'RPM:%' AND qc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycache
  SET qc_title = REPLACE(qc_title, 'RPM:', ''), qc_namespace = 111
  WHERE qc_title LIKE 'RPM:%' AND qc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:Changes_to_database'
  WHERE qcc_title = 'Changes_to_Wiki_database' AND qcc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:Changes_to_database'
  WHERE qcc_title = 'Changes_to_Wiki_database' AND qcc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:LocalSettings.php'
  WHERE qcc_title = 'LocalSettings.php' AND qcc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:LocalSettings.php'
  WHERE qcc_title = 'LocalSettings.php' AND qcc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE qcc_title = 'Changes_to_Monobook_skin' AND qcc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE qcc_title = 'Changes_to_Monobook_skin' AND qcc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = REPLACE(qcc_title, 'Wiki:', ''), qcc_namespace = 100
  WHERE qcc_title LIKE 'Wiki:%' AND qcc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = REPLACE(qcc_title, 'Wiki:', ''), qcc_namespace = 101
  WHERE qcc_title LIKE 'Wiki:%' AND qcc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = REPLACE(qcc_title, 'RPM:', ''), qcc_namespace = 110
  WHERE qcc_title LIKE 'RPM:%' AND qcc_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_querycachetwo
  SET qcc_title = REPLACE(qcc_title, 'RPM:', ''), qcc_namespace = 111
  WHERE qcc_title LIKE 'RPM:%' AND qcc_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:Changes_to_database'
  WHERE rd_title = 'Changes_to_Wiki_database' AND rd_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:Changes_to_database'
  WHERE rd_title = 'Changes_to_Wiki_database' AND rd_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:LocalSettings.php'
  WHERE rd_title = 'LocalSettings.php' AND rd_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:LocalSettings.php'
  WHERE rd_title = 'LocalSettings.php' AND rd_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE rd_title = 'Changes_to_Monobook_skin' AND rd_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE rd_title = 'Changes_to_Monobook_skin' AND rd_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = REPLACE(rd_title, 'Wiki:', ''), rd_namespace = 100
  WHERE rd_title LIKE 'Wiki:%' AND rd_namespace = 0;
  
  Query OK, 0 rows affected (0.01 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = REPLACE(rd_title, 'Wiki:', ''), rd_namespace = 101
  WHERE rd_title LIKE 'Wiki:%' AND rd_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = REPLACE(rd_title, 'RPM:', ''), rd_namespace = 110
  WHERE rd_title LIKE 'RPM:%' AND rd_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_redirect
  SET rd_title = REPLACE(rd_title, 'RPM:', ''), rd_namespace = 111
  WHERE rd_title LIKE 'RPM:%' AND rd_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:Changes_to_database'
  WHERE tl_title = 'Changes_to_Wiki_database' AND tl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:Changes_to_database'
  WHERE tl_title = 'Changes_to_Wiki_database' AND tl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:LocalSettings.php'
  WHERE tl_title = 'LocalSettings.php' AND tl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:LocalSettings.php'
  WHERE tl_title = 'LocalSettings.php' AND tl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE tl_title = 'Changes_to_Monobook_skin' AND tl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE tl_title = 'Changes_to_Monobook_skin' AND tl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = REPLACE(tl_title, 'Wiki:', ''), tl_namespace = 100
  WHERE tl_title LIKE 'Wiki:%' AND tl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = REPLACE(tl_title, 'Wiki:', ''), tl_namespace = 101
  WHERE tl_title LIKE 'Wiki:%' AND tl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = REPLACE(tl_title, 'RPM:', ''), tl_namespace = 110
  WHERE tl_title LIKE 'RPM:%' AND tl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_templatelinks
  SET tl_title = REPLACE(tl_title, 'RPM:', ''), tl_namespace = 111
  WHERE tl_title LIKE 'RPM:%' AND tl_namespace = 1;
  
  Query OK, 0 rows affected (0.01 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:Changes_to_database'
  WHERE wl_title = 'Changes_to_Wiki_database' AND wl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:Changes_to_database'
  WHERE wl_title = 'Changes_to_Wiki_database' AND wl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:LocalSettings.php'
  WHERE wl_title = 'LocalSettings.php' AND wl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:LocalSettings.php'
  WHERE wl_title = 'LocalSettings.php' AND wl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE wl_title = 'Changes_to_Monobook_skin' AND wl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = 'Wiki:Changes_to_Monobook_skin'
  WHERE wl_title = 'Changes_to_Monobook_skin' AND wl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = REPLACE(wl_title, 'Wiki:', ''), wl_namespace = 100
  WHERE wl_title LIKE 'Wiki:%' AND wl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = REPLACE(wl_title, 'Wiki:', ''), wl_namespace = 101
  WHERE wl_title LIKE 'Wiki:%' AND wl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = REPLACE(wl_title, 'RPM:', ''), wl_namespace = 110
  WHERE wl_title LIKE 'RPM:%' AND wl_namespace = 0;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0
  
  UPDATE mw_watchlist
  SET wl_title = REPLACE(wl_title, 'RPM:', ''), wl_namespace = 111
  WHERE wl_title LIKE 'RPM:%' AND wl_namespace = 1;
  
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 0  Changed: 0  Warnings: 0

InterWiki links

In order to use the "Wiki:" namespace, the InterWiki prefix for the C2 Wiki was changed from Wiki to WikiWiki. The result is WikiWiki:FrontPage.

Here's the change to the database. 

 mysql> select * from mw_interwiki where iw_prefix = 'wiki'\G
 *************************** 1. row ***************************
 iw_prefix: wiki
    iw_url: http://c2.com/cgi/wiki?$1
  iw_local: 0
  iw_trans: 0
 
 mysql> update mw_interwiki set iw_prefix = 'wikiwiki' where iw_prefix = 'wiki';

Here's the result. 

 mysql> select * from mw_interwiki where iw_prefix = 'wikiwiki'\G
 *************************** 1. row ***************************
 iw_prefix: wikiwiki
    iw_url: http://c2.com/cgi/wiki?$1
  iw_local: 0
  iw_trans: 0

For some reason, the MediaWiki prefix isn't installed -- perhaps the old installation we started this Wiki just didn't have it or something--seems like a glaring omission. 

 mysql> insert into mw_interwiki (iw_prefix, iw_url) values ('mw', 'http://www.mediawiki.org/wiki/$1');
 Query OK, 1 row affected (0.02 sec)
 
 mysql> select * from mw_interwiki where iw_prefix = 'mw'\G
 *************************** 1. row ***************************
 iw_prefix: mw
    iw_url: http://www.mediawiki.org/wiki/$1
  iw_local: 0
  iw_trans: 0
 1 row in set (0.00 sec)

Here are all the InterWiki prefixes. 

 mysql> select iw_prefix as "Prefix", iw_url as "URL" from mw_interwiki;
Prefix URL
abbenormal http://www.ourpla.net/cgi-bin/pikie.cgi?$1
acadwiki http://xarch.tu-graz.ac.at/autocad/wiki/$1
acronym http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=$1
advogato http://www.advogato.org/$1
aiwiki http://www.ifi.unizh.ch/ailab/aiwiki/aiw.cgi?$1
alife http://news.alife.org/wiki/index.php?$1
annotation http://bayle.stanford.edu/crit/nph-med.cgi/$1
annotationwiki http://www.seedwiki.com/page.cfm?wikiid=368&doc=$1
arxiv http://www.arxiv.org/abs/$1
aspienetwiki http://aspie.mela.de/Wiki/index.php?title=$1
bemi http://bemi.free.fr/vikio/index.php?$1
benefitswiki http://www.benefitslink.com/cgi-bin/wiki.cgi?$1
brasilwiki http://rio.ifi.unizh.ch/brasilienwiki/index.php/$1
bridgeswiki http://c2.com/w2/bridges/$1
c2find http://c2.com/cgi/wiki?FindPage&value=$1
cache http://www.google.com/search?q=cache:$1
ciscavate http://ciscavate.org/index.php/$1
cliki http://ww.telent.net/cliki/$1
cmwiki http://www.ourpla.net/cgi-bin/wiki.pl?$1
codersbase http://www.codersbase.com/$1
commons http://commons.wikimedia.org/wiki/$1
consciousness http://teadvus.inspiral.org/
corpknowpedia http://corpknowpedia.org/wiki/index.php/$1
creationmatters http://www.ourpla.net/cgi-bin/wiki.pl?$1
dejanews http://www.deja.com/=dnc/getdoc.xp?AN=$1
demokraatia http://wiki.demokraatia.ee/
dictionary http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1
disinfopedia http://www.disinfopedia.org/wiki.phtml?title=$1
diveintoosx http://diveintoosx.org/$1
docbook http://docbook.org/wiki/moin.cgi/$1
dolphinwiki http://www.object-arts.com/wiki/html/Dolphin/$1
drumcorpswiki http://www.drumcorpswiki.com/index.php/$1
dwjwiki http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1
echei http://www.ikso.net/cgi-bin/wiki.pl?$1
ecxei http://www.ikso.net/cgi-bin/wiki.pl?$1
efnetceewiki http://purl.net/wiki/c/$1
efnetcppwiki http://purl.net/wiki/cpp/$1
efnetpythonwiki http://purl.net/wiki/python/$1
efnetxmlwiki http://purl.net/wiki/xml/$1
elibre http://enciclopedia.us.es/index.php/$1
eljwiki http://elj.sourceforge.net/phpwiki/index.php/$1
emacswiki http://www.emacswiki.org/cgi-bin/wiki.pl?$1
eokulturcentro http://esperanto.toulouse.free.fr/wakka.php?wiki=$1
evowiki http://www.evowiki.org/index.php/$1
eĉei http://www.ikso.net/cgi-bin/wiki.pl?$1
finalempire http://final-empire.sourceforge.net/cgi-bin/wiki.pl?$1
firstwiki http://firstwiki.org/index.php/$1
foldoc http://www.foldoc.org/foldoc/foldoc.cgi?$1
foxwiki http://fox.wikis.com/wc.dll?Wiki~$1
fr.be http://fr.wikinations.be/$1
fr.ca http://fr.ca.wikinations.org/$1
fr.fr http://fr.fr.wikinations.org/$1
fr.org http://fr.wikinations.org/$1
freebsdman http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1
gamewiki http://gamewiki.org/wiki/index.php/$1
gej http://www.esperanto.de/cgi-bin/aktivikio/wiki.pl?$1
gentoo-wiki http://gentoo-wiki.com/$1
globalvoices http://cyber.law.harvard.edu/dyn/globalvoices/wiki/$1
gmailwiki http://www.gmailwiki.com/index.php/$1
google http://www.google.com/search?q=$1
googlegroups http://groups.google.com/groups?q=$1
gotamac http://www.got-a-mac.org/$1
greencheese http://www.greencheese.org/$1
hammondwiki http://www.dairiki.org/HammondWiki/index.php3?$1
haribeau http://wiki.haribeau.de/cgi-bin/wiki.pl?$1
herzkinderwiki http://www.herzkinderinfo.de/Mediawiki/index.php/$1
hewikisource http://he.wikisource.org/wiki/$1
hrwiki http://www.hrwiki.org/index.php/$1
iawiki http://www.IAwiki.net/$1
imdb http://us.imdb.com/Title?$1
infosecpedia http://www.infosecpedia.org/pedia/index.php/$1
jargonfile http://sunir.org/apps/meta.pl?wiki=JargonFile&redirect=$1
jefo http://www.esperanto-jeunes.org/vikio/index.php?$1
jiniwiki http://www.cdegroot.com/cgi-bin/jini?$1
jspwiki http://www.ecyrd.com/JSPWiki/Wiki.jsp?page=$1
kerimwiki http://wiki.oxus.net/$1
kmwiki http://www.voght.com/cgi-bin/pywiki?$1
knowhow http://www2.iro.umontreal.ca/~paquetse/cgi-bin/wiki.cgi?$1
lanifexwiki http://opt.lanifex.com/cgi-bin/wiki.pl?$1
lasvegaswiki http://wiki.gmnow.com/index.php/$1
linuxwiki http://www.linuxwiki.de/$1
lojban http://www.lojban.org/tiki/tiki-index.php?page=$1
lqwiki http://wiki.linuxquestions.org/wiki/$1
lugkr http://lug-kr.sourceforge.net/cgi-bin/lugwiki.pl?$1
lutherwiki http://www.lutheranarchives.com/mw/index.php/$1
mathsongswiki http://SeedWiki.com/page.cfm?wikiid=237&doc=$1
mbtest http://www.usemod.com/cgi-bin/mbtest.pl?$1
meatball http://www.usemod.com/cgi-bin/mb.pl?$1
mediazilla http://bugzilla.wikipedia.org/$1
memoryalpha http://www.memory-alpha.org/en/index.php/$1
metaweb http://www.metaweb.com/wiki/wiki.phtml?title=$1
metawiki http://sunir.org/apps/meta.pl?$1
metawikipedia http://meta.wikimedia.org/wiki/$1
moinmoin http://purl.net/wiki/moin/$1
mozillawiki http://wiki.mozilla.org/index.php/$1
muweb http://www.dunstable.com/scripts/MuWebWeb?$1
mw http://www.mediawiki.org/wiki/$1
netvillage http://www.netbros.com/?$1
oeis http://www.research.att.com/cgi-bin/access.cgi/as/njas/sequences/eisA.cgi?Anum=$1
openfacts http://openfacts.berlios.de/index.phtml?title=$1
openwiki http://openwiki.com/?$1
opera7wiki http://nontroppo.org/wiki/$1
orgpatterns http://www.bell-labs.com/cgi-user/OrgPatterns/OrgPatterns?$1
osi reference model http://wiki.tigma.ee/
pangalacticorg http://www.pangalactic.org/Wiki/$1
patwiki http://gauss.ffii.org/$1
personaltelco http://www.personaltelco.net/index.cgi/$1
phpwiki http://phpwiki.sourceforge.net/phpwiki/index.php?$1
pikie http://pikie.darktech.org/cgi/pikie?$1
pmeg http://www.bertilow.com/pmeg/$1.php
ppr http://c2.com/cgi/wiki?$1
purlnet http://purl.oclc.org/NET/$1
pythoninfo http://www.python.org/cgi-bin/moinmoin/$1
pythonwiki http://www.pythonwiki.de/$1
pywiki http://www.voght.com/cgi-bin/pywiki?$1
raec http://www.raec.clacso.edu.ar:8080/raec/Members/raecpedia/$1
revo http://purl.org/NET/voko/revo/art/$1.html
rfc http://www.rfc-editor.org/rfc/rfc$1.txt
s23wiki http://is-root.de/wiki/index.php/$1
scoutpedia http://www.scoutpedia.info/index.php/$1
seapig http://www.seapig.org/$1
seattlewiki http://seattlewiki.org/wiki/$1
seattlewireless http://seattlewireless.net/?$1
seeds http://www.IslandSeeds.org/wiki/$1
senseislibrary http://senseis.xmp.net/?$1
shakti http://cgi.algonet.se/htbin/cgiwrap/pgd/ShaktiWiki/$1
slashdot http://slashdot.org/article.pl?sid=$1
smikipedia http://www.smikipedia.org/$1
sockwiki http://wiki.socklabs.com/$1
sourceforge http://sourceforge.net/$1
squeak http://minnow.cc.gatech.edu/squeak/$1
strikiwiki http://ch.twi.tudelft.nl/~mostert/striki/teststriki.pl?$1
susning http://www.susning.nu/$1
svgwiki http://www.protocol7.com/svg-wiki/default.asp?$1
tavi http://tavi.sourceforge.net/$1
tejo http://www.tejo.org/vikio/$1
terrorwiki http://www.liberalsagainstterrorism.com/wiki/index.php/$1
theopedia http://www.theopedia.com/$1
tmbw http://www.tmbw.net/wiki/index.php/$1
tmnet http://www.technomanifestos.net/?$1
tmwiki http://www.EasyTopicMaps.com/?page=$1
turismo http://www.tejo.org/turismo/$1
twiki http://twiki.org/cgi-bin/view/$1
twistedwiki http://purl.net/wiki/twisted/$1
uea http://www.tejo.org/uea/$1
unreal http://wiki.beyondunreal.com/wiki/$1
ursine http://ursine.ca/$1
usej http://www.tejo.org/usej/$1
usemod http://www.usemod.com/cgi-bin/wiki.pl?$1
visualworks http://wiki.cs.uiuc.edu/VisualWorks/$1
warpedview http://www.warpedview.com/index.php/$1
webdevwikinl http://www.promo-it.nl/WebDevWiki/index.php?page=$1
webisodes http://www.webisodes.org/$1
webseitzwiki http://webseitz.fluxent.com/wiki/$1
why http://clublet.com/c/c/why?$1
wikia http://www.wikia.com/wiki/index.php/$1
wikibooks http://en.wikibooks.org/wiki/$1
wikicities http://www.wikicities.com/index.php/$1
wikif1 http://www.wikif1.org/$1
wikimedia http://wikimediafoundation.org/wiki/$1
wikinews http://en.wikinews.org/wiki/$1
wikinfo http://www.wikinfo.org/wiki.php?title=$1
wikiquote http://en.wikiquote.org/wiki/$1
wikisource http://sources.wikipedia.org/wiki/$1
wikispecies http://species.wikipedia.org/wiki/$1
wikitravel http://wikitravel.org/en/$1
wikiwiki http://c2.com/cgi/wiki?$1
wikiworld http://WikiWorld.com/wiki/index.php/$1
wikt http://en.wiktionary.org/wiki/$1
wiktionary http://en.wiktionary.org/wiki/$1
wlug http://www.wlug.org.nz/$1
wlwiki http://winslowslair.supremepixels.net/wiki/index.php/$1
ypsieyeball http://sknkwrks.dyndns.org:1957/writewiki/wiki.pl?$1
zwiki http://www.zwiki.org/$1
zzz wiki http://wiki.zzz.ee/
Retrieved from "http://www.uvm.org/vague/wiki/index.php/Wiki:Changes_to_database"
Personal tools