index 397c11a347600b7bdb8a339c60afb0a0cefbd509..be8b8422064e623779312293bbacc64792f7a11c 100644 (file)
create database asteriskcdrdb;
+use asteriskcdrdb;
create table cdr (
calldate datetime NOT NULL default '0000-00-00 00:00:00',
userfield varchar(255) NOT NULL default ''
);
+GRANT INSERT,SELECT ON asteriskcdrdb.cdr TO asterisk@localhost IDENTIFIED BY 'somemysqlpass';
+