SQL syntax error

 <?php
 mysql_connect("localhost","root","");
 mysql_select_db("tutos");
 if(!empty($_POST)){
 $username = $_POST['username'];
 $email = $_POST['email'];
 $about = $_POST['about'];
 if($username&&$email&&$about){
 extract($_POST);
 $sql="UPDATE users SET username='$username', email='$email', about='{$_POST["about"]}'";
 $req = mysql_query($sql) or die(mysql_error());
 $sql = stripslashes($_POST['about']);
 $success="Votre compte a bien été modifié {$_SESSION["Auth"]["username"]}";
 }else{
 $erreur="Veuillez compléter tous les champs";
 }
 }
 $sql="SELECT * FROM users";
 $req = mysql_query($sql);
 while($d=mysql_fetch_assoc($req)){
 ?>

DROP TABLE IF EXISTS Concierge ;

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

DROP TABLE IF EXISTS Résidence ;

CREATE TABLE Résidence (id_resi int AUTO_INCREMENT 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 NOT NULL,
charges NUMERIC(50),
loyer NUMERIC(5),
id_resi INT NOT NULL,
id_loc INT NOT NULL,
id_prop INT NOT NULL,
PRIMARY KEY (id_studio) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Locataire ;

CREATE TABLE Locataire (id_loc int AUTO_INCREMENT 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 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); 

Error
SQL query:

CREATE TABLE Concierge(

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

MySQL responded: 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