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

trunk/install/upgrade_1.6.2.php

@@ -78 +78 @@
   PRIMARY KEY  (`id`),
   KEY `history_i1` (`summarized`)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -136 +136 @@
   `nb_pages` int(11) default NULL,
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -147 +147 @@
   `hit` int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (`permalink`)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -156 +156 @@
   `version` varchar(64) NOT NULL default '0',
   PRIMARY KEY  (`id`)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -167 +167 @@
   `count_categories` mediumint(8) unsigned default '0',
   PRIMARY KEY  (`user_id`,`cat_id`)
-) TYPE=MyISAM
+) ENGINE=MyISAM
 ;",
 
@@ -183 +183 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `ws_access_ui1` (`name`)
-) TYPE=MyISAM COMMENT='Access for Web Services'
+) ENGINE=MyISAM COMMENT='Access for Web Services'
 ;",*/