×
Create a new article
Write your page title here:
We currently have 3,189 articles on s23. Type your article name above or create one of the articles listed here!



    s23
    s23
    3,189Articles
    Add new page
    in:
    Wiki, Scripts

    Wikistats/Table structures: Difference between revisions

    Content added Content deleted
    imported>mutante
    mNo edit summary
     
    imported>mutante
    mNo edit summary
    Line 2: Line 2:
    -->[[Wikistats]]->Table structures
    -->[[Wikistats]]->Table structures
    <pre>
    <pre>
    mysql> describe wikistats;
    mysql> show tables;
    +---------------------+
    | Tables_in_wikistats |
    +---------------------+
    | anarchopedias |
    | editthis |
    | mediawikis |
    | s23 |
    | uncyclomedia |
    | wikia |
    | wikibooks |
    | wikicities |
    | wikinews |
    | wikipedias |
    | wikiquotes |
    | wikisources |
    | wikistats |
    | wikitravel |
    | wiktionaries |
    | wmspecials |
    +---------------------+
    16 rows in set (0.00 sec)

    mysql> describe anarchopedias;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    14 rows in set (0.00 sec)

    mysql> describe editthis;
    +----------+--------------+------+-----+---------------------+----------------+
    +----------+--------------+------+-----+---------------------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    | Field | Type | Null | Key | Default | Extra |
    Line 8: Line 52:
    | id | int(11) | | PRI | NULL | auto_increment |
    | id | int(11) | | PRI | NULL | auto_increment |
    | name | varchar(64) | YES | | NULL | |
    | name | varchar(64) | YES | | NULL | |
    | label | varchar(128) | YES | | NULL | |
    | url | varchar(255) | YES | | NULL | |
    | total | int(11) | YES | | NULL | |
    | total | int(11) | YES | | NULL | |
    | good | int(11) | | | 0 | |
    | good | int(11) | | | 0 | |
    Line 21: Line 63:
    | color | varchar(32) | YES | | NULL | |
    | color | varchar(32) | YES | | NULL | |
    | linktype | tinyint(4) | YES | | NULL | |
    | linktype | tinyint(4) | YES | | NULL | |
    | statsurl | varchar(255) | YES | MUL | NULL | |
    | version | varchar(32) | YES | | NULL | |
    | images | int(11) | YES | | NULL | |
    +----------+--------------+------+-----+---------------------+----------------+
    +----------+--------------+------+-----+---------------------+----------------+
    15 rows in set (0.03 sec)
    16 rows in set (0.01 sec)
    </pre>


    mysql> describe mediawikis;
    === Wikipedias ===
    +----------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +----------+--------------+------+-----+---------------------+----------------+
    15 rows in set (0.00 sec)


    mysql> describe s23;
    <pre>
    +--------+-----------+------+-----+---------------------+----------------+
    mysql> describe wikipedias;
    | 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 | |
    +--------+-----------+------+-----+---------------------+----------------+
    8 rows in set (0.00 sec)

    mysql> describe uncyclomedia;
    +----------+--------------+------+-----+---------------------+----------------+
    +----------+--------------+------+-----+---------------------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    | Field | Type | Null | Key | Default | Extra |
    Line 41: Line 119:
    | users | int(11) | YES | | NULL | |
    | users | int(11) | YES | | NULL | |
    | admins | int(11) | YES | | NULL | |
    | admins | int(11) | YES | | NULL | |
    | started | date | YES | | NULL | |
    | ts | timestamp | YES | | 0000-00-00 00:00:00 | |
    | ts | timestamp | YES | | 0000-00-00 00:00:00 | |
    | loclang | varchar(128) | YES | | NULL | |
    | loclang | varchar(128) | YES | | NULL | |
    | mainpage | varchar(64) | YES | | NULL | |
    | images | int(11) | YES | | NULL | |
    | statsurl | varchar(255) | YES | MUL | NULL | |
    +----------+--------------+------+-----+---------------------+----------------+
    +----------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.03 sec)
    13 rows in set (0.00 sec)

    mysql> describe wikia;
    +--------+-------------+------+-----+---------------------+----------------+
    | 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 | |
    +--------+-------------+------+-----+---------------------+----------------+
    10 rows in set (0.00 sec)

    mysql> describe wikibooks;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wikicities;
    +----------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +----------+--------------+------+-----+---------------------+----------------+
    11 rows in set (0.00 sec)

    mysql> describe wikinews;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wikipedias;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    12 rows in set (0.00 sec)

    mysql> describe wikiquotes;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wikisources;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wikistats;
    +----------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +----------+--------------+------+-----+---------------------+----------------+
    16 rows in set (0.00 sec)

    mysql> describe wikitravel;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    12 rows in set (0.00 sec)

    mysql> describe wiktionaries;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wiktionaries;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    13 rows in set (0.00 sec)

    mysql> describe wmspecials;
    +---------+--------------+------+-----+---------------------+----------------+
    | 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 | |
    +---------+--------------+------+-----+---------------------+----------------+
    14 rows in set (0.00 sec)

    </pre>
    </pre>



    Back to [[Wikistats]]
    Back to [[Wikistats]]

    Revision as of 18:11, 2 October 2006

    Mediawikis

    -->Wikistats->Table structures 

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

mysql> describe anarchopedias;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
14 rows in set (0.00 sec)

mysql> describe editthis;
+----------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+----------+--------------+------+-----+---------------------+----------------+
16 rows in set (0.01 sec)

mysql> describe mediawikis;
+----------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+----------+--------------+------+-----+---------------------+----------------+
15 rows in set (0.00 sec)

mysql> describe s23;
+--------+-----------+------+-----+---------------------+----------------+
| 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 |                |
+--------+-----------+------+-----+---------------------+----------------+
8 rows in set (0.00 sec)

mysql> describe uncyclomedia;
+----------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+----------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wikia;
+--------+-------------+------+-----+---------------------+----------------+
| 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                |                |
+--------+-------------+------+-----+---------------------+----------------+
10 rows in set (0.00 sec)

mysql> describe wikibooks;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wikicities;
+----------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+----------+--------------+------+-----+---------------------+----------------+
11 rows in set (0.00 sec)

mysql> describe wikinews;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wikipedias;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
12 rows in set (0.00 sec)

mysql> describe wikiquotes;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wikisources;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wikistats;
+----------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+----------+--------------+------+-----+---------------------+----------------+
16 rows in set (0.00 sec)

mysql> describe wikitravel;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
12 rows in set (0.00 sec)

mysql> describe wiktionaries;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wiktionaries;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.00 sec)

mysql> describe wmspecials;
+---------+--------------+------+-----+---------------------+----------------+
| 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                |                |
+---------+--------------+------+-----+---------------------+----------------+
14 rows in set (0.00 sec)


    Back to Wikistats

    Retrieved from "https://wiki.s23.org/wiki/Wikistats/Table_structures?oldid=26922"
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    More information
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    More information