mysql> CREATE TABLE IF NOT EXISTS users (id int(11) NOT NULL auto_increment,first_name varchar(60) NOT NULL DEFAULT '',last_name varchar(60) NOT NULL DEFAULT '',user_name varchar(60) NOT NULL DEFAULT '',email varchar(60) NOT NULL DEFAULT '',pager_email varchar(255),password varchar(255) NOT NULL DEFAULT '',office varchar(60) DEFAULT NULL,phone varchar(48) DEFAULT NULL,viewer int(1) NOT NULL DEFAULT '0',user int(1) NOT NULL DEFAULT '0',supporter int(1) NOT NULL DEFAULT '0',admin int(1) NOT NULL DEFAULT '0',theme varchar(60) DEFAULT 'default' NOT NULL,secret_question text,secret_answer text,lastactive int(60) NOT NULL,language varchar(60) DEFAULT 'English' NOT NULL,time_offset int(5) DEFAULT '0' NOT NULL,routing varchar(255) DEFAULT NULL,title varchar(255) NOT NULL DEFAULT '',address varchar(255) NOT NULL DEFAULT '',city varchar(255) NOT NULL DEFAULT '',state_province varchar(255) NOT NULL DEFAULT '',zip_postal varchar(255) NOT NULL DEFAULT '',country varchar(255) NOT NULL DEFAULT '',website varchar(255) NOT NULL DEFAULT '',other text NOT NULL,PRIMARY KEY (id),UNIQUE KEY (user_name)) -> CREATE TABLE IF NOT EXISTS time_track (id int(11) NOT NULL auto_increment,ticket_id int(11) NOT NULL,supporter_id int(11) NOT NULL,resolution_date int(60) DEFAULT 0,minutes int(11) DEFAULT 0,opened_date int(60) DEFAULT 0,closed_date int(60) DEFAULT 0,primary key(id),key(ticket_id),key(supporter_id)); ERROR 1064 (42000): 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 IF NOT EXISTS time_track (id int(11) NOT NULL auto_increment,ticket' at line 2 mysql>