Page MenuHomeWickedGov Phorge
Files F5985909

tables-generated.sql
No OneTemporary
Actions

Size
4 KB
Referenced Files
None
Subscribers
None

tables-generated.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaSql.php.
-- Source: schema/tables.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TABLE /*_*/globalnames (
gn_name VARBINARY(255) NOT NULL,
PRIMARY KEY(gn_name)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/localnames (
ln_wiki VARBINARY(255) NOT NULL,
ln_name VARBINARY(255) NOT NULL,
INDEX ln_name_wiki (ln_name, ln_wiki),
PRIMARY KEY(ln_wiki, ln_name)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/globaluser (
gu_id INT AUTO_INCREMENT NOT NULL,
gu_name VARBINARY(255) DEFAULT NULL,
gu_home_db VARBINARY(255) DEFAULT NULL,
gu_email VARBINARY(255) DEFAULT NULL,
gu_email_authenticated BINARY(14) DEFAULT NULL,
gu_password TINYBLOB DEFAULT NULL,
gu_locked TINYINT(1) DEFAULT 0 NOT NULL,
gu_hidden_level INT DEFAULT 0 NOT NULL,
gu_registration BINARY(14) DEFAULT NULL,
gu_password_reset_key TINYBLOB DEFAULT NULL,
gu_password_reset_expiration BINARY(14) DEFAULT NULL,
gu_auth_token VARBINARY(32) DEFAULT NULL,
gu_cas_token INT UNSIGNED DEFAULT 1 NOT NULL,
UNIQUE INDEX gu_name (gu_name),
INDEX gu_email (gu_email),
INDEX gu_locked (
gu_name(255),
gu_locked
),
INDEX gu_hidden_level (
gu_name(255),
gu_hidden_level
),
PRIMARY KEY(gu_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/localuser (
lu_wiki VARBINARY(255) NOT NULL,
lu_name VARBINARY(255) NOT NULL,
lu_attached_timestamp BINARY(14) DEFAULT NULL,
lu_attached_method ENUM(
'primary', 'empty', 'mail', 'password',
'admin', 'new', 'login'
) DEFAULT NULL,
lu_attachment_method TINYINT UNSIGNED DEFAULT NULL,
lu_local_id INT UNSIGNED DEFAULT NULL,
lu_global_id INT UNSIGNED DEFAULT NULL,
INDEX lu_name_wiki (lu_name, lu_wiki),
PRIMARY KEY(lu_wiki, lu_name)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/global_user_groups (
gug_user INT NOT NULL,
gug_group VARCHAR(255) NOT NULL,
gug_expiry VARBINARY(14) DEFAULT NULL,
INDEX gug_group (gug_group),
INDEX gug_expiry (gug_expiry),
PRIMARY KEY(gug_user, gug_group)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/global_group_permissions (
ggp_group VARCHAR(255) NOT NULL,
ggp_permission VARCHAR(255) NOT NULL,
INDEX ggp_permission (ggp_permission),
PRIMARY KEY(ggp_group, ggp_permission)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/wikiset (
ws_id INT AUTO_INCREMENT NOT NULL,
ws_name VARCHAR(255) NOT NULL,
ws_type ENUM('optin', 'optout') DEFAULT NULL,
ws_wikis BLOB NOT NULL,
UNIQUE INDEX ws_name (ws_name),
PRIMARY KEY(ws_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/global_group_restrictions (
ggr_group VARCHAR(255) NOT NULL,
ggr_set INT NOT NULL,
INDEX ggr_set (ggr_set),
PRIMARY KEY(ggr_group)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/renameuser_status (
ru_oldname VARBINARY(255) NOT NULL,
ru_wiki VARBINARY(255) NOT NULL,
ru_newname VARBINARY(255) NOT NULL,
ru_status ENUM('queued', 'inprogress', 'failed') DEFAULT NULL,
PRIMARY KEY(ru_oldname, ru_wiki)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/renameuser_queue (
rq_id INT AUTO_INCREMENT NOT NULL,
rq_name VARBINARY(255) NOT NULL,
rq_wiki VARBINARY(255) DEFAULT NULL,
rq_newname VARBINARY(255) NOT NULL,
rq_reason BLOB DEFAULT NULL,
rq_requested_ts BINARY(14) DEFAULT NULL,
rq_status ENUM(
'pending', 'approved', 'rejected'
) NOT NULL,
rq_completed_ts BINARY(14) DEFAULT NULL,
rq_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rq_performer INT DEFAULT NULL,
rq_comments BLOB DEFAULT NULL,
rq_type TINYINT UNSIGNED DEFAULT 0 NOT NULL,
INDEX rq_oldstatus (rq_name, rq_wiki, rq_status),
INDEX rq_newstatus (rq_newname, rq_status),
INDEX rq_requested_ts (rq_requested_ts),
PRIMARY KEY(rq_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/users_to_rename (
utr_id INT AUTO_INCREMENT NOT NULL,
utr_name VARBINARY(255) NOT NULL,
utr_wiki VARBINARY(255) NOT NULL,
utr_status INT DEFAULT 0,
UNIQUE INDEX utr_user (utr_name, utr_wiki),
INDEX utr_notif (utr_status),
INDEX utr_wiki (utr_wiki),
PRIMARY KEY(utr_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/global_edit_count (
gec_user INT NOT NULL,
gec_count INT NOT NULL,
PRIMARY KEY(gec_user)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/global_user_autocreate_serial (
uas_shard INT UNSIGNED NOT NULL,
uas_year SMALLINT UNSIGNED NOT NULL,
uas_value INT UNSIGNED NOT NULL,
PRIMARY KEY(uas_shard, uas_year)
) /*$wgDBTableOptions*/;

File Metadata

Mime Type
text/plain
Expires
Sat, Oct 3, 23:56 (2 w, 4 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
4c/1e/57397dc7e0599c9060d5d5949a48
Default Alt Text
tables-generated.sql (4 KB)

Event Timeline