ipaddr TEXT,
confirmed TIMESTAMP,
decided TIMESTAMP,
- msg TEXT NOT NULL);
+ msg TEXT NOT NULL,
+ unix_passwd TEXT NOT NULL,
+ paypal TEXT,
+ checkout TEXT);
CREATE SEQUENCE MemberAppSeq START 1;
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 (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
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
FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
CREATE SEQUENCE SecSeq START 1;
+
+CREATE TABLE Ip(
+ id INTEGER PRIMARY KEY,
+ usr INTEGER NOT NULL,
+ node INTEGER NOT NULL,
+ data TEXT NOT NULL,
+ msg TEXT NOT NULL,
+ status INTEGER NOT NULL,
+ stamp TIMESTAMP NOT NULL,
+ cstamp TIMESTAMP,
+ FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
+ FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
+
+CREATE SEQUENCE IpSeq START 1;
+
+CREATE TABLE Cert(
+ id INTEGER PRIMARY KEY,
+ usr INTEGER NOT NULL,
+ data TEXT NOT NULL,
+ msg TEXT NOT NULL,
+ status INTEGER NOT NULL,
+ stamp TIMESTAMP NOT NULL,
+ cstamp TIMESTAMP,
+ FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
+ FOREIGN KEY (node) REFERENCES WebNode(id) ON DELETE CASCADE);
+
+CREATE SEQUENCE CertSeq START 1;