From 022dce248fb8fe0763f765f5015aacca1c5d20e5 Mon Sep 17 00:00:00 2001 From: Greg Gay Date: Mon, 12 Sep 2011 15:41:03 +0000 Subject: [PATCH] update install sql replacing db type with db Engine --- docs/install/db/db_schema.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/docs/install/db/db_schema.sql b/docs/install/db/db_schema.sql index d6e8262..768d8bf 100644 --- a/docs/install/db/db_schema.sql +++ b/docs/install/db/db_schema.sql @@ -498,19 +498,19 @@ CREATE TABLE `primary_resources` ( `resource` TEXT, `language_code` varchar(20) default NULL, PRIMARY KEY (`primary_resource_id`) -) TYPE = MYISAM; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `primary_resources_types` ( `primary_resource_id` mediumint(8) unsigned NOT NULL, `type_id` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`primary_resource_id`,`type_id`) -) TYPE = MYISAM; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `resource_types` ( `type_id` mediumint(8) unsigned NOT NULL auto_increment, `type` TEXT, PRIMARY KEY (`type_id`) -) TYPE = MYISAM; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `secondary_resources` ( `secondary_resource_id` mediumint(8) unsigned NOT NULL auto_increment, @@ -518,13 +518,13 @@ CREATE TABLE `secondary_resources` ( `secondary_resource` TEXT, `language_code` varchar(20) default NULL, PRIMARY KEY (`secondary_resource_id`) -) TYPE = MYISAM; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; CREATE TABLE `secondary_resources_types` ( `secondary_resource_id` mediumint(8) unsigned NOT NULL, `type_id` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`secondary_resource_id`,`type_id`) -) TYPE = MYISAM; +) ENGINE = MYISAM DEFAULT CHARSET=utf8; INSERT INTO `resource_types` VALUES (1, 'auditory'), -- 2.17.1