Using this Wiki

From Beakstar Wiki

Editing the navagation bar

Editing the bar itself (or what's in the bar)

MediaWiki:Sidebar

Links to edit each item:

mainpage text mainpage url
portal text portal url
currentevents text currentevents url
recentchanges text recentchanges url
randompage text randompage url
help text helppage url
sitesupport text sitesupport url
technotes text technotes url

Database Deletion

Just some general notes:

mysql> select * from beakstar_wiki_page where page_title='Health';
+---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random    | page_touched   | page_latest | page_len |
+---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
|    1618 |              0 | Health     |                   |            0 |                0 |           1 | 0.369918624189 | 20060906150951 |        2427 |     1934 |
+---------+----------------+------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
1 row in set (0.00 sec)

mysql> select * from  beakstar_wiki_revision where rev_page=1618;
+--------+----------+-------------+-----------------------+----------+---------------+----------------+----------------+-------------+
| rev_id | rev_page | rev_text_id | rev_comment           | rev_user | rev_user_text | rev_timestamp  | rev_minor_edit | rev_deleted |
+--------+----------+-------------+-----------------------+----------+---------------+----------------+----------------+-------------+
|   2427 |     1618 |        2426 | /* The other thing */ |        1 | Mtwomey       | 20060831213406 |              0 |           0 |
+--------+----------+-------------+-----------------------+----------+---------------+----------------+----------------+-------------+
1 row in set (0.00 sec)

mysql> select * from beakstar_wiki_archive limit 10;
+--------------+----------+---------+------------+---------+---------------+----------------+---------------+----------+-----------+------------+
| ar_namespace | ar_title | ar_text | ar_comment | ar_user | ar_user_text  | ar_timestamp   | ar_minor_edit | ar_flags | ar_rev_id | ar_text_id |
+--------------+----------+---------+------------+---------+---------------+----------------+---------------+----------+-----------+------------+
|            0 | Health   |         |            |       0 | 192.110.64.17 | 20060619194711 |             0 |          |      2110 |       2109 |
|            0 | Health   |         |            |       1 | Mtwomey       | 20060619194936 |             0 |          |      2111 |       2110 |
|            0 | Health   |         |            |       1 | Mtwomey       | 20060829030444 |             0 |          |      2426 |       2425 |
+--------------+----------+---------+------------+---------+---------------+----------------+---------------+----------+-----------+------------+
3 rows in set (0.00 sec)

mysql> select * from beakstar_wiki_recentchanges where rc_comment like '%Health%';
+-------+----------------+----------------+---------+--------------+--------------+--------------+---------------------------------------------+----------+--------+--------+-----------+---------------+---------------+---------+----------------+-------------------+--------------+---------------+
| rc_id | rc_timestamp   | rc_cur_time    | rc_user | rc_user_text | rc_namespace | rc_title     | rc_comment                                  | rc_minor | rc_bot | rc_new | rc_cur_id | rc_this_oldid | rc_last_oldid | rc_type | rc_moved_to_ns | rc_moved_to_title | rc_patrolled | rc_ip         |
+-------+----------------+----------------+---------+--------------+--------------+--------------+---------------------------------------------+----------+--------+--------+-----------+---------------+---------------+---------+----------------+-------------------+--------------+---------------+
|   666 | 20060619194747 | 20060619194747 |       1 | Mtwomey      |           -1 | Log/restrict | restricted [[Health]]                       |        0 |      0 |      0 |         0 |             0 |             0 |       3 |              0 |                   |            1 |               |
|   682 | 20060906142927 | 20060906142927 |       1 | Mtwomey      |           -1 | Log/delete   | deleted "[[Health]]"                        |        0 |      0 |      0 |         0 |             0 |             0 |       3 |              0 |                   |            1 | 192.110.64.17 |
|   683 | 20060906150951 | 20060906150951 |       1 | Mtwomey      |           -1 | Log/delete   | restored "[[Health]]": 1 revisions restored |        0 |      0 |      0 |         0 |             0 |             0 |       3 |              0 |                   |            1 | 192.110.64.17 |
+-------+----------------+----------------+---------+--------------+--------------+--------------+---------------------------------------------+----------+--------+--------+-----------+---------------+---------------+---------+----------------+-------------------+--------------+---------------+
3 rows in set (0.00 sec)

mysql>