CREATE TABLE `person` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `job` VARCHAR(255) NOT NULL, `info` MEDIUMTEXT NULL , `image_id` INT(11), PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB