diff options
| author | plegall <plg@piwigo.org> | 2011-02-03 21:59:51 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2011-02-03 21:59:51 +0000 |
| commit | 8ca4d94d94e5007f9b41af646a8de3d268876331 (patch) | |
| tree | c0fa1e9948ca6f6ef38d3af1c1e9f4fd71dba42d /install/upgrade_1.6.2.php | |
| parent | a201d100437fd2d16f582bbbe269779f047a2723 (diff) | |
bug 2155 fixed: for MySQL, use the "ENGINE=MyISAM" syntax instead of the
deprecated "TYPE=MyISAM", so that SQL creation table statements complies
with MySQL 5.5
git-svn-id: http://piwigo.org/svn/trunk@9086 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/upgrade_1.6.2.php')
| -rw-r--r-- | install/upgrade_1.6.2.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/install/upgrade_1.6.2.php b/install/upgrade_1.6.2.php index 7e1d8c481..dd7451007 100644 --- a/install/upgrade_1.6.2.php +++ b/install/upgrade_1.6.2.php @@ -77,7 +77,7 @@ CREATE TABLE `".PREFIX_TABLE."history` ( `image_type` enum('picture','high','other') default NULL, PRIMARY KEY (`id`), KEY `history_i1` (`summarized`) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -135,7 +135,7 @@ CREATE TABLE `".PREFIX_TABLE."history_summary` ( `hour` tinyint(2) default NULL, `nb_pages` int(11) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -146,7 +146,7 @@ CREATE TABLE `".PREFIX_TABLE."old_permalinks` ( `last_hit` datetime default NULL, `hit` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`permalink`) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -155,7 +155,7 @@ CREATE TABLE `".PREFIX_TABLE."plugins` ( `state` enum('inactive','active') NOT NULL default 'inactive', `version` varchar(64) NOT NULL default '0', PRIMARY KEY (`id`) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -166,7 +166,7 @@ CREATE TABLE `".PREFIX_TABLE."user_cache_categories` ( `count_images` mediumint(8) unsigned default '0', `count_categories` mediumint(8) unsigned default '0', PRIMARY KEY (`user_id`,`cat_id`) -) TYPE=MyISAM +) ENGINE=MyISAM ;", /* TABLE DROPPED BEFORE Butterfly/Piwigo release - see later DROP IF EXISTS @@ -182,7 +182,7 @@ CREATE TABLE `".PREFIX_TABLE."ws_access` ( `comment` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `ws_access_ui1` (`name`) -) TYPE=MyISAM COMMENT='Access for Web Services' +) ENGINE=MyISAM COMMENT='Access for Web Services' ;",*/ " |