From ab1a4a3daa441fcd2e4d9b37267de3b48fae9d6f Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Fri, 17 Oct 2008 10:08:34 +0000
Subject: Changes to access any system log code. Introducing owner guid on
 items which is necessary for access control. Requires upgrade.php to be run

git-svn-id: https://code.elgg.org/elgg/trunk@2278 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/upgrades/2008101701.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 engine/schema/upgrades/2008101701.sql

(limited to 'engine/schema/upgrades/2008101701.sql')

diff --git a/engine/schema/upgrades/2008101701.sql b/engine/schema/upgrades/2008101701.sql
new file mode 100644
index 000000000..3e6fc9653
--- /dev/null
+++ b/engine/schema/upgrades/2008101701.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `prefix_system_log` ADD COLUMN `owner_guid` int(11) NOT NULL AFTER `performed_by_guid`;
+
+ALTER TABLE `prefix_system_log` DROP KEY `owner_guid`;
+ALTER TABLE `prefix_system_log` ADD KEY `owner_guid` (`owner_guid`);
+
+ALTER TABLE `prefix_system_log` DROP KEY `river_key`;
+ALTER TABLE `prefix_system_log` ADD KEY `river_key` (`object_type`, `object_subtype`, `event`, `access_id`);
-- 
cgit v1.2.3

