| | |
| | | `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', |
| | | `limit_client` int(11) NOT NULL default '0', |
| | | `parent_client_id` int(10) unsigned NOT NULL default '0', |
| | | `username` varchar(255) default NULL, |
| | | `password` varchar(255) default NULL, |
| | | `language` varchar(255) NOT NULL default 'en', |
| | |
| | | `redirect_type` varchar(255) default NULL, |
| | | `redirect_path` varchar(255) default NULL, |
| | | `ssl` enum('n','y') NOT NULL default 'n', |
| | | `ssl_state` varchar(255) NOT NULL, |
| | | `ssl_locality` varchar(255) NOT NULL, |
| | | `ssl_organisation` varchar(255) NOT NULL, |
| | | `ssl_organisation_unit` varchar(255) NOT NULL, |
| | | `ssl_country` varchar(255) NOT NULL, |
| | | `ssl_request` mediumtext NOT NULL, |
| | | `ssl_cert` mediumtext NOT NULL, |
| | | `ssl_bundle` mediumtext NOT NULL, |
| | | `ssl_action` varchar(10) NOT NULL, |
| | | `ssl_state` varchar(255) NULL, |
| | | `ssl_locality` varchar(255) NULL, |
| | | `ssl_organisation` varchar(255) NULL, |
| | | `ssl_organisation_unit` varchar(255) NULL, |
| | | `ssl_country` varchar(255) NULL, |
| | | `ssl_request` mediumtext NULL, |
| | | `ssl_cert` mediumtext NULL, |
| | | `ssl_bundle` mediumtext NULL, |
| | | `ssl_action` varchar(10) NULL, |
| | | `active` varchar(255) NOT NULL default 'y', |
| | | PRIMARY KEY (`domain_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
| | |
| | | -- |
| | | -- Daten für Tabelle `web_domain` |
| | | -- |
| | | |
| | | -- |
| | | -- Table for attempts login |
| | | -- |
| | | |
| | | CREATE TABLE `attempts_login` ( |
| | | `ip` varchar(12) NOT NULL, |
| | | `times` tinyint(1) NOT NULL default '1', |
| | | `login_time` timestamp NOT NULL default '0000-00-00 00:00:00' |
| | | ); |