미디어위키 사용자명 관련 DB컬럼

1 개요[ | ]

미디어위키 user_text 컬럼
미디어위키 사용자명 관련 DB컬럼

원장: user 테이블의 user_name 컬럼

테이블	컬럼
abuse_filter	af_user_text
abuse_filter_history	afh_user_text
abuse_filter_log	afl_user_text
archive	ar_user_text
cu_changes	cuc_user_text
cu_log	cul_user_text
filearchive	fa_user_text
image	img_user_text
logging	log_user_text
oldimage	oi_user_text
recentchanges	rc_user_text
revision	rev_user_text
spoofuser	su_name
user	user_name

2 user_text 컬럼[ | ]

미디어위키 user_text 컬럼 문서를 참고하십시오.

MariaDB [(none)]> SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE
    -> FROM information_schema.COLUMNS
    -> WHERE TABLE_SCHEMA='my_wiki' AND COLUMN_NAME LIKE '%_user_text'
    -> ORDER BY TABLE_NAME;
+----------------------+---------------+----------------+
| TABLE_NAME           | COLUMN_NAME   | COLUMN_TYPE    |
+----------------------+---------------+----------------+
| abuse_filter         | af_user_text  | varbinary(255) |
| abuse_filter_history | afh_user_text | varbinary(255) |
| abuse_filter_log     | afl_user_text | varbinary(255) |
| archive              | ar_user_text  | varbinary(255) |
| cu_changes           | cuc_user_text | varbinary(255) |
| cu_log               | cul_user_text | varbinary(255) |
| filearchive          | fa_user_text  | varbinary(255) |
| image                | img_user_text | varbinary(255) |
| logging              | log_user_text | varbinary(255) |
| oldimage             | oi_user_text  | varbinary(255) |
| recentchanges        | rc_user_text  | varbinary(255) |
| revision             | rev_user_text | varbinary(255) |
+----------------------+---------------+----------------+
12 rows in set (0.00 sec)

3 같이 보기[ | ]