HCoop
/
hcoop
/
zz_old
/
portal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Peeking into members' applications
[hcoop/zz_old/portal.git]
/
tables.sql
diff --git
a/tables.sql
b/tables.sql
index
f0067e8
..
56a68ed
100644
(file)
--- a/
tables.sql
+++ b/
tables.sql
@@
-14,7
+14,9
@@
CREATE TABLE MemberApp(
confirmed TIMESTAMP,
decided TIMESTAMP,
msg TEXT NOT NULL,
confirmed TIMESTAMP,
decided TIMESTAMP,
msg TEXT NOT NULL,
- unix_passwd TEXT NOT NULL);
+ unix_passwd TEXT NOT NULL,
+ paypal TEXT,
+ checkout TEXT);
CREATE SEQUENCE MemberAppSeq START 1;
CREATE SEQUENCE MemberAppSeq START 1;
@@
-37,6
+39,8
@@
CREATE TABLE WebUser(
joined TIMESTAMP NOT NULL,
app INTEGER NOT NULL,
shares INTEGER NOT NULL,
joined TIMESTAMP NOT NULL,
app INTEGER NOT NULL,
shares INTEGER NOT NULL,
+ paypal TEXT,
+ checkout TEXT
FOREIGN KEY (bal) REFERENCES Balance(id) ON DELETE CASCADE,
FOREIGN KEY (app) REFERENCES MemberApp(id) ON DELETE CASCADE);
FOREIGN KEY (bal) REFERENCES Balance(id) ON DELETE CASCADE,
FOREIGN KEY (app) REFERENCES MemberApp(id) ON DELETE CASCADE);
@@
-270,7
+274,7
@@
CREATE TABLE AppVote(
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
CREATE VIEW WebUserPaying
FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE);
CREATE VIEW WebUserPaying
- AS SELECT id, name, rname, bal, joined, app, shares
+ AS SELECT id, name, rname, bal, joined, app, shares
, paypal, checkout
FROM WebUser
JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id
FROM WebUser
JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id
@@
-278,7
+282,7
@@
CREATE VIEW WebUserPaying
ON usr = WebUser.id;
CREATE VIEW WebUserActive
ON usr = WebUser.id;
CREATE VIEW WebUserActive
- AS SELECT id, name, rname, bal, joined, app, shares
+ AS SELECT id, name, rname, bal, joined, app, shares
, paypal, checkout
FROM WebUser
LEFT OUTER JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id AND (WebGroup.name IN ('retired', 'phantom'))) AS mem
FROM WebUser
LEFT OUTER JOIN (SELECT usr FROM Membership JOIN WebGroup
ON grp = WebGroup.id AND (WebGroup.name IN ('retired', 'phantom'))) AS mem