X-Git-Url: https://git.hcoop.net/hcoop/zz_old/portal.git/blobdiff_plain/6ff384e988e79bbe08d5db4c6a34098335ca5783..ace1af387535e3be6aff8e253930fcc2d9ecce25:/init.sml diff --git a/init.sml b/init.sml index 4db7408..cd066b1 100644 --- a/init.sml +++ b/init.sml @@ -128,9 +128,11 @@ fun addUser (name, rname, bal, app, shares) = val db = getDb () val id = nextSeq (db, "WebUserSeq") in - C.dml db ($`INSERT INTO WebUser (id, name, rname, bal, joined, app, shares) + C.dml db ($`INSERT INTO WebUser (id, name, rname, bal, joined, app, shares, paypal, checkout) VALUES (^(C.intToSql id), ^(C.stringToSql name), ^(C.stringToSql rname), ^(C.intToSql bal), - CURRENT_TIMESTAMP, ^(C.intToSql app), ^(C.intToSql shares))`); + CURRENT_TIMESTAMP, ^(C.intToSql app), ^(C.intToSql shares), + (SELECT paypal FROM MemberApp WHERE id = ^(C.intToSql app)), + (SELECT checkout FROM MemberApp WHERE id = ^(C.intToSql app)))`); id end