diff options
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) |