Why isn't this working? Am I using the right sql language?

File: 1478528247004.jpg (879KB, 1345x1550px) Image search: [Google]

879KB, 1345x1550px

Why isn't this working?
Am I using the right sql language?
how do I fix it?


SQL query:

CREATE TABLE affiliates(
ID int( 10 ) NOT NULL AUTO_INCREMENT ,
username varchar( 50 ) NOT NULL default”,
PASSWORD varchar( 32 ) NOT NULL default”,
site varchar( 255 ) NOT NULL default”,
email varchar( 255 ) NOT NULL default”,
akey varchar( 32 ) NOT NULL default”,
ptype varchar( 32 ) NOT NULL default‘0’,
pemail varchar( 255 ) NOT NULL default”,
address text NOT NULL ,
PRIMARY KEY ( ID ) ,
UNIQUE KEY akey( akey )
) TYPE = MYISAM AUTO_INCREMENT =1;

MySQL said: 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 '”,
password varchar(32) NOT NULL default ”,
site varchar(255) NOT NULL d' at line 3