diff --git a/CHANGELOG.txt b/CHANGELOG.txt index d6ff57f706f00facc21e339850fbb3515fa30104..492f39ac434129cf71e22f6f6818f71d88a9ff95 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -67,6 +67,7 @@ Views 4.7.x-dev field to sort on. o 88343: $arg in urls (foo/$arg/bar) had locale problems. o 97497: rss feed did not call module_invoke_all('exit') as it should. + o 89332: Don't default tables to MyISAM type New features: o 101324: New op for views_build_view: 'queries' diff --git a/views.install b/views.install index 27d8e55f8aa37bcd52b1a17004cccbd190f9885b..e0183736ec1383154664d1407a847f8c4a30f34e 100644 --- a/views.install +++ b/views.install @@ -54,7 +54,7 @@ view_args_php longtext, PRIMARY KEY (vid), KEY (name) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); db_query("CREATE TABLE if not exists {view_sort} ( vid int(10) unsigned NOT NULL default '0', @@ -64,7 +64,7 @@ options varchar(255), tablename varchar(255), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); db_query("CREATE TABLE if not exists {view_argument} ( vid int(10) unsigned NOT NULL default '0', @@ -76,7 +76,7 @@ wildcard varchar(32), wildcard_substitution varchar(32), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); db_query("CREATE TABLE if not exists {view_tablefield} ( vid int(10) unsigned NOT NULL default '0', @@ -89,7 +89,7 @@ options varchar(255), position int(2), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); db_query("CREATE TABLE if not exists {view_filter} ( vid int(10) unsigned NOT NULL default '0', @@ -100,7 +100,7 @@ options varchar(255), position int(2), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); db_query("CREATE TABLE if not exists {view_exposed_filter} ( vid int(10) unsigned NOT NULL default '0', @@ -112,7 +112,7 @@ single int(1), position int(2), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); $success = TRUE; break; @@ -273,7 +273,7 @@ function views_update_3() { single int(1), position int(2), KEY (vid) - ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); + ) /*!40100 DEFAULT CHARACTER SET utf8 */"); break; case 'pgsql': $ret[] = update_sql("CREATE TABLE {view_exposed_filter} (