1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `protected_dirs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `non_ssl` enum('false','true') NOT NULL DEFAULT 'false',
  `ssl` enum('false','true') NOT NULL DEFAULT 'false',
  `cgi_bin` enum('false','true') NOT NULL DEFAULT 'false',
  `realm` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `path` varchar(245) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `dom_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dom_id` (`dom_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `protected_dirs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `non_ssl` enum('false','true') NOT NULL DEFAULT 'false', `ssl` enum('false','true') NOT NULL DEFAULT 'false', `cgi_bin` enum('false','true') NOT NULL DEFAULT 'false', `realm` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `path` varchar(245) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `dom_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `dom_id` (`dom_id`,`path`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1