Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
Line 2:
-->[[Wikistats]]->Table structures
<pre>
mysql>
+---------------------+
| 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 |
Line 8 ⟶ 52:
| id | int(11) | | PRI | NULL | auto_increment |
| name | varchar(64) | YES | | NULL | |
| total | int(11) | YES | | NULL | |
| good | int(11) | | | 0 | |
Line 21 ⟶ 63:
| color | varchar(32) | YES | | NULL | |
| linktype | tinyint(4) | YES | | NULL | |
| statsurl | varchar(255) | YES | MUL | NULL | |
| version | varchar(32) | YES | | NULL | |
| images | int(11) | YES | | NULL | |
+----------+--------------+------+-----+---------------------+----------------+
mysql> describe mediawikis;
+----------+--------------+------+-----+---------------------+----------------+
| 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 |
Line 41 ⟶ 119:
| users | int(11) | YES | | NULL | |
| admins | int(11) | YES | | NULL | |
| ts | timestamp | YES | | 0000-00-00 00:00:00 | |
| loclang | varchar(128) | YES | | NULL | |
|
| statsurl | varchar(255) | YES | MUL | NULL | |
+----------+--------------+------+-----+---------------------+----------------+
13 rows in set (0.
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>
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