/usr/share/gforge/db/20041031.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | 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;
|