Wikistats/Table structures

From S23Wiki
Revision as of 23:35, 18 January 2007 by Mutante (Talk | contribs) (Category:Wikistats)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)

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