Requests for FTP access

[hcoop/zz_old/portal.git] / tables.sql

diff --git a/tables.sql b/tables.sql
index 97a890c..7054c74 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -247,6 +247,14 @@ CREATE TABLE AppVote(
        FOREIGN KEY (app) REFERENCES MemberApp(id) ON DELETE CASCADE,
        FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
 
+CREATE VIEW WebUserPaying
+       AS SELECT id, name, rname, bal, joined, app
+               FROM WebUser
+                       JOIN (SELECT usr FROM Membership JOIN WebGroup
+                               ON grp = WebGroup.id
+                                       AND WebGroup.name = 'paying')
+                               ON usr = WebUser.id;
+
 CREATE VIEW WebUserActive
        AS SELECT id, name, rname, bal, joined, app
                FROM WebUser