gistfile1.txt

mysql> describe deals
    -> ;
+----------------+---------------+------+-----+---------+----------------+
| Field          | Type          | Null | Key | Default | Extra          |
+----------------+---------------+------+-----+---------+----------------+
| id             | int(11)       | NO   | PRI | NULL    | auto_increment |
| name           | varchar(255)  | YES  |     | NULL    |                |
| permalink      | varchar(255)  | YES  |     | NULL    |                |
| deal_id        | varchar(255)  | YES  |     | NULL    |                |
| sale_price     | decimal(10,0) | YES  |     | NULL    |                |
| actual_price   | decimal(10,0) | YES  |     | NULL    |                |
| division_id    | int(11)       | YES  |     | NULL    |                |
| site_id        | int(11)       | YES  |     | NULL    |                |
| active         | tinyint(1)    | YES  |     | 1       |                |
| sold           | tinyint(1)    | YES  |     | 0       |                |
| hotness        | int(11)       | YES  |     | 0       |                |
| lat            | float         | YES  |     | 0       |                |
| lng            | float         | YES  |     | 0       |                |
| created_at     | datetime      | YES  |     | NULL    |                |
| updated_at     | datetime      | YES  |     | NULL    |                |
| expires_at     | datetime      | YES  |     | NULL    |                |
| raw_address    | varchar(255)  | YES  |     | NULL    |                |
| telephone      | varchar(30)   | YES  |     | NULL    |                |
| max_sold_count | int(11)       | YES  |     | 0       |                |
+----------------+---------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)