[vhffs-dev] [726] Fixes vhffs_forum view

[subversion@xxxxxxxxx]

Revision: 726
Author:   gradator
Date:     2007-07-13 23:30:29 +0000 (Fri, 13 Jul 2007)

Log Message:
-----------
Fixes vhffs_forum view

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


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-07-13 16:45:19 UTC (rev 725)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-07-13 23:30:29 UTC (rev 726)
@@ -342,7 +342,7 @@
 FROM vhffs_users;
 
 CREATE VIEW vhffs_forum AS
-SELECT users.username, users.passwd, users.firstname, users.lastname, users.mail, users.date_creation, object.state
+SELECT users.username, users.passwd, users.firstname, users.lastname, users.mail, object.date_creation, object.state
 FROM vhffs_users users, vhffs_object object
 WHERE object.object_id=users.object_id;