From 8ca4d94d94e5007f9b41af646a8de3d268876331 Mon Sep 17 00:00:00 2001 From: plegall Date: Thu, 3 Feb 2011 21:59:51 +0000 Subject: 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 --- install/upgrade_1.4.0.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'install/upgrade_1.4.0.php') diff --git a/install/upgrade_1.4.0.php b/install/upgrade_1.4.0.php index 430fbc608..9a2a0dc18 100644 --- a/install/upgrade_1.4.0.php +++ b/install/upgrade_1.4.0.php @@ -138,7 +138,7 @@ CREATE TABLE piwigo_caddie ( user_id smallint(5) NOT NULL default '0', element_id mediumint(8) NOT NULL default '0', PRIMARY KEY (user_id,element_id) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -147,7 +147,7 @@ CREATE TABLE piwigo_user_cache ( need_update enum('true','false') NOT NULL default 'true', forbidden_categories text, PRIMARY KEY (user_id) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -156,7 +156,7 @@ CREATE TABLE piwigo_user_feed ( user_id smallint(5) NOT NULL default '0', last_check datetime default NULL, PRIMARY KEY (id) -) TYPE=MyISAM +) ENGINE=MyISAM ;", " @@ -174,7 +174,7 @@ CREATE TABLE piwigo_user_infos ( template varchar(255) NOT NULL default 'yoga', registration_date datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY user_infos_ui1 (user_id) -) TYPE=MyISAM +) ENGINE=MyISAM ;" ); -- cgit v1.2.3