Changeset 10605 for extensions/AMenuManager/amm_install.class.inc.php

Timestamp:

Apr 24, 2011, 2:36:50 PM (13 years ago)

Author:

grum

Message:

bug:2275 ; install don't create tables

File:

• extensions/AMenuManager/amm_install.class.inc.php (modified) (6 diffs)

extensions/AMenuManager/amm_install.class.inc.php

@@ -63 +63 @@
   PRIMARY KEY  (`id`),
   KEY `order_key` (`position`)
-) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE,
+) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci",
 
 "CREATE TABLE  `".$this->tables['personalised']."` (
@@ -70 +70 @@
   `nfo` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`id`)
-) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE,
+) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci",
 
 "CREATE TABLE `".$this->tables['personalised_langs']."` (
@@ -78 +78 @@
   `content` TEXT  NOT NULL,
   PRIMARY KEY (`id`, `lang`)
-) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE,
+) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci",
 
 "CREATE TABLE `".$this->tables['blocks']."` (
@@ -87 +87 @@
   PRIMARY KEY (`id`),
   INDEX `byOrder`(`order`)
-) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE
+) DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci"
 
 );
@@ -264 +264 @@
   `content` TEXT  NOT NULL,
   PRIMARY KEY (`id`, `lang`)
-)  DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE,
+)  DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci",
 
 "CREATE TABLE `".$this->tables['blocks']."` (
@@ -273 +273 @@
   PRIMARY KEY (`id`),
   INDEX `byOrder`(`order`)
-)  DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE ".DB_COLLATE
+)  DEFAULT CHARACTER SET ".DB_CHARSET." COLLATE utf8_general_ci"
       );