Wikistats/Table structures

Mediawikis
-->Wikistats->Table structures mysql> describe wikistats; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 15 rows in set (0.03 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * name    | varchar(64)  | YES  |     | NULL                |                |
 * label   | varchar(128) | YES  |     | NULL                |                |
 * url     | varchar(255) | YES  |     | NULL                |                |
 * total   | int(11)      | YES  |     | NULL                |                |
 * good    | int(11)      |      |     | 0                   |                |
 * views   | int(11)      | YES  |     | NULL                |                |
 * edits   | int(11)      | YES  |     | NULL                |                |
 * users   | int(11)      | YES  |     | NULL                |                |
 * admins  | int(11)      | YES  |     | NULL                |                |
 * started | date         | YES  |     | NULL                |                |
 * host    | varchar(128) | YES  |     | NULL                |                |
 * ts      | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * color   | varchar(32)  | YES  |     | NULL                |                |
 * linktype | tinyint(4)  | YES  |     | NULL                |                |

Wikipedias
mysql> describe wikipedias; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 13 rows in set (0.03 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * lang    | varchar(128) | YES  |     | NULL                |                |
 * prefix  | varchar(16)  | YES  | MUL | NULL                |                |
 * total   | int(11)      | YES  |     | NULL                |                |
 * good    | int(11)      | YES  |     | NULL                |                |
 * views   | int(11)      | YES  |     | NULL                |                |
 * edits   | int(11)      | YES  |     | NULL                |                |
 * users   | int(11)      | YES  |     | NULL                |                |
 * admins  | int(11)      | YES  |     | NULL                |                |
 * started | date         | YES  |     | NULL                |                |
 * ts      | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * loclang | varchar(128) | YES  |     | NULL                |                |
 * mainpage | varchar(64) | YES  |     | NULL                |                |

Back to Wikistats