Commits

Zhang Huangbin  committed b01a79a

New index in amavisd database for SQL column: policy.policy_name.
Required by iRedAdmin-Pro self-service.

  • Participants
  • Parent commits 885dc93

Comments (0)

Files changed (5)

File iRedMail/ChangeLog

 iRedMail-0.9.0:
+    * Improvement:
+        - New index in `amavisd` database for SQL column `policy.policy_name`.
+          Required by iRedAdmin-Pro self-service.
+
     * Fixed:
         - Add missing SQL column (mailbox.enableindexer-worker) and LDAP
           attribute/value pair: enabledService=indexer-worker. Required by

File iRedMail/samples/amavisd/amavisd-2.7.0.mysql

   sa_username         varchar(64) default NULL
 );
 
+-- Required by iRedMail
+CREATE UNIQUE INDEX policy_idx_policy_name ON policy (policy_name);
 
 -- Read-write part of the dataset (optional) - @storage_sql_dsn.
 --   May reside in the same or in a separate database as lookups database;

File iRedMail/samples/amavisd/amavisd-2.7.0.pgsql

   sa_username         varchar(64) default NULL
 );
 
+-- Required by iRedMail
+CREATE UNIQUE INDEX policy_idx_policy_name ON policy (policy_name);
 
 -- Read-write part of the dataset (optional) - @storage_sql_dsn.
 --   May reside in the same or in a separate database as lookups database;

File iRedMail/samples/amavisd/amavisd.mysql

         -- names mapped through %banned_rules to actual banned_filename tables
 );
 
-
+-- Required by iRedMail
+CREATE UNIQUE INDEX policy_idx_policy_name ON policy (policy_name);
 
 -- R/W part of the dataset (optional)
 --   May reside in the same or in a separate database as lookups database;

File iRedMail/samples/amavisd/amavisd.pgsql

         -- names mapped through %banned_rules to actual banned_filename tables
 );
 
+-- Required by iRedMail
+CREATE UNIQUE INDEX policy_idx_policy_name ON policy (policy_name);
 
 -- R/W part of the dataset (optional)
 --   May reside in the same or in a separate database as lookups database;