Changeset 9086 for trunk/install/upgrade_1.4.0.php

Timestamp:

Feb 3, 2011, 10:59:51 PM (13 years ago)

Author:

plg

Message:

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

File:

• trunk/install/upgrade_1.4.0.php (modified) (4 diffs)

trunk/install/upgrade_1.4.0.php

@@ -139 +139 @@
   element_id mediumint(8) NOT NULL default '0',
   PRIMARY KEY  (user_id,element_id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -148 +148 @@
   forbidden_categories text,
   PRIMARY KEY  (user_id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -157 +157 @@
   last_check datetime default NULL,
   PRIMARY KEY  (id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -175 +175 @@
   registration_date datetime NOT NULL default '0000-00-00 00:00:00',
   UNIQUE KEY user_infos_ui1 (user_id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;"
   );