Questa è la struttura delle due tabelle

TABLE user
Field Type Null Key Default Extra
id int(5) PRI auto_increment
fname varchar(36)
lname varchar(36)
username varchar(10) UNI
password varchar(10)
email varchar(255)
acct_type int(2) 1
point_inc decimal(3,1) 0.0
referral varchar(10)
joindate timestamp YES CURRENT_TIMESTAMP
verified char(1) YES n
receiveEmail char(1) y


TABLE points
Field Type Null Key Default Extra
userid int(5) PRI 0
username varchar(10) points decimal(7,1) 0.0