Avoid using the same gid/uid number

[gosa.git] / contrib / mysql / gofon / gofon.sql

diff --git a/contrib/mysql/gofon/gofon.sql b/contrib/mysql/gofon/gofon.sql
index 4d9b84d9fc5b693d0659b649c44c70e1612a40a7..be8b8422064e623779312293bbacc64792f7a11c 100644 (file)
--- a/contrib/mysql/gofon/gofon.sql
+++ b/contrib/mysql/gofon/gofon.sql
@@ -1,4 +1,5 @@
-create database gophone;
+create database asteriskcdrdb;
+use asteriskcdrdb;
 
 create table cdr (
   calldate datetime NOT NULL default '0000-00-00 00:00:00',
@@ -19,3 +20,5 @@ create table cdr (
   userfield varchar(255) NOT NULL default ''
 );
 
+GRANT INSERT,SELECT ON asteriskcdrdb.cdr TO asterisk@localhost IDENTIFIED BY 'somemysqlpass';
+