text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: 17 Jan 2018 pada 14.31
  -- Versi Server: 10.1.21-MariaDB
  -- PHP Version: 7.1.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `laravel_oauth`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `migrations`
  --
  
  CREATE TABLE `migrations` (
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `migrations`
  --
  
  INSERT INTO `migrations` (`migration`, `batch`) VALUES
  ('2014_04_24_110151_create_oauth_scopes_table', 1),
  ('2014_04_24_110304_create_oauth_grants_table', 1),
  ('2014_04_24_110403_create_oauth_grant_scopes_table', 1),
  ('2014_04_24_110459_create_oauth_clients_table', 1),
  ('2014_04_24_110557_create_oauth_client_endpoints_table', 1),
  ('2014_04_24_110705_create_oauth_client_scopes_table', 1),
  ('2014_04_24_110817_create_oauth_client_grants_table', 1),
  ('2014_04_24_111002_create_oauth_sessions_table', 1),
  ('2014_04_24_111109_create_oauth_session_scopes_table', 1),
  ('2014_04_24_111254_create_oauth_auth_codes_table', 1),
  ('2014_04_24_111403_create_oauth_auth_code_scopes_table', 1),
  ('2014_04_24_111518_create_oauth_access_tokens_table', 1),
  ('2014_04_24_111657_create_oauth_access_token_scopes_table', 1),
  ('2014_04_24_111810_create_oauth_refresh_tokens_table', 1),
  ('2014_10_12_000000_create_users_table', 1),
  ('2014_10_12_100000_create_password_resets_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_access_tokens`
  --
  
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `session_id` int(10) UNSIGNED NOT NULL,
    `expire_time` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `oauth_access_tokens`
  --
  
  INSERT INTO `oauth_access_tokens` (`id`, `session_id`, `expire_time`, `created_at`, `updated_at`) VALUES
  ('Qr3yh4zPNqT1wVHo7asBVOCHNHY4yZV8MxaSw1GE', 3, 1516199214, '2018-01-17 06:26:54', '2018-01-17 06:26:54'),
  ('Roqn66LPuyA1N8kUNVpd9oVLxxmWOWIPStFZNMGi', 4, 1516199250, '2018-01-17 06:27:30', '2018-01-17 06:27:30'),
  ('sbmKqVYUCDW1sBfFezBkg0yRlMH4M71iKjj0XAhi', 5, 1516199363, '2018-01-17 06:29:23', '2018-01-17 06:29:23'),
  ('SEM2xXHFnq0SR3qGATQByvFGD2DLTawquOO2G29E', 2, 1516199210, '2018-01-17 06:26:50', '2018-01-17 06:26:50'),
  ('WF6PdsoV7Dmpff0fvqTTkXF31juqybgVOXV4bOqS', 1, 1516198997, '2018-01-17 06:23:17', '2018-01-17 06:23:17');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_access_token_scopes`
  --
  
  CREATE TABLE `oauth_access_token_scopes` (
    `id` int(10) UNSIGNED NOT NULL,
    `access_token_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `scope_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_auth_codes`
  --
  
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `session_id` int(10) UNSIGNED NOT NULL,
    `redirect_uri` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `expire_time` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_auth_code_scopes`
  --
  
  CREATE TABLE `oauth_auth_code_scopes` (
    `id` int(10) UNSIGNED NOT NULL,
    `auth_code_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `scope_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_clients`
  --
  
  CREATE TABLE `oauth_clients` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `secret` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `oauth_clients`
  --
  
  INSERT INTO `oauth_clients` (`id`, `secret`, `name`, `created_at`, `updated_at`) VALUES
  ('f3d259ddd3ed8ff3843839b', '4c7f6f8fa93d59c45502c0ae8c4a95b', 'Main website', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_client_endpoints`
  --
  
  CREATE TABLE `oauth_client_endpoints` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `redirect_uri` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_client_grants`
  --
  
  CREATE TABLE `oauth_client_grants` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `grant_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_client_scopes`
  --
  
  CREATE TABLE `oauth_client_scopes` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `scope_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_grants`
  --
  
  CREATE TABLE `oauth_grants` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_grant_scopes`
  --
  
  CREATE TABLE `oauth_grant_scopes` (
    `id` int(10) UNSIGNED NOT NULL,
    `grant_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `scope_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_refresh_tokens`
  --
  
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `access_token_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `expire_time` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_scopes`
  --
  
  CREATE TABLE `oauth_scopes` (
    `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_sessions`
  --
  
  CREATE TABLE `oauth_sessions` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `owner_type` enum('client','user') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user',
    `owner_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `client_redirect_uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `oauth_sessions`
  --
  
  INSERT INTO `oauth_sessions` (`id`, `client_id`, `owner_type`, `owner_id`, `client_redirect_uri`, `created_at`, `updated_at`) VALUES
  (1, 'f3d259ddd3ed8ff3843839b', 'user', '1', NULL, '2018-01-17 06:23:17', '2018-01-17 06:23:17'),
  (2, 'f3d259ddd3ed8ff3843839b', 'user', '1', NULL, '2018-01-17 06:26:50', '2018-01-17 06:26:50'),
  (3, 'f3d259ddd3ed8ff3843839b', 'user', '1', NULL, '2018-01-17 06:26:54', '2018-01-17 06:26:54'),
  (4, 'f3d259ddd3ed8ff3843839b', 'user', '1', NULL, '2018-01-17 06:27:30', '2018-01-17 06:27:30'),
  (5, 'f3d259ddd3ed8ff3843839b', 'user', '1', NULL, '2018-01-17 06:29:23', '2018-01-17 06:29:23');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `oauth_session_scopes`
  --
  
  CREATE TABLE `oauth_session_scopes` (
    `id` int(10) UNSIGNED NOT NULL,
    `session_id` int(10) UNSIGNED NOT NULL,
    `scope_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'test user', 'test@test.com', '$2y$10$EYIdjZBcP5ZwJ3KAKOXEpupqYbhbUsCyFRK0GFabi3H7pCHf5unCm', NULL, '2018-01-17 06:03:39', '2018-01-17 06:03:39');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `oauth_access_tokens`
  --
  ALTER TABLE `oauth_access_tokens`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `oauth_access_tokens_id_session_id_unique` (`id`,`session_id`),
    ADD KEY `oauth_access_tokens_session_id_index` (`session_id`);
  
  --
  -- Indexes for table `oauth_access_token_scopes`
  --
  ALTER TABLE `oauth_access_token_scopes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_access_token_scopes_access_token_id_index` (`access_token_id`),
    ADD KEY `oauth_access_token_scopes_scope_id_index` (`scope_id`);
  
  --
  -- Indexes for table `oauth_auth_codes`
  --
  ALTER TABLE `oauth_auth_codes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_auth_codes_session_id_index` (`session_id`);
  
  --
  -- Indexes for table `oauth_auth_code_scopes`
  --
  ALTER TABLE `oauth_auth_code_scopes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_auth_code_scopes_auth_code_id_index` (`auth_code_id`),
    ADD KEY `oauth_auth_code_scopes_scope_id_index` (`scope_id`);
  
  --
  -- Indexes for table `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `oauth_clients_id_secret_unique` (`id`,`secret`);
  
  --
  -- Indexes for table `oauth_client_endpoints`
  --
  ALTER TABLE `oauth_client_endpoints`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `oauth_client_endpoints_client_id_redirect_uri_unique` (`client_id`,`redirect_uri`);
  
  --
  -- Indexes for table `oauth_client_grants`
  --
  ALTER TABLE `oauth_client_grants`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_client_grants_client_id_index` (`client_id`),
    ADD KEY `oauth_client_grants_grant_id_index` (`grant_id`);
  
  --
  -- Indexes for table `oauth_client_scopes`
  --
  ALTER TABLE `oauth_client_scopes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_client_scopes_client_id_index` (`client_id`),
    ADD KEY `oauth_client_scopes_scope_id_index` (`scope_id`);
  
  --
  -- Indexes for table `oauth_grants`
  --
  ALTER TABLE `oauth_grants`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `oauth_grant_scopes`
  --
  ALTER TABLE `oauth_grant_scopes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_grant_scopes_grant_id_index` (`grant_id`),
    ADD KEY `oauth_grant_scopes_scope_id_index` (`scope_id`);
  
  --
  -- Indexes for table `oauth_refresh_tokens`
  --
  ALTER TABLE `oauth_refresh_tokens`
    ADD PRIMARY KEY (`access_token_id`),
    ADD UNIQUE KEY `oauth_refresh_tokens_id_unique` (`id`);
  
  --
  -- Indexes for table `oauth_scopes`
  --
  ALTER TABLE `oauth_scopes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `oauth_sessions`
  --
  ALTER TABLE `oauth_sessions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_sessions_client_id_owner_type_owner_id_index` (`client_id`,`owner_type`,`owner_id`);
  
  --
  -- Indexes for table `oauth_session_scopes`
  --
  ALTER TABLE `oauth_session_scopes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_session_scopes_session_id_index` (`session_id`),
    ADD KEY `oauth_session_scopes_scope_id_index` (`scope_id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`),
    ADD KEY `password_resets_token_index` (`token`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `oauth_access_token_scopes`
  --
  ALTER TABLE `oauth_access_token_scopes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_auth_code_scopes`
  --
  ALTER TABLE `oauth_auth_code_scopes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_client_endpoints`
  --
  ALTER TABLE `oauth_client_endpoints`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_client_grants`
  --
  ALTER TABLE `oauth_client_grants`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_client_scopes`
  --
  ALTER TABLE `oauth_client_scopes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_grant_scopes`
  --
  ALTER TABLE `oauth_grant_scopes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `oauth_sessions`
  --
  ALTER TABLE `oauth_sessions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `oauth_session_scopes`
  --
  ALTER TABLE `oauth_session_scopes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
  --
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_access_tokens`
  --
  ALTER TABLE `oauth_access_tokens`
    ADD CONSTRAINT `oauth_access_tokens_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_access_token_scopes`
  --
  ALTER TABLE `oauth_access_token_scopes`
    ADD CONSTRAINT `oauth_access_token_scopes_access_token_id_foreign` FOREIGN KEY (`access_token_id`) REFERENCES `oauth_access_tokens` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `oauth_access_token_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_auth_codes`
  --
  ALTER TABLE `oauth_auth_codes`
    ADD CONSTRAINT `oauth_auth_codes_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_auth_code_scopes`
  --
  ALTER TABLE `oauth_auth_code_scopes`
    ADD CONSTRAINT `oauth_auth_code_scopes_auth_code_id_foreign` FOREIGN KEY (`auth_code_id`) REFERENCES `oauth_auth_codes` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `oauth_auth_code_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_client_endpoints`
  --
  ALTER TABLE `oauth_client_endpoints`
    ADD CONSTRAINT `oauth_client_endpoints_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_client_grants`
  --
  ALTER TABLE `oauth_client_grants`
    ADD CONSTRAINT `oauth_client_grants_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
    ADD CONSTRAINT `oauth_client_grants_grant_id_foreign` FOREIGN KEY (`grant_id`) REFERENCES `oauth_grants` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_client_scopes`
  --
  ALTER TABLE `oauth_client_scopes`
    ADD CONSTRAINT `oauth_client_scopes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `oauth_client_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_grant_scopes`
  --
  ALTER TABLE `oauth_grant_scopes`
    ADD CONSTRAINT `oauth_grant_scopes_grant_id_foreign` FOREIGN KEY (`grant_id`) REFERENCES `oauth_grants` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `oauth_grant_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_refresh_tokens`
  --
  ALTER TABLE `oauth_refresh_tokens`
    ADD CONSTRAINT `oauth_refresh_tokens_access_token_id_foreign` FOREIGN KEY (`access_token_id`) REFERENCES `oauth_access_tokens` (`id`) ON DELETE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_sessions`
  --
  ALTER TABLE `oauth_sessions`
    ADD CONSTRAINT `oauth_sessions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Ketidakleluasaan untuk tabel `oauth_session_scopes`
  --
  ALTER TABLE `oauth_session_scopes`
    ADD CONSTRAINT `oauth_session_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `oauth_session_scopes_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  