From: Greg Gay <info@atutor.ca>
Date: Mon, 12 Sep 2011 16:15:28 +0000 (-0000)
Subject: commit initial sql upgrade script to alter table type to engine and set the default... 
X-Git-Tag: v1.2~33
X-Git-Url: https://iam.tj/gitweb/gitweb.cgi?p=acontent.git;a=commitdiff_plain;h=93a5e25595095970166e472a32056f8a6df09089

commit initial sql upgrade script to alter table type to engine and set the default charset to utf-8 for the AFA tables
---

diff --git a/docs/install/db/acontent_upgrade_1.1_to_1.2.sql b/docs/install/db/acontent_upgrade_1.1_to_1.2.sql
new file mode 100644
index 0000000..42f1c30
--- /dev/null
+++ b/docs/install/db/acontent_upgrade_1.1_to_1.2.sql
@@ -0,0 +1,5 @@
+ALTER TABLE primary_resources ENGINE = MYISAM DEFAULT CHARSET=utf8;
+ALTER TABLE primary_resources_types ENGINE = MYISAM DEFAULT CHARSET=utf8;
+ALTER TABLE resource_types ENGINE = MYISAM DEFAULT CHARSET=utf8;
+ALTER TABLE secondary_resources ENGINE = MYISAM DEFAULT CHARSET=utf8;
+ALTER TABLE secondary_resources_types ENGINE = MYISAM DEFAULT CHARSET=utf8;
\ No newline at end of file