-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ucview`
--

-- --------------------------------------------------------

--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `auth_token`
--

CREATE TABLE `auth_token` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `email` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expire_in` int(255) NOT NULL,
  `tokenGetTime` datetime NOT NULL,
  `provider` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_token` mediumtext COLLATE utf8mb4_unicode_ci,
  `refresh_token` mediumtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_token`
--

INSERT INTO `auth_token` (`id`, `user_id`, `email`, `expire_in`, `tokenGetTime`, `provider`, `access_token`, `refresh_token`, `created_at`, `updated_at`) VALUES
(1, 2, 'Yoritan@ucview.com', 3599, '2017-09-21 21:45:30', 'graph', 'eyJ0eXAiOiJKV1QiLCJub25jZSI6IkFRQUJBQUFBQUFBQmxEcnFmRUZsU2F1aTZ4blJqWDVFYmJ2cVYwSkUtYkt3UWxUYUlTa0l4TzdHN1BKOUlMcFFRVUIwb05haXJRYlQ2VFEwSnM3dHFRWVduNy1OLXA2b21McENDQy1SbHJUMWs5d1p0OFo2M3lBQSIsImFsZyI6IlJTMjU2IiwieDV0IjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIiwia2lkIjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIn0.eyJhdWQiOiJodHRwczovL2dyYXBoLm1pY3Jvc29mdC5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC82Mzk5YzAyYS1lYThhLTQxNmMtYjRiOS0zZDI1ZDU4OGYxNTMvIiwiaWF0IjoxNTA2MDI2NDMzLCJuYmYiOjE1MDYwMjY0MzMsImV4cCI6MTUwNjAzMDMzMywiYWNyIjoiMSIsImFpbyI6IkFTUUEyLzhGQUFBQVppbDhvaHJnYnphNXFtMVAwZnJlOHpTRG5Ba0JtNi9pNXBCMS90bEkvVzg9IiwiYW1yIjpbInB3ZCJdLCJhcHBfZGlzcGxheW5hbWUiOiJvZmZpY2UgMzY1IiwiYXBwaWQiOiJlN2FlZGY2NC1hMGVmLTQ5YzMtOTAxNi1jMWRlNDA2MmE3NzUiLCJhcHBpZGFjciI6IjEiLCJmYW1pbHlfbmFtZSI6IldlaW5iZXJnZXIiLCJnaXZlbl9uYW1lIjoiWW9uYXRhbiIsImlwYWRkciI6IjE3NS4xMTAuNDkuNzEiLCJuYW1lIjoiWW9uYXRhbiBXZWluYmVyZ2VyIiwib2lkIjoiYTNlMWZhMTctMTIxZC00MWU5LWExYzUtZmI5MDJiMWYwZjg5IiwicGxhdGYiOiI1IiwicHVpZCI6IjEwMDMwMDAwOTU1NEJFQzIiLCJzY3AiOiJDYWxlbmRhcnMuUmVhZCBVc2VyLlJlYWQgVXNlci5SZWFkLkFsbCIsInN1YiI6IjRxclZTcGJWMU13Zld5VDZWRFJ2bnJxVnExS1puMGxLY2tvMmp0TnR3b3ciLCJ0aWQiOiI2Mzk5YzAyYS1lYThhLTQxNmMtYjRiOS0zZDI1ZDU4OGYxNTMiLCJ1bmlxdWVfbmFtZSI6IllvbmF0YW5AdWN2aWV3LmNvbSIsInVwbiI6IllvbmF0YW5AdWN2aWV3LmNvbSIsInV0aSI6ImdwZTFPa2NTNDBhR0dhZWZ6N3diQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0NWUxMCJdfQ.Iqx6yhzkF7Gm0MeXqRCdo8oNMbincXU2MKj21RtMfTJiPVX7w8IE3JTKyWrgS-hTDm_3gX64Qdfq_piC981C97yITn7j8DNfXWb9-_5FgPErQlBhsLU3NkndDKULmwn_vNfZNRVNDTIBDVxy1EmgjNI_j2UZ8G6MDpid2FGeApZrUUZ1pGlDDeXg2l5Se1QjgBwBFcpLA9EeociyQk0yOSkLZGHtf2d7yyhjYq5-bAi1K0HfsItFVdgXhhkeSEBEHOacFAGCsSKAnuWwjCjHQkW7dBgAxoUQoZMFpfFRetdTbj9mGVQXmeyVmlkyaMQ6vJSkyLXAL2KGErvD0QCNXw', 'OAQABAAAAAAABlDrqfEFlSaui6xnRjX5EXjhPz_RHDVwJMJW885AkCuzf6WCGPA-AFYmmPrb3w8oPsEAebuMHPfoiNUnM8wew6VsqdJdU9Jqp79UG4mZAjgbQ-wqn-VzlouxONGmCS4TZhWDijE5PG3j5hJrw5YpD5eNfdmH0BqrUp5L1B1zmFT3vX5IMRJFC6yikj2i1gkCPWi0z1kKDvp2j4nhUfjVlNCXJYh5iah_HOGz3SO7386ewx_TjBIGpSYjhw79mKDixhOr7dVvDUWx9Hy4ksLMR3IqisBpuHNSjHFsgVvbRG-ZY98hMrmWjt6OEIcMtMzbjGirM1FlOmyshGJnRsSKp5ySkauF0WHbUfyo_ljA5OQnU3s5Z2p4Z-De_1cAVo4ZFEw5XdZscb8vU8Q2rvzLBDyc2KqxHIdzGR3G4wRf76jlpqbqief6TUUZFSQPs9wkuyNw2_dxdiu759-XUF39v9Fd8-V7ubpSpq4ni9z2IowGxlol6bawWpGDcLzLv_Ibj8i_CCkxeBaexQN-QV1GsuTk8IYSVYF1NcSYwu4CfFYdIQXHlruYzvVQ3HvEA330ga1Nuyu8GgH6aRz_XwJ0hj5fbN-1f7cC0w4aXAXTldgqPqurf33GoJmbl2cpkJfk1u0dJ6_tqLLPtXfPRPxSPKz6Pj9POzZFy9kONiYZgFzsvY9MHYWjUE5dqzQS0EIGLg7_RdMBMgvM4BdKO4K2HTLujbbiqgj1xVjm5eo5BWKHfAAVA7ROHtFd1jkXYDm2InuNBFt_BYZZEV7iIJ3apGXs59PlKBA6hYLzRIhUKUiAA', '2017-09-21 19:00:00', '2017-09-21 16:45:30'),
(8, 5, 'Yonatan@ucview.com', 3599, '2017-09-22 00:49:32', 'graph', 'eyJ0eXAiOiJKV1QiLCJub25jZSI6IkFRQUJBQUFBQUFBQmxEcnFmRUZsU2F1aTZ4blJqWDVFbEdJTXRXSzBRMTR3US1PNkNxbDFKOXpxeGJwN2ZwbnJ4TDB1eEdCdkw4SU5LTjNHREo0bjEteXVFLWRlTDBETzB2ZFhZSlNRTzlQaXRkckp1MkxqNHlBQSIsImFsZyI6IlJTMjU2IiwieDV0IjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIiwia2lkIjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIn0.eyJhdWQiOiJodHRwczovL2dyYXBoLm1pY3Jvc29mdC5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC82Mzk5YzAyYS1lYThhLTQxNmMtYjRiOS0zZDI1ZDU4OGYxNTMvIiwiaWF0IjoxNTA2MDQxMDY4LCJuYmYiOjE1MDYwNDEwNjgsImV4cCI6MTUwNjA0NDk2OCwiYWNyIjoiMSIsImFpbyI6IlkyVmdZTGh6MVhhdGo5MmZmNWtoamN6MmlkVjlGazh2OGhzZXFtUGJwSlNjMTM1MmZnWUEiLCJhbXIiOlsicHdkIl0sImFwcF9kaXNwbGF5bmFtZSI6Im9mZmljZSAzNjUiLCJhcHBpZCI6ImU3YWVkZjY0LWEwZWYtNDljMy05MDE2LWMxZGU0MDYyYTc3NSIsImFwcGlkYWNyIjoiMSIsImZhbWlseV9uYW1lIjoiV2VpbmJlcmdlciIsImdpdmVuX25hbWUiOiJZb25hdGFuIiwiaXBhZGRyIjoiMTc1LjExMC40OS43MSIsIm5hbWUiOiJZb25hdGFuIFdlaW5iZXJnZXIiLCJvaWQiOiJhM2UxZmExNy0xMjFkLTQxZTktYTFjNS1mYjkwMmIxZjBmODkiLCJwbGF0ZiI6IjUiLCJwdWlkIjoiMTAwMzAwMDA5NTU0QkVDMiIsInNjcCI6IkNhbGVuZGFycy5SZWFkIFVzZXIuUmVhZCBVc2VyLlJlYWQuQWxsIiwic3ViIjoiNHFyVlNwYlYxTXdmV3lUNlZEUnZucnFWcTFLWm4wbEtja28yanROdHdvdyIsInRpZCI6IjYzOTljMDJhLWVhOGEtNDE2Yy1iNGI5LTNkMjVkNTg4ZjE1MyIsInVuaXF1ZV9uYW1lIjoiWW9uYXRhbkB1Y3ZpZXcuY29tIiwidXBuIjoiWW9uYXRhbkB1Y3ZpZXcuY29tIiwidXRpIjoiNjdZczlOa084VUtJNGZ6d3IzSWtBQSIsInZlciI6IjEuMCIsIndpZHMiOlsiNjJlOTAzOTQtNjlmNS00MjM3LTkxOTAtMDEyMTc3MTQ1ZTEwIl19.f8CC4zkByERiw_3kS-E7kvfYDNsoaa2wLPV-FN1GJU3ohhgaidyUNpfKuKJ9-2sn6uKU4RjFCkuI2vjzIvIHaKo9QQEmV5iffmxBpGI67fia8sSVXjJzyt_IFhIQ68FbL2DphWsrseaJ6pDENhdUyalFs053U_G7ABrd5aS8iZjZmGbvyAlBLuoOLdZ_FRn3ZA1OR6_MwSZcN5S-A2qt5hJxgE2BtveWpVemQLuQW1rxJcA4oZ9Wzf-h_fcFQV4b-i17jgfRjcC2NuYO00EeYxKBQPt21MCImEI3Va5Uw6xMYzrpfEoNK0ZWHwmOmBJgMj1L4u5UxO17ccGgWy5mjw', 'OAQABAAAAAAABlDrqfEFlSaui6xnRjX5Ehr-vQoqcGR7cyOYpNVrxGPSdwoO3F0sJR94i8ngZmtHcsTGv-HUpMm2kBES-OrIE_6afRXJLe4DNhdFRD6mCnf4JTWNvONMy9sMADZeyyIrurjkPHMpUCvPd78-o850onz-DRGgPXZ6c4LwLFOy61vvuUsgEmPJQOaDk6GUIYl_LcGXj1ceYepMc4iQjjbewnjhpHSa45OxYNev52tzy1B4ZxmAjm-ydD6Kx17zmurU6CyP64fy_3RJGQhtfXhroqR254qSQhtEvblX53eH8c2Qcl4uWsncPFdMghuOEckv5y7_a1gopB-P9s7wCsRUeCBz8w_Kr6OTdso-2jdjYgF-Zun2qAguI3Wec_V2dqqAIob_q7VR4Bh1TY6Jq3Fr3AvyaZdie5MRaXDBrCYdhvNvw5kDnLUhte6K5uNu4Vr55qRxgYSW9olcNuQMhtK2X4hCmHUXqcbaJoenz3tA7sO8Ymoo3hW-8yI2yw4n7PpMw-NciuD2MFQhob3OL6I5GNooZswTUUQfsIpKzhvyquju4dRWVqVSQdRnJYwGq3wpuNmFTXF-ak3M8nMKisw6GHB1nvWloXV8gl_IVh1QtuZ2kDiIsBgbPVC1NADKyMaOmsYE6bMg81DvqhvYZ1FXLJAJPSUTum23GcK-S-OURmn4FWtQIzkUF7nssWeWxIovairFd-ETnBAWBt7Nmt_wlzw-lEkou6CusbacjXlto0JTx8LxxPcNhuJSfcJHPUDu7eyc85z5JGDp4U0MbwisCO_ysJCQwaYbTc7oQlS0jjkJvwb7V8S29NrLYG4usRfMgAA', '2017-09-21 19:49:32', '2017-09-21 19:49:32'),
(11, 1, 'Yonatan@ucview.com', 3599, '2017-09-22 00:54:02', 'graph', 'eyJ0eXAiOiJKV1QiLCJub25jZSI6IkFRQUJBQUFBQUFBQmxEcnFmRUZsU2F1aTZ4blJqWDVFb0pBUEZVYjVSY0VQUjBIMjhhQlJVSk9zUnBTSFRmXy1ySlMxcXBQRTNheGVOakFMTkxUa0NoRFpSWHVhbXRwSXg4Z1R0dFg3UzVaNTJyeGJ6czUyNUNBQSIsImFsZyI6IlJTMjU2IiwieDV0IjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIiwia2lkIjoiSEhCeUtVLTBEcUFxTVpoNlpGUGQyVldhT3RnIn0.eyJhdWQiOiJodHRwczovL2dyYXBoLm1pY3Jvc29mdC5jb20iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC82Mzk5YzAyYS1lYThhLTQxNmMtYjRiOS0zZDI1ZDU4OGYxNTMvIiwiaWF0IjoxNTA2MDQxMzQwLCJuYmYiOjE1MDYwNDEzNDAsImV4cCI6MTUwNjA0NTI0MCwiYWNyIjoiMSIsImFpbyI6IkFTUUEyLzhGQUFBQXhldlUrV0lhdURIckFTdzRBdmtwMVh1UHVQOXRTQzdnZHJRdVFKZlZvb2M9IiwiYW1yIjpbInB3ZCJdLCJhcHBfZGlzcGxheW5hbWUiOiJvZmZpY2UgMzY1IiwiYXBwaWQiOiJlN2FlZGY2NC1hMGVmLTQ5YzMtOTAxNi1jMWRlNDA2MmE3NzUiLCJhcHBpZGFjciI6IjEiLCJmYW1pbHlfbmFtZSI6IldlaW5iZXJnZXIiLCJnaXZlbl9uYW1lIjoiWW9uYXRhbiIsImlwYWRkciI6IjE3NS4xMTAuNDkuNzEiLCJuYW1lIjoiWW9uYXRhbiBXZWluYmVyZ2VyIiwib2lkIjoiYTNlMWZhMTctMTIxZC00MWU5LWExYzUtZmI5MDJiMWYwZjg5IiwicGxhdGYiOiI1IiwicHVpZCI6IjEwMDMwMDAwOTU1NEJFQzIiLCJzY3AiOiJDYWxlbmRhcnMuUmVhZCBVc2VyLlJlYWQgVXNlci5SZWFkLkFsbCIsInN1YiI6IjRxclZTcGJWMU13Zld5VDZWRFJ2bnJxVnExS1puMGxLY2tvMmp0TnR3b3ciLCJ0aWQiOiI2Mzk5YzAyYS1lYThhLTQxNmMtYjRiOS0zZDI1ZDU4OGYxNTMiLCJ1bmlxdWVfbmFtZSI6IllvbmF0YW5AdWN2aWV3LmNvbSIsInVwbiI6IllvbmF0YW5AdWN2aWV3LmNvbSIsInV0aSI6Inh5QlBpRjFLYlV5VnVIbnJVTHNPQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbIjYyZTkwMzk0LTY5ZjUtNDIzNy05MTkwLTAxMjE3NzE0NWUxMCJdfQ.IowffL2P7vynnk5YQTF7fE8b-DT0VjyejNh1QVAJHtb174jST66kVIJf0P_1a8NQc6_gJWvEy98f9uhTAuHOQddmLIFV21BXTC6e6cOK_DJCgsUczLC48jUyNUMeI3bEB3ZzKfPZZ1wC8YZGhlw8PR8ImqwafstQiLKAHdqm39FxboBbzkBeAZ1a_Xk2ZH3o-YE3Qx8kMsX81iW16ZZj_msdZic1HxHwBru_74_CbaOvYZzYpzMY-dsk-aOo6s2bTfOvHiuGwSd_DCLdW9A66HF57MBN11XnJE5mKDRgHmyIBX2ZDMKeom7U5NtyhzkkSM5dO2Fslfj6r4Ul6NsoeA', 'OAQABAAAAAAABlDrqfEFlSaui6xnRjX5EmMaIrF5E8CkbUV1C1B3NRtNEpYVUxhZ_eA5tdJR8bxm8_3chlXEdKsLcH44NCnVkNFOPKkNoakJYj447GmVzaDJDX-Z5U70_aYwr9Sjwlns4T86Ab6q6OtnQU6ga_qosDCVhLYxbGKK8I2-4Dfye7JfKoV7nhrcUw0yc3Ye5x5UOMGQE_B1k_TPtdoCZBLDulzbEgPWnny6cHdu_GW_y-JSyow80-gg4UnxtfwPCrR-mPDUh-0Nhurl4rMLQ2F0K1310t5RiEbFob-1o1xwDWAjTwu52LdgAnhGCowGJAxfZpJHAlLyNrBsTp_L9DI3erYS29dw6MB3aqGG9eMMVAhov_L1bsakXUibKU7pn2gQnPI6YzgOlfaC-akVur9RqqdmwkxNHwJAX5QCkVe5IEebNp5zxuBC07PcWpof6-7F1ZXMNtRctN5O3uzklPZCMw_IJ6OguKB6JzeDv1FywGxrnZYD4hAUC60SVvgEqGmm_krYp7Vx_WisnCh3Wt8liyooOHzXh2raN7LUe7nlFhGMFEeptBNHKildRvW_9FCU1FOO25aGh9CeFi5xlqIOKlfCGI7O2Kj-yOzGkvjvgCl8phq0Petc4G7WzllSi84mK72-cdKPz67_Kq1sRINv7r6SN04U0opEytXbLaF6aE0LmFfEuZOad6jJcm2waDeSM5PCvix5s6bQWMwsi141Qozk0iVQdo3Y0QpS9FGxAYS-CnaH5wS8FxXBa7I_IzMrq1u7IwMeQcyiIYSZ2_Mc0lIQ0IjaULtXRRVG5o3kEkIQr2Z_iayyPgAzlBKHR6dogAA', '2017-09-21 19:54:02', '2017-09-21 19:54:02');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_15_105324_create_roles_table', 1),
(4, '2016_01_15_114412_create_role_user_table', 1),
(5, '2016_01_26_115212_create_permissions_table', 1),
(6, '2016_01_26_115523_create_permission_role_table', 1),
(7, '2016_02_09_132439_create_permission_user_table', 1),
(8, '2017_03_09_082449_create_social_logins_table', 1),
(9, '2017_03_09_082526_create_activations_table', 1),
(10, '2017_03_20_213554_create_themes_table', 1),
(11, '2017_03_21_042918_create_profiles_table', 1),
(12, '2017_09_19_193104_create_auth_token_table', 2);

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `slug`, `description`, `model`, `created_at`, `updated_at`) VALUES
(1, 'Can View Users', 'view.users', 'Can view users', 'Permission', '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(2, 'Can Create Users', 'create.users', 'Can create new users', 'Permission', '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(3, 'Can Edit Users', 'edit.users', 'Can edit users', 'Permission', '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(4, 'Can Delete Users', 'delete.users', 'Can delete users', 'Permission', '2017-09-13 07:58:38', '2017-09-13 07:58:38');

-- --------------------------------------------------------

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(2, 2, 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(3, 3, 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(4, 4, 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38');

-- --------------------------------------------------------

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `theme_id` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `twitter_username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `github_username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `theme_id`, `location`, `bio`, `twitter_username`, `github_username`, `avatar`, `avatar_status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(2, 2, 1, NULL, NULL, NULL, NULL, NULL, 0, '2017-09-13 07:58:39', '2017-09-13 07:58:39'),
(4, 4, 1, NULL, NULL, NULL, NULL, NULL, 0, '2017-09-19 13:59:55', '2017-09-19 13:59:55'),
(5, 5, 1, NULL, NULL, NULL, NULL, NULL, 0, '2017-09-21 19:47:46', '2017-09-21 19:47:46');

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `level`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', 'Admin Role', 5, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(2, 'User', 'user', 'User Role', 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38');

-- --------------------------------------------------------

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2017-09-13 07:58:38', '2017-09-13 07:58:38'),
(2, 2, 2, '2017-09-13 07:58:39', '2017-09-13 07:58:39'),
(4, 2, 4, '2017-09-19 13:59:55', '2017-09-19 13:59:55'),
(5, 2, 5, '2017-09-21 19:47:46', '2017-09-21 19:47:46');

-- --------------------------------------------------------

--
-- Table structure for table `social_logins`
--

CREATE TABLE `social_logins` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `provider` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `taggable_id` int(10) UNSIGNED NOT NULL,
  `taggable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `link`, `notes`, `status`, `taggable_id`, `taggable_type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Default', 'null', NULL, 1, 1, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(2, 'Darkly', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/darkly/bootstrap.min.css', NULL, 1, 2, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(3, 'Cyborg', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/cyborg/bootstrap.min.css', NULL, 1, 3, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(4, 'Cosmo', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/cosmo/bootstrap.min.css', NULL, 1, 4, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(5, 'Cerulean', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/cerulean/bootstrap.min.css', NULL, 1, 5, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(6, 'Flatly', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/flatly/bootstrap.min.css', NULL, 1, 6, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(7, 'Journal', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/journal/bootstrap.min.css', NULL, 1, 7, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(8, 'Lumen', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/lumen/bootstrap.min.css', NULL, 1, 8, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(9, 'Paper', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/paper/bootstrap.min.css', NULL, 1, 9, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(10, 'Readable', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/readable/bootstrap.min.css', NULL, 1, 10, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(11, 'Sandstone', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/sandstone/bootstrap.min.css', NULL, 1, 11, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(12, 'Simplex', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/simplex/bootstrap.min.css', NULL, 1, 12, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(13, 'Slate', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/slate/bootstrap.min.css', NULL, 1, 13, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(14, 'Spacelab', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/spacelab/bootstrap.min.css', NULL, 1, 14, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(15, 'Superhero', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/superhero/bootstrap.min.css', NULL, 1, 15, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(16, 'United', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/united/bootstrap.min.css', NULL, 1, 16, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(17, 'Yeti', 'https://maxcdn.bootstrapcdn.com/bootswatch/3.3.7/yeti/bootstrap.min.css', NULL, 1, 17, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(18, 'Bootstrap 4.0.0 Alpha', 'https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.6/css/bootstrap.min.css', NULL, 1, 18, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(19, 'Materialize', 'https://cdnjs.cloudflare.com/ajax/libs/materialize/0.98.0/css/materialize.min.css', NULL, 1, 19, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(20, 'Bootstrap Material Design 0.3.0', 'https://cdnjs.cloudflare.com/ajax/libs/bootstrap-material-design/0.3.0/css/material-fullpalette.min.css', NULL, 1, 20, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(21, 'Bootstrap Material Design 0.5.10', 'https://cdnjs.cloudflare.com/ajax/libs/bootstrap-material-design/0.5.10/css/bootstrap-material-design.min.css', NULL, 1, 21, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(22, 'Bootstrap Material Design 4.0.0', 'https://cdnjs.cloudflare.com/ajax/libs/bootstrap-material-design/4.0.0/bootstrap-material-design.min.css', NULL, 1, 22, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(23, 'Bootstrap Material Design 4.0.2', 'https://cdnjs.cloudflare.com/ajax/libs/bootstrap-material-design/4.0.2/bootstrap-material-design.min.css', NULL, 1, 23, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(24, 'mdbootstrap', 'https://cdnjs.cloudflare.com/ajax/libs/mdbootstrap/4.3.1/css/mdb.min.css', NULL, 1, 24, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(25, 'bootflat', 'https://cdnjs.cloudflare.com/ajax/libs/bootflat/2.0.4/css/bootflat.min.css', NULL, 1, 25, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(26, 'flat-ui', 'https://cdnjs.cloudflare.com/ajax/libs/flat-ui/2.3.0/css/flat-ui.min.css', NULL, 1, 26, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(27, 'm8tro-bootstrap', 'https://cdnjs.cloudflare.com/ajax/libs/m8tro-bootstrap/3.3.7/m8tro.min.css', NULL, 1, 27, 'theme', '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activated` tinyint(1) NOT NULL DEFAULT '0',
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `signup_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signup_confirmation_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signup_sm_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `first_name`, `last_name`, `email`, `password`, `remember_token`, `activated`, `token`, `signup_ip_address`, `signup_confirmation_ip_address`, `signup_sm_ip_address`, `admin_ip_address`, `updated_ip_address`, `deleted_ip_address`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'fhoppe', 'Donald', 'Kirlin', 'admin@admin.com', '$2y$10$zhbsSsPOOya0vVJsHiprCucYKqyNN2f9FIAQw67zJZSkA6jhoJBni', 'w0DA0uJRiq3jVYSwP6XDjZXWOG0E9YBaVwwIot3V30CdYprbcM97Mb532nui', 1, 'CGzxRlO7q0kPeMWbDrXeqSgKgx9O9SaXbmr7RSSIlSxYAgiQ0h9LPpqEqzhiCgIu', NULL, '39.164.227.230', NULL, '77.52.121.125', NULL, NULL, '2017-09-13 07:58:38', '2017-09-13 07:58:38', NULL),
(2, 'heidenreich.sarah', 'Rachelle', 'Daugherty', 'user@user.com', '$2y$10$ckwnq6wXSokpn4uwKaOoX.8.LxYiny9I/X2VmZlx2R.WK23d1OFdK', NULL, 1, 'i2FU3pkanbOX2l7hNA2DPjMON0T0BLuVzGZK5DNfkGnVDP02zP8YW0QRjbWPgI7z', '120.147.141.227', '105.151.13.235', NULL, NULL, NULL, '::1', '2017-09-13 07:58:39', '2017-09-21 18:52:32', '2017-09-21 18:52:32'),
(4, 'Abdul Mannan', 'Abdul Mannan', 'Asif', 'abdulmannan9@outlook.com', '$2y$10$1j8HI8ei8yg5CabThzhpB.JCU/J8XKbflZESUYOpN1UQHGi5IafT2', NULL, 1, 'nO0IuVs7AaXJxerhX6lhiwvI2yamjNUOLaNIUIi4nfXmkrYVjg79CwJ6gVoTRGS0', NULL, NULL, NULL, '::1', NULL, '::1', '2017-09-19 13:59:54', '2017-09-21 18:52:36', '2017-09-21 18:52:36'),
(5, 'AbdulMannan', 'Abdul Mannan', 'Asif', 'abdulmannanasif93@gmail.com', '$2y$10$e8Y0dWle4781w0glfzO2LeIopQgoaaU1z0eon4JUk32DYu.w6s.D2', 'he7k7cF9JA7P0APAl059TQ27JSTuegzcLdXLYMHxTKJKf4wDyjXE3BORyHJs', 1, 'UPPCDPcVyf7hG29caNTsRfSNJ3QuX6EwoNFgi3p1H5bH865RBRlR9i0JHYVMRhwx', NULL, NULL, NULL, '::1', NULL, NULL, '2017-09-21 19:47:46', '2017-09-21 19:47:46', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activations`
--
ALTER TABLE `activations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activations_user_id_index` (`user_id`);

--
-- Indexes for table `auth_token`
--
ALTER TABLE `auth_token`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_token_user_id_index` (`user_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `password_resets_email_index` (`email`),
  ADD KEY `password_resets_token_index` (`token`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_slug_unique` (`slug`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_user_permission_id_index` (`permission_id`),
  ADD KEY `permission_user_user_id_index` (`user_id`);

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profiles_theme_id_foreign` (`theme_id`),
  ADD KEY `profiles_user_id_index` (`user_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_user_role_id_index` (`role_id`),
  ADD KEY `role_user_user_id_index` (`user_id`);

--
-- Indexes for table `social_logins`
--
ALTER TABLE `social_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `social_logins_user_id_index` (`user_id`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `themes_name_unique` (`name`),
  ADD UNIQUE KEY `themes_link_unique` (`link`),
  ADD KEY `themes_taggable_id_taggable_type_index` (`taggable_id`,`taggable_type`),
  ADD KEY `themes_id_index` (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_name_unique` (`name`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activations`
--
ALTER TABLE `activations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `auth_token`
--
ALTER TABLE `auth_token`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `permission_role`
--
ALTER TABLE `permission_role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `permission_user`
--
ALTER TABLE `permission_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `profiles`
--
ALTER TABLE `profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `role_user`
--
ALTER TABLE `role_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `social_logins`
--
ALTER TABLE `social_logins`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `activations`
--
ALTER TABLE `activations`
  ADD CONSTRAINT `activations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `auth_token`
--
ALTER TABLE `auth_token`
  ADD CONSTRAINT `auth_token_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
  ADD CONSTRAINT `profiles_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`),
  ADD CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `social_logins`
--
ALTER TABLE `social_logins`
  ADD CONSTRAINT `social_logins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

