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"

Globaluser table
mysql> describe global_group_permissions; ++--+--+-+-+---+ ++--+--+-+-+---+ ++--+--+-+-+---+ 2 rows in set (0.01 sec)
 * 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).
 * Field         | Type         | Null | Key | Default | Extra |
 * ggp_group     | varchar(255) | NO   |     | NULL    |       |
 * ggp_permission | varchar(255) | NO  |     | NULL    |       |

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

mysql> describe globaluser; +-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+ 6 rows in set (0.00 sec)
 * 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       |       |

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

mysql> describe localuser; +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+ 4 rows in set (0.00 sec) Toolserver:Category:Database schema
 * 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    |       |