diff options
| author | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-28 19:05:11 +0000 |
|---|---|---|
| committer | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-28 19:05:11 +0000 |
| commit | e44437d841d0e1fc788adfec2043c60a4aa40f45 (patch) | |
| tree | f4224d36b2953abdaf44adbb53f275c674f77f27 /engine/schema | |
| parent | f9404514ffad818bc071b1e7a393775a8bf6b62c (diff) | |
| download | elgg-e44437d841d0e1fc788adfec2043c60a4aa40f45.tar.gz elgg-e44437d841d0e1fc788adfec2043c60a4aa40f45.tar.bz2 | |
Added table locking and disabling keys for the UTF8 database upgrade.
git-svn-id: http://code.elgg.org/elgg/trunk@3594 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/upgrades/2009100701.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/engine/schema/upgrades/2009100701.sql b/engine/schema/upgrades/2009100701.sql index f84096a94..1ba083416 100644 --- a/engine/schema/upgrades/2009100701.sql +++ b/engine/schema/upgrades/2009100701.sql @@ -1,19 +1,35 @@ SET NAMES utf8; +LOCK TABLES `prefix_metastrings` WRITE; +/*!40000 ALTER TABLE `prefix_metastrings` DISABLE KEYS */; REPLACE INTO `prefix_metastrings` (id, string) SELECT id, unhex(hex(convert(string using latin1))) FROM `prefix_metastrings`; +/*!40000 ALTER TABLE `prefix_metastrings` ENABLE KEYS */; +UNLOCK TABLES; +LOCK TABLES `prefix_groups_entity` WRITE; +/*!40000 ALTER TABLE `prefix_groups_entity` DISABLE KEYS */; REPLACE INTO `prefix_groups_entity` (guid, name, description) SELECT guid, unhex(hex(convert(name using latin1))), unhex(hex(convert(description using latin1))) FROM `prefix_groups_entity`; +/*!40000 ALTER TABLE `prefix_groups_entity` ENABLE KEYS */; +UNLOCK TABLES; +LOCK TABLES `prefix_objects_entity` WRITE; +/*!40000 ALTER TABLE `prefix_objects_entity` DISABLE KEYS */; REPLACE INTO `prefix_objects_entity` (guid, title, description) SELECT guid, unhex(hex(convert(title using latin1))), unhex(hex(convert(description using latin1))) FROM `prefix_objects_entity`; +/*!40000 ALTER TABLE `prefix_objects_entity` ENABLE KEYS */; +UNLOCK TABLES; +LOCK TABLES `prefix_users_entity` WRITE; +/*!40000 ALTER TABLE `prefix_users_entity` DISABLE KEYS */; REPLACE INTO `prefix_users_entity` (guid, name, username, password, salt, email, language, code, banned, last_action, prev_last_action, last_login, prev_last_login) SELECT guid, unhex(hex(convert(name using latin1))), username, password, salt, email, language, code, banned, last_action, prev_last_action, last_login, prev_last_login FROM `prefix_users_entity`; +/*!40000 ALTER TABLE `prefix_users_entity` ENABLE KEYS */; +UNLOCK TABLES; |