开发者

Database design changes for facebook connect with existing website users

开发者 https://www.devze.com 2023-02-28 01:16 出处:网络
I have already running website and would like to 开发者_运维技巧integrate facebook connect with it.

I have already running website and would like to 开发者_运维技巧integrate facebook connect with it.

My existing users table schema is :

CREATE TABLE  `tbl_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(32) NOT NULL,
  `last_name` varchar(32)  NOT NULL,
  `email` varchar(96)  NOT NULL ,
  `password` varchar(120)  NOT NULL,
  `gender` varchar(5) DEFAULT NULL,
  `about_me` text,
  `image` varchar(120),
  `status` int(1) NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0',
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

What are the changes required in above db table design?


Take a look at the following article:

http://net.tutsplus.com/tutorials/php/how-to-authenticate-your-users-with-facebook-connect/

0

精彩评论

暂无评论...
验证码 换一张
取 消