From ce0f4c066bf70dd9a2e1d7454e36d97cf43b5abd Mon Sep 17 00:00:00 2001 From: marcus Date: Tue, 7 Oct 2008 14:08:28 +0000 Subject: Bugfixes to river script git-svn-id: https://code.elgg.org/elgg/trunk@2212 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 8 ++++---- engine/schema/upgrades/2008100601.sql | 3 ++- 2 files changed, 6 insertions(+), 5 deletions(-) diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 6eafb0791..0ef2c8b8c 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -283,11 +283,11 @@ CREATE TABLE `prefix_system_log` ( `object_id` int(11) NOT NULL, - `object_class` varchar(128) NOT NULL, - `object_type` varchar(128) NOT NULL, - `object_subtype` varchar(128) NOT NULL, + `object_class` varchar(50) NOT NULL, + `object_type` varchar(50) NOT NULL, + `object_subtype` varchar(50) NOT NULL, - `event` varchar(128) NOT NULL, + `event` varchar(50) NOT NULL, `performed_by_guid` int(11) NOT NULL, `time_created` int(11) NOT NULL, diff --git a/engine/schema/upgrades/2008100601.sql b/engine/schema/upgrades/2008100601.sql index 2576487bd..d02dd9f6c 100644 --- a/engine/schema/upgrades/2008100601.sql +++ b/engine/schema/upgrades/2008100601.sql @@ -1,6 +1,7 @@ ALTER TABLE `prefix_system_log` ADD COLUMN `object_type` varchar(50) NOT NULL AFTER `object_class`; ALTER TABLE `prefix_system_log` ADD COLUMN `object_subtype` varchar(50) NOT NULL AFTER `object_type`; -ALTER TABLE `prefix_system_log` MODIFY `object_type` varchar(50) NOT NULL; +ALTER TABLE `prefix_system_log` MODIFY `object_event` varchar(50) NOT NULL; +ALTER TABLE `prefix_system_log` MODIFY `object_class` varchar(50) NOT NULL; ALTER TABLE `prefix_system_log` DROP KEY `object_type`; -- cgit v1.2.3