File: 20041031.sql

package info (click to toggle)
gforge 4.5.14-22etch13
  • links: PTS
  • area: main
  • in suites: etch
  • size: 13,004 kB
  • ctags: 11,918
  • sloc: php: 36,047; sql: 29,050; sh: 10,538; perl: 6,496; xml: 3,810; makefile: 341; python: 263; ansic: 256
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;