Logho_tables_before.sql

mysql> show tables;
+--------------------------+
| Tables_in_db_hogehoge    |
+--------------------------+
| entrys                   |
| timestamps               |
+--------------------------+

mysql> desc entrys;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | int(11)      | NO   | PRI | NULL    | auto_increment |
| rank         | int(11)      | NO   | MUL | NULL    |                |
| timestamp_id | int(11)      | NO   | MUL | NULL    |                |
| title        | varchar(255) | NO   |     | NULL    |                |
| url          | varchar(255) | NO   |     | NULL    |                |
| description  | text         | YES  |     | NULL    |                |
| cnt          | int(11)      | YES  |     | NULL    |                |
| created      | datetime     | YES  |     | NULL    |                |
| modified     | datetime     | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

mysql> desc timestamps;
+----------+-------------------+------+-----+---------+----------------+
| Field    | Type              | Null | Key | Default | Extra          |
+----------+-------------------+------+-----+---------+----------------+
| id       | int(11)           | NO   | PRI | NULL    | auto_increment |
| tweet    | varchar(500)      | YES  |     | NULL    |                |
| type     | enum('hot','new') | NO   |     | hot     |                |
| created  | datetime          | YES  |     | NULL    |                |
| modified | datetime          | YES  |     | NULL    |                |
+----------+-------------------+------+-----+---------+----------------+