Erreur SQL syntax [Résolu/Fermé]

DROP TABLE IF EXISTS Concierge ;

CREATE TABLE Concierge (id_conc int AUTO_INCREMENT(8) NOT NULL,
nom_conc TEXT, ad_conc TEXT,
tel_conc NUMERIC(10),
id_resi INT(8) NOT NULL,
PRIMARY KEY (id_conc) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Résidence ;

CREATE TABLE Résidence (id_resi int AUTO_INCREMENT(8) NOT NULL,
nom_resi TEXT, ad_resi TEXT,
tel_resi NUMERIC(10),
PRIMARY KEY (id_resi) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Studio ;

CREATE TABLE Studio (id_studio int AUTO_INCREMENT(8) NOT NULL,
charges NUMERIC(50),
loyer NUMERIC(5),
id_resi INT(8) NOT NULL,
id_loc INT(8) NOT NULL,
id_prop INT(8) NOT NULL,
PRIMARY KEY (id_studio) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Locataire ;

CREATE TABLE Locataire (id_loc int AUTO_INCREMENT(8) NOT NULL,
nom_loc TEXT, ad_loc TEXT,
tel_loc NUMERIC(10),
PRIMARY KEY (id_loc) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Propriétaire ;

CREATE TABLE Propriétaire (id_prop int AUTO_INCREMENT(8) NOT NULL,
nom_prop TEXT, ad_prop TEXT,
tel_prop NUMERIC(10),
PRIMARY KEY (id_prop) ) ENGINE=InnoDB;

ALTER TABLE Concierge
ADD CONSTRAINT FK_Concierge_id_resi
FOREIGN KEY (id_resi)
REFERENCES Résidence (id_resi);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_resi
FOREIGN KEY (id_resi)
REFERENCES Résidence (id_resi);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_loc
FOREIGN KEY (id_loc)
REFERENCES Locataire (id_loc);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_prop
FOREIGN KEY (id_prop)
REFERENCES Propriétaire (id_prop); 

Erreur
Requête SQL:

CREATE TABLE Concierge(

id_conc INT AUTO_INCREMENT ( 8 ) NOT NULL ,
nom_conc TEXT,
ad_conc TEXT,
tel_conc NUMERIC( 10 ) ,
id_resi INT( 8 ) NOT NULL ,
PRIMARY KEY ( id_conc )
) ENGINE = INNODB;

MySQL a répondu: Documentation

#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 '(8) NOT NULL,
nom_conc TEXT, ad_conc TEXT,
tel_conc NUMERIC(10),
id_resi INT(8) ' at line 1