Glassroom database table structure 

Authentication table format 

( 
   user varchar(50), 
   password varchar(40) 
)

User information table format 

( 
   nick            VARCHAR(50) NOT NULL,
   realname     VRCHAR(80), 
   email           VARCHAR(80),
   gender         CHAR(1),    // 'M' -> male     'F' -> female    '_' -> none
   iconNo        SMALLINT,
   age              SMALLINT,
   country        VARCHAR(40),
   theme          VARCHAR(50),   // reserved for future use
   score           INTEGER,           // reserved for future use
   secondName VARCHAR(80),// reserved for future use
   flags1          INTEGER,
   flags2          INTEGER,
   PRIMARY KEY (fieldNameNick)
)