please help. ive been adding tables just like the install says to. still not working though?
SQL query:
CREATE TABLE `tassie12_db`.`users` (`userid` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `username` VARCHAR(255) NOT NULL, `userpass` VARCHAR(255) NOT NULL, `level` INT(11) NOT NULL DEFAULT '0', `exp` DECIMAL(11,4) NOT NULL DEFAULT '0.0000', `money` BIGINT(20) NOT NULL DEFAULT '0', `laston` INT(11) NOT NULL DEFAULT '0', `lastip` VARCHAR(255) NOT NULL, `energy` INT(11) NOT NULL DEFAULT '0', `will` INT(11) NOT NULL DEFAULT '0', `maxwill` INT(11) NOT NULL DEFAULT '0', `brave` INT(11) NOT NULL DEFAULT '0', `maxbrave` INT(11) NOT NULL DEFAULT '0', `maxenergy` INT(11) NOT NULL DEFAULT '0', `hp` INT(11) NOT NULL DEFAULT '0', `maxhp` INT(11) NOT NULL DEFAULT '0', `location` INT(11) NOT NULL DEFAULT '0', `fedjail` INT(11) NOT NULL DEFAULT '0', `user_level` INT(11) NOT NULL DEFAULT '1', `gender` ENUM(male,female) NOT NULL DEFAULT 'male', `daysold` INT(11) NOT NULL DEFAULT '0', `signedup` INT(11) NOT NULL DEFAULT '0', `email` VARCHAR(255) NOT NULL, `login_name` VARCHAR(255) NOT NULL, `display_pi[...]
MySQL said:
#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 'male,female) NOT NULL DEFAULT 'male', `daysold` INT(11) NOT NULL DEFAULT '0', `s' at line 1
why??????