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

[lo-lan-do]

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

Added Files:
        20041031.sql 
Log Message:
Continued work on replacing LDAP by direct PostgreSQL lookups: Exim4
done, for both e-mail forwarding and mailing-lists.


--- NEW FILE: 20041031.sql ---
CREATE VIEW mta_users AS
        SELECT  user_name AS login,
                email
        FROM users
        WHERE status='A';

CREATE VIEW mta_lists AS
        SELECT
                list_name,
                '|/var/lib/mailman/mail/mailman post ' || list_name AS 
post_address,
                '|/var/lib/mailman/mail/mailman admin ' || list_name AS 
admin_address,
                '|/var/lib/mailman/mail/mailman bounces ' || list_name AS 
bounces_address,
                '|/var/lib/mailman/mail/mailman confirm ' || list_name AS 
confirm_address,
                '|/var/lib/mailman/mail/mailman join ' || list_name AS 
join_address,
                '|/var/lib/mailman/mail/mailman leave ' || list_name AS 
leave_address,
                '|/var/lib/mailman/mail/mailman owner ' || list_name AS 
owner_address,
                '|/var/lib/mailman/mail/mailman request ' || list_name AS 
request_address,
                '|/var/lib/mailman/mail/mailman subscribe ' || list_name AS 
subscribe_address,
                '|/var/lib/mailman/mail/mailman unsubscribe ' || list_name AS 
unsubscribe_address
        FROM mail_group_list
        WHERE status = 3;