aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-12-04 13:51:25 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-12-04 13:51:25 +0000
commita7189c65575becfeb03eed05972a45eeef96ccc5 (patch)
tree777ecd5654cc2559046aa27742b95bdfb7f915a1 /engine/schema
parentba283cd07db0614fb7260cca3c7f22a83392fc3f (diff)
downloadelgg-a7189c65575becfeb03eed05972a45eeef96ccc5.tar.gz
elgg-a7189c65575becfeb03eed05972a45eeef96ccc5.tar.bz2
Fixed update script
git-svn-id: https://code.elgg.org/elgg/trunk@2502 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/upgrades/2008112002.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/engine/schema/upgrades/2008112002.sql b/engine/schema/upgrades/2008112002.sql
index 31b3cc6eb..cdd308fe0 100644
--- a/engine/schema/upgrades/2008112002.sql
+++ b/engine/schema/upgrades/2008112002.sql
@@ -10,7 +10,7 @@ INSERT INTO `prefix_private_settings` (entity_guid, name, `value`)
-- Delete previous settings
CREATE TEMPORARY TABLE __upgrade_2008112002_1 (
- SELECT distinct meta.id as id from `prefix_metadata meta`
+ SELECT distinct meta.id as id from `prefix_metadata` meta
JOIN `prefix_private_settings` settings ON meta.entity_guid = settings.entity_guid
JOIN `prefix_entities` e ON e.guid = meta.entity_guid