X-Git-Url: https://git.ralfj.de/ansible.git/blobdiff_plain/0aacb9f875a40b18dfbbc01b705b5337bf872368..a0ef97a3169e9da8b4618116075d54c49b4292b4:/roles/email/vmail.sql

diff --git a/roles/email/vmail.sql b/roles/email/vmail.sql
new file mode 100644
index 0000000..72c3e30
--- /dev/null
+++ b/roles/email/vmail.sql
@@ -0,0 +1,33 @@
+CREATE DATABASE IF NOT EXISTS `vmail`;
+USE `vmail`;
+
+--
+-- Table structure for table `aliases`
+--
+
+CREATE TABLE `aliases` (
+  `mail` varchar(255) NOT NULL,
+  `user` varchar(255) NOT NULL,
+  PRIMARY KEY (`mail`)
+) DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `senders`
+--
+
+CREATE TABLE `senders` (
+  `sender` varchar(255) NOT NULL,
+  `user` varchar(255) NOT NULL,
+  PRIMARY KEY (`sender`)
+) DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE `users` (
+  `username` varchar(255) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `active` tinyint(4) NOT NULL,
+  PRIMARY KEY (`username`)
+) DEFAULT CHARSET=utf8;
