diff options
| author | Horus3 | 2015-03-20 14:26:08 +0100 |
|---|---|---|
| committer | Horus3 | 2015-03-20 14:26:08 +0100 |
| commit | 9ab1f49c4c4aa5dcaa0dd50ec606ca06ca071c71 (patch) | |
| tree | 378bdbab80905a53c1193bfe28e22d1df0fbbcd3 /schema.txt | |
| parent | 039fb0ce71d132a1dfe93b516bc5953dcb61285e (diff) | |
| download | freemail-9ab1f49c4c4aa5dcaa0dd50ec606ca06ca071c71.tar.gz | |
Validate MX from domain. Improve Makefile. Add schema.txt
Diffstat (limited to 'schema.txt')
| -rw-r--r-- | schema.txt | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/schema.txt b/schema.txt new file mode 100644 index 0000000..864bda3 --- /dev/null +++ b/schema.txt @@ -0,0 +1,30 @@ +MariaDB [mailserver]> explain virtual_users; ++-----------+--------------+------+-----+---------+----------------+ +| Field | Type | Null | Key | Default | Extra | ++-----------+--------------+------+-----+---------+----------------+ +| id | int(11) | NO | PRI | NULL | auto_increment | +| domain_id | int(11) | NO | MUL | NULL | | +| password | varchar(32) | NO | | NULL | | +| email | varchar(100) | NO | UNI | NULL | | ++-----------+--------------+------+-----+---------+----------------+ +4 rows in set (0.00 sec) + +MariaDB [mailserver]> explain virtual_domains; ++-------+-------------+------+-----+---------+----------------+ +| Field | Type | Null | Key | Default | Extra | ++-------+-------------+------+-----+---------+----------------+ +| id | int(11) | NO | PRI | NULL | auto_increment | +| name | varchar(50) | NO | | NULL | | ++-------+-------------+------+-----+---------+----------------+ +2 rows in set (0.00 sec) + +MariaDB [mailserver]> explain virtual_aliases; ++-------------+--------------+------+-----+---------+----------------+ +| Field | Type | Null | Key | Default | Extra | ++-------------+--------------+------+-----+---------+----------------+ +| id | int(11) | NO | PRI | NULL | auto_increment | +| domain_id | int(11) | NO | MUL | NULL | | +| source | varchar(100) | NO | | NULL | | +| destination | varchar(100) | NO | | NULL | | ++-------------+--------------+------+-----+---------+----------------+ +4 rows in set (0.00 sec) |