[Gforge-commits] gforge/db 20041001.sql,NONE,1.1

[lo-lan-do]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv28501/db

Added Files:
        20041001.sql 
Log Message:
Added views for NSS-PGSQL.


--- NEW FILE: 20041001.sql ---
CREATE VIEW nss_groups AS
        SELECT group_id+10000 AS gid,
        unix_group_name AS name,
        CHAR(1) 'x' AS passwd
        FROM groups;

CREATE VIEW nss_accounts AS
        SELECT unix_uid+20000 AS uid,
                unix_uid+20000 AS gid,
                user_name AS login,
                unix_pw AS passwd,
                realname AS gecos,
                shell,
                '/var/lib/gforge/chroot/home/users/' || user_name AS homedir
        FROM users
        WHERE status='A';

CREATE VIEW nss_usergroups AS
        SELECT group_id+10000 AS gid,
                user_id+20000 AS uid
        FROM user_group
        WHERE group_id!=800;    -- drop unused and overfull Debian group