     UNIQUE KEY group_name(domain_id, name)
 );
 
----
---- Table: `group_contents`
----
+--
+-- Table: `group_contents`
+--
 DROP TABLE IF EXISTS `vexim`.`group_contents`;
 CREATE TABLE IF NOT EXISTS `vexim`.`group_contents` 
 (

    PRIMARY KEY (group_id, member_id)
);

---
--- Priviledges:
---
GRANT SELECT,INSERT,DELETE,UPDATE ON `vexim`.* to "vexim"@"localhost" 
    IDENTIFIED BY 'CHANGE';
FLUSH PRIVILEGES;

---
--- add initial domain: admin
---
INSERT INTO `vexim`.`domains` (domain_id, domain) VALUES ('1', 'admin');

---
--- add initial user; postmaster
---
INSERT INTO `vexim`.`users`
(
    domain_id, localpart, username, clear, crypt, uid, gid, 

	KEY domains (domain)
);

--
-- Table: `users`
--
DROP TABLE IF EXISTS `vexim`.`users`;
CREATE TABLE IF NOT EXISTS `vexim`.`users` 
(
