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

START TRANSACTION;



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

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `session_id` bigint(20) UNSIGNED NOT NULL,
  `question` longtext NOT NULL,
  `answer` longtext DEFAULT 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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `free_tokens`
--

CREATE TABLE `free_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokens` int(11) 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 `free_tokens`
--

INSERT INTO `free_tokens` (`id`, `tokens`, `created_at`, `updated_at`) VALUES
(1, 100, NULL, '2023-07-27 02:18:19');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_07_09_100607_create_tokens_table', 1),
(6, '2023_07_09_121011_create_sessions_table', 2),
(7, '2023_07_10_054148_create_chats_table', 3),
(8, '2023_07_10_060635_create_admins_table', 4),
(9, '2023_07_11_103437_create_packeg_table', 5),
(10, '2023_07_11_105434_create_packeg_table', 6),
(11, '2023_07_11_122450_add_pack_id_to_users', 7),
(12, '2023_07_12_092220_add_buy_psck_date_to_users', 8),
(13, '2023_07_12_104033_add_expiar_date_psck_date_to_users', 9),
(14, '2023_07_13_055056_create_setting_table', 10),
(15, '2023_07_13_104427_create_notification_table', 11),
(16, '2023_07_13_110349_create_device_tokens_table', 11),
(17, '2023_07_13_111528_create_device_tokens_table', 12),
(18, '2023_07_22_112412_add_fildes_settings', 13),
(19, '2023_07_22_113527_add_fildes_f_settings', 14),
(20, '2023_07_26_113608_create_free_tokens_table', 15),
(21, '2023_07_26_124538_create_free_tokens_table', 16),
(22, '2023_07_27_072706_add_sms_fields_to_settings_table', 17),
(23, '2023_07_30_073727_status_fields_to_packegs_table', 18),
(24, '2023_07_30_081826_add_pack_name_fields_to_users_table', 19),
(25, '2023_07_30_100010_tokens_field_to_settings_table', 20),
(26, '2023_07_31_100052_add_user_id_to_device_tokens', 21),
(27, '2023_08_01_111556_promte_link_fields_to_settings_table', 22),
(28, '2023_08_13_062557_add_new_registaion_field_users_table', 23),
(29, '2023_08_14_055218_add_dield_carecter_limit_package_table', 24),
(30, '2023_08_14_061419_create_prompts_categories_table', 25),
(31, '2023_08_14_072820_create_new_prompts_table', 26),
(32, '2023_08_14_111012_create_tokens_prichings_table', 27),
(33, '2023_08_17_064735_add_buy_tokens_to_tokens_table', 28),
(34, '2023_08_26_055355_add_init_credits_credits_count_to_tokens_table', 28),
(35, '2023_08_28_092731_add_contract_url_table', 28),
(36, '2023_08_31_075730_change_tokens_table', 29),
(40, '2023_11_01_104218_create_advertisements_table', 30),
(43, '2023_11_05_071114_create_servers_table', 31);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `image_url` varchar(255) 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 `notifications`
--

