ALTER TABLE `ie_User` ADD `directorAccess` ENUM('y','n') NOT NULL DEFAULT 'n' AFTER `viewAllReports`;

CREATE TABLE `ie_DirectorFile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idCategory` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `file` varchar(255) NOT NULL,
  `enabled` enum('y','n') NOT NULL DEFAULT 'y',
  `sorter` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idCategory` (`idCategory`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `ie_DirectorFileCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `sorter` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `ie_zz_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES
(26, 'DirectorFile_', 'Director Files', 220);