From faff46b45580ab76fb6078a39ab9294fc8079991 Mon Sep 17 00:00:00 2001 From: hickert Date: Thu, 28 Feb 2008 09:11:21 +0000 Subject: [PATCH] Upated contrib logging sql. git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@9180 594d385d-05f5-0310-b6e9-bd551577e9d8 --- gosa-core/contrib/mysql/logging/logging.sql | 23 ++++++++++++++++----- 1 file changed, 18 insertions(+), 5 deletions(-) diff --git a/gosa-core/contrib/mysql/logging/logging.sql b/gosa-core/contrib/mysql/logging/logging.sql index 0ddf4db64..8ddf9dace 100644 --- a/gosa-core/contrib/mysql/logging/logging.sql +++ b/gosa-core/contrib/mysql/logging/logging.sql @@ -1,14 +1,15 @@ -create database gosa_log; -use gosa_log; +CREATE DATABASE `gosa_log`; +USE `gosa_log`; +DROP TABLE IF EXISTS `gosa_locations`; 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 ; - +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; +DROP TABLE IF EXISTS `gosa_log`; CREATE TABLE `gosa_log` ( `id` int(10) unsigned NOT NULL auto_increment, `timestamp` int(10) NOT NULL, @@ -24,5 +25,17 @@ CREATE TABLE `gosa_log` ( KEY `timestamp` (`timestamp`), KEY `objecttype` (`objecttype`), KEY `result` (`result`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; + + +-- %HOST% The name of the source host (e.g. locahost,vserver-01,% WHERE % allows all) +-- %USER% The username +-- %PWD% The password for the new user + +-- CREATE USER '%USER%'@'%HOST%' IDENTIFIED BY '%PWD%'; + +-- GRANT SELECT , INSERT , UPDATE , DELETE +-- ON `gosa_log`.* +-- TO '%USER%'@'%HOST%' +-- IDENTIFIED BY '%PWD%'; -- 2.30.2