-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 01, 2023 at 04:01 PM -- Server version: 10.4.27-MariaDB -- PHP Version: 8.1.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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: `vue` -- -- -------------------------------------------------------- -- -- Table structure for table `amount_transfers` -- CREATE TABLE `amount_transfers` ( `id` bigint(20) UNSIGNED NOT NULL, `amount` int(11) NOT NULL, `transfer_type` enum('Tip','Deposit','Withdrawal') NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `game_id` bigint(20) UNSIGNED DEFAULT NULL, `status` enum('pending','processing','complete','cancel') NOT NULL DEFAULT 'pending', `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 `blocked_users` -- CREATE TABLE `blocked_users` ( `id` bigint(20) UNSIGNED NOT NULL, `blocked` varchar(255) NOT NULL, `user_id` bigint(20) 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 `contact_us` -- CREATE TABLE `contact_us` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `message` text 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 `credit_transfers` -- CREATE TABLE `credit_transfers` ( `id` bigint(20) UNSIGNED NOT NULL, `method_id` bigint(20) UNSIGNED NOT NULL, `expiry_time` varchar(255) DEFAULT NULL, `req_status` varchar(255) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `amount` varchar(255) DEFAULT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `plateform_id` bigint(20) UNSIGNED NOT NULL, `reciever_id` bigint(20) UNSIGNED NOT NULL, `time` timestamp NULL DEFAULT NULL, `extra_details` varchar(255) 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 `matched_offers` -- CREATE TABLE `matched_offers` ( `id` bigint(20) UNSIGNED NOT NULL, `buyer_id` bigint(20) UNSIGNED NOT NULL, `seller_id` bigint(20) UNSIGNED NOT NULL, `offer_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `price` double(8,2) NOT NULL, `payment_method` varchar(255) NOT NULL, `buyer_payment_details` varchar(255) DEFAULT NULL, `payment_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payment_details`)), `expire_time` varchar(255) NOT NULL, `report` tinyint(4) NOT NULL DEFAULT 0, `reported_credit_add` tinyint(4) NOT NULL DEFAULT 0, `reported_credit_sub` tinyint(4) NOT NULL DEFAULT 0, `payment_sent` tinyint(4) NOT NULL DEFAULT 0, `status` varchar(255) NOT NULL DEFAULT 'requested', `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 `messages` -- CREATE TABLE `messages` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `message` text 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 `methods` -- CREATE TABLE `methods` ( `id` bigint(20) UNSIGNED NOT NULL, `name` 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 `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, '2022_06_10_130903_create_offers_table', 1), (6, '2022_06_14_133907_create_messages_table', 1), (7, '2022_06_22_131818_create_methods_table', 1), (8, '2022_06_22_131914_create_offers_methods_table', 1), (9, '2022_06_23_090317_create_user_method_table', 1), (10, '2022_06_29_114458_create_permission_tables', 1), (11, '2022_07_15_125455_create_order_bies_table', 1), (12, '2022_07_15_130702_create_contact_us_table', 1), (13, '2022_07_22_151212_create_operators_table', 1), (14, '2022_09_09_105406_create_matched_offers_table', 1), (15, '2023_01_18_131749_create_plateforms_table', 1), (16, '2023_01_18_135122_create_blocked_users_table', 1), (17, '2023_01_18_153322_create_amount_transfers_table', 1), (18, '2023_01_19_104328_user_plateforms', 1), (19, '2023_01_19_162025_credit_transfers', 1), (20, '2023_01_26_084048_create_payment_methods_table', 1), (21, '2023_01_31_154000_create_transfer_options_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `model_has_permissions` -- CREATE TABLE `model_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `model_has_roles` -- CREATE TABLE `model_has_roles` ( `role_id` bigint(20) UNSIGNED NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `offers` -- CREATE TABLE `offers` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `price` int(11) NOT NULL, `requested_price` int(11) DEFAULT NULL, `match_user_id` bigint(20) UNSIGNED DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'open', `payment_method` int(11) 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 `offers_methods` -- CREATE TABLE `offers_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `offer_id` bigint(20) UNSIGNED NOT NULL, `method_id` 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 `operators` -- CREATE TABLE `operators` ( `id` bigint(20) UNSIGNED NOT NULL, `operator_id` bigint(20) UNSIGNED NOT NULL, `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; -- -------------------------------------------------------- -- -- Table structure for table `order_bies` -- CREATE TABLE `order_bies` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `offer_id` bigint(20) UNSIGNED NOT NULL, `match_user_id` bigint(20) UNSIGNED DEFAULT NULL, `seller_id` bigint(20) UNSIGNED DEFAULT NULL, `buyer_id` bigint(20) UNSIGNED DEFAULT NULL, `price` int(11) NOT NULL, `method` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'complete', `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 `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 `payment_methods` -- CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `field_name` varchar(255) NOT NULL, `type` enum('Email','Phone','Text','Number') NOT NULL, `method_id` bigint(20) 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 `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL 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 `plateforms` -- CREATE TABLE `plateforms` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `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; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `guard_name` 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 `role_has_permissions` -- CREATE TABLE `role_has_permissions` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transfer_options` -- CREATE TABLE `transfer_options` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `time_frame` varchar(255) NOT NULL, `min_limit` int(11) NOT NULL, `max_limit` int(11) NOT NULL, `frequency_count` int(11) NOT NULL, `frequency_amount` int(11) NOT NULL, `frequency_time` 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; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `username` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `facebookusername` varchar(255) DEFAULT NULL, `is_email_verified` tinyint(1) NOT NULL DEFAULT 0, `is_phone_verified` tinyint(1) NOT NULL DEFAULT 0, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `funds` double NOT NULL DEFAULT 0, `email_code` varchar(255) DEFAULT NULL, `image` varchar(255) NOT NULL DEFAULT 'http://localhost/zillas_top_swap/assets/images/dashboard-profile.png', `phone_code` varchar(255) DEFAULT NULL, `request_token` varchar(255) DEFAULT NULL, `reset_token` varchar(255) DEFAULT NULL, `isLogin` tinyint(1) NOT NULL DEFAULT 0, `isBusy` tinyint(1) NOT NULL DEFAULT 0, `status` tinyint(1) NOT NULL DEFAULT 1, `activity_at` timestamp NULL DEFAULT current_timestamp(), `device_token` text DEFAULT NULL, `remember_token` varchar(100) 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 `user_method` -- CREATE TABLE `user_method` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `method_id` varchar(255) NOT NULL, `fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`fields`)), `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 `user_plateforms` -- CREATE TABLE `user_plateforms` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `plateform_id` bigint(20) UNSIGNED NOT NULL, `mobile_id` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `amount_transfers` -- ALTER TABLE `amount_transfers` ADD PRIMARY KEY (`id`), ADD KEY `amount_transfers_user_id_foreign` (`user_id`), ADD KEY `amount_transfers_game_id_foreign` (`game_id`); -- -- Indexes for table `blocked_users` -- ALTER TABLE `blocked_users` ADD PRIMARY KEY (`id`), ADD KEY `blocked_users_user_id_foreign` (`user_id`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`id`), ADD KEY `contact_us_user_id_foreign` (`user_id`); -- -- Indexes for table `credit_transfers` -- ALTER TABLE `credit_transfers` ADD PRIMARY KEY (`id`), ADD KEY `credit_transfers_method_id_foreign` (`method_id`), ADD KEY `credit_transfers_user_id_foreign` (`user_id`), ADD KEY `credit_transfers_plateform_id_foreign` (`plateform_id`), ADD KEY `credit_transfers_reciever_id_foreign` (`reciever_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 `matched_offers` -- ALTER TABLE `matched_offers` ADD PRIMARY KEY (`id`), ADD KEY `matched_offers_buyer_id_foreign` (`buyer_id`), ADD KEY `matched_offers_seller_id_foreign` (`seller_id`); -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `methods` -- ALTER TABLE `methods` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `offers` -- ALTER TABLE `offers` ADD PRIMARY KEY (`id`), ADD KEY `offers_user_id_foreign` (`user_id`); -- -- Indexes for table `offers_methods` -- ALTER TABLE `offers_methods` ADD PRIMARY KEY (`id`), ADD KEY `offers_methods_offer_id_foreign` (`offer_id`); -- -- Indexes for table `operators` -- ALTER TABLE `operators` ADD PRIMARY KEY (`id`), ADD KEY `operators_operator_id_foreign` (`operator_id`); -- -- Indexes for table `order_bies` -- ALTER TABLE `order_bies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payment_methods` -- ALTER TABLE `payment_methods` ADD PRIMARY KEY (`id`), ADD KEY `payment_methods_method_id_foreign` (`method_id`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `plateforms` -- ALTER TABLE `plateforms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indexes for table `transfer_options` -- ALTER TABLE `transfer_options` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_phone_unique` (`phone`); -- -- Indexes for table `user_method` -- ALTER TABLE `user_method` ADD PRIMARY KEY (`id`), ADD KEY `user_method_user_id_foreign` (`user_id`); -- -- Indexes for table `user_plateforms` -- ALTER TABLE `user_plateforms` ADD PRIMARY KEY (`id`), ADD KEY `user_plateforms_user_id_foreign` (`user_id`), ADD KEY `user_plateforms_plateform_id_foreign` (`plateform_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `amount_transfers` -- ALTER TABLE `amount_transfers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blocked_users` -- ALTER TABLE `blocked_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `credit_transfers` -- ALTER TABLE `credit_transfers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `matched_offers` -- ALTER TABLE `matched_offers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `methods` -- ALTER TABLE `methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `offers` -- ALTER TABLE `offers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `offers_methods` -- ALTER TABLE `offers_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `operators` -- ALTER TABLE `operators` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_bies` -- ALTER TABLE `order_bies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_methods` -- ALTER TABLE `payment_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `plateforms` -- ALTER TABLE `plateforms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transfer_options` -- ALTER TABLE `transfer_options` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_method` -- ALTER TABLE `user_method` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_plateforms` -- ALTER TABLE `user_plateforms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `amount_transfers` -- ALTER TABLE `amount_transfers` ADD CONSTRAINT `amount_transfers_game_id_foreign` FOREIGN KEY (`game_id`) REFERENCES `plateforms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `amount_transfers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `blocked_users` -- ALTER TABLE `blocked_users` ADD CONSTRAINT `blocked_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `contact_us` -- ALTER TABLE `contact_us` ADD CONSTRAINT `contact_us_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `credit_transfers` -- ALTER TABLE `credit_transfers` ADD CONSTRAINT `credit_transfers_method_id_foreign` FOREIGN KEY (`method_id`) REFERENCES `methods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `credit_transfers_plateform_id_foreign` FOREIGN KEY (`plateform_id`) REFERENCES `plateforms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `credit_transfers_reciever_id_foreign` FOREIGN KEY (`reciever_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `credit_transfers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `matched_offers` -- ALTER TABLE `matched_offers` ADD CONSTRAINT `matched_offers_buyer_id_foreign` FOREIGN KEY (`buyer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `matched_offers_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `offers` -- ALTER TABLE `offers` ADD CONSTRAINT `offers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `offers_methods` -- ALTER TABLE `offers_methods` ADD CONSTRAINT `offers_methods_offer_id_foreign` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `operators` -- ALTER TABLE `operators` ADD CONSTRAINT `operators_operator_id_foreign` FOREIGN KEY (`operator_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `payment_methods` -- ALTER TABLE `payment_methods` ADD CONSTRAINT `payment_methods_method_id_foreign` FOREIGN KEY (`method_id`) REFERENCES `methods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `user_method` -- ALTER TABLE `user_method` ADD CONSTRAINT `user_method_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `user_plateforms` -- ALTER TABLE `user_plateforms` ADD CONSTRAINT `user_plateforms_plateform_id_foreign` FOREIGN KEY (`plateform_id`) REFERENCES `plateforms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `user_plateforms_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!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 */;