[vhffs-dev] [svn] commit: r254 - /trunk/vhffs-backend/src/pgsql/initdb.sql

[vhffs-dev@xxxxxxxxx]

Author: gradator
Date: Sun Oct 29 19:23:59 2006
New Revision: 254

Log:
add creation date in the vhffs_forum view


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

Modified: trunk/vhffs-backend/src/pgsql/initdb.sql
==============================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql (original)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql Sun Oct 29 19:23:59 2006
@@ -444,6 +444,6 @@
 FROM vhffs_users;
 
 CREATE VIEW vhffs_forum AS
-SELECT users.username, users.passwd, user_info.firstname, user_info.lastname, user_info.mail, object.state
+SELECT users.username, users.passwd, user_info.firstname, user_info.lastname, user_info.mail, user_info.date_creation, object.state
 FROM vhffs_users users, vhffs_user_info user_info, vhffs_object object
 WHERE user_info.uid=users.uid AND object.object_id=users.object_id;