Erreur SQL syntax

 <?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é modifier {$_SESSION["Auth"]["username"]}";
                                                    }else{
                                                        $erreur="Veuillez completer 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(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