I get this error when trying to apply the sql patch. Does anyone know how to fix this?
Code:
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `supplier_admin_groups`
--
CREATE TABLE `supplier_admin_groups` ( `supplier_admin_group_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`supplier_id` int( 10 ) unsigned NOT NULL ,
`supplier_admin_group_enabled` tinyint( 1 ) NOT NULL ,
`supplier_admin_group_name` varchar( 32 ) NOT NULL ,
`supplier_admin_group_issuperadmin` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `supplier_admin_group_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
MySQL said:
#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 'DEFAULT CHARSET=utf8' at line 8