src/db/20110408-anonymous-read-news.sql -text
src/db/20110414-move-news-forums-to-own-project.sql -text
src/db/20110701-gforge-5.1.sql -text
+src/db/20110728-fix-mta-lists-view.sql -text
src/db/FTI-20061025.sql -text
src/db/SQL_2.6/replicate.sh svneol=native#text/x-sh
src/db/gforge-data-mysql.sql -text
--- /dev/null
+CREATE OR REPLACE 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 OR status = 4;
&update_with_sql("20110408-anonymous-read-news","5.0.51-13");
&update_with_sql("20110414-move-news-forums-to-own-project","5.0.51-14");
&update_with_sql("20110701-gforge-5.1","5.1-1");
+ &update_with_sql("20110728-fix-mta-lists-view","5.1-2");
########################### INSERT HERE #################################