Friday, June 26, 2009

DB Tables v1.2

at Friday, June 26, 2009
DB Tables description for v1.1 is here.

LastLogin

FieldType
e_oidint(12)
user_IDint(12)
timeint(16)
ipAddressvarchar(15)


MaskedCookieData

FieldType
e_oidint(12)
user_IDint(12)
masked_IDvarchar(21)


TempInvitation

FieldType
e_oidint(12)
registrationCodevarchar(10)
eMailAddressvarchar(64)
creationTimeint(16)


TempVerification

FieldType
e_oidint(12)
user_IDint(12)
verificationCodevarchar(21)
creationTimeint(16)


User

FieldType
e_oidint(12)
userNamevarchar(64)
passwordvarchar(32)
eMailAddressvarchar(64)
gendervarchar(1)
birthYearint(16)
memberSinceint(16)
isVerifiedtinyint(1)
remainingInvitationsint(12)

0 comments on "DB Tables v1.2"

 

PHP Authentication Copyright 2009 Reflection Designed by Ipiet Templates | Image by Tadpole's Notez | Distributed by Blogger Blog Templates