[vhffs-dev] [1149] Add fix for vhffs_ml_subscribers sequence value.

[subversion@xxxxxxxxxxxxx]

Revision: 1149
Author:   beuss
Date:     2008-02-05 12:25:44 +0000 (Tue, 05 Feb 2008)

Log Message:
-----------
Add fix for vhffs_ml_subscribers sequence value.

Modified Paths:
--------------
    trunk/vhffs-compat/4.0.sql.in


Modified: trunk/vhffs-compat/4.0.sql.in
===================================================================
--- trunk/vhffs-compat/4.0.sql.in	2008-02-05 11:41:45 UTC (rev 1148)
+++ trunk/vhffs-compat/4.0.sql.in	2008-02-05 12:25:44 UTC (rev 1149)
@@ -11,6 +11,7 @@
 SELECT setval('vhffs_mailings_id_mailing_seq', (SELECT COALESCE(MAX(id_mailing), 1) FROM vhffs_mailings));
 SELECT setval('vhffs_mxdomain_mxdomain_id_seq', (SELECT COALESCE(MAX(mxdomain_id), 1) FROM vhffs_mxdomain));
 SELECT setval('vhffs_ml_ml_id_seq', (SELECT COALESCE(MAX(ml_id), 1) FROM vhffs_ml));
+SELECT setval('vhffs_ml_subscribers_sub_id_seq', (SELECT COALESCE(MAX(sub_id), 1) FROM vhffs_ml_subscribers));
 SELECT setval('vhffs_mysql_mysql_id_seq', (SELECT COALESCE(MAX(mysql_id), 1) FROM vhffs_mysql));
 SELECT setval('vhffs_history_history_id_seq', (SELECT COALESCE(MAX(history_id), 1) FROM vhffs_history));
 SELECT setval('vhffs_pgsql_pgsql_id_seq', (SELECT COALESCE(MAX(pgsql_id), 1) FROM vhffs_pgsql));