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 'TYPE=MyISAM' at line 8 SQL=CREATE TABLE IF NOT EXISTS jos_jev_attendance(
id int(11) NOT NULL auto_increment,
ev_id int(11) NOT NULL default 0,
allowregistration tinyint(1) unsigned NOT NULL default 0,
allowcancellation tinyint(1) unsigned NOT NULL default 0,
allrepeats tinyint(1) unsigned NOT NULL default 1,
PRIMARY KEY (id)
) TYPE=MyISAM;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 'TYPE=MyISAM' at line 9 SQL=CREATE TABLE IF NOT EXISTS jos_jev_attendees(
id int(11) NOT NULL auto_increment,
at_id int(11) NOT NULL default 0,
user_id int(11) NOT NULL default 0,
rp_id int(11) NOT NULL default 0,
PRIMARY KEY (id),
INDEX (at_id,user_id),
INDEX (at_id,user_id,rp_id)
) TYPE=MyISAM;
