CREATE TABLE `DirtyFile` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shopId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL DEFAULT '0',
  `creationDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `elaborationDate` TIMESTAMP NULL,
  `worked` TINYINT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  INDEX `shopId` (`shopId`),
  CONSTRAINT `FK1_DirtyFile` FOREIGN KEY (`shopId`) REFERENCES `Shop` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
  COMMENT='For storing the worked file by importer'
  COLLATE='utf8_general_ci'
  ENGINE=InnoDB
;
