Project InfoSponsor & PartnerInstalling ispCPFAQDocumentationDevelopment
Current time: 11-26-2024, 06:48 AM Hello There, Guest! (Login — Register)

ispCP - Board - Support / ispCP Omega International Area / German Corner / Archiv v / [ERLEDIGT]migrieren von confixx auf ispCP

Thread Closed 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[ERLEDIGT]migrieren von confixx auf ispCP
Author Message
tsaenger Offline
Junior Member
*

Posts: 69
Joined: Dec 2007
Reputation: 0
Post: #1
[ERLEDIGT]migrieren von confixx auf ispCP
Hallo,

ich verwende mom. noch einen debian sarge mit confixx. Ich würde aber gerne auf ispCP wechseln. Gibt es bereits ein script mit dem man confixx daten importieren kann?

Gruß und noch schöne Feiertage

Tobias

P.S: Leider konnte ich die Suche des Forums nicht verwenden: Bekomme schon seit einigen Stunden diese Meldung:

Error 500!

/forum/search.php
Internal Server Error!
(This post was last modified: 04-23-2010 08:21 PM by ZooL.)
12-26-2007 10:33 AM
Find all posts by this user
gOOvER Offline
Banned

Posts: 3,561
Joined: Jul 2007
Post: #2
RE: migrieren von confixx auf ispCP
tsaenger Wrote:Hallo,

ich verwende mom. noch einen debian sarge mit confixx. Ich würde aber gerne auf ispCP wechseln. Gibt es bereits ein script mit dem man confixx daten importieren kann?

Nein, da gibt es leider noch nichts. Im Moment wird nur an einem Script gearbeitet, von dem Du vhcs auf ispCP imigrieren kannst.

Quote:P.S: Leider konnte ich die Suche des Forums nicht verwenden: Bekomme schon seit einigen Stunden diese Meldung:

Error 500!

/forum/search.php
Internal Server Error!

Ja, das passiert hier ab und zu, wenn der Server arbeitet, d.h. die Backups macht, etc. Smile
12-26-2007 03:08 PM
Visit this user's website Find all posts by this user
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #3
RE: migrieren von confixx auf ispCP
könntest du hier im forum einen dump deiner confix datenbank reinstellen?
geht speziell um die struktur. Dann liese sich mit etwas arbeit sicher ein migrations script basteln.
12-26-2007 08:32 PM
Find all posts by this user
tsaenger Offline
Junior Member
*

Posts: 69
Joined: Dec 2007
Reputation: 0
Post: #4
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.)
12-26-2007 08:46 PM
Find all posts by this user
ZooL Offline
Moderator
*****
Moderators

Posts: 3,429
Joined: Jan 2007
Reputation: 79
Post: #5
RE: migrieren von confixx auf ispCP
tsaenger Wrote:Hi
anbei die Struktur der DB:
Quote:strucktur

Gruß

Tobias

ich glaube die db ist weitaus größer als die vhcs2 db..
das wird eventuell mehr arbeit als erwartet.. aber vieleicht eine herrausforderung der leute aus dem forum... vieleicht da ein coder
einen ansatz wie es klappen kann..

mfg
12-27-2007 07:37 AM
Visit this user's website Find all posts by this user
daynight Offline
Newbie
*

Posts: 9
Joined: Apr 2010
Reputation: 0
Post: #6
RE: migrieren von confixx auf ispCP
Wurde da eigentlich dran weitergearbeitet?

Oder gibts was neues?
04-20-2010 05:22 AM
Find all posts by this user
ZooL Offline
Moderator
*****
Moderators

Posts: 3,429
Joined: Jan 2007
Reputation: 79
Post: #7
RE: migrieren von confixx auf ispCP
meines wissens nicht... nach der strukture haben alle angst bekommen Big Grin
04-20-2010 07:15 AM
Visit this user's website Find all posts by this user
Thread Closed 


Forum Jump:


User(s) browsing this thread: 6 Guest(s)

Contact Us | isp Control Panel ( ispCP ) | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication