Joomla Users Table:
1. jos_users
2. jos_core_acl_aro
3. jos_core_acl_groups_aro_map
Adding new registered user:
1. Insert into jos_users
– fields are : id( = autoincrement field), username, name, email, password, gid (18=registered user,25=super admin)
– these are compulsory fields to fillup.
2. Insert into jos_core_acl_aro
-fields are : aro_id ( = autoincrement field), section_value(=”users” string), value(=jos_users.id), name=(=jos_users.name)
3. Insert into jos_core_acl_groups_aro_map
-fields are : group_id ( =jos_users.gid), aro_id( =jos_core_acl_aro.aro_id)
If you want your own component for registation then make a table like this:
4. Insert into your_table.
-fields are : id ( = autoincrement field), user_id ( =jos_users.id), other fields ( =username,name,email,password are stored in users table , so no need to add here)