Toolserver:Database schema/Global

Global tables


Toolserver database

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

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
+---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * Field        | Type           | Null | Key | Default | Extra |
 * dbname       | varchar(32)    | NO   |     | NULL    |       |
 * lang         | varchar(16)    | NO   |     | NULL    |       |
 * family       | varchar(16)    | NO   |     | NULL    |       |
 * domain       | varchar(48)    | YES  |     | NULL    |       |
 * size         | int(11)        | NO   |     | 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
+-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+
 * This table is replicated.
 * Database is "centralauth_p"
 * Field          | Type         | Null | Key | Default | Extra |
 * gu_id          | int(11)      | NO   |     | 0       |       |
 * gu_name        | varchar(255) | YES  |     | NULL    |       |
 * gu_registration | varchar(14) | YES  |     | NULL    |       |