✔ Fehler bei create Table - Mysql

[Remme]

Hi, ich hoffe einer von euch kann mir weiter helfen. Ich habe in phpmyadmin folgendes bei SQL eingegeben

create table homes
(
id int primary key AUTO_INCREMENT,
type_e tinytext,
type_f tinytext,
short_description_e tinytext,
short_description_f tinytext,
description_e text,
description_f text,
location_e tinytext,
location_f tinytext,
address_e tinytext,
address_f tinytext,
postal_code tinytext
)

create table market
(
id int primary key AUTO_INCREMENT,
home_id int not null,
date_posted date,
date_available date,
rented tinyint not null,
sold tinyint not null,
price float(255, 2) unsigned,
rent_furnished float(255, 2) unsigned,
rent_unfurnished float(255, 2) unsigned,
condo_fees float(255, 2) unsigned,
municipal_taxes float(255, 2) unsigned,
school_taxes float(255, 2) unsigned
)

create table images
(
id int primary key AUTO_INCREMENT,
home_id int not null,
description_e tinytext,
description_f tinytext
)

Dann bekomme ich folgende Fehlermeldung

Fehler

SQL-Befehl:

CREATE TABLE homes(
id int PRIMARY KEY AUTO_INCREMENT ,
type_e tinytext,
type_f tinytext,
short_description_e tinytext,
short_description_f tinytext,
description_e text,
description_f text,
location_e tinytext,
location_f tinytext,
address_e tinytext,
address_f tinytext,
postal_code tinytext
) CREATE TABLE market(
id int PRIMARY KEY AUTO_INCREMENT ,
home_id int NOT NULL ,
date_posted date,
date_available date,
rented tinyint NOT NULL ,
sold tinyint NOT NULL ,
price float( 255, 2 ) unsigned,
rent_furnished float( 255, 2 ) unsigned,
rent_unfurnished float( 255, 2 ) unsigned,
condo_fees float( 255, 2 ) unsigned,
municipal_taxes float( 255, 2 ) unsigned,
school_taxes float( 255, 2 ) unsigned
) CREATE TABLE images(
id int PRIMARY KEY AUTO_INCREMENT ,
home_id int NOT NULL ,
description_e tinytext,
description_f tinytext
)

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'create table market
(
id int primary key AUTO_INCREMENT,
hom

Was ist da falsch, ich komme nicht dahinter.
Danke schonmal im Vorraus
Gruß Remme

 

[campari]

CREATE TABLE homes(
id int PRIMARY KEY AUTO_INCREMENT ,
type_e tinytext,
type_f tinytext,
short_description_e tinytext,
short_description_f tinytext,
description_e text,
description_f text,
location_e tinytext,
location_f tinytext,
address_e tinytext,
address_f tinytext,
postal_code tinytext
) TYPE = MYISAM ;
CREATE TABLE market(
id int PRIMARY KEY AUTO_INCREMENT ,
home_id int NOT NULL ,
date_posted date,
date_available date,
rented tinyint NOT NULL ,
sold tinyint NOT NULL ,
price float( 255, 2 ) unsigned,
rent_furnished float( 255, 2 ) unsigned,
rent_unfurnished float( 255, 2 ) unsigned,
condo_fees float( 255, 2 ) unsigned,
municipal_taxes float( 255, 2 ) unsigned,
school_taxes float( 255, 2 ) unsigned
) TYPE = MYISAM ;
CREATE TABLE images(
id int PRIMARY KEY AUTO_INCREMENT ,
home_id int NOT NULL ,
description_e tinytext,
description_f tinytext
) TYPE = MYISAM ;

 

[Remme]

Danke dir

Gruß Remme