[vhffs-dev] [1479] the default to 'LATIN1' saved the 4.2 release, despite the useless field ;)

[subversion@xxxxxxxxxxxxx]

Revision: 1479
Author:   gradator
Date:     2009-07-26 17:57:44 +0200 (Sun, 26 Jul 2009)

Log Message:
-----------
the default to 'LATIN1' saved the 4.2 release, despite the useless field ;)

Modified Paths:
--------------
    trunk/vhffs-backend/src/pgsql/initdb.sql.in
    trunk/vhffs-compat/4.1.sql
    trunk/vhffs-compat/4.2.sql


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2009-07-26 11:46:54 UTC (rev 1478)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2009-07-26 15:57:44 UTC (rev 1479)
@@ -371,8 +371,6 @@
 	dbuser varchar(200) NOT NULL,
 -- Password for the database, cleared after creation
 	dbpass varchar(32) NOT NULL,
--- Character encoding for the database
-    dbencoding varchar(20) NOT NULL DEFAULT 'LATIN1',
 	object_id int4 NOT NULL,
 	CONSTRAINT vhffs_pgsql_pkey PRIMARY KEY (pgsql_id)
 ) WITH OIDS;

Modified: trunk/vhffs-compat/4.1.sql
===================================================================
--- trunk/vhffs-compat/4.1.sql	2009-07-26 11:46:54 UTC (rev 1478)
+++ trunk/vhffs-compat/4.1.sql	2009-07-26 15:57:44 UTC (rev 1479)
@@ -62,6 +62,3 @@
 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-26 11:46:54 UTC (rev 1478)
+++ trunk/vhffs-compat/4.2.sql	2009-07-26 15:57:44 UTC (rev 1479)
@@ -1,3 +1,5 @@
+-- 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;