DO NOT ADD 'DraftPage' to SanityCheckFileRegistry table !!!

DROP TABLE IF EXISTS `qs_SanityCheckFileRegistry`;
CREATE TABLE `qs_SanityCheckFileRegistry` (
    `tableAlias` VARCHAR(50) NOT NULL,
    `fieldName` VARCHAR(50) NOT NULL,
    `pageQuery` VARCHAR(255) NULL DEFAULT NULL,
    PRIMARY KEY(`tableAlias`, `fieldName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `qs_SanityCheckFileRegistry` (`tableAlias`, `fieldName`, `pageQuery`) VALUES
('Gallery', 'image', '<type=Gallery\\Admin\\>'),
('GalleryCategory', 'image', '<type=Gallery\\Category\\Admin\\>'),
('Manufacturer', 'image', '<type=Manufacturer_Admin_>'),
('News', 'image', '<type=News_Admin_>'),
('News', 'file', '<type=News_Admin_>'),
('Page', 'headerImage', '<type=Cms_>'),
('People', 'image', '<type=People_Admin_>'),
('Slide', 'image', '<type=Slide_Admin_>'),
('Slide', 'backgroundImage', '<type=Slide_Admin_>'),
('SocialLink', 'image', '<type=SocialLink_Admin_>');


DROP TABLE IF EXISTS `qs_SanityCheckAppFile`;
CREATE TABLE `qs_SanityCheckAppFile` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `tableAlias` VARCHAR(50) NOT NULL,
    `fieldName` VARCHAR(50) NOT NULL,
    `primaryKey` VARCHAR(150) NOT NULL,
    `fileName` VARCHAR(255) NOT NULL,
    `fileRecordExists` ENUM('y','n') NOT NULL DEFAULT 'n',
    `userFileExists` ENUM('y','n') NOT NULL DEFAULT 'n',
    `status` VARCHAR(50) NULL DEFAULT NULL,
    PRIMARY KEY(`id`),
    INDEX `fileName` (`fileName` ASC)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `qs_SanityCheckUserFile`;
CREATE TABLE `qs_SanityCheckUserFile` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `fileName` VARCHAR(255) NOT NULL,
    `appFileExists` ENUM('y','n') NOT NULL DEFAULT 'n',
    `status` VARCHAR(50) NULL DEFAULT NULL,
    PRIMARY KEY(`id`),
    INDEX `fileName` (`fileName` ASC)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- TRUNCATE `qs_SanityCheckFileRegistry`;
-- TRUNCATE `qs_SanityCheckAppFile`;
-- TRUNCATE `qs_SanityCheckUserFile`;