SIMPLE CREATE TABLE FAILS

[GIDEON ISAAC]

I have a simple Create Table statement, and I checked it against mysql syntax examples. It should work (I think) but it doesn't.
Here it is:
USE events_afsi1sitea879257

CREATE TABLE IF NOT EXISTS 'calendar'(
'MyID' INTEGER NOT NULL AUTO_INCREMENT,
'theevent' VARCHAR(80) NULL,
'datehappens' (date) NOT NULL,
'location' VARCHAR(160) NULL,
'thelink' VARCHAR(80) NULL,
'description' VARCHAR(240) NULL,
PRIMARY KEY ('MyID')
)
Any help is appreciated