Code

* Created "old" branch and moved stuff
[gosa.git] / branches / old / gosa-plugins / log / contrib / golog.sql
diff --git a/branches/old/gosa-plugins/log/contrib/golog.sql b/branches/old/gosa-plugins/log/contrib/golog.sql
new file mode 100644 (file)
index 0000000..d5b5f6b
--- /dev/null
@@ -0,0 +1,14 @@
+
+create database gomon;
+use gomon;
+
+create table golog (
+       time_stamp DATETIME,
+       host VARCHAR(50),
+       message VARCHAR(255),
+       log_level VARCHAR(15),
+       matched_dn VARCHAR(255),
+       matched_ts DATETIME
+       );
+
+GRANT INSERT,SELECT,DELETE ON gomon.golog TO gomon@localhost IDENTIFIED BY 'somemysqlpass';