#!/bin/bash

DATABASE=`/sbin/e-smith/db configuration getprop bugzilla DbDatabase`
USERNAME=`/sbin/e-smith/db configuration getprop bugzilla DbUser`
PASSWORD=`/sbin/e-smith/db configuration getprop bugzilla DbPassword`

mysql105 -e "CREATE DATABASE IF NOT EXISTS $DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql105 -e "USE mysql; GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES,LOCK TABLES,CREATE TEMPORARY TABLES ON $DATABASE.* TO $USERNAME@localhost IDENTIFIED BY '$PASSWORD'; FLUSH PRIVILEGES;" 

/etc/e-smith/events/actions/bugzilla
