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

[vhffs-dev@xxxxxxxxx]

Author: gradator
Date: Sat Oct 28 15:26:37 2006
New Revision: 243

Log:
Add a vue for the vhffs forum


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 Sat Oct 28 15:26:37 2006
@@ -442,7 +442,11 @@
 SELECT uid, gid, username, shell, '*'::character varying AS passwd, homedir
 FROM vhffs_users;
 
-
 CREATE VIEW vhffs_shadow AS
 SELECT uid, gid, username, shell, passwd, '0'::int4 as newtok , '0'::int4 as expired , homedir
 FROM vhffs_users;
+
+CREATE VIEW vhffs_forum AS
+SELECT users.username, users.passwd, user_info.firstname, user_info.lastname, user_info.mail, 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;