Source

iredmail / iRedMail / samples / iredmail.mysql

Diff from to

iRedMail/samples/iredmail.mysql

     INDEX (active)
 ) ENGINE=MyISAM;
 
+-- Used to store basic info of deleted mailboxes.
+CREATE TABLE IF NOT EXISTS `deleted_mailboxes` (
+    `id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
+    `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    -- Email address of deleted user
+    `username` VARCHAR(255) NOT NULL DEFAULT '',
+    -- Domain part of user email address
+    domain VARCHAR(255) NOT NULL DEFAULT '',
+    -- Absolute path of user's mailbox
+    `maildir` TEXT NOT NULL DEFAULT '',
+    -- Which domain admin deleted this user
+    `admin` VARCHAR(255) NOT NULL DEFAULT '',
+    KEY id (id),
+    INDEX (timestamp),
+    INDEX (username),
+    INDEX (domain),
+    INDEX (admin)
+) ENGINE=MyISAM;
+
 #
 # IMAP shared folders. User 'from_user' shares folders to user 'to_user'.
 # WARNING: Works only with Dovecot 1.2+.