Database

Database

• information_schema
• mysql
• performance_schema
• wiki (neet_wiki / toyhouse_wiki)
• matomo (matomo /toyhousecc_matomo)
• wordpress

wiki

Num	Table_name	Main table_important field	Description	Whether it exists in toyhouse.cc
1	actor	actor_id PRI actor_user UNI actor_name UNI		Y
2	archive	ar_id PRI auto_increment(Extra) ar_namespace MUL ? ar_title ar_comment ar_user (=user.user_id) ar_user_text (=user.user_name) ar_timestamp ar_len ar_deleted ar_sha1		Y
3	babel
4	bot_passwords			Y
5	category	cat_id PRI auto_increment(Extra) cat_title UNI cat_pages MUL cat_subcats cat_files	How many categories? "cat_title" How many times has a specific category been played? "cat_pages" + "cat_subcats"	Y
6	categorylinks	cl_from PRI (type number) cl_to PRI (=category.cat_title) cl_sortkey (type name) cl_timestamp cl_type (page or subcat)	Which categories are referenced on a type(page/subcat)？ “cl_from=xx, cl_to PRI” Which types(pages/subcats) are referenced by a specific category？ “cl_to PRI=xx, cl_from” and When was it quoted? “cl_timestamp”	Y
7	change_tag	ct_id PRI auto_increment(Extra) ct_rc_id MUL ct_rev_id MUL ct_tag MUL (/Special:Tags)		Y
8	comment	comment_id PRI auto_increment(Extra) comment_hash MUL comment_text comment_data		Y
9	content			Y
10	content_models			Y
11	externallinks	el_id PRI auto_increment(Extra) el_from MUL el_to MUL el_index MUL	All external links?	Y
12	filearchive	fa_id PRI auto_increment(Extra) fa_storage_group fa_deleted_user (=user.user_id) fa_deleted_timestamp MUL fa_deleted_reason fa_size fa_metadata fa_media_type fa_major_mime fa_minor_mime fa_description fa_user (=user.user_id) fa_user_text (=user.user_name) fa_timestamp fa_sha1	The deleted archives.	Y
13	image	img_name PRI img_size img_metadata img_media_type ('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO', 'MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') img_major_mime ('unknown','application','audio','image','text','video', 'message','model','multipart','chemical') img_minor_mime img_description img_user (=user.user_id) img_user_text (=user.user_name) img_timestamp img_sha1	The historical picture information classified in the file is shown in “Table: oldimage”. How many images of a certain type? “img_media_type”/“img_major_mime”/“img_minor_mime”	Y
14	image_comment_temp			Y
15	imagelinks	il_from PRI il_from_namespace ? il_to PRI	How many links are related to the image? “number of rows in this table” How many connections are linked to the image? “il_to PRI=xx，il_from PRI”	Y
16	interwiki	iw_prefix PRI iw_url	All internal links?	Y
17	ip_changes			Y
18	ipblocks			Y
19	iwlinks	iwl_from PRI （page.page_id） iwl_prefix PRI (commons/wiki/wikipedia) wl_title PRI	The article uses “commons:”/”wiki:”/”wikipedia:” as the tag's vocabulary How many vocabularies are marked with “commons:”/”wiki:”/”wikipedia:” on the same page? “iwl_prefix PRI=xx, iwl_from PRI+ wl_title PRI” a vocabulary, how many pages are marked with “commons:”/”wiki:”/”wikipedia:”? “wl_title PRI=xx, iwl_from PRI +iwl_prefix PRI” Mark “commons:”/”wiki:”/”wikipedia:”, how many times have been used repeatedly (including the same label on different pages , excluding the same label on the same page)？ “iwl_prefix PRI=xx, iwl_from PRI+ wl_title PRI”	Y
20	job			Y
21	l10n_cache		cache	Y
22	langlinks	ll_from PRI ll_lang PRI ll_title	NULL	Y
23	log_search	ls_field PRI (associated_rev_id/ ipb_id/ pr_id ) ls_value PRI ls_log_id PRI	How many times has the page been searched and viewed?	Y
24	logging	log_id PRI auto_increment(Extra) log_type MUL log_action log_timestamp MUL log_user MUL (user.user_id) log_user_text MUL (user.user_name) log_namespace MUL? log_title log_page MUL (page.page_id) log_comment log_params	What operations did the key pages do during a certain period of time? “log_timestamp =xx, log_page=xx, log_type+ log_action”	Y
25	math
26	mathoid
27	module_deps			Y
28	objectcache		cache	Y
29	oldimage	oi_name oi_archive_name oi_size oi_description oi_user oi_user_text oi_timestamp: 20190426071929 oi_metadata oi_media_type oi_major_mime oi_minor_mime oi_sha1	Historical image information classified in the archive, like “Table: image”.	Y
30	page	page_id PRI auto_increment(Extra) page_namespace ? page_title page_is_redirect MUL page_touched page_links_updated page_latest page_len MUL page_content_model	Page information How many pages are there in Wiki as of the current query? “row number” How many pages in WIKI are deleted due to the current query? “page_id - row number” How many WIKI pages have been revised during a certain period of time? “page_touched”	Y
31	page_props	pp_page PRI (=page.page_id) pp_propname PRI pp_value pp_sortkey	page properties information	Y
32	page_restrictions	pr_id PRI (=page.page_id) pr_page MUL pr_type MUL pr_level MUL pr_cascade MUL pr_user pr_expiry	page protection information.	Y
33	pagelinks	pl_from PRI (=page.page_id) pl_from_namespace pl_namespace PRI pl_title PRI	How many links are in a page? “pl_from=xx, row number”	Y
34	protected_titles	pt_namespace PRI pt_title PRI pt_user pt_reason pt_reason_id pt_timestamp MUL pt_expiry pt_create_perm	Read-only page, cannot be edited ?	Y
35	querycache	qcc_type MUL (=querycache_info. qci_type) qcc_value qcc_namespace? qcc_title	query cache information	Y
36	querycache_info	qci_type PRI (activeusers) qci_timestamp	query cache type information.	Y
37	querycachetwo	qcc_type MUL (=querycache_info. qci_type) qcc_value qcc_namespace? qcc_title	query cache information Which users are active？ "qcc_type=activeusers"	Y
38	recentchanges	rc_id PRI auto_increment(Extra) rc_timestamp MUL rc_user (=user.user_id) rc_user_text MUL (=user.user_name) rc_actor MUL rc_namespace? MUL rc_title rc_comment rc_comment_id rc_cur_id MUL rc_this_oldid rc_last_oldid rc_type rc_source rc_patrolled rc_ip MUL rc_old_len rc_new_len rc_deleted rc_logid rc_log_type rc_log_action rc_params	Change log for the last 3 months.	Y
39	redirect	rd_from PRI (Before redirection page.page_id) rd_namespace MUL? rd_title	Redirect page information.	Y
40	revision	rev_id PRI auto_increment(Extra) rev_page MUL (=page.page_id) rev_text_id rev_comment rev_user MUL (=user.user_id) rev_user_text MUL (=user.user_name) rev_timestamp MUL rev_minor_edit rev_deleted rev_len (=page.page_len) rev_parent_id rev_sha1	Version change log How many times does a page version change(at a certain time period)? ”rev_page=xx (rev_timestamp), row number”	Y
41	revision_actor_temp	revactor_rev PRI (=revision.rev_id) revactor_actor PRI (=actor.actor_id) revactor_timestamp revactor_page MUL (=page.page_id)		Y
42	revision_comment_temp	revcomment_rev PRI (=revision.rev_id) revcomment_comment_id PRI (=comment.comment_id)		Y
43	revtag
44	searchindex			Y
45	site_identifiers	si_site MUL (=sites.site_id) si_type PRI (=sites.site_type) si_key PRI		Y
46	site_stats	ss_row_id PRI ss_total_edits ss_good_articles ss_total_pages ss_users ss_active_users ss_images	Summary statistics	Y
47	sites	site_id PRI auto_increment(Extra) site_global_key UNI site_type MUL site_group MUL site_source MUL site_data		Y
48	slot_roles			Y
49	slots			Y
50	smw_concept_cache
51	smw_di_blob	s_id p_id o_hash	Glossary information, name, definition, and link how many glosssary how many pages are referenced by a specific glossary	May be related to extension: Semantic Mediawiki
52	smw_di_bool			May be related to extension: Semantic Mediawiki
53	smw_di_coords			May be related to extension: Semantic Mediawiki
54	smw_di_number			May be related to extension: Semantic Mediawiki
55	smw_di_time			May be related to extension: Semantic Mediawiki
56	smw_di_uri			May be related to extension: Semantic Mediawiki
57	smw_di_wikipage		statistics?	May be related to extension: Semantic Mediawiki
58	smw_fpt_ask			May be related to extension: Semantic Mediawiki
59	smw_fpt_askde			May be related to extension: Semantic Mediawiki
60	smw_fpt_askdu			May be related to extension: Semantic Mediawiki
61	smw_fpt_askfo			May be related to extension: Semantic Mediawiki
62	smw_fpt_askpa			May be related to extension: Semantic Mediawiki
63	smw_fpt_asksi			May be related to extension: Semantic Mediawiki
64	smw_fpt_askst			May be related to extension: Semantic Mediawiki
65	smw_fpt_conc			May be related to extension: Semantic Mediawiki
66	smw_fpt_conv			May be related to extension: Semantic Mediawiki
67	smw_fpt_dtitle			May be related to extension: Semantic Mediawiki
68	smw_fpt_impo			May be related to extension: Semantic Mediawiki
69	smw_fpt_inst			May be related to extension: Semantic Mediawiki
70	smw_fpt_lcode			May be related to extension: Semantic Mediawiki
71	smw_fpt_list			May be related to extension: Semantic Mediawiki
72	smw_fpt_mdat			May be related to extension: Semantic Mediawiki
73	smw_fpt_pplb			May be related to extension: Semantic Mediawiki
74	smw_fpt_prec			May be related to extension: Semantic Mediawiki
75	smw_fpt_pval			May be related to extension: Semantic Mediawiki
76	smw_fpt_redi			May be related to extension: Semantic Mediawiki
77	smw_fpt_serv			May be related to extension: Semantic Mediawiki
78	smw_fpt_sobj			May be related to extension: Semantic Mediawiki
79	smw_fpt_subc			May be related to extension: Semantic Mediawiki
80	smw_fpt_subp			May be related to extension: Semantic Mediawiki
81	smw_fpt_text			May be related to extension: Semantic Mediawiki
82	smw_fpt_type			May be related to extension: Semantic Mediawiki
83	smw_fpt_unit			May be related to extension: Semantic Mediawiki
84	smw_fpt_uri			May be related to extension: Semantic Mediawiki
85	smw_ft_search			May be related to extension: Semantic Mediawiki
86	smw_object_ids			May be related to extension: Semantic Mediawiki
87	smw_prop_stats		statistics?	May be related to extension: Semantic Mediawiki
88	smw_query_links			May be related to extension: Semantic Mediawiki
89	tag_summary	ts_id PRI auto_increment(Extra) ts_rc_id UNI ts_log_id UNI ts_rev_id UNI ts_tags (/Special:Tags)	tagged changes information How many times has a certain Tag been changed? ”ts_tags=xx, row number”	Y
90	templatelinks	tl_from PRI （=page.page_id） tl_namespace PRI ? tl_namespace PRI ? tl_title PRI (=page.page_title)	Which templates are used (link to), and the number of uses? "tl_title" Which pages are referenced by a template? “tl_title=xx, tl_from”	Y
91	text			Y
92	transcache		cache	Y
93	translate_groupreviews
94	translate_groupstats
95	translate_messageindex
96	translate_metadata
97	translate_reviews
98	translate_sections
99	translate_stash
100	translate_tmf
101	translate_tms
102	translate_tmt
103	updatelog			Y
104	uploadstash	us_id PRI auto_increment(Extra) us_user MUL us_key MUL us_source_type us_timestamp MUL us_status us_props us_size us_sha1 us_mime us_media_type	Upload information	Y
105	user	user_id PRI auto_increment(Extra) user_name UNI user_touched user_token user_registration editcount	User information The number of users in the current system? “row number” Number of users registered in a certain period of time? ”user_registration=xx, row number” Log in on a certain day. ”user_touched=xx, row number”	Y
106	user_former_groups	ufg_user PRI (=user.user_id) ufg_group PRI (=user_groups.ug_group)		Y
107	user_groups	ug_user PRI (=user.user_id) ug_group PRI (/Special:ListGroupRights) ug_expiry MUL	user group information How many user groups? “ug_group(Exclude duplicates)” How many user groups are invalid? “ug_expiry MUL、ug_group(Exclude duplicates)” How many users are in a user group? “ug_group=xx, row number”	Y
108	user_newtalk			Y
109	user_properties	up_user PRI (=user.user_id) up_property PRI up_value		Y
110	valid_tag			Y
111	watchlist	wl_id PRI wl_user MUL (=user.user_id) wl_namespace MUL ? wl_title (=page.page_title) wl_notificationtimestamp	Monitor user action data	Y
112	wiki_globalimagelinks	gil_wiki PRI gil_page PRI gil_page_namespace_id gil_page_namespace gil_page_title gil_to PRI	only exist in toyhouse.cc	Y

