F7CM8hC3

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `email` varchar(200) NOT NULL,
4  `password` varchar(200) NOT NULL,
5  `first_name` varchar(200) NOT NULL,
6  `last_name` varchar(200) NOT NULL,
7  `created_at` datetime NOT NULL,
8  PRIMARY KEY (`id`)
9) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
10
11-- --------------------------------------------------------
12
13CREATE TABLE IF NOT EXISTS `authentications` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `user_id` int(11) NOT NULL COMMENT 'refer to users.id',
16  `provider` varchar(100) NOT NULL,
17  `provider_uid` varchar(255) NOT NULL,
18  `email` varchar(200) NOT NULL,
19  `display_name` varchar(150) NOT NULL,
20  `first_name` varchar(100) NOT NULL,
21  `last_name` varchar(100) NOT NULL,
22  `profile_url` varchar(300) NOT NULL,
23  `website_url` varchar(300) NOT NULL,
24  `created_at` datetime NOT NULL,
25  PRIMARY KEY (`id`),
26  UNIQUE KEY `provider_uid` (`provider_uid`)
27) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;