From dd858e525ca502b490e11af31691372e2be4fd81 Mon Sep 17 00:00:00 2001 From: hickert Date: Wed, 27 Feb 2008 15:20:49 +0000 Subject: [PATCH] Updated mysql logging schema git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@9178 594d385d-05f5-0310-b6e9-bd551577e9d8 --- gosa-core/contrib/mysql/logging/logging.sql | 21 ++++++++++++++++----- 1 file changed, 16 insertions(+), 5 deletions(-) diff --git a/gosa-core/contrib/mysql/logging/logging.sql b/gosa-core/contrib/mysql/logging/logging.sql index e61472d8b..0ddf4db64 100644 --- a/gosa-core/contrib/mysql/logging/logging.sql +++ b/gosa-core/contrib/mysql/logging/logging.sql @@ -1,17 +1,28 @@ create database gosa_log; use gosa_log; + +CREATE TABLE `gosa_locations` ( + `id` int(11) NOT NULL auto_increment, + `location` text NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; + + CREATE TABLE `gosa_log` ( `id` int(10) unsigned NOT NULL auto_increment, `timestamp` int(10) NOT NULL, - `user` longtext NOT NULL, + `user` text NOT NULL, `action` varchar(255) NOT NULL, `objecttype` varchar(255) NOT NULL, - `object` varchar(255) NOT NULL, + `object` text NOT NULL, `changes` blob NOT NULL, `result` varchar(255) NOT NULL, - PRIMARY KEY (`id`) - KEY `timestamp` (`timestamp`) + `location_id` int(11) NOT NULL, + PRIMARY KEY (`id`), KEY `action` (`action`), -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; + KEY `timestamp` (`timestamp`), + KEY `objecttype` (`objecttype`), + KEY `result` (`result`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- 2.30.2