×
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

    Talk:Wikistats/ToDo: Difference between revisions

    Content added Content deleted
    imported>mutante
    mNo edit summary
     
    imported>mutante
    mNo edit summary
    Line 1: Line 1:
    moved to [[Wikistats/Table structures]]
    <pre>
    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)

    </pre>

    Revision as of 18:11, 2 October 2006

    moved to Wikistats/Table structures

    Retrieved from "https://wiki.s23.org/wiki/Talk:Wikistats/ToDo?oldid=36872"
    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