Hi,

I've been stuck on this one simple(ish) thing for the last 1/2 hour so I thought I might try to get a quick answer here.

What exactly is incorrect about my SQL syntax, assuming I'm using mysql 5.1

CREATE TABLE 'users' (
    'id' MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    'username' VARCHAR(20) NOT NULL,
    'password' VARCHAR(40) NOT NULL,
    'salt' VARCHAR(40) DEFAULT NULL,
    'email' VARCHAR(80) NOT NULL,
    'created_on' INT(11) UNSIGNED NOT NULL,
    'last_login' INT(11) UNSIGNED DEFAULT NULL,
    'active' TINYINT(1) UNSIGNED DEFAULT NULL,
) 
ENGINE InnoDB;

Also, does anyone have any good tutorials about how to use Zend_Auth for complete noobs?

Thanks.