CREATE TABLE `df_users_sessions` (

[1000] Fix | Delete

`id` mediumint(9) NOT NULL AUTO_INCREMENT,

[1001] Fix | Delete

`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[1002] Fix | Delete

`token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

[1003] Fix | Delete

`csrf_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[1004] Fix | Delete

`user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[1005] Fix | Delete

`ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[1006] Fix | Delete

`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

[1007] Fix | Delete

PRIMARY KEY (`id`),

[1008] Fix | Delete

UNIQUE KEY `token` (`token`)

[1009] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[1010] Fix | Delete

[1011] Fix | Delete

--

[1012] Fix | Delete

-- Constraints for dumped tables

[1013] Fix | Delete

--

[1014] Fix | Delete

[1015] Fix | Delete

--

[1016] Fix | Delete

-- Constraints for table `df_oauth_access_tokens`

[1017] Fix | Delete

--

[1018] Fix | Delete

ALTER TABLE `df_oauth_access_tokens`

[1019] Fix | Delete

ADD CONSTRAINT `df_oauth_access_tokens_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `df_oauth_sessions` (`id`) ON DELETE CASCADE;

[1020] Fix | Delete

[1021] Fix | Delete

--

[1022] Fix | Delete

-- Constraints for table `df_oauth_access_token_scopes`

[1023] Fix | Delete

--

[1024] Fix | Delete

ALTER TABLE `df_oauth_access_token_scopes`

[1025] Fix | Delete

ADD CONSTRAINT `df_oauth_access_token_scopes_ibfk_1` FOREIGN KEY (`access_token_id`) REFERENCES `df_oauth_access_tokens` (`id`) ON DELETE CASCADE,

[1026] Fix | Delete

ADD CONSTRAINT `df_oauth_access_token_scopes_ibfk_2` FOREIGN KEY (`scope`) REFERENCES `df_oauth_scopes` (`id`) ON DELETE CASCADE;

[1027] Fix | Delete

[1028] Fix | Delete

--

[1029] Fix | Delete

-- Constraints for table `df_oauth_auth_codes`

[1030] Fix | Delete

--

[1031] Fix | Delete

ALTER TABLE `df_oauth_auth_codes`

[1032] Fix | Delete

ADD CONSTRAINT `df_oauth_auth_codes_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `df_oauth_sessions` (`id`) ON DELETE CASCADE;

[1033] Fix | Delete

[1034] Fix | Delete

--

[1035] Fix | Delete

-- Constraints for table `df_oauth_auth_code_scopes`

[1036] Fix | Delete

--

[1037] Fix | Delete

ALTER TABLE `df_oauth_auth_code_scopes`

[1038] Fix | Delete

ADD CONSTRAINT `df_oauth_auth_code_scopes_ibfk_1` FOREIGN KEY (`auth_code_id`) REFERENCES `df_oauth_auth_codes` (`id`) ON DELETE CASCADE,

[1039] Fix | Delete

ADD CONSTRAINT `df_oauth_auth_code_scopes_ibfk_2` FOREIGN KEY (`scope`) REFERENCES `df_oauth_scopes` (`id`) ON DELETE CASCADE;

[1040] Fix | Delete

[1041] Fix | Delete

--

[1042] Fix | Delete

-- Constraints for table `df_oauth_client_redirect_uris`

[1043] Fix | Delete

--

[1044] Fix | Delete

ALTER TABLE `df_oauth_client_redirect_uris`

[1045] Fix | Delete

ADD CONSTRAINT `df_oauth_client_redirect_uris_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `df_oauth_clients` (`id`) ON DELETE CASCADE;

[1046] Fix | Delete

[1047] Fix | Delete

--

[1048] Fix | Delete

-- Constraints for table `df_oauth_refresh_tokens`

[1049] Fix | Delete

--

[1050] Fix | Delete

ALTER TABLE `df_oauth_refresh_tokens`

[1051] Fix | Delete

ADD CONSTRAINT `df_oauth_refresh_tokens_ibfk_1` FOREIGN KEY (`access_token_id`) REFERENCES `df_oauth_access_tokens` (`id`) ON DELETE CASCADE;

[1052] Fix | Delete

[1053] Fix | Delete

--

[1054] Fix | Delete

-- Constraints for table `df_oauth_sessions`

[1055] Fix | Delete

--

[1056] Fix | Delete

ALTER TABLE `df_oauth_sessions`

[1057] Fix | Delete

ADD CONSTRAINT `df_oauth_sessions_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `df_oauth_clients` (`id`) ON DELETE CASCADE;

[1058] Fix | Delete

[1059] Fix | Delete

--

[1060] Fix | Delete

-- Constraints for table `df_oauth_session_scopes`

[1061] Fix | Delete

--

[1062] Fix | Delete

ALTER TABLE `df_oauth_session_scopes`

[1063] Fix | Delete

ADD CONSTRAINT `df_oauth_session_scopes_ibfk_1` FOREIGN KEY (`scope`) REFERENCES `df_oauth_scopes` (`id`) ON DELETE CASCADE,

[1064] Fix | Delete

ADD CONSTRAINT `df_oauth_session_scopes_ibfk_2` FOREIGN KEY (`sid`) REFERENCES `df_oauth_sessions` (`id`) ON DELETE CASCADE;

[1065] Fix | Delete

[1066] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[1067] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[1068] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[1069] Fix | Delete

[1070] Fix | Delete