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



    s23
    3,185Articles

    Wikistats/Table structures

    Mediawikis[edit]

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


    Back to Wikistats

    Cookies help us deliver our services. By using our services, you agree to our use of cookies.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.