+----------------+----------------------+------+-----+---------+----------------+
| Field          | Type                 | Null | Key | Default | Extra          |
+----------------+----------------------+------+-----+---------+----------------+
| id             | int(11)              | NO   | PRI | NULL    | auto_increment | 
| isbn           | char(13)             | NO   | UNI | NULL    |                | 
| ean            | char(13)             | YES  | MUL | NULL    |                | 
| flipflop       | tinyint(1)           | NO   |     | 1       |                | 
| bookid         | varchar(32)          | YES  | MUL | NULL    |                | 
| title          | varchar(128)         | NO   |     | NULL    |                | 
| edition        | varchar(10)          | YES  |     | NULL    |                | 
| author         | varchar(255)         | YES  |     | NULL    |                | 
| pub_name       | varchar(80)          | YES  |     | NULL    |                | 
| pub_date       | date                 | YES  |     | NULL    |                | 
| pub_streetdate | date                 | YES  |     | NULL    |                | 
| price_list     | decimal(13,2)        | YES  |     | NULL    |                | 
| price_amazon   | decimal(13,2)        | YES  |     | NULL    |                | 
| page_count     | smallint(5) unsigned | NO   |     | NULL    |                | 
| dim_depth      | decimal(13,2)        | YES  |     | NULL    |                | 
| dim_width      | decimal(13,2)        | YES  |     | NULL    |                | 
| dim_height     | decimal(13,2)        | YES  |     | NULL    |                | 
| dim_weight     | decimal(13,2)        | YES  |     | NULL    |                | 
| binding        | varchar(15)          | YES  |     | NULL    |                | 
| subtitle       | varchar(150)         | YES  |     | NULL    |                | 
| volume         | varchar(10)          | YES  |     | NULL    |                | 
| series_title   | varchar(255)         | YES  |     | NULL    |                | 
| image_thumb    | varchar(255)         | YES  |     | NULL    |                | 
| image_medium   | varchar(255)         | YES  |     | NULL    |                | 
| image_large    | varchar(255)         | YES  |     | NULL    |                | 
| reload         | tinyint(1)           | YES  |     | 0       |                | 
+----------------+----------------------+------+-----+---------+----------------+