Wikistats/Table structures

Mediawikis
-->Wikistats->Table structures mysql> show tables; +-+ +-+ +-+ 16 rows in set (0.00 sec)
 * Tables_in_wikistats |
 * anarchopedias      |
 * editthis           |
 * mediawikis         |
 * s23                |
 * uncyclomedia       |
 * wikia              |
 * wikibooks          |
 * wikicities         |
 * wikinews           |
 * wikipedias         |
 * wikiquotes         |
 * wikisources        |
 * wikistats          |
 * wikitravel         |
 * wiktionaries       |
 * wmspecials         |

mysql> describe anarchopedias; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 14 rows in set (0.00 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                |                |
 * ts     | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * loclang | varchar(128) | YES |     | NULL                |                |
 * images | int(11)      | YES  |     | NULL                |                |
 * version | varchar(64) | YES  |     | NULL                |                |
 * gettype | varchar(32) | YES  |     | NULL                |                |

mysql> describe editthis; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 16 rows in set (0.01 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * name    | varchar(64)  | 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                |                |
 * statsurl | varchar(255) | YES | MUL | NULL                |                |
 * version | varchar(32)  | YES  |     | NULL                |                |
 * images  | int(11)      | YES  |     | NULL                |                |

mysql> describe mediawikis; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 15 rows in set (0.00 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * name    | varchar(64)  | 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 |                |
 * linktype | tinyint(4)  | YES  |     | NULL                |                |
 * statsurl | varchar(255) | YES | MUL | NULL                |                |
 * version | varchar(32)  | YES  |     | NULL                |                |
 * images  | int(11)      | YES  |     | NULL                |                |

mysql> describe s23; ++---+--+-+-++ ++---+--+-+-++ ++---+--+-+-++ 8 rows in set (0.00 sec)
 * Field | Type      | Null | Key | Default             | Extra          |
 * id    | int(11)   |      | PRI | NULL                | auto_increment |
 * 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                |                |
 * ts    | timestamp | YES  |     | 0000-00-00 00:00:00 |                |

mysql> describe uncyclomedia; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * ts      | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * loclang | varchar(128) | YES  |     | NULL                |                |
 * images  | int(11)      | YES  |     | NULL                |                |
 * statsurl | varchar(255) | YES | MUL | NULL                |                |

mysql> describe wikia; ++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++ 10 rows in set (0.00 sec)
 * Field | Type        | Null | Key | Default             | Extra          |
 * id    | int(11)     |      | PRI | NULL                | auto_increment |
 * name  | varchar(64) | 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                |                |
 * ts    | timestamp   | YES  |     | 0000-00-00 00:00:00 |                |
 * images | int(11)    | YES  |     | NULL                |                |

mysql> describe wikibooks; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikicities; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 11 rows in set (0.00 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * name    | varchar(64)  | 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                |                |
 * ts      | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * statsurl | varchar(255) | YES | MUL | NULL                |                |
 * images  | int(11)      | YES  |     | NULL                |                |

mysql> describe wikinews; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikipedias; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 12 rows in set (0.00 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                |                |
 * ts     | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * loclang | varchar(128) | YES |     | NULL                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikiquotes; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikisources; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikistats; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 16 rows in set (0.00 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  | MUL | 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                |                |
 * images  | int(11)      | YES  |     | NULL                |                |

mysql> describe wikitravel; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 12 rows in set (0.00 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                |                |
 * ts     | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |
 * loclang | varchar(128) | YES |     | NULL                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wiktionaries; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wiktionaries; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 13 rows in set (0.00 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                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wmspecials; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++ 14 rows in set (0.00 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                |                |
 * url    | varchar(128) | YES  |     | NULL                |                |
 * images | int(11)      | YES  |     | NULL                |                |

mysql> describe wikis; +--+--+--+-+-++ +--+--+--+-+-++ +--+--+--+-+-++ 13 rows in set (0.03 sec)
 * Field   | Type         | Null | Key | Default             | Extra          |
 * id      | int(11)      |      | PRI | NULL                | auto_increment |
 * name    | varchar(64)  | YES  |     | NULL                |                |
 * statsurl | varchar(255) | YES | MUL | 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                |                |
 * images  | int(11)      | YES  |     | NULL                |                |
 * jobs    | int(11)      | YES  |     | NULL                |                |
 * version | varchar(32)  | YES  |     | NULL                |                |
 * ts      | timestamp    | YES  |     | 0000-00-00 00:00:00 |                |

Back to Wikistats