Was ist bei meiner CREATE Table falsch?
Hallo miteinander,
ich habe gerade meine Tabellen für mein php-Script anlegen wollen.
was ist an diesem Syntax falsch? (lt. MyAdmin in den ersten Zeilen)
PHP-Code:
CREATE TABLE 'miet' (
'idmiet' INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
'objectid' INT NOT NULL UNSIGNED,
'adresse' TEXT INT NOT NULL UNSIGNED,
'plz' TINYINT NOT NULL UNSIGNED,
'ort' TEXT NOT NULL,
'kaltmiete' TINYINT NOT NULL,
'warmmiete' TINYINT NOT NULL,
'aussicht' SMALLINT NOT NULL,
'kabel' SMALLINT NOT NULL,
'internet' SMALLINT NOT NULL,
'lift' SMALLINT NOT NULL,
'parkplatz' SMALLINT NOT NULL,
'garage' SMALLINT NOT NULL,
'haustiere' SMALLINT NOT NULL,
'balkon' SMALLINT NOT NULL,
'beschreibung' TEXT NOT NULL,
'titel' TINYTEXT NOT NULL,
'bild' SMALLINT NULL,
'zimmer' INT NOT NULL UNSIGNED,
'qm' SMALLINT NOT NULL UNSIGNED,
'baujahr' SMALLINT NOT NULL UNSIGNED,
'verfuegbar' TEXT NOT NULL UNSIGNED,
);
