https://bugzilla.wikimedia.org/show_bug.cgi?id=39108

--- Comment #4 from Sam Reed (reedy) <[email protected]> 2012-09-18 23:28:29 
UTC ---
mysql> explain mw_pagetriage_tags;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| ptrt_tag_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| ptrt_tag_name | varbinary(20)    | NO   | UNI | NULL    |                |
| ptrt_tag_desc | varbinary(255)   | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)

mysql> select count(*) from mw_pagetriage_tags;
+----------+
| count(*) |
+----------+
|       16 |
+----------+
1 row in set (0.01 sec)

mysql> select * from mw_pagetriage_tags;
+-------------+--------------------+--------------------------------+
| ptrt_tag_id | ptrt_tag_name      | ptrt_tag_desc                  |
+-------------+--------------------+--------------------------------+
|           1 | linkcount          | Number of inbound links        |
|           2 | category_count     | Category mapping count         |
|           3 | csd_status         | CSD status                     |
|           4 | prod_status        | PROD status                    |
|           5 | blp_prod_status    | BLP PROD status                |
|           6 | afd_status         | AFD status                     |
|           7 | rev_count          | Number of edits to the article |
|           8 | page_len           | Number of bytes of article     |
|           9 | snippet            | Beginning of article snippet   |
|          10 | user_name          | User name                      |
|          11 | user_editcount     | User total edit                |
|          12 | user_creation_date | User registration date         |
|          13 | user_autoconfirmed | Check if user is autoconfirmed |
|          14 | user_bot           | Check if user is in bot group  |
|          15 | user_block_status  | User block status              |
|          16 | user_id            | User id                        |
+-------------+--------------------+--------------------------------+
16 rows in set (0.00 sec)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to