`resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`primary_resource_id`)\r
-) TYPE = MYISAM;\r
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;\r
\r
CREATE TABLE `primary_resources_types` (\r
`primary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`primary_resource_id`,`type_id`)\r
-) TYPE = MYISAM;\r
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;\r
\r
CREATE TABLE `resource_types` (\r
`type_id` mediumint(8) unsigned NOT NULL auto_increment,\r
`type` TEXT,\r
PRIMARY KEY (`type_id`)\r
-) TYPE = MYISAM;\r
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;\r
\r
CREATE TABLE `secondary_resources` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL auto_increment,\r
`secondary_resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`secondary_resource_id`)\r
-) TYPE = MYISAM;\r
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;\r
\r
CREATE TABLE `secondary_resources_types` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`secondary_resource_id`,`type_id`)\r
-) TYPE = MYISAM;\r
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;\r
\r
INSERT INTO `resource_types` VALUES\r
(1, 'auditory'),\r