I have been going through Tank auth library all day with some success but I could not understand user_profiles table that is created in database.
CREATE TABLE IF NOT EXISTS `user_profiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`country` varchar(20) COLLATE utf8_bin DEFAULT NULL,
`website` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
I tried to google it but there wasn`t huge success ... There are articles about user accounts vs user profiles but there is no information about how it works in database level.
I have managed to adjust library for my needs - user now on registration are required to enter home address and it is saved in database in user table. But now I am doubting myself whether or not to save it under user_profiles for later use.
So the question - what is the reason for user_profiles table and how should I use it?
Use the
userstable to store theUserobject information i.euser_id,passwordetc...Use the
users_profilestable to store information about theUserobject i.e address information