aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/upgrades/2008112002.sql
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema/upgrades/2008112002.sql')
-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