Toolserver:Database schema/Global

From mediawiki.org
Jump to navigation Jump to search
Wikimedia Community Logo-Toolserver.svg

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

Global tables[edit]

Toolserver database[edit]

  • Please note: These tables are not replicated as such, but created for toolserver users.
  • Database is "toolserver"

Namespace table[edit]

Namespace table
Field Type Null Key Default Extra
dbname varbinary(32) No Null
domain varbinary(48) No Null
ns_id int(8) No Null
ns_name varbinary(255) Yes Null

Wiki table[edit]

Wiki table
Field Type Null Key Default Extra
dbname varbinary(32) No Null
lang varbinary(16) No Null
family varbinary(16) No Null
domain varbinary(48) Yes Null
size int(11) Yes Null
is_meta tinyint(4) No Null
is_closed tinyint(4) No Null
is_multilang tinyint(4) No Null
is_sensitive tinyint(4) No Null
root_category varbinary(255) Yes Null
server tinyint(4) Yes Null

Globaluser table[edit]

  • This table is replicated.
  • Database is "centralauth_p"
  • Currently you can connect to it via "mysql -h sql-s3 centralauth_p" or "mysql -hcentralauth-p.userdb or sql metawiki_p (command-line access).
mysql> describe global_group_permissions;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| ggp_group      | varchar(255) | NO   |     | NULL    |       |
| ggp_permission | varchar(255) | NO   |     | NULL    |       |
+----------------+--------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> describe global_user_groups
;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| gug_user  | int(11)      | NO   |     | NULL    |       |
| gug_group | varchar(255) | NO   |     | NULL    |       |
+-----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe globaluser;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| gu_id           | int(11)      | NO   |     | 0       |       |
| gu_name         | varchar(255) | YES  |     | NULL    |       |
| gu_registration | varchar(14)  | YES  |     | NULL    |       |
| gu_home_db      | varchar(255) | YES  |     | NULL    |       |
| gu_locked       | tinyint(1)   | NO   |     | 0       |       |
| gu_hidden       | tinyint(1)   | NO   |     | 0       |       |
+-----------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> describe localnames;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| ln_wiki | varchar(255) | NO   |     |         |       |
| ln_name | varchar(255) | NO   |     |         |       |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> describe localuser;
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
| Field                 | Type                                                            | Null | Key | Default | Extra |
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
| lu_wiki               | varchar(255)                                                    | NO   |     | NULL    |       |
| lu_name               | varchar(255)                                                    | NO   |     |         |       |
| lu_attached_timestamp | varchar(14)                                                     | YES  |     | NULL    |       |
| lu_attached_method    | enum('primary','empty','mail','password','admin','new','login') | YES  |     | NULL    |       |
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

Category:Database schema