Commits

Zhang Huangbin committed 78373c3

Add missing SQL index: deleted_mailboxes.timestamp.

  • Participants
  • Parent commits c2e78ae

Comments (0)

Files changed (2)

docs/samples/iredadmin.pgsql

     admin VARCHAR(255) NOT NULL DEFAULT ''
 );
 
+CREATE INDEX idx_deleted_mailboxes_timestamp ON deleted_mailboxes (timestamp);
 CREATE INDEX idx_deleted_mailboxes_username ON deleted_mailboxes (username);
 CREATE INDEX idx_deleted_mailboxes_domain ON deleted_mailboxes (domain);
 CREATE INDEX idx_deleted_mailboxes_admin ON deleted_mailboxes (admin);

docs/samples/iredadmin.sql

     -- Which domain admin deleted this user
     `admin` VARCHAR(255) NOT NULL DEFAULT '',
     KEY id (id),
+    INDEX (timestamp),
     INDEX (username),
     INDEX (domain),
     INDEX (admin)