2 CREATE DATABASE `gosa_log`;
3 USE `gosa_log`;
5 DROP TABLE IF EXISTS `gosa_locations`;
6 CREATE TABLE `gosa_locations` (
7 `id` int(11) NOT NULL auto_increment,
8 `location` text NOT NULL,
9 PRIMARY KEY (`id`)
10 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
12 DROP TABLE IF EXISTS `gosa_log`;
13 CREATE TABLE `gosa_log` (
14 `id` int(10) unsigned NOT NULL auto_increment,
15 `timestamp` int(10) NOT NULL,
16 `user` text NOT NULL,
17 `action` varchar(255) NOT NULL,
18 `objecttype` varchar(255) NOT NULL,
19 `object` text NOT NULL,
20 `changes` blob NOT NULL,
21 `result` varchar(255) NOT NULL,
22 `location_id` int(11) NOT NULL,
23 PRIMARY KEY (`id`),
24 KEY `action` (`action`),
25 KEY `timestamp` (`timestamp`),
26 KEY `objecttype` (`objecttype`),
27 KEY `result` (`result`)
28 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
31 -- %HOST% The name of the source host (e.g. locahost,vserver-01,% WHERE % allows all)
32 -- %USER% The username
33 -- %PWD% The password for the new user
35 -- CREATE USER '%USER%'@'%HOST%' IDENTIFIED BY '%PWD%';
37 -- GRANT SELECT , INSERT , UPDATE , DELETE
38 -- ON `gosa_log`.*
39 -- TO '%USER%'@'%HOST%'
40 -- IDENTIFIED BY '%PWD%';