X-Git-Url: https://git.ralfj.de/ansible.git/blobdiff_plain/d60c3d0624872eacb41ee95e2cc29ae88a0372f9..4ae7df074f5a9241c4e2590562efc45defc9f579:/roles/postfix/vmail.sql

diff --git a/roles/postfix/vmail.sql b/roles/postfix/vmail.sql
new file mode 100644
index 0000000..72c3e30
--- /dev/null
+++ b/roles/postfix/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;