All pastes #232758 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-11-01 14:56 UTC
rendered paste body
mysql> describe entry;
+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| entry_id       | int(10) unsigned |      | PRI | NULL    | auto_increment |
| feed_id        | int(10) unsigned |      | MUL | 0       |                |
| title          | varchar(254)     |      | MUL |         |                |
| link           | varchar(254)     |      | MUL |         |                |
| summary        | text             | YES  |     | NULL    |                |
| updated        | datetime         | YES  | MUL | NULL    |                |
| created        | datetime         | YES  |     | NULL    |                |
| category_id    | varchar(254)     | YES  |     | NULL    |                |
| language       | varchar(24)      | YES  |     | NULL    |                |
| alexa_ranking  | float            |      |     | 0       |                |
| rating         | float            | YES  |     | 0       |                |
| votes          | int(11)          | YES  |     | 0       |                |
| comments       | int(11)          | YES  |     | 0       |                |
| merged_ranking | float            | YES  |     | 0       |                |
| user_ranking   | float            | YES  |     | 0       |                |
| country_code   | varchar(45)      | YES  |     | None    |                |
+----------------+------------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)

mysql> select count(*) from entry;
+----------+
| count(*) |
+----------+
|  2255444 |
+----------+
1 row in set (0.00 sec)