Файл: protected/extensions/HybridAuth/hybridauth-2.1.2/examples/signin_signup/database.sql
Строк: 15
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`email` varchar(200) NOT NULL,
`password`
varchar(200) NOT NULL,
`first_name` varchar(200) NOT NULL,
`last_name` varchar(200) NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
--
--------------------------------------------------------
CREATE TABLE IF
NOT EXISTS `authentications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT 'refer to users.id',
`provider`
varchar(100) NOT NULL,
`provider_uid` varchar(255) NOT NULL,
`email`
varchar(200) NOT NULL,
`display_name` varchar(150) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`profile_url` varchar(300) NOT NULL,
`website_url` varchar(300) NOT
NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE
KEY `provider_uid` (`provider_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
;