[vhffs-dev] [1478] update_id field is cleared when the user is unsubscribing

[subversion@xxxxxxxxxxxxx]

Revision: 1478
Author:   gradator
Date:     2009-07-26 13:46:54 +0200 (Sun, 26 Jul 2009)

Log Message:
-----------
update_id field is cleared when the user is unsubscribing

Modified Paths:
--------------
    trunk/vhffs-compat/4.1.sql
    trunk/vhffs-compat/4.2.sql


Modified: trunk/vhffs-compat/4.1.sql
===================================================================
--- trunk/vhffs-compat/4.1.sql	2009-07-24 13:42:32 UTC (rev 1477)
+++ trunk/vhffs-compat/4.1.sql	2009-07-26 11:46:54 UTC (rev 1478)
@@ -62,3 +62,6 @@
 DELETE FROM vhffs_ml_subscribers WHERE EXISTS ( SELECT 'x' FROM vhffs_ml_subscribers m WHERE LOWER(m.member) = LOWER(vhffs_ml_subscribers.member) AND m.ml_id = vhffs_ml_subscribers.ml_id AND m.sub_id < vhffs_ml_subscribers.sub_id );
 UPDATE vhffs_ml_subscribers set member=LOWER(member);
 
+
+-- Server encoding is always used to avoid compatibility issues
+ALTER TABLE vhffs_pgsql DROP COLUMN dbencoding;

Modified: trunk/vhffs-compat/4.2.sql
===================================================================
--- trunk/vhffs-compat/4.2.sql	2009-07-24 13:42:32 UTC (rev 1477)
+++ trunk/vhffs-compat/4.2.sql	2009-07-26 11:46:54 UTC (rev 1478)
@@ -1,4 +1,3 @@
--- Probably not complete
 
--- Server encoding is always used to avoid compatibility issues
-ALTER TABLE vhffs_pgsql DROP COLUMN dbencoding;
+-- update_id field is cleared when the user is unsubscribing
+ALTER TABLE vhffs_object_tag ALTER COLUMN updater_id DROP NOT NULL;