blob: 2ae52e0c92f688c5e1ef42b614d448c6043ab9cb (
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
--- Ensure default character set is UTF8
ALTER TABLE `prefix_config` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_entities` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_entity_subtypes` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_entity_relationships` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_access_collections` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_access_collection_membership` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_objects_entity` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_sites_entity` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_users_entity` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_groups_entity` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_annotations` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_metadata` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_metastrings` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_api_users` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_users_apisessions` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_datalists` DEFAULT CHARACTER SET utf8;
ALTER TABLE `prefix_system_log` DEFAULT CHARACTER SET utf8;
-- Drop keys to avoid errors (grr)
ALTER TABLE `prefix_entities` DROP KEY `type`;
ALTER TABLE `prefix_entities` DROP KEY `subtype`;
ALTER TABLE `prefix_entities` DROP KEY `owner_guid`;
ALTER TABLE `prefix_entities` DROP KEY `container_guid`;
ALTER TABLE `prefix_entities` DROP KEY `access_id`;
ALTER TABLE `prefix_entities` DROP KEY `time_created`;
ALTER TABLE `prefix_entities` DROP KEY `time_updated`;
ALTER TABLE `prefix_users_entity` DROP KEY `email`;
ALTER TABLE `prefix_users_entity` DROP KEY `code`;
ALTER TABLE `prefix_annotations` DROP KEY `entity_guid`;
ALTER TABLE `prefix_annotations` DROP KEY `name_id`;
ALTER TABLE `prefix_annotations` DROP KEY `value_id`;
ALTER TABLE `prefix_annotations` DROP KEY `owner_guid`;
ALTER TABLE `prefix_annotations` DROP KEY `access_id`;
ALTER TABLE `prefix_metadata` DROP KEY `entity_guid`;
ALTER TABLE `prefix_metadata` DROP KEY `name_id`;
ALTER TABLE `prefix_metadata` DROP KEY `value_id`;
ALTER TABLE `prefix_metadata` DROP KEY `owner_guid`;
ALTER TABLE `prefix_metadata` DROP KEY `access_id`;
ALTER TABLE `prefix_users_apisessions` DROP KEY `token`;
ALTER TABLE `prefix_system_log` DROP KEY `object_id`;
ALTER TABLE `prefix_system_log` DROP KEY `object_class`;
ALTER TABLE `prefix_system_log` DROP KEY `event`;
ALTER TABLE `prefix_system_log` DROP KEY `performed_by_guid`;
ALTER TABLE `prefix_system_log` DROP KEY `time_created`;
-- New keys
ALTER TABLE `prefix_entities` ADD KEY `type` (`type`);
ALTER TABLE `prefix_entities` ADD KEY `subtype` (`subtype`);
ALTER TABLE `prefix_entities` ADD KEY `owner_guid` (`owner_guid`);
ALTER TABLE `prefix_entities` ADD KEY `container_guid` (`container_guid`);
ALTER TABLE `prefix_entities` ADD KEY `access_id` (`access_id`);
ALTER TABLE `prefix_entities` ADD KEY `time_created` (`time_created`);
ALTER TABLE `prefix_entities` ADD KEY `time_updated` (`time_updated`);
ALTER TABLE `prefix_users_entity` ADD KEY `email` (`email`(50));
ALTER TABLE `prefix_users_entity` ADD KEY `code` (`code`(50));
ALTER TABLE `prefix_annotations` ADD KEY `entity_guid` (`entity_guid`);
ALTER TABLE `prefix_annotations` ADD KEY `name_id` (`name_id`);
ALTER TABLE `prefix_annotations` ADD KEY `value_id` (`value_id`);
ALTER TABLE `prefix_annotations` ADD KEY `owner_guid` (`owner_guid`);
ALTER TABLE `prefix_annotations` ADD KEY `access_id` (`access_id`);
ALTER TABLE `prefix_metadata` ADD KEY `entity_guid` (`entity_guid`);
ALTER TABLE `prefix_metadata` ADD KEY `name_id` (`name_id`);
ALTER TABLE `prefix_metadata` ADD KEY `value_id` (`value_id`);
ALTER TABLE `prefix_metadata` ADD KEY `owner_guid` (`owner_guid`);
ALTER TABLE `prefix_metadata` ADD KEY `access_id` (`access_id`);
ALTER TABLE `prefix_metastrings` DROP KEY `string`;
ALTER TABLE `prefix_metastrings` ADD KEY `string` (`string`(50));
ALTER TABLE `prefix_users_apisessions` ADD KEY `token` (`token`);
ALTER TABLE `prefix_system_log` ADD KEY `object_id` (`object_id`);
ALTER TABLE `prefix_system_log` ADD KEY `object_class` (`object_class`);
ALTER TABLE `prefix_system_log` ADD KEY `event` (`event`);
ALTER TABLE `prefix_system_log` ADD KEY `performed_by_guid` (`performed_by_guid`);
ALTER TABLE `prefix_system_log` ADD KEY `time_created` (`time_created`);
DROP TABLE `prefix_privileged_paths`;
-- HMAC Cache protecting against Replay attacks
CREATE TABLE IF NOT EXISTS `prefix_hmac_cache` (
`hmac` varchar(255) NOT NULL,
`ts` int(11) NOT NULL,
PRIMARY KEY (`hmac`),
KEY `ts` (`ts`)
) ENGINE=MEMORY;
|
