CREATE  TABLE IF NOT EXISTS `nfyii`.`files` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `title` VARCHAR(50) NOT NULL ,
  `slug` VARCHAR(50) NOT NULL ,
  `url` VARCHAR(100) NOT NULL ,
  `description` TEXT NULL ,
  `author_id` INT(11) UNSIGNED NOT NULL ,
  `editor_id` INT(11) UNSIGNED NULL ,
  `created` DATETIME NOT NULL ,
  `modified` DATETIME NOT NULL ,
  `category_id` INT(11) UNSIGNED NOT NULL ,
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = unpublished; 1= published' ,
  `isexternal` TINYINT(1) NOT NULL DEFAULT '0' ,
  `images` BLOB NULL ,
  `options` BLOB NULL ,
  `visits` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
  `downloads` VARCHAR(45) NOT NULL ,
  `size` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'in bytes' ,
  `average_rating` TINYINT UNSIGNED NULL DEFAULT NULL ,
  `commentcount` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
  `featured_end` DATETIME NULL ,
  `language` VARCHAR(5) NOT NULL DEFAULT 'en-US' ,
  `metadata_keywords` TEXT NULL ,
  `metadata_description` TEXT NULL ,
  `game_id` INT UNSIGNED NOT NULL DEFAULT 0 ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_files_users1_idx` (`author_id` ASC) ,
  INDEX `fk_files_users2_idx` (`editor_id` ASC) ,
  INDEX `fk_files_categories1_idx` (`category_id` ASC) ,
  INDEX `fk_files_games1_idx` (`game_id` ASC) ,
  CONSTRAINT `fk_files_categories1`
    FOREIGN KEY (`category_id` )
    REFERENCES `nfyii`.`categories` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_files_users1`
    FOREIGN KEY (`author_id` )
    REFERENCES `nfyii`.`users` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_files_users2`
    FOREIGN KEY (`editor_id` )
    REFERENCES `nfyii`.`users` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_files_games1`
    FOREIGN KEY (`game_id` )
    REFERENCES `nfyii`.`games` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1