Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante |
||
(2 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
-->[[Wikistats]]->Table structures |
-->[[Wikistats]]->Table structures |
||
<pre> |
<pre> |
||
mysql> |
mysql> show tables; |
||
+---------------------+ |
|||
| Tables_in_wikistats | |
|||
+---------------------+ |
|||
| anarchopedias | |
|||
| editthis | |
|||
| mediawikis | |
|||
| s23 | |
|||
| uncyclomedia | |
|||
| wikia | |
|||
| wikibooks | |
|||
| wikicities | |
|||
| wikinews | |
|||
| wikipedias | |
|||
| wikiquotes | |
|||
| wikisources | |
|||
| wikistats | |
|||
| wikitravel | |
|||
| wiktionaries | |
|||
| wmspecials | |
|||
+---------------------+ |
|||
16 rows in set (0.00 sec) |
|||
mysql> describe anarchopedias; |
|||
+---------+--------------+------+-----+---------------------+----------------+ |
|||
| Field | Type | Null | Key | Default | Extra | |
|||
+---------+--------------+------+-----+---------------------+----------------+ |
|||
| id | int(11) | | PRI | NULL | auto_increment | |
|||
| lang | varchar(128) | YES | | NULL | | |
|||
| prefix | varchar(16) | YES | MUL | NULL | | |
|||
| total | int(11) | YES | | NULL | | |
|||
| good | int(11) | YES | | NULL | | |
|||
| views | int(11) | YES | | NULL | | |
|||
| edits | int(11) | YES | | NULL | | |
|||
| users | int(11) | YES | | NULL | | |
|||
| admins | int(11) | YES | | NULL | | |
|||
| ts | timestamp | YES | | 0000-00-00 00:00:00 | | |
|||
| loclang | varchar(128) | YES | | NULL | | |
|||
| images | int(11) | YES | | NULL | | |
|||
| version | varchar(64) | YES | | NULL | | |
|||
| gettype | varchar(32) | YES | | NULL | | |
|||
+---------+--------------+------+-----+---------------------+----------------+ |
|||
14 rows in set (0.00 sec) |
|||
mysql> describe editthis; |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
+----------+--------------+------+-----+---------------------+----------------+ |
||
| Field | Type | Null | Key | Default | Extra | |
| Field | Type | Null | Key | Default | Extra | |
||
Line 8: | Line 52: | ||
| id | int(11) | | PRI | NULL | auto_increment | |
| id | int(11) | | PRI | NULL | auto_increment | |
||
| name | varchar(64) | YES | | NULL | | |
| name | varchar(64) | YES | | NULL | | |
||
| label | varchar(128) | YES | | NULL | | |
|||
| url | varchar(255) | YES | | NULL | | |
|||
| total | int(11) | YES | | NULL | | |
| total | int(11) | YES | | NULL | | |
||
| good | int(11) | | | 0 | | |
| good | int(11) | | | 0 | | |
||
Line 21: | Line 63: | ||
| color | varchar(32) | YES | | NULL | | |
| color | varchar(32) | YES | | NULL | | |
||
| linktype | tinyint(4) | YES | | NULL | | |
| linktype | tinyint(4) | YES | | NULL | | |
||
| statsurl | varchar(255) | YES | MUL | NULL | | |
|||
| version | varchar(32) | YES | | NULL | | |
|||
| images | int(11) | YES | | NULL | | |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
+----------+--------------+------+-----+---------------------+----------------+ |
||
16 rows in set (0.01 sec) |
|||
</pre> |
|||
mysql> describe mediawikis; |
|||
=== Wikipedias === |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
|||
| Field | Type | Null | Key | Default | Extra | |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
|||
| id | int(11) | | PRI | NULL | auto_increment | |
|||
| name | varchar(64) | YES | | NULL | | |
|||
| total | int(11) | YES | | NULL | | |
|||
| good | int(11) | | | 0 | | |
|||
| views | int(11) | YES | | NULL | | |
|||
| edits | int(11) | YES | | NULL | | |
|||
| users | int(11) | YES | | NULL | | |
|||
| admins | int(11) | YES | | NULL | | |
|||
| started | date | YES | | NULL | | |
|||
| host | varchar(128) | YES | | NULL | | |
|||
| ts | timestamp | YES | | 0000-00-00 00:00:00 | | |
|||
| linktype | tinyint(4) | YES | | NULL | | |
|||
| statsurl | varchar(255) | YES | MUL | NULL | | |
|||
| version | varchar(32) | YES | | NULL | | |
|||
| images | int(11) | YES | | NULL | | |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
|||
15 rows in set (0.00 sec) |
|||
mysql> describe s23; |
|||
<pre> |
|||
+--------+-----------+------+-----+---------------------+----------------+ |
|||
mysql> describe wikipedias; |
|||
| Field | Type | Null | Key | Default | Extra | |
|||
+--------+-----------+------+-----+---------------------+----------------+ |
|||
| id | int(11) | | PRI | NULL | auto_increment | |
|||
| total | int(11) | YES | | NULL | | |
|||
| good | int(11) | YES | | NULL | | |
|||
| views | int(11) | YES | | NULL | | |
|||
| edits | int(11) | YES | | NULL | | |
|||
| users | int(11) | YES | | NULL | | |
|||
| admins | int(11) | YES | | NULL | | |
|||
| ts | timestamp | YES | | 0000-00-00 00:00:00 | | |
|||
+--------+-----------+------+-----+---------------------+----------------+ |
|||
8 rows in set (0.00 sec) |
|||
mysql> describe uncyclomedia; |
|||
+----------+--------------+------+-----+---------------------+----------------+ |
+----------+--------------+------+-----+---------------------+----------------+ |
||
| Field | Type | Null | Key | Default | Extra | |
| Field | Type | Null | Key | Default | Extra | |
||
Line 41: | Line 119: | ||
| users | int(11) | YES | | NULL | | |
| users | int(11) | YES | | NULL | | |
||
| admins | int(11) | YES | | NULL | | |
| admins | int(11) | YES | | NULL | | |
||
| started | date | YES | | NULL | | |
|||
| ts | timestamp | YES | | 0000-00-00 00:00:00 | | |
| ts | timestamp | YES | | 0000-00-00 00:00:00 | | |
||
| loclang | varchar(128) | YES | | NULL | | |
| loclang | varchar(128) | YES | | NULL | | |
||
| |
| 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) |
13 rows in set (0.03 sec) |
||
</pre> |
</pre> |
||
Back to [[Wikistats]] |
Back to [[Wikistats]] |
||
Line 53: | Line 391: | ||
[[Category:Wiki]] |
[[Category:Wiki]] |
||
[[Category:Scripts]] |
[[Category:Scripts]] |
||
[[Category:Wikistats]] |
Latest revision as of 07:35, 19 January 2007
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