| | |
| | | `destination` text, |
| | | `type` enum('alias','aliasdomain','forward','catchall') NOT NULL default 'alias', |
| | | `active` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `greylisting` enum('n','y' ) NOT NULL DEFAULT 'n', |
| | | PRIMARY KEY (`forwarding_id`), |
| | | KEY `server_id` (`server_id`,`source`), |
| | | KEY `type` (`type`) |
| | |
| | | `move_junk` enum('n','y') NOT NULL default 'n', |
| | | `custom_mailfilter` mediumtext, |
| | | `postfix` enum('n','y') NOT NULL default 'y', |
| | | `greylisting` enum('n','y' ) NOT NULL DEFAULT 'n', |
| | | `access` enum('n','y') NOT NULL default 'y', |
| | | `disableimap` enum('n','y') NOT NULL default 'n', |
| | | `disablepop3` enum('n','y') NOT NULL default 'n', |
| | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `server_ip_map` |
| | | -- |
| | | |
| | | CREATE TABLE `server_ip_map` ( |
| | | `server_ip_map_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| | | `sys_userid` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `sys_perm_user` varchar(5) DEFAULT NULL, |
| | | `sys_perm_group` varchar(5) DEFAULT NULL, |
| | | `sys_perm_other` varchar(5) DEFAULT NULL, |
| | | `server_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `source_ip` varchar(15) DEFAULT NULL, |
| | | `destination_ip` varchar(35) DEFAULT '', |
| | | `active` enum('n','y') NOT NULL DEFAULT 'y', |
| | | PRIMARY KEY (`server_ip_map_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `server_php` |
| | |
| | | `redirect_type` varchar(255) default NULL, |
| | | `redirect_path` varchar(255) default NULL, |
| | | `seo_redirect` varchar(255) default NULL, |
| | | `rewrite_to_https` ENUM('y','n') NOT NULL DEFAULT 'n', |
| | | `ssl` enum('n','y') NOT NULL default 'n', |
| | | `ssl_state` varchar(255) NULL, |
| | | `ssl_locality` varchar(255) NULL, |
| | |
| | | `added_date` date NOT NULL DEFAULT '0000-00-00', |
| | | `added_by` varchar(255) DEFAULT NULL, |
| | | `directive_snippets_id` int(11) unsigned NOT NULL default '0', |
| | | `enable_pagespeed` ENUM('y','n') NULL DEFAULT 'n', |
| | | `enable_pagespeed` ENUM('y','n') NOT NULL DEFAULT 'n', |
| | | `http_port` int(11) unsigned NOT NULL DEFAULT '80', |
| | | `https_port` int(11) unsigned NOT NULL DEFAULT '443', |
| | | PRIMARY KEY (`domain_id`), |