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)
)
|