From b35e8cbe9e9776d86be034365c1033b61497bbb0 Mon Sep 17 00:00:00 2001 From: ben Date: Tue, 23 Sep 2008 17:27:09 +0000 Subject: The database schema will now automatically update itself on upgrade. git-svn-id: https://code.elgg.org/elgg/trunk@2107 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/upgrades/2008092301.sql | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) (limited to 'engine/schema') diff --git a/engine/schema/upgrades/2008092301.sql b/engine/schema/upgrades/2008092301.sql index d6f1a950a..2ae52e0c9 100644 --- a/engine/schema/upgrades/2008092301.sql +++ b/engine/schema/upgrades/2008092301.sql @@ -18,6 +18,39 @@ 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`); -- cgit v1.2.3