Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F195714
LQT user rename old username before
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
•
Mattflaschen-WMF
Jul 17 2015, 8:31 PM
2015-07-17 20:31:10 (UTC+0)
Size
14 KB
Referenced Files
None
Subscribers
None
LQT user rename old username before
View Options
mysql> SELECT * FROM thread WHERE thread_author_name = 'Old username' LIMIT 10 \G
*************************** 1. row ***************************
thread_id: 11013
thread_root: 860
thread_ancestor: 0
thread_parent: NULL
thread_summary_page: NULL
thread_subject: New thread
thread_author_id: 432
thread_author_name: Old username
thread_modified: 20150717202302
thread_created: 20150717202145
thread_editedness: 1
thread_article_namespace: 0
thread_article_title: LQT_Rename_Test
thread_article_id: 859
thread_type: 0
thread_sortkey: 20150717202302
thread_replies: 2
thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]])
*************************** 2. row ***************************
thread_id: 11014
thread_root: 861
thread_ancestor: 11013
thread_parent: 11013
thread_summary_page: NULL
thread_subject: New thread
thread_author_id: 432
thread_author_name: Old username
thread_modified: 20150717202302
thread_created: 20150717202153
thread_editedness: 2
thread_article_namespace: 0
thread_article_title: LQT_Rename_Test
thread_article_id: 859
thread_type: 0
thread_sortkey: 20150717202302
thread_replies: 1
thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]])
*************************** 3. row ***************************
thread_id: 11015
thread_root: 862
thread_ancestor: 11013
thread_parent: 11014
thread_summary_page: NULL
thread_subject: New thread
thread_author_id: 432
thread_author_name: Old username
thread_modified: 20150717202203
thread_created: 20150717202203
thread_editedness: 0
thread_article_namespace: 0
thread_article_title: LQT_Rename_Test
thread_article_id: 859
thread_type: 0
thread_sortkey: 20150717202203
thread_replies: 0
thread_signature: [[User:Old username|Old username]] ([[User talk:Old username|talk]])
3 rows in set (0.02 sec)
mysql> SELECT * FROM revision WHERE rev_user_text = 'Old username' LIMIT 10\G
*************************** 1. row ***************************
rev_id: 1797
rev_page: 860
rev_text_id: 1348
rev_comment: New thread: New thread
rev_user: 432
rev_user_text: Old username
rev_timestamp: 20150717202145
rev_minor_edit: 0
rev_deleted: 0
rev_len: 4
rev_parent_id: 0
rev_sha1: e22wovd8j8vhmq10h6bwfdx02okycwb
rev_content_format: NULL
rev_content_model: NULL
*************************** 2. row ***************************
rev_id: 1798
rev_page: 861
rev_text_id: 1349
rev_comment: Reply to [[Thread:LQT Rename Test/New thread|New thread]]
rev_user: 432
rev_user_text: Old username
rev_timestamp: 20150717202153
rev_minor_edit: 0
rev_deleted: 0
rev_len: 5
rev_parent_id: 0
rev_sha1: cmvob5khb95z6zw12kzyqs84pcvnp55
rev_content_format: NULL
rev_content_model: NULL
*************************** 3. row ***************************
rev_id: 1799
rev_page: 862
rev_text_id: 1350
rev_comment: Reply to [[Thread:LQT Rename Test/New thread/reply|New thread]]
rev_user: 432
rev_user_text: Old username
rev_timestamp: 20150717202203
rev_minor_edit: 0
rev_deleted: 0
rev_len: 13
rev_parent_id: 0
rev_sha1: bx86uzhrqfjdmzkp0bedjz7yrh9rmcs
rev_content_format: NULL
rev_content_model: NULL
*************************** 4. row ***************************
rev_id: 1800
rev_page: 861
rev_text_id: 1351
rev_comment:
rev_user: 432
rev_user_text: Old username
rev_timestamp: 20150717202302
rev_minor_edit: 1
rev_deleted: 0
rev_len: 12
rev_parent_id: 1798
rev_sha1: rnienf2y4vqzi0akvoqhlo4q877mo8l
rev_content_format: NULL
rev_content_model: NULL
4 rows in set (0.00 sec)
mysql> SELECT * FROM thread_history WHERE th_user_text = 'Old username' LIMIT 10\G
*************************** 1. row ***************************
th_id: 14285
th_thread: 11013
th_timestamp: 20150717202145
th_user: 432
th_user_text: Old username
th_change_type: 0
th_change_object: 11013
th_change_comment:
th_content: O:6:"Thread":26:{s:9:" * rootId";i:860;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";i:0;s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202145";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202145";s:5:" * id";i:11013;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;}
*************************** 2. row ***************************
th_id: 14286
th_thread: 11013
th_timestamp: 20150717202154
th_user: 432
th_user_text: Old username
th_change_type: 1
th_change_object: 11014
th_change_comment: Reply to [[Thread:LQT Rename Test/New thread|New thread]]
th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202154";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202154";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:1;s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";i:861;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202153";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202153";s:5:" * id";i:11014;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;}}s:12:" * reactions";N;s:10:"replyCount";i:1;}
*************************** 3. row ***************************
th_id: 14287
th_thread: 11013
th_timestamp: 20150717202203
th_user: 432
th_user_text: Old username
th_change_type: 1
th_change_object: 11015
th_change_comment: Reply to [[Thread:LQT Rename Test/New thread/reply|New thread]]
th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"1";s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";s:3:"861";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11014";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:1;s:10:" * editors";N;s:10:" * replies";a:1:{i:11015;O:6:"Thread":26:{s:9:" * rootId";i:862;s:12:" * articleId";i:859;s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11014";s:14:" * superthread";r:26;s:11:" * ancestor";r:1;s:19:" * articleNamespace";i:0;s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202203";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";i:11015;s:7:" * type";i:0;s:10:" * subject";s:10:"New thread";s:11:" * authorId";i:432;s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:0;s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";i:0;}}s:12:" * reactions";N;s:10:"replyCount";i:1;}}s:12:" * reactions";N;s:10:"replyCount";i:2;}
*************************** 4. row ***************************
th_id: 14288
th_thread: 11013
th_timestamp: 20150717202302
th_user: 432
th_user_text: Old username
th_change_type: 2
th_change_object: 11014
th_change_comment:
th_content: O:6:"Thread":26:{s:9:" * rootId";s:3:"860";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:1:"0";s:11:" * parentId";N;s:14:" * superthread";N;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202302";s:10:" * created";s:14:"20150717202145";s:10:" * sortkey";s:14:"20150717202302";s:5:" * id";s:5:"11013";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"1";s:10:" * editors";N;s:10:" * replies";a:1:{i:11014;O:6:"Thread":26:{s:9:" * rootId";s:3:"861";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11013";s:14:" * superthread";r:1;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202302";s:10:" * created";s:14:"20150717202153";s:10:" * sortkey";s:14:"20150717202302";s:5:" * id";s:5:"11014";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";i:2;s:10:" * editors";N;s:10:" * replies";a:1:{i:11015;O:6:"Thread":26:{s:9:" * rootId";s:3:"862";s:12:" * articleId";s:3:"859";s:12:" * summaryId";N;s:13:" * ancestorId";s:5:"11013";s:11:" * parentId";s:5:"11014";s:14:" * superthread";r:26;s:11:" * ancestor";r:1;s:19:" * articleNamespace";s:1:"0";s:15:" * articleTitle";s:15:"LQT_Rename_Test";s:11:" * modified";s:14:"20150717202203";s:10:" * created";s:14:"20150717202203";s:10:" * sortkey";s:14:"20150717202203";s:5:" * id";s:5:"11015";s:7:" * type";s:1:"0";s:10:" * subject";s:10:"New thread";s:11:" * authorId";s:3:"432";s:13:" * authorName";s:12:"Old username";s:12:" * signature";s:68:"[[User:Old username|Old username]] ([[User talk:Old username|talk]])";s:16:" * allDataLoaded";N;s:15:" * isHistorical";b:0;s:15:" * rootRevision";N;s:10:"editedness";s:1:"0";s:10:" * editors";N;s:10:" * replies";a:0:{}s:12:" * reactions";N;s:10:"replyCount";s:1:"0";}}s:12:" * reactions";N;s:10:"replyCount";s:1:"1";}}s:12:" * reactions";N;s:10:"replyCount";s:1:"2";}
4 rows in set (0.03 sec)
mysql> SELECT * FROM thread_reaction WHERE tr_user_text = 'Old username';
Empty set (0.00 sec)
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
186619
Default Alt Text
LQT user rename old username before (14 KB)
Attached To
Mode
P1010 LQT user rename old username before
Attached
Detach File
Event Timeline
Log In to Comment