aboutsummaryrefslogtreecommitdiffstats
path: root/install/upgrade_1.4.0.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2011-02-03 21:59:51 +0000
committerplegall <plg@piwigo.org>2011-02-03 21:59:51 +0000
commit8ca4d94d94e5007f9b41af646a8de3d268876331 (patch)
treec0fa1e9948ca6f6ef38d3af1c1e9f4fd71dba42d /install/upgrade_1.4.0.php
parenta201d100437fd2d16f582bbbe269779f047a2723 (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 '')
-rw-r--r--install/upgrade_1.4.0.php8
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
;"
);