From bcdd83ae8a72ca60784f241cef460e281be2865f Mon Sep 17 00:00:00 2001
From: hickert <hickert@594d385d-05f5-0310-b6e9-bd551577e9d8>
Date: Tue, 15 May 2007 07:03:20 +0000
Subject: [PATCH] Added logging database

git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@6374 594d385d-05f5-0310-b6e9-bd551577e9d8
---
 contrib/mysql/logging/logging.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 contrib/mysql/logging/logging.sql

diff --git a/contrib/mysql/logging/logging.sql b/contrib/mysql/logging/logging.sql
new file mode 100644
index 000000000..d589e2306
--- /dev/null
+++ b/contrib/mysql/logging/logging.sql
@@ -0,0 +1,14 @@
+create database gosa_log;
+use gosa_log;
+
+CREATE TABLE `gosa_log` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `timestamp` int(10) NOT NULL,
+  `user` longtext NOT NULL,
+  `action` varchar(255) NOT NULL,
+  `objecttype` varchar(255) NOT NULL,
+  `object` varchar(255) NOT NULL,
+  `changes` blob NOT NULL,
+  `result` varchar(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- 
2.30.2