File: 20041031.sql

package info (click to toggle)
fusionforge 5.3.2%2B20141104-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 60,472 kB
  • sloc: php: 271,846; sql: 36,817; python: 14,575; perl: 6,406; sh: 5,980; xml: 4,294; pascal: 1,411; makefile: 911; cpp: 52; awk: 27
file content (21 lines) | stat: -rw-r--r-- 938 bytes parent folder | download | duplicates (6) 
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;