Transpondertiming "Domainserver Start"				ECA "Domainserver 2010"
Username: 50030698						Username: 50030698
Passwort: joerg@tt						Passwort: joerg@tt

******************************************************************************************************************
Transpondertiming						ECA
FTP Server: ftp76.world4you.com					ftp29.world4you.com

Username: transpondert						enduro
Password: joerg@tt						8275


******************************************************************************************************************
Transpondertiming						ECA
MySQL-Zugangsdaten
https://mysqlsvr20admin.world4you.com				https://mysqlsvr02admin.world4you.com		

Username: transpondertimat					enduro
Passwort: enduro14						8275

Server: 	mysqlsvr20.world4you.com			mysqlsvr02.world4you.com
DatenDB:	transpondertimingatdb1				enduroclubaichfelddb1
DatenDB:	transpondertimingatdb2				enduroclubaichfelddb2
DatenDB:	transpondertimingatdb3				enduroclubdb1
******************************************************************************************************************
Transpondertiming						ECA
https://webmail.world4you.com   				https://webmail.world4you.com
POP3 Server: mail13.world4you.com				mail18.world4you.com
SMTP Server: mail13.world4you.com				mail18.world4you.com

Login: admin@transpondertiming.at				admin@enduro-club-aichfeld.at
Passwort: joerg@tt						8275

******************************************************************************************************************

			! ! !   I N F O zur ERSTELLUNG EINER A N M E L D U N G   ! ! !


Orndner Link ändern				Eigenschaft Ordner

******************************************************************************************************************
SQL Renntabelle erstellen
Achtung Table umbenennen
******************************************************************************************************************

CREATE TABLE IF NOT EXISTS `anmeldungen_Rachau_13` (
  `ID` varchar(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Perh` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `TeamID` varchar(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Stnum` char(4) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Trans1` char(6) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Trans2` char(6) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Ffrei` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `bez` varchar(6) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Fname` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Vorname` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `SNr` varchar(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Profi` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Klasse` char(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Klbez` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Strasse` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `PLZ` varchar(5) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Ort` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Nat` char(4) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Geburtsdatum` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Verein` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Sponsor` varchar(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Marke` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Typ` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Telefon` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `eMail` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Anrede` varchar(4) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Aaut` char(4) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Klwe` varchar(6) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Teil_Text` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `TOK` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Toktext` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `MW` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Rennen` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `AnmeldeID` int(4) NOT NULL AUTO_INCREMENT,
  `AktundOk` char(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Registrierungszeitpunkt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `IP` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `TSA` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `TInfo` varchar(300) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `NenngeldText` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `NenngeldMail` varchar(2) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `NenngeldINFO` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
PRIMARY KEY (`AnmeldeID`),
  KEY `Name` (`Fname`),
  KEY `Verein` (`Verein`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=1 ;

******************************************************************************************************************
Fahrerdatenbank aus AN exportieren nach Klasseneinteilung
Telefonummern überprüfen, doppelte ID einträge checken
als csv Trennzeichen-getrennt speichern
Fahrerdatenbank löschen
SQL FahrerDatenbank erstellen
auf neue Fahrerdatenbank gehen
Importieren
Datei auswählen
Zeichencodierung der Datei: 					windows 1250
Anzahl der am Anfang zu überspringenden Zeilen:			1
Spalten getrennt mit						;
umlaute überprüfen 

******************************************************************************************************************


----------------------------------------------------------------
Fahrerdatenbank anlegen AN
----------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `AN` (
  `ID` varchar(5) DEFAULT NULL,
  `Perh` varchar(10) DEFAULT 'TT:DD:YYYY',
  `TeamID` varchar(5) DEFAULT NULL,
  `Stnum` char(4) DEFAULT NULL,
  `Trans1` char(6) DEFAULT NULL,
  `Trans2` char(6) DEFAULT NULL,
  `Ffrei` varchar(6) DEFAULT NULL,
  `bez` varchar(6) DEFAULT NULL,
  `Fname` varchar(20) DEFAULT NULL,
  `Vorname` varchar(20) DEFAULT NULL,
  `SNr` varchar(6) DEFAULT NULL,
  `Profi` varchar(6) DEFAULT NULL,
  `Klasse` char(2) DEFAULT NULL,
  `Klbez` varchar(10) DEFAULT NULL,
  `Strasse` varchar(40) DEFAULT NULL,
  `PLZ` varchar(5) DEFAULT NULL,
  `Ort` varchar(20) DEFAULT NULL,
  `Nat` char(4) DEFAULT NULL,
  `Geburtsdatum` varchar(10) DEFAULT 'TT:DD:YYYY',
  `VereinID` varchar(3) NULL DEFAULT '',
  `Verein` varchar(50) DEFAULT NULL,
  `Sponsor` varchar(3) NULL DEFAULT '',
  `Marke` varchar(20) DEFAULT NULL,
  `Typ` varchar(20) DEFAULT NULL,
  `Telefon` varchar(16) DEFAULT NULL,
  `eMail` varchar(50) DEFAULT NULL,
  `Anrede` varchar(4) DEFAULT NULL,
  `Aaut` char(6) DEFAULT NULL,
  `Klwe` varchar(10) DEFAULT 'TT:DD:YYYY',
  `Teil_Text` varchar(50) DEFAULT NULL,
  `TOK` varchar(2) DEFAULT NULL,
  `Toktext` varchar(50) DEFAULT NULL,
  `MW` varchar(6) DEFAULT NULL,
  `BEW` varchar(50) NOT NULL DEFAULT '',
  `RegOK` varchar(10) DEFAULT NULL,
  `TransPerh` varchar(10) DEFAULT NULL,
  `Transbuchung` varchar(3) DEFAULT NULL,
  `Klwebuchung` varchar(10) DEFAULT NULL,
  `Cbuchung` varchar(3) DEFAULT NULL,
  `TOKName` varchar(10) DEFAULT NULL,
  `TOKPerh` varchar(10) DEFAULT NULL,
  `Bl` varchar(1) DEFAULT NULL,
  `Lizenz` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;