tsaenger
Junior Member
Posts: 69
Joined: Dec 2007
Reputation: 0
|
RE: migrieren von confixx auf ispCP
Hi
anbei die Struktur der DB:
Quote:-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 26. Dezember 2007 um 11:34
-- Server Version: 4.0.24
-- PHP-Version: 4.3.10-22
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Datenbank: `confixx`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `admin`
--
CREATE TABLE `admin` (
`passwort` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`emailbetreff` varchar(255) NOT NULL default '',
`emailtext` blob NOT NULL,
`emailadresse` varchar(255) NOT NULL default '',
`emailname` varchar(255) NOT NULL default '',
`mysqlshelluser` varchar(25) NOT NULL default '',
`mysqlshellpasswort` varchar(25) NOT NULL default '',
`mysqlshellhost` varchar(255) NOT NULL default '',
`pop` tinyint(4) NOT NULL default '0',
`email` tinyint(4) NOT NULL default '0',
`ftp` tinyint(4) NOT NULL default '0',
`subdomains` tinyint(4) NOT NULL default '0',
`mysql` tinyint(4) NOT NULL default '0',
`php` tinyint(4) NOT NULL default '1',
`perl` tinyint(4) NOT NULL default '0',
`ssi` tinyint(4) NOT NULL default '0',
`cssl` tinyint(4) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '0',
`shell` tinyint(4) NOT NULL default '0',
`statistik` tinyint(4) NOT NULL default '0',
`pwschutz` tinyint(4) NOT NULL default '0',
`fehlerseiten` tinyint(4) NOT NULL default '0',
`webftp` tinyint(4) NOT NULL default '0',
`webmail` tinyint(4) NOT NULL default '0',
`phpmyadmin` tinyint(4) NOT NULL default '0',
`phpmyadminpfad` varchar(255) NOT NULL default '',
`lokaleips` blob NOT NULL,
`minuid` mediumint(9) NOT NULL default '2000',
`maxuid` mediumint(9) NOT NULL default '1999',
`quota` tinyint(4) NOT NULL default '0',
`ftpmaxkb` int(11) NOT NULL default '5120',
`popmaxkb` int(11) NOT NULL default '5120',
`standardip` varchar(15) NOT NULL default '',
`neukundenreload` tinyint(4) NOT NULL default '0',
`indexcode` blob,
`indexfile` varchar(30) default NULL,
`mysqlshelluid` mediumint(9) NOT NULL default '0',
`mysqlshellpasswortcrypt` varchar(25) NOT NULL default '',
`mysqlshelllongpwcrypt` varchar(255) NOT NULL default '',
`autoresponder` tinyint(4) NOT NULL default '0',
`stdcgi` tinyint(4) NOT NULL default '0',
`stddomain` tinyint(4) NOT NULL default '1',
`flock` int(11) NOT NULL default '0',
`standarddomain` varchar(255) NOT NULL default '',
`language` char(2) NOT NULL default 'de',
`lastchange` int(14) NOT NULL default '0',
`httpdspezial` blob NOT NULL,
`asp` tinyint(4) NOT NULL default '0',
`wap` tinyint(4) NOT NULL default '0',
`dirlist` tinyint(4) NOT NULL default '0',
`login` varchar(255) NOT NULL default '',
`ispemail` varchar(255) NOT NULL default '',
`ispservername` varchar(255) NOT NULL default '',
`isplastrun` varchar(255) NOT NULL default '',
`httpdlogin` blob NOT NULL,
`phpupload` tinyint(4) NOT NULL default '0',
`dns` tinyint(4) NOT NULL default '0',
`ip_pns` varchar(255) NOT NULL default '',
`ip_sns` varchar(255) NOT NULL default '',
`dnstemplate` blob NOT NULL,
`dnr` tinyint(4) NOT NULL default '0',
`userprefix` varchar(16) NOT NULL default '',
`cronjobs` tinyint(4) NOT NULL default '0',
`checkupdates` tinyint(4) NOT NULL default '0',
`spamfilter` tinyint(4) NOT NULL default '0',
`hostname` varchar(255) NOT NULL default '',
`oldskins` tinyint(4) NOT NULL default '1',
`business` tinyint(4) NOT NULL default '0',
`postconf` tinyint(4) NOT NULL default '0',
`idn` tinyint(4) NOT NULL default '0',
`majordomoml` varchar(255) NOT NULL default '',
`majordomohome` varchar(255) NOT NULL default '',
`majordomo` tinyint(4) NOT NULL default '0',
`imap_options` varchar(50) NOT NULL default '',
`modpython` tinyint(4) NOT NULL default '0',
`scponly` tinyint(4) NOT NULL default '0',
`coldfusion` tinyint(4) NOT NULL default '0',
`awstats` tinyint(4) NOT NULL default '0',
`popmaxkbhard` int(11) NOT NULL default '10360',
`personalinfoid` int(10) unsigned NOT NULL default '0',
`backup` tinyint(4) NOT NULL default '2',
`treemenu` tinyint(4) NOT NULL default '0',
`confixx_ip` varchar(16) NOT NULL default '',
`confixx_domain` varchar(255) NOT NULL default '',
`nextrun` int(15) NOT NULL default '0',
`list_size` int(11) NOT NULL default '10',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`master` tinyint(4) NOT NULL default '0',
`webapp` tinyint(4) NOT NULL default '0',
`shareddomains` tinyint(4) NOT NULL default '0',
`httpd_options` tinyint(4) NOT NULL default '0',
`httpdspecialflag` tinyint(4) NOT NULL default '1'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `alerts`
--
CREATE TABLE `alerts` (
`id` int(11) NOT NULL auto_increment,
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`prefix` varchar(8) NOT NULL default '',
`activ` tinyint(4) NOT NULL default '1',
`send` tinyint(4) NOT NULL default '1',
`activ_date` date default NULL,
`deactiv_date` date default NULL,
`sendcc` varchar(255) NOT NULL default '',
`sendfrom` varchar(255) NOT NULL default '',
`sendto` varchar(255) NOT NULL default '',
`sendsubject` varchar(255) NOT NULL default '',
`sendmessage` text,
`traffic` int(11) default NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `allgemein`
--
CREATE TABLE `allgemein` (
`quota` tinyint(4) NOT NULL default '0',
`domains` tinyint(4) NOT NULL default '0',
`newips` tinyint(4) NOT NULL default '1',
`frontpage` tinyint(4) NOT NULL default '0',
`perl` tinyint(4) NOT NULL default '0',
`webalizer` tinyint(4) NOT NULL default '0',
`lokaleips` tinyint(4) NOT NULL default '0',
`deluser` tinyint(4) NOT NULL default '0',
`delpop` tinyint(4) NOT NULL default '0',
`delftp` tinyint(4) NOT NULL default '0',
`adduser` tinyint(4) NOT NULL default '0',
`addpop` tinyint(4) NOT NULL default '0',
`addftp` tinyint(4) NOT NULL default '0',
`htaccess` tinyint(4) NOT NULL default '0',
`newpwd` tinyint(4) NOT NULL default '0',
`aliases` tinyint(4) NOT NULL default '0',
`aliaseslr` int(15) NOT NULL default '0',
`aliasesupdate` int(11) NOT NULL default '1',
`httpd` tinyint(4) NOT NULL default '0',
`httpdlr` int(15) NOT NULL default '1',
`httpdupdate` int(11) NOT NULL default '0',
`speicherlr` int(15) NOT NULL default '1',
`speicherupdate` int(11) NOT NULL default '1',
`ftptraffiklr` int(15) NOT NULL default '1',
`ftptraffikupdate` int(11) NOT NULL default '0',
`httpdtraffikupdate` int(11) NOT NULL default '0',
`httpdtraffiklr` int(15) NOT NULL default '1',
`lastrun` int(15) NOT NULL default '0',
`frontpageadd` tinyint(4) NOT NULL default '0',
`frontpagedel` tinyint(4) NOT NULL default '0',
`frontpagepw` tinyint(4) NOT NULL default '0',
`fpaliasadd` tinyint(4) NOT NULL default '0',
`fpaliasdel` tinyint(4) NOT NULL default '0',
`confixxupdate` int(11) NOT NULL default '0',
`newsletter` tinyint(4) NOT NULL default '0',
`webalizerpw` tinyint(4) NOT NULL default '0',
`frontpageemail` tinyint(4) NOT NULL default '0',
`stdcgi` tinyint(4) NOT NULL default '0',
`cssl` tinyint(4) NOT NULL default '0',
`dns` tinyint(4) NOT NULL default '0',
`spamupdate` tinyint(4) NOT NULL default '0',
`checknewversion` int(11) NOT NULL default '12',
`cronupdate` tinyint(4) NOT NULL default '0',
`modpython` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `anbieter`
--
CREATE TABLE `anbieter` (
`anbieter` varchar(8) NOT NULL default '',
`passwort` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`maxkunden` smallint(6) NOT NULL default '0',
`maxkundenlimit` tinyint(4) NOT NULL default '0',
`maxpop` smallint(6) NOT NULL default '0',
`maxpoplimit` tinyint(4) NOT NULL default '0',
`maxkb` int(11) NOT NULL default '0',
`maxkblimit` tinyint(4) NOT NULL default '0',
`maxmysql` smallint(6) NOT NULL default '0',
`maxmysqllimit` tinyint(4) NOT NULL default '0',
`maxemail` mediumint(9) NOT NULL default '0',
`maxemaillimit` tinyint(4) NOT NULL default '0',
`maxftp` mediumint(9) NOT NULL default '0',
`maxftplimit` tinyint(4) NOT NULL default '0',
`maxtransfer` int(11) NOT NULL default '0',
`maxsubdomains` mediumint(9) NOT NULL default '0',
`maxsubdomainslimit` tinyint(4) NOT NULL default '0',
`maxwildcards` mediumint(9) NOT NULL default '0',
`php` tinyint(4) NOT NULL default '0',
`perl` tinyint(4) NOT NULL default '0',
`ssi` tinyint(4) NOT NULL default '0',
`cssl` tinyint(4) NOT NULL default '0',
`shell` tinyint(4) NOT NULL default '0',
`statistik` tinyint(4) NOT NULL default '0',
`pwschutz` tinyint(4) NOT NULL default '0',
`fehlerseiten` tinyint(4) NOT NULL default '0',
`webftp` tinyint(4) NOT NULL default '0',
`webmail` tinyint(4) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '0',
`anmeldedatum` int(14) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`firma` varchar(255) NOT NULL default '',
`anschrift` varchar(255) NOT NULL default '',
`plzort` varchar(255) NOT NULL default '',
`telefon` varchar(255) NOT NULL default '',
`fax` varchar(255) NOT NULL default '',
`emailadresse` varchar(255) NOT NULL default '',
`kundennummer` varchar(255) NOT NULL default '',
`freifeldname1` varchar(255) NOT NULL default '',
`freifeldwert1` varchar(255) NOT NULL default '',
`freifeldname2` varchar(255) NOT NULL default '',
`freifeldwert2` varchar(255) NOT NULL default '',
`freifeldname3` varchar(255) NOT NULL default '',
`freifeldwert3` varchar(255) NOT NULL default '',
`personendatenangeben` tinyint(4) NOT NULL default '0',
`kundendatenanzeigen` tinyint(4) NOT NULL default '0',
`kundendatenbeikundenanzeigen` tinyint(4) NOT NULL default '0',
`emailbetreff` varchar(255) NOT NULL default '',
`emailtext` blob NOT NULL,
`emailemailadresse` varchar(255) NOT NULL default '',
`emailname` varchar(255) NOT NULL default '',
`number` int(11) NOT NULL default '0',
`indexcode` blob,
`indexfile` varchar(30) default NULL,
`emailbcc` varchar(255) NOT NULL default '',
`hilfecode` blob,
`stdcgi` tinyint(4) NOT NULL default '0',
`maxautoresponder` mediumint(9) NOT NULL default '0',
`maxautoresponderlimit` tinyint(4) NOT NULL default '0',
`ftp` tinyint(4) NOT NULL default '0',
`gesperrt` tinyint(4) NOT NULL default '0',
`maxdomains` mediumint(9) NOT NULL default '-1',
`maxdomainslimit` tinyint(4) NOT NULL default '0',
`standardip` varchar(15) NOT NULL default '',
`httpdspezial` blob NOT NULL,
`language` char(2) NOT NULL default 'de',
`lastchange` int(14) NOT NULL default '0',
`ispemail` varchar(255) NOT NULL default '',
`ispservername` varchar(255) NOT NULL default '',
`isplastrun` varchar(255) NOT NULL default '',
`asp` tinyint(4) NOT NULL default '0',
`wap` tinyint(4) NOT NULL default '0',
`dirlist` tinyint(4) NOT NULL default '0',
`logcopy` tinyint(4) NOT NULL default '0',
`phpupload` tinyint(4) NOT NULL default '0',
`dbext` tinyint(4) NOT NULL default '0',
`dns` tinyint(4) NOT NULL default '0',
`pns` varchar(255) NOT NULL default '',
`sns` varchar(255) NOT NULL default '',
`dnsspezial` blob NOT NULL,
`dnr` tinyint(4) NOT NULL default '0',
`gender` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`plz` varchar(255) NOT NULL default '',
`land` varchar(255) NOT NULL default '',
`spamfilter` tinyint(4) NOT NULL default '0',
`maxidnlimit` tinyint(4) NOT NULL default '0',
`custom_skins` tinyint(4) NOT NULL default '1',
`maxcronjobslimit` tinyint(4) NOT NULL default '0',
`maxmaillist` int(11) NOT NULL default '0',
`maxwildcardslimit` tinyint(4) NOT NULL default '0',
`maxcronjobs` mediumint(9) NOT NULL default '0',
`maxidn` int(11) NOT NULL default '0',
`maxmaillistlimit` tinyint(4) NOT NULL default '0',
`maxatdomainslimit` tinyint(4) NOT NULL default '0',
`modpython` tinyint(4) NOT NULL default '0',
`scponly` tinyint(4) NOT NULL default '0',
`maxatdomains` mediumint(9) NOT NULL default '0',
`coldfusion` tinyint(4) NOT NULL default '0',
`popmaxkb` int(11) NOT NULL default '0',
`popmaxkblimit` tinyint(4) NOT NULL default '0',
`awstats` tinyint(4) NOT NULL default '0',
`list_size` int(11) NOT NULL default '10',
`backup` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`maxwebapp` int(11) NOT NULL default '0',
`maxwebapplimit` tinyint(4) NOT NULL default '0',
`maxshareddomains` mediumint(9) NOT NULL default '0',
`maxshareddomainslimit` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`anbieter`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `angebote`
--
CREATE TABLE `angebote` (
`ident` smallint(6) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`maxpop` smallint(6) NOT NULL default '0',
`maxkb` int(11) NOT NULL default '0',
`maxmysql` smallint(6) NOT NULL default '0',
`maxemail` smallint(6) NOT NULL default '0',
`maxftp` smallint(6) NOT NULL default '0',
`maxtransfer` int(11) NOT NULL default '0',
`maxsubdomains` smallint(6) NOT NULL default '0',
`php` tinyint(4) NOT NULL default '0',
`wildcard` smallint(6) NOT NULL default '0',
`perl` tinyint(4) NOT NULL default '0',
`ssi` tinyint(4) NOT NULL default '0',
`shell` tinyint(4) NOT NULL default '0',
`statistik` tinyint(4) NOT NULL default '0',
`pwschutz` tinyint(4) NOT NULL default '0',
`fehlerseiten` tinyint(4) NOT NULL default '0',
`webftp` tinyint(4) NOT NULL default '0',
`webmail` tinyint(4) NOT NULL default '0',
`emailbetreff` varchar(255) NOT NULL default '',
`emailtext` blob NOT NULL,
`emailemailadresse` varchar(255) NOT NULL default '',
`emailname` varchar(255) NOT NULL default '',
`emailbcc` varchar(255) NOT NULL default '',
`stdcgi` tinyint(4) NOT NULL default '0',
`maxautoresponder` smallint(6) NOT NULL default '0',
`ftp` tinyint(4) NOT NULL default '0',
`wap` tinyint(4) NOT NULL default '0',
`phpupload` tinyint(4) NOT NULL default '0',
`dirlist` tinyint(4) NOT NULL default '0',
`asp` tinyint(4) NOT NULL default '0',
`spamfilter` tinyint(4) NOT NULL default '0',
`maxmaillist` int(11) NOT NULL default '0',
`maxcronjobs` smallint(6) NOT NULL default '0',
`maxidn` int(11) NOT NULL default '0',
`modpython` tinyint(4) NOT NULL default '0',
`scponly` tinyint(4) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '0',
`maxatdomains` smallint(6) NOT NULL default '0',
`coldfusion` tinyint(4) NOT NULL default '0',
`popmaxkb` int(11) NOT NULL default '0',
`awstats` tinyint(4) NOT NULL default '0',
`backup` tinyint(4) NOT NULL default '1',
`cssl` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`maxwebapp` int(11) NOT NULL default '0',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `atdomains`
--
CREATE TABLE `atdomains` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`id_from` int(10) unsigned default NULL,
`todomain` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
UNIQUE KEY `name` (`name`,`id_from`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `autoresponder`
--
CREATE TABLE `autoresponder` (
`ident` int(11) NOT NULL default '0',
`negvon` tinyint(4) NOT NULL default '0',
`von` varchar(255) NOT NULL default '',
`link` tinyint(4) NOT NULL default '0',
`negrcpt` tinyint(4) NOT NULL default '0',
`rcpt` varchar(255) NOT NULL default '',
`absenderemail` varchar(255) NOT NULL default '',
`absendername` varchar(255) NOT NULL default '',
`emailbetreff` varchar(255) NOT NULL default '',
`emailtext` blob NOT NULL,
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `backup`
--
CREATE TABLE `backup` (
`id` int(11) NOT NULL auto_increment,
`kunde` varchar(16) NOT NULL default '',
`src` varchar(16) NOT NULL default '',
`dst` varchar(255) NOT NULL default '',
`paswd` varchar(16) NOT NULL default '',
`ttl` tinyint(4) NOT NULL default '2',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bdefault`
--
CREATE TABLE `bdefault` (
`defaultserver` int(11) default NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `billing_del`
--
CREATE TABLE `billing_del` (
`date` int(14) NOT NULL default '0',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`item` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `billing_exp`
--
CREATE TABLE `billing_exp` (
`start` int(14) NOT NULL default '0',
`anbieter` varchar(8) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`modul` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bin`
--
CREATE TABLE `bin` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`grp` varchar(32) NOT NULL default '',
`path` varchar(255) default NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
UNIQUE KEY `name` (`name`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bmysql`
--
CREATE TABLE `bmysql` (
`KeyServer` int(11) unsigned NOT NULL auto_increment,
`Servername` varchar(64) default NULL,
`ip` varchar(64) default NULL,
`cuser` varchar(64) default NULL,
`cpassword` varchar(64) default NULL,
`port` int(11) default NULL,
`dbname` varchar(64) default NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`KeyServer`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `config`
--
CREATE TABLE `config` (
`name` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`name`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `cronjobs`
--
CREATE TABLE `cronjobs` (
`kunde` varchar(16) NOT NULL default '',
`cronfile` blob NOT NULL,
`lastchange` int(10) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`kunde`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `cssl`
--
CREATE TABLE `cssl` (
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`privatekey` blob NOT NULL,
`crt` blob NOT NULL,
`csr` blob NOT NULL,
`neu` tinyint(4) NOT NULL default '0',
`loeschen` tinyint(4) NOT NULL default '0',
`aendern` tinyint(4) NOT NULL default '0',
`countrycode` varchar(4) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`firm` varchar(255) NOT NULL default '',
`unit` varchar(255) NOT NULL default '',
`common` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`challenge` varchar(255) NOT NULL default '',
`optional` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`ca` blob NOT NULL,
PRIMARY KEY (`kunde`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `custom_skins`
--
CREATE TABLE `custom_skins` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`show_name` varchar(255) NOT NULL default '',
`owner_type` enum('preinstalled','admin','reseller','user') NOT NULL default 'preinstalled',
`anbieter` varchar(8) NOT NULL default '',
`version` varchar(255) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `delaccs`
--
CREATE TABLE `delaccs` (
`account` varchar(255) NOT NULL default '',
`type` varchar(8) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`pfad` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `dns`
--
CREATE TABLE `dns` (
`domain` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`zonefile` blob NOT NULL,
`lastchange` int(10) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`domain`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domainlog`
--
CREATE TABLE `domainlog` (
`domain` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`loeschen` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `domains`
--
CREATE TABLE `domains` (
`domain` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`pfad` varchar(255) NOT NULL default '',
`richtigedomain` tinyint(4) NOT NULL default '0',
`cssl` tinyint(4) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '0',
`zusatz` blob NOT NULL,
`lastchange` int(14) NOT NULL default '0',
`dns` tinyint(4) NOT NULL default '0',
`dnr` tinyint(4) NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`grp` int(10) NOT NULL default '0',
`httpd` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`catch` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `email`
--
CREATE TABLE `email` (
`ident` int(11) NOT NULL auto_increment,
`prefix` varchar(65) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`neu` tinyint(4) NOT NULL default '1',
`lastchange` int(14) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `email_forward`
--
CREATE TABLE `email_forward` (
`id` int(11) NOT NULL auto_increment,
`email_ident` int(11) NOT NULL default '0',
`pop3` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ereignisse`
--
CREATE TABLE `ereignisse` (
`ident` int(11) NOT NULL auto_increment,
`timestamp` int(11) NOT NULL default '0',
`nachricht` varchar(255) NOT NULL default '',
`script` varchar(255) NOT NULL default '',
`code` tinyint(4) NOT NULL default '0',
`anbieter` varchar(8) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`geloescht` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `events`
--
CREATE TABLE `events` (
`id` int(11) NOT NULL auto_increment,
`object_type` int(11) NOT NULL default '0',
`object_id` int(11) default NULL,
`object_prop` varchar(32) NOT NULL default '',
`event_type` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '1',
`event` int(11) NOT NULL default '0',
`event_prop` varchar(16) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`data` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `fehlermeldungen`
--
CREATE TABLE `fehlermeldungen` (
`ident` int(11) NOT NULL auto_increment,
`pfad` varchar(255) NOT NULL default '',
`fehlertyp` int(11) NOT NULL default '0',
`seite` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `frontpage`
--
CREATE TABLE `frontpage` (
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`passwort` varchar(12) NOT NULL default '',
`pw` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '1',
`loeschen` tinyint(4) NOT NULL default '0',
`domain` varchar(255) NOT NULL default '',
`benutzer` varchar(16) NOT NULL default '',
`email` tinyint(4) NOT NULL default '0',
`emailadresse` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `frontpagealias`
--
CREATE TABLE `frontpagealias` (
`domain` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`port` smallint(6) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`loeschen` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ftp`
--
CREATE TABLE `ftp` (
`account` varchar(16) NOT NULL default '',
`uid` mediumint(9) NOT NULL default '0',
`passwort` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`pfad` varchar(255) NOT NULL default '',
`gesperrt` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '1',
`pw` tinyint(4) NOT NULL default '0',
`number` int(11) NOT NULL default '0',
`quota` tinyint(4) NOT NULL default '0',
`maxkb` int(11) NOT NULL default '0',
`lastchange` int(14) NOT NULL default '0',
`language` char(2) NOT NULL default 'de',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`account`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `grep`
--
CREATE TABLE `grep` (
`kunde` varchar(16) NOT NULL default '',
`type` varchar(8) NOT NULL default '',
`pattern` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `htaccess`
--
CREATE TABLE `htaccess` (
`ident` int(11) NOT NULL auto_increment,
`pfad` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`lastchange` int(14) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `httpd_definitions`
--
CREATE TABLE `httpd_definitions` (
`id` int(11) NOT NULL auto_increment,
`label` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `httpd_entries`
--
CREATE TABLE `httpd_entries` (
`id` int(11) NOT NULL auto_increment,
`httpd_id` int(11) NOT NULL default '0',
`reseller` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`domain_id` int(11) NOT NULL default '0',
`state` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`),
KEY `first` (`httpd_id`,`domain_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `httpd_permissions`
--
CREATE TABLE `httpd_permissions` (
`httpd_id` int(11) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`reseller` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`template_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `httpd_states`
--
CREATE TABLE `httpd_states` (
`id` int(11) NOT NULL auto_increment,
`httpd_id` int(11) NOT NULL default '0',
`label` varchar(255) NOT NULL default '',
`data` blob NOT NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `idn_aliases`
--
CREATE TABLE `idn_aliases` (
`id` int(11) NOT NULL auto_increment,
`domain_id` int(11) NOT NULL default '0',
`idn_name` varchar(255) NOT NULL default '',
`charset` varchar(32) NOT NULL default 'UTF8',
`ascii_name` varchar(255) default NULL,
`neu` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
UNIQUE KEY `idn_name` (`idn_name`),
UNIQUE KEY `ascii_name` (`ascii_name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `ipadressen`
--
CREATE TABLE `ipadressen` (
`ip` varchar(15) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`lastchange` int(14) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`status` tinyint(4) NOT NULL default '1',
`ip_num` varchar(12) NOT NULL default '',
PRIMARY KEY (`ip`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `iprestriction`
--
CREATE TABLE `iprestriction` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(15) NOT NULL default '',
`rest` enum('accept','deny') NOT NULL default 'accept',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `kunden`
--
CREATE TABLE `kunden` (
`kunde` varchar(16) NOT NULL default '',
`uid` mediumint(9) NOT NULL default '0',
`passwort` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`maxpop` smallint(6) NOT NULL default '0',
`maxkb` int(11) NOT NULL default '0',
`kbhomedir` int(11) NOT NULL default '0',
`kbdb` int(11) NOT NULL default '0',
`maxmysql` smallint(6) NOT NULL default '0',
`maxemail` smallint(6) NOT NULL default '0',
`maxftp` smallint(6) NOT NULL default '0',
`maxtransfer` int(11) NOT NULL default '0',
`maxsubdomains` smallint(6) NOT NULL default '0',
`php` tinyint(4) NOT NULL default '0',
`wildcard` smallint(6) NOT NULL default '0',
`perl` tinyint(4) NOT NULL default '0',
`ssi` tinyint(4) NOT NULL default '0',
`shell` tinyint(4) NOT NULL default '0',
`statistik` tinyint(4) NOT NULL default '0',
`pwschutz` tinyint(4) NOT NULL default '0',
`fehlerseiten` tinyint(4) NOT NULL default '0',
`webftp` tinyint(4) NOT NULL default '0',
`webmail` tinyint(4) NOT NULL default '0',
`kundendatenanzeigen` tinyint(4) NOT NULL default '0',
`anmeldedatum` int(14) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`firma` varchar(255) NOT NULL default '',
`anschrift` varchar(255) NOT NULL default '',
`plzort` varchar(255) NOT NULL default '',
`telefon` varchar(255) NOT NULL default '',
`fax` varchar(255) NOT NULL default '',
`emailadresse` varchar(255) NOT NULL default '',
`kundennummer` varchar(255) NOT NULL default '',
`freifeldname1` varchar(255) NOT NULL default '',
`freifeldwert1` varchar(255) NOT NULL default '',
`freifeldname2` varchar(255) NOT NULL default '',
`freifeldwert2` varchar(255) NOT NULL default '',
`freifeldname3` varchar(255) NOT NULL default '',
`freifeldwert3` varchar(255) NOT NULL default '',
`anzahldateien` int(11) NOT NULL default '0',
`gesperrt` tinyint(4) NOT NULL default '0',
`pw` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '1',
`number` int(11) NOT NULL default '0',
`quota` tinyint(4) NOT NULL default '0',
`frontpage` tinyint(4) NOT NULL default '0',
`stdcgi` tinyint(4) NOT NULL default '0',
`ftp` tinyint(4) NOT NULL default '0',
`maxautoresponder` smallint(6) NOT NULL default '0',
`statistikpasswort` varchar(20) NOT NULL default '',
`statistiklongpw` varchar(255) NOT NULL default '',
`changedomains` tinyint(4) NOT NULL default '0',
`hatalias` tinyint(4) NOT NULL default '0',
`language` char(2) NOT NULL default 'de',
`lastchange` int(14) NOT NULL default '0',
`countdomains` int(14) NOT NULL default '0',
`httpdspezial` blob NOT NULL,
`asp` tinyint(4) NOT NULL default '0',
`wap` tinyint(4) NOT NULL default '0',
`dirlist` tinyint(4) NOT NULL default '0',
`logcopy` tinyint(4) NOT NULL default '0',
`phpupload` tinyint(4) NOT NULL default '0',
`gender` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`plz` varchar(255) NOT NULL default '',
`land` varchar(255) NOT NULL default '',
`spamfilter` tinyint(4) NOT NULL default '0',
`maxmaillist` int(11) NOT NULL default '0',
`maxcronjobs` smallint(6) NOT NULL default '0',
`maxidn` int(11) NOT NULL default '0',
`modpython` tinyint(4) NOT NULL default '0',
`list_size` int(11) NOT NULL default '10',
`scponly` tinyint(4) NOT NULL default '0',
`maxatdomains` smallint(6) NOT NULL default '0',
`coldfusion` tinyint(4) NOT NULL default '0',
`kbpop` int(11) NOT NULL default '0',
`popmaxkb` int(11) NOT NULL default '0',
`awstats` tinyint(4) NOT NULL default '0',
`backup` tinyint(4) NOT NULL default '1',
`backup_url` varchar(255) NOT NULL default '',
`backup_paswd` varchar(16) NOT NULL default '',
`cssl` tinyint(4) NOT NULL default '0',
`httpd` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`maxwebapp` int(11) NOT NULL default '0',
`def_popmaxkb` int(11) NOT NULL default '0',
`def_popmaxkbhard` int(11) NOT NULL default '0',
PRIMARY KEY (`kunde`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `logout`
--
CREATE TABLE `logout` (
`acc` varchar(12) NOT NULL default '',
`logout` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`acc`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `maillist`
--
CREATE TABLE `maillist` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`domain_id` int(10) unsigned NOT NULL default '0',
`owner_mail` varchar(255) NOT NULL default '',
`neu` tinyint(4) NOT NULL default '1',
`pwd` varchar(32) NOT NULL default '',
`gesperrt` tinyint(4) NOT NULL default '0',
`quota` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `menublock`
--
CREATE TABLE `menublock` (
`id` int(10) unsigned NOT NULL auto_increment,
`label` varchar(255) NOT NULL default '',
`overview` text NOT NULL,
`usertype` enum('reseller','user') NOT NULL default 'reseller',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `menuitem`
--
CREATE TABLE `menuitem` (
`id` int(10) unsigned NOT NULL auto_increment,
`menublock_id` int(10) unsigned NOT NULL default '0',
`label` varchar(255) NOT NULL default '',
`href` varchar(255) NOT NULL default '',
`in_frame` tinyint(4) NOT NULL default '0',
`ind` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `mysql_datenbanken`
--
CREATE TABLE `mysql_datenbanken` (
`dbname` varchar(19) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`datenbank` int(15) NOT NULL default '1',
`lastchange` int(14) NOT NULL default '0',
`dbext` tinyint(4) NOT NULL default '0',
`kommentar` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`dbname`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `nladressen`
--
CREATE TABLE `nladressen` (
`ident` int(11) NOT NULL auto_increment,
`mailid` int(11) NOT NULL default '0',
`emailadresse` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `nlinhalt`
--
CREATE TABLE `nlinhalt` (
`ident` int(11) NOT NULL auto_increment,
`mail` blob NOT NULL,
`von` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `perl`
--
CREATE TABLE `perl` (
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(16) NOT NULL default '',
`loeschen` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `personalinfo`
--
CREATE TABLE `personalinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`gender` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`firma` varchar(255) NOT NULL default '',
`anschrift` varchar(255) NOT NULL default '',
`plzort` varchar(255) NOT NULL default '',
`plz` varchar(255) NOT NULL default '',
`land` varchar(255) NOT NULL default '',
`telefon` varchar(255) NOT NULL default '',
`fax` varchar(255) NOT NULL default '',
`emailadresse` varchar(255) NOT NULL default '',
`kundennummer` varchar(255) NOT NULL default '',
`freifeldname1` varchar(255) NOT NULL default '',
`freifeldwert1` varchar(255) NOT NULL default '',
`freifeldname2` varchar(255) NOT NULL default '',
`freifeldwert2` varchar(255) NOT NULL default '',
`freifeldname3` varchar(255) NOT NULL default '',
`freifeldwert3` varchar(255) NOT NULL default '',
`kundendatenanzeigen` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pop3`
--
CREATE TABLE `pop3` (
`account` varchar(16) NOT NULL default '',
`uid` mediumint(9) NOT NULL default '0',
`passwort` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(15) NOT NULL default '',
`gesperrt` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '1',
`number` int(11) NOT NULL default '0',
`quota` tinyint(4) NOT NULL default '0',
`maxkb` int(11) NOT NULL default '0',
`lastchange` int(14) NOT NULL default '0',
`language` char(2) NOT NULL default 'de',
`kommentar` varchar(255) NOT NULL default '',
`spamfilter` tinyint(4) NOT NULL default '0',
`auto_whitelist` tinyint(4) NOT NULL default '1',
`maxkbhard` int(11) NOT NULL default '0',
`diskusage` int(11) NOT NULL default '0',
`sortfield` varchar(15) NOT NULL default '',
`sortorder` varchar(15) NOT NULL default '',
`list_size` int(11) NOT NULL default '25',
`encoding` varchar(20) NOT NULL default 'ISO-8859-1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`account`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pwdreminder`
--
CREATE TABLE `pwdreminder` (
`user` varchar(16) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`usertype` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`user`,`password`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pwschutz`
--
CREATE TABLE `pwschutz` (
`ident` int(11) NOT NULL auto_increment,
`pfad` varchar(255) NOT NULL default '',
`bereich` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`lastchange` int(14) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `register`
--
CREATE TABLE `register` (
`seriennummer` varchar(255) NOT NULL default '',
`hwaddr` varchar(255) NOT NULL default '',
`version` varchar(255) NOT NULL default '',
`lizenz` blob NOT NULL,
`hinweis` blob NOT NULL,
`ip` varchar(15) NOT NULL default '',
`ablauf` varchar(255) NOT NULL default '',
`install` tinyint(4) NOT NULL default '0',
`pw_root` varchar(255) NOT NULL default '',
`pw_db_root` varchar(255) NOT NULL default '',
`pw_db_user` varchar(255) NOT NULL default '',
`pw_admin` varchar(255) NOT NULL default '',
`logindomain` varchar(255) NOT NULL default '',
`loginip` varchar(15) NOT NULL default '',
`standarddomain` varchar(255) NOT NULL default '',
`standardip` varchar(15) NOT NULL default '',
`hostname` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `restore`
--
CREATE TABLE `restore` (
`id` int(11) NOT NULL auto_increment,
`kunde` varchar(16) NOT NULL default '',
`src` varchar(255) NOT NULL default '',
`dst` varchar(16) NOT NULL default '',
`paswd` varchar(16) NOT NULL default '',
`ttl` tinyint(4) NOT NULL default '2',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `server`
--
CREATE TABLE `server` (
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`name` varchar(64) NOT NULL default '',
`descr` text,
`status` int(11) NOT NULL default '0',
PRIMARY KEY (`server_id`),
UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `sessions`
--
CREATE TABLE `sessions` (
`id` varchar(100) NOT NULL default '',
`startdate` int(11) NOT NULL default '0',
`lastupdate` int(11) NOT NULL default '0',
`sdata` text NOT NULL,
`user` varchar(255) NOT NULL default '',
`ip` varchar(100) NOT NULL default '',
`language` char(2) NOT NULL default 'de',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `lastupdate` (`lastupdate`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `skins`
--
CREATE TABLE `skins` (
`skin` varchar(255) NOT NULL default '',
`cuser` varchar(255) NOT NULL default '',
`skin_id` int(11) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`cuser`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `spampref`
--
CREATE TABLE `spampref` (
`username` varchar(100) NOT NULL default '',
`preference` varchar(30) NOT NULL default '',
`value` varchar(100) NOT NULL default '',
`prefid` int(11) NOT NULL auto_increment,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`prefid`,`server_id`),
KEY `username` (`username`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `traffic`
--
CREATE TABLE `traffic` (
`id` int(10) unsigned NOT NULL auto_increment,
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`year` smallint(4) NOT NULL default '0',
`month` tinyint(4) NOT NULL default '0',
`day` tinyint(4) NOT NULL default '0',
`sent` int(11) unsigned NOT NULL default '0',
`received` int(11) unsigned NOT NULL default '0',
`local` tinyint(4) NOT NULL default '0',
`maillist_id` int(10) unsigned NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `transfer`
--
CREATE TABLE `transfer` (
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`tag` tinyint(4) NOT NULL default '0',
`monat` tinyint(4) NOT NULL default '0',
`jahr` smallint(4) NOT NULL default '0',
`ftp` int(11) NOT NULL default '0',
`web` int(11) NOT NULL default '0',
`email` int(11) NOT NULL default '0',
`geloescht` tinyint(4) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`pop` int(11) NOT NULL default '0',
`other` int(11) NOT NULL default '0',
`log` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `types`
--
CREATE TABLE `types` (
`id` int(11) NOT NULL auto_increment,
`grp` varchar(8) NOT NULL default '',
`code` varchar(16) NOT NULL default '',
`descr` varchar(80) default NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `updates`
--
CREATE TABLE `updates` (
`id` int(10) unsigned NOT NULL auto_increment,
`version` varchar(50) NOT NULL default '',
`type` varchar(30) NOT NULL default '',
`download_url` varchar(255) NOT NULL default '',
`description_url` varchar(255) NOT NULL default '',
`description_text` text NOT NULL,
`release_date` int(10) unsigned NOT NULL default '0',
`new` tinyint(4) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`),
KEY `id` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE `users` (
`ident` int(11) NOT NULL auto_increment,
`login` varchar(35) NOT NULL default '',
`pass` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`kunde` varchar(16) NOT NULL default '',
`parent` int(11) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webalizer`
--
CREATE TABLE `webalizer` (
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(16) NOT NULL default '',
`loeschen` tinyint(4) NOT NULL default '0',
`neu` tinyint(4) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp`
--
CREATE TABLE `webapp` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`version` varchar(64) NOT NULL default '',
`rls` varchar(32) NOT NULL default '',
`descr` text NOT NULL,
`path` varchar(255) NOT NULL default '',
`status` int(11) NOT NULL default '1',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp2confixx`
--
CREATE TABLE `webapp2confixx` (
`id` int(11) NOT NULL auto_increment,
`param` varchar(32) NOT NULL default '',
`realm` varchar(32) default '',
`role` varchar(32) NOT NULL default '',
`ind` int(11) NOT NULL default '0',
`prompt_key` varchar(64) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp_knowledge`
--
CREATE TABLE `webapp_knowledge` (
`id` int(11) NOT NULL auto_increment,
`webapp` varchar(64) NOT NULL default '',
`type` varchar(64) NOT NULL default '',
`hash_type` varchar(32) NOT NULL default 'md5',
`httpd_conf` text NOT NULL,
`start_page` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp_param`
--
CREATE TABLE `webapp_param` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`def_val` varchar(64) default '',
`type` varchar(32) default 'string',
`valtype` varchar(32) default '',
`webapp_id` int(11) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp_requir`
--
CREATE TABLE `webapp_requir` (
`id` int(11) NOT NULL auto_increment,
`webapp_id` int(11) NOT NULL default '0',
`type` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`val` varchar(64) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp_user`
--
CREATE TABLE `webapp_user` (
`id` int(11) NOT NULL auto_increment,
`webapp_id` int(11) NOT NULL default '0',
`kunde` varchar(16) NOT NULL default '',
`anbieter` varchar(8) NOT NULL default '',
`status` int(11) NOT NULL default '0',
`url` varchar(255) NOT NULL default '',
`domain_id` int(11) NOT NULL default '0',
`path` varchar(255) NOT NULL default '',
`db` varchar(32) NOT NULL default '',
`clean_db` int(11) NOT NULL default '0',
`clean_files` int(11) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webapp_user_param`
--
CREATE TABLE `webapp_user_param` (
`id` int(11) NOT NULL auto_increment,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
`param_id` int(11) NOT NULL default '0',
`webapp_id` int(11) NOT NULL default '0',
`kunde` varchar(32) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webmail_ab`
--
CREATE TABLE `webmail_ab` (
`ident` int(11) NOT NULL auto_increment,
`pop3` varchar(16) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`first_name` varchar(255) default NULL,
`last_name` varchar(255) default NULL,
`tel_home` varchar(255) default NULL,
`tel_work` varchar(255) default NULL,
`tel_mobile` varchar(255) default NULL,
`tel_fax` varchar(255) default NULL,
`address` text,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webmail_def_from`
--
CREATE TABLE `webmail_def_from` (
`ident` int(11) NOT NULL auto_increment,
`pop3` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`),
KEY `ident` (`ident`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webmail_session`
--
CREATE TABLE `webmail_session` (
`ident` bigint(20) NOT NULL auto_increment,
`pop3` varchar(16) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`longpw` varchar(255) NOT NULL default '',
`lang` varchar(4) NOT NULL default '',
`timestamp` timestamp(14) NOT NULL,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webmail_sign`
--
CREATE TABLE `webmail_sign` (
`ident` int(11) NOT NULL auto_increment,
`alias` varchar(255) NOT NULL default '',
`pop3` varchar(255) NOT NULL default '',
`signatur` text,
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx',
PRIMARY KEY (`ident`,`server_id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `zeiten`
--
CREATE TABLE `zeiten` (
`httpdtraffikvon` tinyint(4) NOT NULL default '2',
`httpdtraffikbis` tinyint(4) NOT NULL default '3',
`httpdtraffiktag` tinyint(4) NOT NULL default '0',
`ftptraffikvon` tinyint(4) NOT NULL default '3',
`ftptraffikbis` tinyint(4) NOT NULL default '4',
`ftptraffiktag` tinyint(4) NOT NULL default '0',
`speichervon` tinyint(4) NOT NULL default '4',
`speicherbis` tinyint(4) NOT NULL default '5',
`speichertag` tinyint(4) NOT NULL default '0',
`httpdlpr` int(15) NOT NULL default '0',
`httpdfaktor` int(15) NOT NULL default '1',
`aliaseslpr` int(15) NOT NULL default '0',
`aliasesfaktor` int(15) NOT NULL default '3',
`confixxfaktor` int(15) NOT NULL default '1',
`maillistletzt` int(15) NOT NULL default '0',
`maillistbis` tinyint(4) NOT NULL default '24',
`maillistfreq` int(11) NOT NULL default '600',
`maillistvon` tinyint(4) NOT NULL default '0',
`checknewversion` int(10) NOT NULL default '12',
`httpdtraffiklast` int(15) NOT NULL default '0',
`httpdtraffikfreq` tinyint(4) NOT NULL default '120',
`ftptraffiklast` int(15) NOT NULL default '0',
`ftptraffikfreq` tinyint(4) NOT NULL default '120',
`speicherfreq` tinyint(4) NOT NULL default '120',
`speicherlast` int(15) NOT NULL default '0',
`backupfrom` tinyint(4) NOT NULL default '4',
`backupto` tinyint(4) NOT NULL default '5',
`backupfreq` int(11) NOT NULL default '120',
`backuplast` int(15) NOT NULL default '0',
`server_id` varchar(32) NOT NULL default 'd98ad8a96916b13ec88d54f69exxxxxx'
) TYPE=MyISAM;
Gruß
Tobias
(This post was last modified: 12-26-2007 08:46 PM by tsaenger.)
|
|
Search
Member List
Calendar
Help
/
[ERLEDIGT]migrieren von confixx auf ispCP
