vgifts

vgifts — Stores the history of vgifts sent

vgifts

Column name Type Null Default Description
userid int unsigned   0 The user who received the gift
giftid int unsigned   0 The identifer of the vgift
exptime int unsigned   0 Date/time when the gift expires
gifttype smallint unsigned   0 Vgift type
note text YES Attached note displayed to the user
giverid int unsigned   0 The user who sent the gift
anon enum('0','1')   0 Whether the gift was sent anonymously
applied enum('0','1')   0  
daterecv int unsigned   0 Date/time when the dift was received
Key name Type Column(s)
PRIMARY PRIMARY
userid INDEX