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.4.0.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.4.0.php')
| -rw-r--r-- | install/upgrade_1.4.0.php | 8 |
1 files changed, 4 insertions, 4 deletions
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 ;" ); |