"ENUM" is not vallid at his position, expecting ')'
MySQL (and SQL in general??) is very picky about the order of things1.
province CHAR(2) DEFAULT 'QC' ENUM('QC','ON','NB')

--&gt;
province  ENUM('QC','ON','NB')  DEFAULT 'QC'  -- if you want ENUM

But also, ENUM and CHAR are two different datatypes.  So, maybe you wanted this:
province CHAR(2) DEFAULT 'QC'                 -- if you want CHAR


1 - You should try to become comfortable reading syntax diagrams, such as this for the create table statement.