| | |
| | | `limit_traffic_quota` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_client` int(11) NOT NULL DEFAULT '0', |
| | | `limit_mailmailinglist` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_openvz_vm` int(11) NOT NULL DEFAULT '0', |
| | | `limit_openvz_vm_template` int(11) NOT NULL DEFAULT '0', |
| | | `parent_client_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `username` varchar(64) DEFAULT NULL, |
| | | `password` varchar(64) DEFAULT NULL, |
| | |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `parent_domain_id` int(11) unsigned NOT NULL default '0', |
| | | `type` enum('url','chrooted','full') NOT NULL default 'url', |
| | | `command` varchar(255) NOT NULL, |
| | | `command` TEXT NOT NULL, |
| | | `run_min` varchar(100) NULL, |
| | | `run_hour` varchar(100) NULL, |
| | | `run_mday` varchar(100) NULL, |
| | |
| | | `disablepop3` enum('n','y') NOT NULL default 'n', |
| | | `disabledeliver` enum('n','y') NOT NULL default 'n', |
| | | `disablesmtp` enum('n','y') NOT NULL default 'n', |
| | | `disablesieve` enum('n','y') NOT NULL default 'n', |
| | | `disablelda` enum('n','y') NOT NULL default 'n', |
| | | PRIMARY KEY (`mailuser_id`), |
| | | KEY `server_id` (`server_id`,`email`), |
| | | KEY `email_access` (`email`,`access`) |
| | |
| | | `sys_perm_group` varchar(5) default NULL, |
| | | `sys_perm_other` varchar(5) default NULL, |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `client_id` int(11) unsigned NOT NULL default '0', |
| | | `ip_type` enum( 'IPv4', 'IPv6' ) NOT NULL DEFAULT 'IPv4', |
| | | `ip_address` varchar(39) default NULL, |
| | | `virtualhost` enum('n','y') NOT NULL default 'y', |
| | | `virtualhost_port` varchar(255) default '80,443', |
| | | PRIMARY KEY (`server_ip_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |