CREATE TABLE IF NOT EXISTS `qs_zz_DPageOption` (
  `name` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `show` enum('n','y') NOT NULL,
  `value` enum('n','y') NOT NULL,
  `sorter` int(11) NOT NULL,
  PRIMARY KEY  (`name`),
  KEY `name` (`name`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `qs_zz_DPageOption` (`name`, `title`, `show`, `value`, `sorter`) VALUES
('showInSiteMap', 'Show in Sitemap', 'y', 'n', 1),
('showInMenu', 'Show in Menu', 'y', 'n', 2),
('allowDelete', 'Allow delete', 'n', 'n', 3),
('isSecure', 'Secure page', 'n', 'n', 4),
('isIndexing', 'Include this page in search results', 'y', 'n', 5),
('final', 'Final page', 'n', 'n', 6),
('system', 'System (hidden in admin end)', 'n', 'n', 7),
('redirect', 'Redirect', 'n', 'n', 8),
('allowSubpages', 'Allow Subpages', 'n', 'y', 9),
('isAdditional', 'Is Additional', 'n', 'n', 10);

CREATE TABLE IF NOT EXISTS `qs_zz_DraftPageOption` (
  `id` int(11) NOT NULL auto_increment,
  `idPage` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `show` enum('n','y') NOT NULL,
  `value` enum('n','y') NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idPage` (`idPage`,`name`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `qs_zz_PageOption` (
  `id` int(11) NOT NULL auto_increment,
  `idPage` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `show` enum('n','y') NOT NULL,
  `value` enum('n','y') NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idPage` (`idPage`,`name`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


