CMS Mastering Development Wordpress

WordPress database error:

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 ' depart varchar(120) DEFAULT, staffn varchar(120) DEFAULT, ' at line 4]
    $sql="CREATE TABLE IF NOT EXISTS $table_name(   
        id mediumint(9) NOT NULL AUTO_INCREMENT,   
        time timestamp DEFAULT '0000-00-00 00:00:00' DEFAULT,  
        srollno int(119) DEFAULT,    
        sbranch varchar(119)  DEFAULT,   
        student varchar(119)  DEFAULT,   
        fathername varchar(111) DEFAULT,  
        semail varchar(111)  DEFAULT,  
        pass1 varchar(111)  DEFAULT,  
        pass2 varchar(119) DEFAULT,  
        mobile int(100)  DEFAULT,  
        address varchar(139) DEFAULT, 
        img varchar(255) DEFAULT,  
        PRIMARY KEY(id)    )   

Leave a Reply

Your email address will not be published. Required fields are marked *