From: Greg Gay <info@atutor.ca>
Date: Mon, 12 Sep 2011 15:41:03 +0000 (-0000)
Subject: update install sql replacing db type with db Engine
X-Git-Tag: v1.2~34
X-Git-Url: https://iam.tj/gitweb/gitweb.cgi?p=acontent.git;a=commitdiff_plain;h=022dce248fb8fe0763f765f5015aacca1c5d20e5

update install sql replacing db type with db Engine
---

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'),