bal INTEGER NOT NULL,
joined TIMESTAMP NOT NULL,
app INTEGER NOT NULL,
+ shares INTEGER NOT NULL,
FOREIGN KEY (bal) REFERENCES Balance(id) ON DELETE CASCADE,
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
+ AS SELECT id, name, rname, bal, joined, app, shares
FROM WebUser
JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id
- AND WebGroup.name = 'paying')
+ AND WebGroup.name = 'paying') AS bob
ON usr = WebUser.id;
CREATE VIEW WebUserActive
- AS SELECT id, name, rname, bal, joined, app
+ AS SELECT id, name, rname, bal, joined, app, shares
FROM WebUser
LEFT OUTER JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id AND (WebGroup.name IN ('retired', 'phantom'))) AS mem