Matomo

Num	Table_name	Main table_important field	Description	Whether it exists in toyhouse.cc
1	matomo_access	login PRI idsite PRI		Y
2	matomo_archive_blob_2019_01	idarchive PRI name PRI ts_archived	Generate a table each month, named“matomo_archive_blob_year_month”	Y
3	matomo_archive_numeric_2019_01	idarchive PRI name PRI ts_archived value	Generate a table each month, named“matomo_archive_numeric_year_month”	Y
4	matomo_goal	idsite PRI idgoal PRI		Y
5	matomo_log_action	idaction PRI url_prefix		Y
6	matomo_log_conversion	idvisit PRI idgoal PRI buster PRI		Y
7	matomo_log_conversion_item	idsite MUL idvisitor server_time idvisit PRI idorder PRI idaction_sku PRI idaction_name idaction_category		Y
8	matomo_log_link_visit_action	idlink_va PRI auto_increment(Extra) idsite MUL idvisitor idvisit MUL server_time		Y
9	matomo_log_profiling	query UNI count sum_time_ms		Y
10	matomo_log_visit	idvisit PRI auto_increment(Extra) idsite MUL idvisitor visit_last_action_time		Y
11	matomo_logger_message	idlogger_message PRI auto_increment(Extra) tag timestamp		Y
12	matomo_option			Y
13	matomo_plugin_setting			Y
14	matomo_privacy_logdata_anonymizations	idlogdata_anonymization PRI auto_increment(Extra) idsites date_start date_end anonymize_ip anonymize_location anonymize_userid unset_visit_columns unset_link_visit_action_columns requester		Y
15	matomo_report			Y
16	matomo_segment			Y
17	matomo_sequence			Y
18	matomo_session			Y
19	matomo_site	idsite PRI auto_increment(Extra) name main_url ts_created sitesearch sitesearch_keyword_parameters sitesearch_category_parameters timezone currency group type keep_url_fragment		Y
20	matomo_site_setting			Y
21	matomo_site_url			Y
22	matomo_user	login PRI email token_auth UNI date_registered		Y
23	matomo_user_dashboard	login PRI iddashboard PRI name		Y
24	matomo_user_language			Y