From c7f0b83c0da6f807f5859d5d666c1dfd009019b9 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Tue, 06 Nov 2012 10:11:11 -0500 Subject: [PATCH] Implemented: FS#2437 - iterate_query in dovecot-sql.conf is missing The query is added for reference and is commented out by default as it is not compatible with dovecot 1.2 and not required by ispconfig. --- install/sql/incremental/upd_0039.sql | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/install/sql/incremental/upd_0039.sql b/install/sql/incremental/upd_0039.sql index b5f6463..af8a5af 100644 --- a/install/sql/incremental/upd_0039.sql +++ b/install/sql/incremental/upd_0039.sql @@ -1,4 +1,4 @@ --- -------------------------------------------------------- +-- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `web_database_user` @@ -26,6 +26,10 @@ -- -------------------------------------------------------- +INSERT INTO `web_database_user` SELECT NULL, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, '0', `database_user`, `database_password` FROM `web_database` WHERE 1; + +-- -------------------------------------------------------- + UPDATE `web_database`, `web_database_user` SET `web_database`.`database_user_id` = `web_database_user`.`database_user_id` WHERE `web_database_user`.`database_user` = `web_database`.`database_user`; -- -------------------------------------------------------- -- Gitblit v1.9.1