isidor2706
Grünschnabel
Code:
/* CREATE TABLE IF NOT EXISTS `Kunden` */ /* STRATO */
CREATE TABLE IF NOT EXISTS `kunden` /* localhost */
(
`Kd_Id` int NOT NULL PRIMARY KEY AUTO_INCREMENT,
`KdAnrede` varchar(5),
`KdTitel` varchar(10),
`KdNname` varchar(30) NOT NULL,
`KdVname` varchar(30) NOT NULL,
`KdStrasse` varchar (30) NOT NULL,
`KdHausnr` varchar (6),
`KdAdresszusatz` varchar (30),
`KdPlz` varchar (6) NOT NULL,
`KdOrt` varchar (30) NOT NULL,
`KdLand` varchar (3) NOT NULL,
`KdEmail` varchar (40) NOT NULL,
`KdTel` varchar (25),
`KdGebdatum` varchar (10) NOT NULL,
`KdRegdatum` varchar (10) NOT NULL,
`KdKennwort` varchar (100) NOT NULL,
`KdPKWTempo` varchar (10),
`KdPKWTempoZeit` varchar (12),
`KdSperre` char (1) NULL, /* ja = "X", nein = sonst */
`KdAufrufSperre` varchar (20) NULL, /* DATETIME Format: "JJJJ-MM-TT hh:mm:ss" */
`KdGuthaben` DECIMAL(10,2) DEFAULT '0.00',
`KdVolumen` DECIMAL(10,2) DEFAULT '0.00',
`KdIBAN` varchar (22) NULL,
`KdBIC` varchar (11) NULL,
`KdEmailNews` varchar (80) NOT NULL DEFAULT '0',/* enthält md5 (KdEmail) */
`KdNewsletter_1` char (1) NOT NULL DEFAULT '0', /* ja = "X", nein = sonst */
`KdNewsletter_2` char (1) NOT NULL DEFAULT '0', /* ja = "X", nein = sonst */
`KdNewsletter_3` char (1) NOT NULL DEFAULT '0', /* ja = "X", nein = sonst */
`KdEinwilligung` varchar (1) NULL, /* ja = "X", nein = sonst */
`KdBemerkung` varchar (1000),
CONSTRAINT `KdKontrolle1`
UNIQUE (`KdEmail`)
);
/*
ALTER TABLE `Kunden` ADD INDEX `KdKontrolle3` (`KdEmailNews`);
ALTER TABLE `Kunden` ADD INDEX `KdKontrolle4` (`KdNewsletter_1`);
ALTER TABLE `Kunden` ADD INDEX `KdKontrolle5` (`KdNewsletter_2`);
ALTER TABLE `Kunden` ADD INDEX `KdKontrolle6` (`KdNewsletter_3`);
*/ /* STRATO */
ALTER TABLE `kunden` ADD INDEX `KdKontrolle3` (`KdEmailNews`);
ALTER TABLE `kunden` ADD INDEX `KdKontrolle4` (`KdNewsletter_1`);
ALTER TABLE `kunden` ADD INDEX `KdKontrolle5` (`KdNewsletter_2`);
ALTER TABLE `kunden` ADD INDEX `KdKontrolle6` (`KdNewsletter_3`);
/* localhost */Kann mir bitte jemand erklären, wo genau der Fehler liegt und wie es richtig heißen muß, das wäre super!
