commit initial sql upgrade script to alter table type to engine and set the default...
authorGreg Gay <info@atutor.ca>
Mon, 12 Sep 2011 16:15:28 +0000 (16:15 -0000)
committerGreg Gay <info@atutor.ca>
Mon, 12 Sep 2011 16:15:28 +0000 (16:15 -0000)
docs/install/db/acontent_upgrade_1.1_to_1.2.sql [new file with mode: 0644]

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 (file)
index 0000000..42f1c30
--- /dev/null
@@ -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