könnte es noch etwas mit den Sprachen zu tun haben wenn diese nicht vorhanden sind (dutch)?
Hier ist die komplette Datenbank Struktur, vieleicht fällt euch ja noch etwas auf ...
[code=php]
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Datenbank: `ispcp`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `admin`
--
CREATE TABLE `admin` (
`admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`admin_name` varchar(200) DEFAULT NULL,
`admin_pass` varchar(200) DEFAULT NULL,
`admin_type` varchar(10) DEFAULT NULL,
`domain_created` int(10) unsigned NOT NULL DEFAULT '0',
`customer_id` varchar(200) DEFAULT '0',
`created_by` int(10) unsigned DEFAULT '0',
`fname` varchar(200) DEFAULT NULL,
`lname` varchar(200) DEFAULT NULL,
`firm` varchar(200) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`state` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`fax` varchar(200) DEFAULT NULL,
`street1` varchar(200) DEFAULT NULL,
`street2` varchar(200) DEFAULT NULL,
`uniqkey` varchar(255) DEFAULT NULL,
`gender` varchar(1) DEFAULT NULL,
`uniqkey_time` timestamp NULL DEFAULT NULL,
UNIQUE KEY `admin_id` (`admin_id`),
UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=463 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `autoreplies_log`
--
CREATE TABLE `autoreplies_log` (
`time` datetime NOT NULL COMMENT 'Date and time of the sent autoreply',
`from` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'autoreply message sender',
`to` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'autoreply message recipient',
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sent autoreplies log table';
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `auto_num`
--
CREATE TABLE `auto_num` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`msg` varchar(255) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1698 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `config`
--
CREATE TABLE `config` (
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`value` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `custom_menus`
--
CREATE TABLE `custom_menus` (
`menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menu_level` varchar(10) DEFAULT NULL,
`menu_name` varchar(255) DEFAULT NULL,
`menu_link` varchar(200) DEFAULT NULL,
`menu_target` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domain`
--
CREATE TABLE `domain` (
`domain_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_name` varchar(200) DEFAULT NULL,
`domain_gid` int(10) unsigned NOT NULL DEFAULT '0',
`domain_uid` int(10) unsigned NOT NULL DEFAULT '0',
`domain_admin_id` int(10) unsigned NOT NULL DEFAULT '0',
`domain_created_id` int(10) unsigned NOT NULL DEFAULT '0',
`domain_created` int(10) unsigned NOT NULL DEFAULT '0',
`domain_expires` int(10) unsigned NOT NULL DEFAULT '0',
`domain_last_modified` int(10) unsigned NOT NULL DEFAULT '0',
`domain_mailacc_limit` int(11) DEFAULT NULL,
`domain_ftpacc_limit` int(11) DEFAULT NULL,
`domain_traffic_limit` bigint(20) DEFAULT NULL,
`domain_sqld_limit` int(11) DEFAULT NULL,
`domain_sqlu_limit` int(11) DEFAULT NULL,
`domain_status` varchar(255) DEFAULT NULL,
`domain_alias_limit` int(11) DEFAULT NULL,
`domain_subd_limit` int(11) DEFAULT NULL,
`domain_ip_id` int(10) unsigned DEFAULT NULL,
`domain_disk_limit` bigint(20) unsigned DEFAULT NULL,
`domain_disk_usage` bigint(20) unsigned DEFAULT NULL,
`domain_php` varchar(15) DEFAULT NULL,
`domain_cgi` varchar(15) DEFAULT NULL,
`allowbackup` varchar(8) NOT NULL DEFAULT 'full',
`domain_dns` varchar(15) NOT NULL DEFAULT 'no',
UNIQUE KEY `domain_id` (`domain_id`),
UNIQUE KEY `domain_name` (`domain_name`),
KEY `i_domain_admin_id` (`domain_admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domain_aliasses`
--
CREATE TABLE `domain_aliasses` (
`alias_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`alias_name` varchar(200) DEFAULT NULL,
`alias_status` varchar(255) DEFAULT NULL,
`alias_mount` varchar(200) DEFAULT NULL,
`alias_ip_id` int(10) unsigned DEFAULT NULL,
`url_forward` varchar(200) DEFAULT NULL,
PRIMARY KEY (`alias_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=314 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domain_dns`
--
CREATE TABLE `domain_dns` (
`domain_dns_id` int(11) NOT NULL AUTO_INCREMENT,
`domain_id` int(11) NOT NULL,
`alias_id` int(11) NOT NULL,
`domain_dns` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`domain_class` enum('IN','CH','HS') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'IN',
`domain_type` enum('A','AAAA','CERT','CNAME','DNAME','GPOS','KEY','KX','MX','NAPTR','NSAP','NS','NXT','PTR','PX','SIG','SRV','TXT') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A',
`domain_text` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`protected` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`domain_dns_id`),
UNIQUE KEY `domain_id` (`domain_id`,`alias_id`,`domain_dns`,`domain_class`,`domain_type`,`domain_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domain_traffic`
--
CREATE TABLE `domain_traffic` (
`dtraff_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`dtraff_time` bigint(20) unsigned DEFAULT NULL,
`dtraff_web` bigint(20) unsigned DEFAULT NULL,
`dtraff_ftp` bigint(20) unsigned DEFAULT NULL,
`dtraff_mail` bigint(20) unsigned DEFAULT NULL,
`dtraff_pop` bigint(20) unsigned DEFAULT NULL,
`zt_correction` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`dtraff_id`),
KEY `i_zt_correction` (`zt_correction`),
KEY `i_domain_traffic_domain_id` (`domain_id`),
KEY `i_domain_traffic_dtraff_time` (`dtraff_time`),
KEY `i_domain_id` (`domain_id`),
KEY `i_dtraff_time` (`dtraff_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=193992 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `email_tpls`
--
CREATE TABLE `email_tpls` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(200) DEFAULT NULL,
`subject` varchar(200) DEFAULT NULL,
`message` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `error_pages`
--
CREATE TABLE `error_pages` (
`ep_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`error_401` text NOT NULL,
`error_403` text NOT NULL,
`error_404` text NOT NULL,
`error_500` text NOT NULL,
PRIMARY KEY (`ep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ftp_group`
--
CREATE TABLE `ftp_group` (
`groupname` varchar(255) DEFAULT NULL,
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`members` text,
UNIQUE KEY `groupname` (`groupname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ftp_users`
--
CREATE TABLE `ftp_users` (
`userid` varchar(255) DEFAULT NULL,
`passwd` varchar(255) DEFAULT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`shell` varchar(255) DEFAULT NULL,
`homedir` varchar(255) DEFAULT NULL,
UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `hosting_plans`
--
CREATE TABLE `hosting_plans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`props` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`setup_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`payment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` int(10) unsigned NOT NULL DEFAULT '0',
`tos` blob NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=62 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `htaccess`
--
CREATE TABLE `htaccess` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` varchar(255) DEFAULT NULL,
`group_id` varchar(255) DEFAULT NULL,
`auth_type` varchar(255) DEFAULT NULL,
`auth_name` varchar(255) DEFAULT NULL,
`path` text,
`status` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=178 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `htaccess_groups`
--
CREATE TABLE `htaccess_groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`ugroup` varchar(255) DEFAULT NULL,
`members` text,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=415 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `htaccess_users`
--
CREATE TABLE `htaccess_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`uname` varchar(255) DEFAULT NULL,
`upass` varchar(255) DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=420 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_Dutch`
--
CREATE TABLE `lang_Dutch` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_EnglishBritain`
--
CREATE TABLE `lang_EnglishBritain` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_FrenchFrance`
--
CREATE TABLE `lang_FrenchFrance` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_GermanGermany`
--
CREATE TABLE `lang_GermanGermany` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_ItalianItaly`
--
CREATE TABLE `lang_ItalianItaly` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_Portuguese`
--
CREATE TABLE `lang_Portuguese` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_PortuguesePortugal`
--
CREATE TABLE `lang_PortuguesePortugal` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_Russian`
--
CREATE TABLE `lang_Russian` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `lang_SpanishSpain`
--
CREATE TABLE `lang_SpanishSpain` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `log`
--
CREATE TABLE `log` (
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`log_message` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `login`
--
CREATE TABLE `login` (
`session_id` varchar(200) NOT NULL DEFAULT '',
`lastaccess` int(10) unsigned DEFAULT NULL,
`ipaddr` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`login_count` tinyint(1) DEFAULT '0',
`captcha_count` tinyint(1) DEFAULT '0',
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `mail_users`
--
CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_acc` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_pass` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_forward` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`domain_id` int(10) unsigned DEFAULT NULL,
`mail_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`sub_id` int(10) unsigned DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_auto_respond` tinyint(1) NOT NULL DEFAULT '0',
`mail_auto_respond_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`quota` int(10) DEFAULT '10485760',
`mail_addr` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4277 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `orders`
--
CREATE TABLE `orders` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`plan_id` int(10) unsigned NOT NULL DEFAULT '0',
`date` int(10) unsigned NOT NULL DEFAULT '0',
`domain_name` varchar(200) DEFAULT NULL,
`customer_id` varchar(200) DEFAULT NULL,
`fname` varchar(200) DEFAULT NULL,
`lname` varchar(200) DEFAULT NULL,
`firm` varchar(200) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`state` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`fax` varchar(200) DEFAULT NULL,
`street1` varchar(200) DEFAULT NULL,
`street2` varchar(200) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`gender` varchar(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=482 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `orders_settings`
--
CREATE TABLE `orders_settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`header` text,
`footer` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `quotalimits`
--
CREATE TABLE `quotalimits` (
`name` varchar(30) NOT NULL DEFAULT '',
`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
`per_session` enum('false','true') NOT NULL DEFAULT 'false',
`limit_type` enum('soft','hard') NOT NULL DEFAULT 'soft',
`bytes_in_avail` float NOT NULL DEFAULT '0',
`bytes_out_avail` float NOT NULL DEFAULT '0',
`bytes_xfer_avail` float NOT NULL DEFAULT '0',
`files_in_avail` int(10) unsigned NOT NULL DEFAULT '0',
`files_out_avail` int(10) unsigned NOT NULL DEFAULT '0',
`files_xfer_avail` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `quotatallies`
--
CREATE TABLE `quotatallies` (
`name` varchar(30) NOT NULL DEFAULT '',
`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
`bytes_in_used` float NOT NULL DEFAULT '0',
`bytes_out_used` float NOT NULL DEFAULT '0',
`bytes_xfer_used` float NOT NULL DEFAULT '0',
`files_in_used` int(10) unsigned NOT NULL DEFAULT '0',
`files_out_used` int(10) unsigned NOT NULL DEFAULT '0',
`files_xfer_used` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `reseller_props`
--
CREATE TABLE `reseller_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
`current_dmn_cnt` int(11) DEFAULT NULL,
`max_dmn_cnt` int(11) DEFAULT NULL,
`current_sub_cnt` int(11) DEFAULT NULL,
`max_sub_cnt` int(11) DEFAULT NULL,
`current_als_cnt` int(11) DEFAULT NULL,
`max_als_cnt` int(11) DEFAULT NULL,
`current_mail_cnt` int(11) DEFAULT NULL,
`max_mail_cnt` int(11) DEFAULT NULL,
`current_ftp_cnt` int(11) DEFAULT NULL,
`max_ftp_cnt` int(11) DEFAULT NULL,
`current_sql_db_cnt` int(11) DEFAULT NULL,
`max_sql_db_cnt` int(11) DEFAULT NULL,
`current_sql_user_cnt` int(11) DEFAULT NULL,
`max_sql_user_cnt` int(11) DEFAULT NULL,
`current_disk_amnt` int(11) DEFAULT NULL,
`max_disk_amnt` int(11) DEFAULT NULL,
`current_traff_amnt` int(11) DEFAULT NULL,
`max_traff_amnt` int(11) DEFAULT NULL,
`support_system` enum('yes','no') NOT NULL DEFAULT 'yes',
`customer_id` varchar(200) DEFAULT NULL,
`reseller_ips` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `server_ips`
--
CREATE TABLE `server_ips` (
`ip_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip_number` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip_domain` varchar(200) DEFAULT NULL,
`ip_alias` varchar(200) DEFAULT NULL,
`ip_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip_ssl_domain_id` int(10) DEFAULT NULL,
`ip_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `ip_id` (`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `server_traffic`
--
CREATE TABLE `server_traffic` (
`straff_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`traff_time` bigint(20) unsigned DEFAULT NULL,
`bytes_in` bigint(20) unsigned DEFAULT NULL,
`bytes_out` bigint(20) unsigned DEFAULT NULL,
`bytes_mail_in` bigint(20) unsigned DEFAULT NULL,
`bytes_mail_out` bigint(20) unsigned DEFAULT NULL,
`bytes_pop_in` bigint(20) unsigned DEFAULT NULL,
`bytes_pop_out` bigint(20) unsigned DEFAULT NULL,
`bytes_web_in` bigint(20) unsigned DEFAULT NULL,
`bytes_web_out` bigint(20) unsigned DEFAULT NULL,
`zt_correction` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`straff_id`),
KEY `i_zt_correction` (`zt_correction`),
KEY `i_server_traffic_traff_time` (`traff_time`),
KEY `i_traff_time` (`traff_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36506 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sql_database`
--
CREATE TABLE `sql_database` (
`sqld_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT '0',
`sqld_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
UNIQUE KEY `sqld_id` (`sqld_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=874 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sql_user`
--
CREATE TABLE `sql_user` (
`sqlu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sqld_id` int(10) unsigned DEFAULT '0',
`sqlu_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
`sqlu_pass` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
UNIQUE KEY `sqlu_id` (`sqlu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=986 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `straff_settings`
--
CREATE TABLE `straff_settings` (
`straff_max` int(10) unsigned DEFAULT NULL,
`straff_warn` int(10) unsigned DEFAULT NULL,
`straff_email` int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `subdomain`
--
CREATE TABLE `subdomain` (
`subdomain_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`subdomain_name` varchar(200) DEFAULT NULL,
`subdomain_mount` varchar(200) DEFAULT NULL,
`subdomain_url_forward` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_status` varchar(255) DEFAULT NULL,
PRIMARY KEY (`subdomain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=337 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `subdomain_alias`
--
CREATE TABLE `subdomain_alias` (
`subdomain_alias_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`alias_id` int(10) unsigned DEFAULT NULL,
`subdomain_alias_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_mount` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_url_forward` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`subdomain_alias_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `suexec_props`
--
CREATE TABLE `suexec_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned DEFAULT NULL,
`gid` int(10) unsigned DEFAULT NULL,
`usr` varchar(255) DEFAULT NULL,
`grp` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `tickets`
--
CREATE TABLE `tickets` (
`ticket_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ticket_level` int(10) DEFAULT NULL,
`ticket_from` int(10) unsigned DEFAULT NULL,
`ticket_to` int(10) unsigned DEFAULT NULL,
`ticket_status` int(10) unsigned DEFAULT NULL,
`ticket_reply` int(10) unsigned DEFAULT NULL,
`ticket_urgency` int(10) unsigned DEFAULT NULL,
`ticket_date` int(10) unsigned DEFAULT NULL,
`ticket_subject` varchar(255) DEFAULT NULL,
`ticket_message` text,
PRIMARY KEY (`ticket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `user_gui_props`
--
CREATE TABLE `user_gui_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`lang` varchar(255) DEFAULT '',
`layout` varchar(255) DEFAULT '',
`logo` varchar(255) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=528 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[/php]