X-Git-Url: https://git.ralfj.de/ansible.git/blobdiff_plain/0aacb9f875a40b18dfbbc01b705b5337bf872368..a0ef97a3169e9da8b4618116075d54c49b4292b4:/roles/postfix/vmail.sql diff --git a/roles/postfix/vmail.sql b/roles/postfix/vmail.sql deleted file mode 100644 index 72c3e30..0000000 --- a/roles/postfix/vmail.sql +++ /dev/null @@ -1,33 +0,0 @@ -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;