Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F1426298
patch-drop-afh_user.sql
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
1 KB
Referenced Files
None
Subscribers
None
patch-drop-afh_user.sql
View Options
-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: db_patches/abstractSchemaChanges/patch-drop-afh_user.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE
TEMPORARY
TABLE
/*_*/
__temp__abuse_filter_history
AS
SELECT
afh_id
,
afh_filter
,
afh_actor
,
afh_timestamp
,
afh_pattern
,
afh_comments
,
afh_flags
,
afh_public_comments
,
afh_actions
,
afh_deleted
,
afh_changed_fields
,
afh_group
FROM
/*_*/
abuse_filter_history
;
DROP
TABLE
/*_*/
abuse_filter_history
;
CREATE
TABLE
/*_*/
abuse_filter_history
(
afh_id
INTEGER
PRIMARY
KEY
AUTOINCREMENT
NOT
NULL
,
afh_filter
BIGINT
UNSIGNED
NOT
NULL
,
afh_actor
BIGINT
UNSIGNED
NOT
NULL
,
afh_timestamp
BLOB
NOT
NULL
,
afh_pattern
BLOB
NOT
NULL
,
afh_comments
BLOB
NOT
NULL
,
afh_flags
BLOB
NOT
NULL
,
afh_public_comments
BLOB
DEFAULT
NULL
,
afh_actions
BLOB
DEFAULT
NULL
,
afh_deleted
SMALLINT
DEFAULT
0
NOT
NULL
,
afh_changed_fields
VARCHAR
(
255
)
DEFAULT
''
NOT
NULL
,
afh_group
BLOB
DEFAULT
NULL
);
INSERT
INTO
/*_*/
abuse_filter_history
(
afh_id
,
afh_filter
,
afh_actor
,
afh_timestamp
,
afh_pattern
,
afh_comments
,
afh_flags
,
afh_public_comments
,
afh_actions
,
afh_deleted
,
afh_changed_fields
,
afh_group
)
SELECT
afh_id
,
afh_filter
,
afh_actor
,
afh_timestamp
,
afh_pattern
,
afh_comments
,
afh_flags
,
afh_public_comments
,
afh_actions
,
afh_deleted
,
afh_changed_fields
,
afh_group
FROM
/*_*/
__temp__abuse_filter_history
;
DROP
TABLE
/*_*/
__temp__abuse_filter_history
;
CREATE
INDEX
afh_filter
ON
/*_*/
abuse_filter_history
(
afh_filter
);
CREATE
INDEX
afh_actor
ON
/*_*/
abuse_filter_history
(
afh_actor
);
CREATE
INDEX
afh_timestamp
ON
/*_*/
abuse_filter_history
(
afh_timestamp
);
File Metadata
Details
Attached
Mime Type
text/plain
Expires
Sat, May 16, 13:00 (1 d, 6 h)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
d5/a9/203461323d1a0bf371e05df9fbca
Default Alt Text
patch-drop-afh_user.sql (1 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment