1 CREATE DATABASE IF NOT EXISTS `vmail`;
5 -- Table structure for table `aliases`
8 CREATE TABLE `aliases` (
9 `mail` varchar(255) NOT NULL,
10 `user` varchar(255) NOT NULL,
12 ) DEFAULT CHARSET=utf8;
15 -- Table structure for table `senders`
18 CREATE TABLE `senders` (
19 `sender` varchar(255) NOT NULL,
20 `user` varchar(255) NOT NULL,
21 PRIMARY KEY (`sender`)
22 ) DEFAULT CHARSET=utf8;
25 -- Table structure for table `users`
28 CREATE TABLE `users` (
29 `username` varchar(255) NOT NULL,
30 `password` varchar(255) NOT NULL,
31 `active` tinyint(4) NOT NULL,
32 PRIMARY KEY (`username`)
33 ) DEFAULT CHARSET=utf8;