Importing¶

mysql> explain content;
+-------------------------+--------------+------+-----+---------+----------------+
| Field                   | Type         | Null | Key | Default | Extra          |
+-------------------------+--------------+------+-----+---------+----------------+
| id                      | int(11)      | NO   | PRI | NULL    | auto_increment | ID which is used in the url
| title                   | varchar(255) | NO   |     |         |                | title of a content item [required]
| date                    | datetime     | YES  |     | NULL    |                | only used for events
| body                    | text         | YES  |     | NULL    |                | body of a content item
| place                   | varchar(255) | NO   |     |         |                | 
| created_on              | datetime     | YES  |     | NULL    |                | content item created on [required]
| updated_on              | datetime     | YES  |     | NULL    |                |
| summary                 | text         | NO   |     | NULL    |                | summery content [required]
| url                     | varchar(255) | YES  |     | NULL    |                |
| published_by            | varchar(255) | NO   |     |         |                |
| end_date                | datetime     | YES  |     | NULL    |                |
| event_group_id          | int(11)      | YES  | MUL | NULL    |                |
| contact_email           | varchar(255) | YES  |     | NULL    |                |
| contact_phone           | varchar(255) | YES  |     | NULL    |                |
| user_id                 | int(11)      | YES  |     | NULL    |                |
| type                    | varchar(255) | NO   |     | NULL    |                |
| file                    | varchar(255) | YES  |     | NULL    |                |
| content_id              | int(11)      | YES  |     | NULL    |                |
| processing_status       | int(11)      | YES  |     | NULL    |                |
| media_size              | int(11)      | YES  |     | NULL    |                |
| moderation_status       | varchar(255) | YES  |     | NULL    |                |
| allows_comments         | tinyint(1)   | YES  |     | 1       |                |
| stick_at_top            | tinyint(1)   | YES  |     | NULL    |                |
| collective_id           | int(11)      | YES  |     | NULL    |                |
| auto_moderation_checked | tinyint(1)   | YES  |     | 0       |                |
| admin_note              | text         | NO   |     | NULL    |                |
| file_content_type       | varchar(255) | YES  |     | NULL    |                |
| admin_comment           | text         | YES  |     | NULL    |                |
| wire_id                 | int(11)      | YES  |     | 1       |                |
| aspect_ratio            | varchar(255) | YES  |     | NULL    |                |
| source                  | varchar(255) | YES  |     | NULL    |                |
| video_format            | varchar(5)   | YES  |     | NULL    |                |
+-------------------------+--------------+------+-----+---------+----------------+