| | |
| | | `default_dnsserver` int(10) unsigned NOT NULL default '1', |
| | | `limit_dns_zone` int(11) NOT NULL default '-1', |
| | | `limit_dns_record` int(11) NOT NULL default '-1', |
| | | `default_dbserver` int(10) unsigned NOT NULL default '1', |
| | | `limit_database` int(11) NOT NULL default '-1', |
| | | `limit_client` int(11) NOT NULL default '0', |
| | | `parent_client_id` int(10) unsigned NOT NULL default '0', |
| | | `username` varchar(255) default NULL, |
| | |
| | | UNIQUE KEY `origin` (`origin`), |
| | | KEY `active` (`active`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `firewall` |
| | | -- |
| | | |
| | | CREATE TABLE `firewall` ( |
| | | `firewall_id` bigint(20) NOT NULL auto_increment, |
| | | `sys_userid` int(11) NOT NULL default '0', |
| | | `sys_groupid` int(11) 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) NOT NULL default '0', |
| | | `tcp_port` varchar(255) default NULL, |
| | | `udp_port` varchar(255) default NULL, |
| | | `active` varchar(255) NOT NULL default 'y', |
| | | PRIMARY KEY (`firewall_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `firewall` |
| | | |
| | | |
| | | |
| | |
| | | `domain` varchar(255) NOT NULL default '', |
| | | `active` enum('y','n') NOT NULL, |
| | | PRIMARY KEY (`domain_id`), |
| | | KEY `server_id` (`server_id`,`domain`) |
| | | KEY `server_id` (`server_id`,`domain`), |
| | | KEY `domain_active` (`domain`,`active`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- |
| | |
| | | `custom_mailfilter` text, |
| | | `postfix` enum('y','n') NOT NULL, |
| | | `access` enum('y','n') NOT NULL, |
| | | `disableimap` enum('0','1') NOT NULL default '0', |
| | | `disablepop3` enum('0','1') NOT NULL default '0', |
| | | PRIMARY KEY (`mailuser_id`), |
| | | KEY `server_id` (`server_id`,`email`) |
| | | KEY `server_id` (`server_id`,`email`), |
| | | KEY `email_access` (`email`,`access`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- |
| | |
| | | -- Daten für Tabelle `web_domain` |
| | | -- |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Tabellenstruktur für Tabelle `web_database` |
| | | -- |
| | | |
| | | CREATE TABLE `web_database` ( |
| | | `database_id` bigint(20) NOT NULL auto_increment, |
| | | `sys_userid` int(11) NOT NULL default '0', |
| | | `sys_groupid` int(11) 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) NOT NULL default '0', |
| | | `type` varchar(255) NOT NULL default 'y', |
| | | `database_name` varchar(255) default NULL, |
| | | `database_user` varchar(255) default NULL, |
| | | `database_password` varchar(255) default NULL, |
| | | `remote_access` varchar(255) NOT NULL default 'y', |
| | | `active` varchar(255) NOT NULL default 'y', |
| | | PRIMARY KEY (`database_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | | |
| | | -- |
| | | -- Daten für Tabelle `web_database` |
| | | -- |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table for attempts login |
| | | -- |