blob: cdd308fe0abcb96efdb86cedc0f05ebe287c3d03 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
-- Move user plugins settings to new data store
INSERT INTO `prefix_private_settings` (entity_guid, name, `value`)
SELECT e.guid as guid, name_string.string as name, value_string.string as value FROM `prefix_entities` e
JOIN `prefix_metadata` name_val ON e.guid=name_val.entity_guid
JOIN `prefix_metastrings` name_string ON name_val.name_id = name_string.id
JOIN `prefix_metastrings` value_string ON name_val.value_id = value_string.id
WHERE
e.type='user' AND
name_string.string like 'plugin:settings:%';
-- Delete previous settings
CREATE TEMPORARY TABLE __upgrade_2008112002_1 (
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
JOIN `prefix_metadata` name_val ON e.guid=name_val.entity_guid
JOIN `prefix_metastrings` name_string ON name_val.name_id = name_string.id
JOIN `prefix_metastrings` value_string ON name_val.value_id = value_string.id
WHERE
e.type='user' AND
name_string.string like 'plugin:settings:%' AND
meta.name_id = name_string.id
);
DELETE FROM `prefix_metadata` WHERE id in (SELECT id from __upgrade_2008112002_1);
DROP TABLE __upgrade_2008112002_1;
|
