1 | CREATE 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 | |
---|
13 | CREATE 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 ; |
---|