aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-17 10:08:34 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-17 10:08:34 +0000
commitab1a4a3daa441fcd2e4d9b37267de3b48fae9d6f (patch)
tree6aadca4eb188eb7234c6bc8e0ffd756a1eb6c62a /engine/schema
parenta51e3350ef1a1fff6957e2fec58061a9c839b3e9 (diff)
downloadelgg-ab1a4a3daa441fcd2e4d9b37267de3b48fae9d6f.tar.gz
elgg-ab1a4a3daa441fcd2e4d9b37267de3b48fae9d6f.tar.bz2
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
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql3
-rw-r--r--engine/schema/upgrades/2008101701.sql7
2 files changed, 10 insertions, 0 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 35c079004..bb8646858 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -290,8 +290,11 @@ CREATE TABLE `prefix_system_log` (
`event` varchar(50) NOT NULL,
`performed_by_guid` int(11) NOT NULL,
+ `owner_guid` int(11) NOT NULL,
`access_id` int(11) NOT NULL,
+ `enabled` enum ('yes', 'no') NOT NULL default 'yes',
+
`time_created` int(11) NOT NULL,
PRIMARY KEY (`id`),
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`);