var alias
var sinitial
var ssurname
var sfirst
var smiddle
var sclan
var scity
var sprov
var scountry
var semail
var scomments
var edit
var reject
var approved
read alias,approved,sinitial,ssurname,sfirst,smiddle,sclan,scity,sprov,scountry,semail,scomments
update alias,approved,sinitial,ssurname,sfirst,smiddle,sclan,scity,sprov,scountry,semail,scomments
from clans@discribe.ca
type guest2nd
require semail,sclan,sfirst,ssurname
html /wwwd/tartans/events/1999/2nd_Annual/guest/guest.edit.html
errorhtml /wwwd/tartans/events/1999/2nd_Annual/guest/guest.error.html
database localhost 11105
initial ssurname,sinitial
limit stype=guest+type=guest2nd