========================================== mem ====== name type notes ========================================== uID int unique member ID. Auto-generated name varchar(30) forum name portal char(1) primary portal (ww2ol=1,aa=2,ps=3,swg=4,wow=5) forumID varchar(15) SG Forum ID (created on SG forum server) lastPost date when they posted last on Forums posts int total number of posts last7 smallint total posts seven days ago last14 smallint total posts 14 days ago passwd varchar(20) user password (for updating ribbons) ========================================== psChar ======= name type notes ============================================ charID varchar(10) Planetside character ID uID int memberID from the mem table name varchar(30) Character name rank tinyint SG PS rank (1-15) joinDate date Date they joined PS portal promoDate date Date last promoted notes varchar(120) Notes for DO bg tinyint what BG are they in lGameLog date Last time logged into PS ribbons char(20) bit string of what ribbons / awards they have primeChar enum('n','y') Is this the first (primary) character? outfitPts int outfit points for this char outfitY tinyint change since yesterday outfitWeek smallint change last seven days br varchar(2) battle rank cr char(1) command rank vsKill int vanu kills trKill int terran kills totKill int total kills totY tinyint change since yesterday totWeek smallint change last seven days certs mediumtext comma delimited string of certs face varchar(20) last part of face image (ex: 2_r1_c1.jpg)