· 7 years ago · Jan 12, 2019, 01:26 PM
1CREATE TABLE IF NOT EXISTS `tokens` (
2 `id` int(255) NOT NULL AUTO_INCREMENT,
3 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `senha` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 `session` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 `uid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8 `owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
11
12CREATE TABLE IF NOT EXISTS `users` (
13 `id` int(255) NOT NULL AUTO_INCREMENT,
14 `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
15 `senha` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
16 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
17 PRIMARY KEY (`id`)
18) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;