Changeset 9086 for trunk/install/upgrade_1.3.1.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.3.1.php (modified) (3 diffs)

trunk/install/upgrade_1.3.1.php

@@ -56 +56 @@
   comment varchar(255) default NULL,
   PRIMARY KEY  (param)
-) TYPE=MyISAM COMMENT='configuration table'
+) ENGINE=MyISAM COMMENT='configuration table'
 ;",
 
@@ -280 +280 @@
   rate tinyint(2) unsigned NOT NULL default '0',
   PRIMARY KEY  (user_id,element_id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -289 +289 @@
   forbidden_categories text,
   PRIMARY KEY  (user_id)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",