From 6a5a4ca4c9ab0eae983bbab0a4e4cf10653da76e Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Thu, 4 Feb 2010 21:21:40 -0200
Subject: Adding database class

---
 manifests/database.pp | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 manifests/database.pp

(limited to 'manifests/database.pp')

diff --git a/manifests/database.pp b/manifests/database.pp
new file mode 100644
index 0000000..c2d1fc3
--- /dev/null
+++ b/manifests/database.pp
@@ -0,0 +1,21 @@
+class database {
+  include mysql::server
+
+  # Database definitions
+  define instance($password) {
+    mysql_database { "$name":
+      ensure => present,
+    }
+
+    mysql_user { "$name@%":
+      password_hash => mysql_password($password),
+      ensure        => present,
+      require       => Mysql_database["$name"],
+    }
+
+    mysql_grant { "$name@%/$name":
+      privileges => all,
+      require    => Mysql_user["$name@%"],
+    }
+  }
+}
-- 
cgit v1.2.3