INSERT INTO `notifications` (`id`, `title`, `message`, `url`, `image_url`, `created_at`, `updated_at`) VALUES
(1, 'dsfsd', 'sdfsd', 'sdfsd', 'sdfsd', '2023-07-13 05:16:40', '2023-07-13 05:16:40'),
(2, 'ttt', 'tttt', 'https://www.figma.com/file/Ji6do7juSLi4Wrjy1uri3m/Pet-Project?type=design&node-id=0-1&mode=design&t=YR1rJlpAxQk3TRFu-0', 'https://previews.123rf.com/images/artshock/artshock1210/artshock121000046/15557821-imag-of-water-drops-on-window-and-blue-sky-background.jpg', '2023-07-30 05:50:57', '2023-07-30 05:50:57'),
(3, 'Mijan test', 'final', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:36:38', '2023-07-31 03:36:38'),
(4, 'from admin', 'mijan', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:37:46', '2023-07-31 03:37:46'),
(5, 'from admin', 'mijan', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:38:28', '2023-07-31 03:38:28'),
(6, 'jjjjjj', 'jjjjjjj', '', '', '2023-07-31 03:42:32', '2023-07-31 03:42:32'),
(7, 'ppppp', 'mmmmmm', '', '', '2023-07-31 03:42:55', '2023-07-31 03:42:55'),
(8, 'from admin', 'test', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:43:19', '2023-07-31 03:43:19'),
(9, 'tttt', 'tttttt', '', '', '2023-07-31 03:45:28', '2023-07-31 03:45:28'),
(10, 'sadas', 'asdas', '', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:45:54', '2023-07-31 03:45:54'),
(11, 'rrr', 'rrrrr', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:49:11', '2023-07-31 03:49:11'),
(12, 'eee', 'eeee', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 03:49:34', '2023-07-31 03:49:34'),
(13, 'alfas', 'afasf', '', '', '2023-07-31 03:52:43', '2023-07-31 03:52:43'),
(14, 'dfgfdg', 'dgdfgdf', '', '', '2023-07-31 04:05:19', '2023-07-31 04:05:19'),
(15, 'gdfgdfg', 'dfgdfgdfgdf', '', '', '2023-07-31 04:05:58', '2023-07-31 04:05:58'),
(16, 'dfsf', 'sdfdsf', '', '', '2023-07-31 04:13:30', '2023-07-31 04:13:30'),
(17, 'dasd', 'dsfsdf', '', '', '2023-07-31 04:14:04', '2023-07-31 04:14:04'),
(18, 'sdfdsf', 'ssdfdsfdsfdsfsdf', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 04:17:50', '2023-07-31 04:17:50'),
(19, 'asdasd', 'asdasd', 'http://192.168.68.113:8000/product', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 04:23:35', '2023-07-31 04:23:35'),
(20, 'asdasd', 'asdasd', 'http://192.168.68.113:8000/product', 'https://dfstudio-d420.kxcdn.com/wordpress/wp-content/uploads/2019/06/digital_camera_photo-980x653.jpg', '2023-07-31 04:24:51', '2023-07-31 04:24:51'),
(21, 'hgfhfg', 'dhdfhdf', '', '', '2023-07-31 04:27:02', '2023-07-31 04:27:02'),
(22, 'gfdgfd', 'dgdfgdfg', '', '', '2023-07-31 04:27:36', '2023-07-31 04:27:36'),
(23, 'gdgdf', 'dgfdgfd', '', '', '2023-07-31 04:28:10', '2023-07-31 04:28:10'),
(24, 'asdas', 'asdasd', '', '', '2023-07-31 04:30:27', '2023-07-31 04:30:27'),
(25, 'asd', 'dsadas', '', '', '2023-07-31 04:30:36', '2023-07-31 04:30:36');

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

--
-- Table structure for table `packegs`
--

CREATE TABLE `packegs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `token_amout` varchar(255) NOT NULL,
  `pak_dua` varchar(255) NOT NULL,
  `pak_pric` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `carecte_limit` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packegs`
--

INSERT INTO `packegs` (`id`, `name`, `product_id`, `token_amout`, `pak_dua`, `pak_pric`, `created_at`, `updated_at`, `status`, `carecte_limit`) VALUES
(1, 'Product One', 'asfasasfa', '10000', '3', '100', NULL, '2023-08-13 23:58:52', 'active', 100),
(2, 'Product Two11', 'sdfdfsdfsdfsd', '13300', '6', '100', '2023-07-11 11:01:22', '2023-11-02 01:44:31', 'inactive', 90),
(3, 'Product Three', 'sd4444444', '13300', '6', '100', '2023-07-11 11:01:22', '2023-11-02 01:44:28', 'inactive', 78);

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

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

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `prompts`
--

CREATE TABLE `prompts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `prompts_categories_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `details` varchar(255) 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 `prompts`
--

INSERT INTO `prompts` (`id`, `prompts_categories_id`, `title`, `image_url`, `details`, `created_at`, `updated_at`) VALUES
(12, 8, 'Where to travel1', 'prompt_images/1698922407_Locomotive.png', 'Travelling across us is summer season.', '2023-11-02 04:53:27', '2023-11-04 12:43:52'),
(13, 13, 'Who loves popcorn11', 'prompt_images/1699123460_logo.jpg.jfif', 'Making popcorn from scratch can be tricky', '2023-11-02 04:56:06', '2023-11-04 12:44:20'),
(14, 9, 'Who doesn\'t love fun', 'prompt_images/1698923355_Sunset.png', 'Something that provides mirth or amusement', '2023-11-02 04:57:41', '2023-11-02 05:09:15');

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

--
-- Table structure for table `prompts_categories`
--

CREATE TABLE `prompts_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `flag_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prompts_categories`
--

INSERT INTO `prompts_categories` (`id`, `name`, `created_at`, `updated_at`, `flag_name`) VALUES
(8, 'Pakistann', '2023-11-02 04:50:09', '2023-11-05 00:06:26', 'uploads/image/1699126143_137.istockphoto-1069756720-612x612.jpg'),
(9, 'India', '2023-11-02 04:50:18', '2023-11-04 13:27:55', 'uploads/image/1699126075_935.download.jpg'),
(10, 'Bangladesh', '2023-11-02 04:50:28', '2023-11-04 13:29:23', 'uploads/image/1699126163_241.Flag-Bangladesh.webp'),
(13, 'Afghanistan', '2023-11-02 04:54:08', '2023-11-04 13:30:23', 'uploads/image/1699126223_441.download.png');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) 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 `tokens`
--

CREATE TABLE `tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `token_status` varchar(255) NOT NULL,
  `init_credits` int(11) DEFAULT 0,
  `credits_count` int(11) DEFAULT 0,
  `tokens_buy` int(11) DEFAULT 0,
  `token_count` int(11) 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 `tokens`
--

INSERT INTO `tokens` (`id`, `user_id`, `token_status`, `init_credits`, `credits_count`, `tokens_buy`, `token_count`, `created_at`, `updated_at`) VALUES
(45, 50, 'pro', 166, 1, 13300, 12173, '2023-08-31 02:17:13', '2023-08-31 02:21:50');

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

--
-- Table structure for table `tokens_prichings`
--

CREATE TABLE `tokens_prichings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `tokens` varchar(255) NOT NULL,
  `google_p_id` varchar(255) NOT NULL,
  `price` varchar(255) 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 `tokens_prichings`
--

INSERT INTO `tokens_prichings` (`id`, `name`, `tokens`, `google_p_id`, `price`, `created_at`, `updated_at`) VALUES
(1, 'ttttdfd', '343', 'sdsdfsdf', '1000', '2023-08-14 05:43:49', '2023-08-14 05:54:41'),
(3, 'tttt', '18888', 'gfhfgnh', '134543', '2023-08-24 05:15:10', '2023-08-24 05:15:10'),
(4, 'etrgvcb', '2345435', 'ffghfgfg', '11111', '2023-08-24 05:15:24', '2023-08-24 05:15:24'),
(5, 'fghgfhfghgfh', '1543', 'fvcbfchgfhfgh', '1245', '2023-08-24 05:15:39', '2023-08-24 05:15:39'),
(6, 'fvcb', '124356', 'hfgbv fg', '43534', '2023-08-24 05:15:51', '2023-08-24 05:15:51');

--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chats_user_id_foreign` (`user_id`),
  ADD KEY `chats_session_id_foreign` (`session_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `prompts`
--
ALTER TABLE `prompts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `prompts_prompts_categories_id_foreign` (`prompts_categories_id`);

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

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

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

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

--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `free_tokens`
--
ALTER TABLE `free_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `packegs`
--
ALTER TABLE `packegs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `prompts`
--
ALTER TABLE `prompts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `prompts_categories`
--
ALTER TABLE `prompts_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `sessions`
--
ALTER TABLE `sessions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `tokens`
--
ALTER TABLE `tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `tokens_prichings`
--
ALTER TABLE `tokens_prichings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `chats`
--
ALTER TABLE `chats`
  ADD CONSTRAINT `chats_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`),
  ADD CONSTRAINT `chats_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `prompts`
--
ALTER TABLE `prompts`
  ADD CONSTRAINT `prompts_prompts_categories_id_foreign` FOREIGN KEY (`prompts_categories_id`) REFERENCES `prompts_categories` (`id`);

--
-- Constraints for table `sessions`
--
ALTER TABLE `sessions`
  ADD CONSTRAINT `sessions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `tokens`
--
ALTER TABLE `tokens`
  ADD CONSTRAINT `tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

