From 93a5e25595095970166e472a32056f8a6df09089 Mon Sep 17 00:00:00 2001 From: Greg Gay Date: Mon, 12 Sep 2011 16:15:28 +0000 Subject: [PATCH] commit initial sql upgrade script to alter table type to engine and set the default charset to utf-8 for the AFA tables --- docs/install/db/acontent_upgrade_1.1_to_1.2.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 docs/install/db/acontent_upgrade_1.1_to_1.2.sql 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 -- 2.17.1