Logho_tables_after.sql

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

mysql> desc contents;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| title    | varchar(512) | NO   |     | NULL    |                |
| url      | varchar(512) | NO   |     | NULL    |                |
| created  | datetime     | YES  |     | NULL    |                |
| modified | datetime     | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

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    |                |
| content_id   | int(11)  | NO   |     | 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    |                |
+----------+-------------------+------+-----+---------+----------------+