1 create database gosa_log;
2 use gosa_log;
4 CREATE TABLE `gosa_log` (
5 `id` int(10) unsigned NOT NULL auto_increment,
6 `timestamp` int(10) NOT NULL,
7 `user` longtext NOT NULL,
8 `action` varchar(255) NOT NULL,
9 `objecttype` varchar(255) NOT NULL,
10 `object` varchar(255) NOT NULL,
11 `changes` blob NOT NULL,
12 `result` varchar(255) NOT NULL,
13 PRIMARY KEY (`id`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;