ALTER TABLE `qs_zz_Page` ADD `system` ENUM( 'n', 'y' ) NOT NULL AFTER `final` ;
ALTER TABLE `qs_zz_Page` ADD INDEX ( `system` ) ;
ALTER TABLE `qs_zz_DraftPage` ADD `system` ENUM( 'n', 'y' ) NOT NULL AFTER `final` ;
ALTER TABLE `qs_zz_DraftPage` ADD INDEX ( `system` ) ;

ALTER TABLE `qs_zz_PageItem` ADD `allowDelete` ENUM( 'y', 'n' ) NOT NULL AFTER `title` ;
ALTER TABLE `qs_zz_DraftPageItem` ADD `allowDelete` ENUM( 'y', 'n' ) NOT NULL AFTER `title` ;

CREATE TABLE `qs_zz_PageItemOption` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `idItem` INT NOT NULL ,
    `name` VARCHAR( 255 ) NOT NULL ,
    `value` TEXT NOT NULL ,
    INDEX ( `idItem` ) 
) ENGINE = MYISAM;

CREATE TABLE `qs_zz_DraftPageItemOption` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `idItem` INT NOT NULL ,
    `name` VARCHAR( 255 ) NOT NULL ,
    `value` TEXT NOT NULL ,
    INDEX ( `idItem` ) 
) ENGINE = MYISAM;

ALTER TABLE `qs_zz_Page` ADD `isIndexing` ENUM( 'y', 'n' ) NOT NULL DEFAULT 'y' AFTER `isSecure` ;
ALTER TABLE `qs_zz_DraftPage` ADD `isIndexing` ENUM( 'y', 'n' ) NOT NULL DEFAULT 'y' AFTER `isSecure` ;

ALTER TABLE `qs_zz_PageContent` ADD `menuTitle` VARCHAR( 255 ) NOT NULL AFTER `title` ;
ALTER TABLE `qs_zz_DraftPageContent` ADD `menuTitle` VARCHAR( 255 ) NOT NULL AFTER `title` ;