Joomla Query Analisis

jos_users

table yang menyimpan nama users pada sistem

nama filed yang ada

"Field";"Type";"Null";"Key";"Default";"Extra"
"id";"int(11)";"NO";"PRI";NULL;"auto_increment"
"name";"varchar(255)";"NO";"MUL";"";""
"username";"varchar(150)";"NO";"MUL";"";""
"email";"varchar(100)";"NO";"MUL";"";""
"password";"varchar(100)";"NO";"";"";""
"usertype";"varchar(25)";"NO";"MUL";"";""
"block";"tinyint(4)";"NO";"";"0";""
"sendEmail";"tinyint(4)";"YES";"";"0";""
"gid";"tinyint(3) unsigned";"NO";"MUL";"1";""
"registerDate";"datetime";"NO";"";"0000-00-00 00:00:00";""
"lastvisitDate";"datetime";"NO";"";"0000-00-00 00:00:00";""
"activation";"varchar(100)";"NO";"";"";""
"params";"text";"NO";"";"";""


jos_session

table ini digunakan untuk menyimpan nilai session dari users yang sedang login

"Field";"Type";"Null";"Key";"Default";"Extra"
"username";"varchar(50)";"YES";"";"";""
"time";"varchar(14)";"YES";"";"";""
"session_id";"varchar(200)";"NO";"PRI";"0";""
"guest";"tinyint(4)";"YES";"MUL";"1";""
"userid";"int(11)";"YES";"";"0";""
"usertype";"varchar(50)";"YES";"";"";""
"gid";"tinyint(3) unsigned";"NO";"";"0";""