/home2/mshostin/www/inventry.sql
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 07, 2022 at 02:44 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.0.13
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: `inventry`
--
-- --------------------------------------------------------
--
-- Table structure for table `clients`
--
CREATE TABLE `clients` (
`id` bigint(20) UNSIGNED NOT NULL,
`document_type` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
`document_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_purchase` timestamp NULL DEFAULT NULL,
`total_purchases` int(10) UNSIGNED NOT NULL DEFAULT 0,
`total_paid` decimal(8,2) UNSIGNED NOT NULL DEFAULT 0.00,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`balance` double(16,4) NOT NULL DEFAULT 0.0000
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `clients`
--
INSERT INTO `clients` (`id`, `document_type`, `document_id`, `name`, `email`, `phone`, `last_purchase`, `total_purchases`, `total_paid`, `created_at`, `updated_at`, `deleted_at`, `balance`) VALUES
(1, 'V', 12, 'Hassan', 'h.hsultan277@gmail.com', '03012691232', NULL, 0, '0.00', '2022-01-06 02:17:39', '2022-01-07 02:59:32', NULL, 0.0000),
(2, 'V', 123, 'Fazal', 'fazal@gmail.com', '030123456789', NULL, 0, '0.00', '2022-01-06 10:18:27', '2022-01-07 08:28:04', NULL, 0.0000);
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint(20) UNSIGNED NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) 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) 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_11_02_214601_create_clients_table_migration', 1),
(5, '2019_11_03_032131_create_products_categories_table_migration', 1),
(6, '2019_11_03_032233_create_products_table_migration', 1),
(7, '2019_11_04_000745_create_payment_methods_table_migration', 1),
(8, '2019_11_04_001238_create_sales_table_migration', 1),
(9, '2019_11_04_001246_create_sold_products_table_migration', 1),
(10, '2019_11_04_001339_create_providers_table_migration', 1),
(11, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(12, '2019_12_23_065221_create_transfers_table', 1),
(13, '2019_12_24_001440_create_transactions_table_migration', 1),
(14, '2020_01_15_193356_create_receipts_table', 1),
(15, '2020_01_15_193828_create_received_products_table', 1),
(16, '2020_01_20_191734_add_balance_column_clients_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) 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 `payment_methods`
--
CREATE TABLE `payment_methods` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text 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 `payment_methods`
--
INSERT INTO `payment_methods` (`id`, `name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Hard Cash', 'Cash on Hand', '2022-01-06 02:53:58', '2022-01-06 02:53:58', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint(20) UNSIGNED NOT NULL,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci 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 `products`
--
CREATE TABLE `products` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_category_id` bigint(20) UNSIGNED NOT NULL,
`price` decimal(10,2) UNSIGNED NOT NULL,
`stock` int(10) UNSIGNED NOT NULL DEFAULT 0,
`stock_defective` int(10) UNSIGNED NOT NULL DEFAULT 0,
`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 `products`
--
INSERT INTO `products` (`id`, `name`, `description`, `product_category_id`, `price`, `stock`, `stock_defective`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Toyota Corolla', 'SUG', 1, '2050000.00', 12, 2, '2022-01-06 02:13:06', '2022-01-07 02:17:07', NULL),
(2, 'Corolla Bumper', 'Scrap Pieces', 2, '2500.00', 13, 1, '2022-01-06 10:17:31', '2022-01-07 02:58:03', NULL),
(3, 'Basic Horn', 'Basic Horn Provide By Ali Provider', 2, '600.00', 38, 0, '2022-01-07 03:03:52', '2022-01-07 08:27:22', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `product_categories`
--
CREATE TABLE `product_categories` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) 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 `product_categories`
--
INSERT INTO `product_categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Car', '2022-01-06 02:11:16', '2022-01-06 02:11:16', NULL),
(2, 'Car Parts', '2022-01-06 10:16:38', '2022-01-06 10:16:38', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `providers`
--
CREATE TABLE `providers` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`paymentinfo` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone` varchar(255) 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 `providers`
--
INSERT INTO `providers` (`id`, `name`, `description`, `paymentinfo`, `email`, `phone`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Ali', 'provide basic horn', 'payment collect at the month end.', 'ali@gmail.com', '030123456789', '2022-01-07 02:13:38', '2022-01-07 02:13:38', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `receipts`
--
CREATE TABLE `receipts` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`provider_id` bigint(20) UNSIGNED DEFAULT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`finalized_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;
--
-- Dumping data for table `receipts`
--
INSERT INTO `receipts` (`id`, `title`, `provider_id`, `user_id`, `finalized_at`, `created_at`, `updated_at`) VALUES
(1, 'First Receipt', 1, 1, '2022-01-07 03:05:05', '2022-01-07 03:01:23', '2022-01-07 03:05:05');
-- --------------------------------------------------------
--
-- Table structure for table `received_products`
--
CREATE TABLE `received_products` (
`id` bigint(20) UNSIGNED NOT NULL,
`receipt_id` bigint(20) UNSIGNED NOT NULL,
`product_id` bigint(20) UNSIGNED NOT NULL,
`stock` int(11) NOT NULL,
`stock_defective` 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 `received_products`
--
INSERT INTO `received_products` (`id`, `receipt_id`, `product_id`, `stock`, `stock_defective`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 20, 0, '2022-01-07 03:04:43', '2022-01-07 03:04:43');
-- --------------------------------------------------------
--
-- Table structure for table `sales`
--
CREATE TABLE `sales` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED NOT NULL,
`client_id` bigint(20) UNSIGNED NOT NULL,
`total_amount` decimal(10,2) DEFAULT NULL,
`finalized_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;
--
-- Dumping data for table `sales`
--
INSERT INTO `sales` (`id`, `user_id`, `client_id`, `total_amount`, `finalized_at`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '4600000.00', '2022-01-06 02:48:27', '2022-01-06 02:19:02', '2022-01-06 02:48:27'),
(4, 1, 2, '3000.00', '2022-01-07 02:11:18', '2022-01-07 01:55:55', '2022-01-07 02:11:18'),
(5, 1, 2, '3000.00', '2022-01-07 02:11:58', '2022-01-07 02:11:39', '2022-01-07 02:11:58'),
(6, 1, 2, '9000.00', '2022-01-07 02:18:21', '2022-01-07 02:17:56', '2022-01-07 02:18:21'),
(8, 1, 1, '6000.00', '2022-01-07 02:58:03', '2022-01-07 02:57:10', '2022-01-07 02:58:03'),
(9, 1, 2, '1400.00', '2022-01-07 08:27:22', '2022-01-07 08:26:42', '2022-01-07 08:27:22');
-- --------------------------------------------------------
--
-- Table structure for table `sold_products`
--
CREATE TABLE `sold_products` (
`id` bigint(20) UNSIGNED NOT NULL,
`sale_id` bigint(20) UNSIGNED NOT NULL,
`product_id` bigint(20) UNSIGNED NOT NULL,
`qty` int(11) NOT NULL,
`price` decimal(10,2) NOT NULL,
`total_amount` decimal(10,2) 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 `sold_products`
--
INSERT INTO `sold_products` (`id`, `sale_id`, `product_id`, `qty`, `price`, `total_amount`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 2, '2300000.00', '4600000.00', '2022-01-06 02:24:46', '2022-01-06 02:24:46'),
(2, 4, 2, 1, '3000.00', '3000.00', '2022-01-07 02:11:07', '2022-01-07 02:11:07'),
(3, 5, 2, 1, '3000.00', '3000.00', '2022-01-07 02:11:55', '2022-01-07 02:11:55'),
(4, 6, 2, 3, '3000.00', '9000.00', '2022-01-07 02:18:14', '2022-01-07 02:18:14'),
(5, 8, 2, 2, '3000.00', '6000.00', '2022-01-07 02:57:43', '2022-01-07 02:57:43'),
(6, 9, 3, 2, '700.00', '1400.00', '2022-01-07 08:27:10', '2022-01-07 08:27:10');
-- --------------------------------------------------------
--
-- Table structure for table `transactions`
--
CREATE TABLE `transactions` (
`id` bigint(20) UNSIGNED NOT NULL,
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`client_id` bigint(20) UNSIGNED DEFAULT NULL,
`sale_id` bigint(20) UNSIGNED DEFAULT NULL,
`provider_id` bigint(20) UNSIGNED DEFAULT NULL,
`transfer_id` bigint(20) UNSIGNED DEFAULT NULL,
`payment_method_id` bigint(20) UNSIGNED NOT NULL,
`amount` decimal(10,2) 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;
--
-- Dumping data for table `transactions`
--
INSERT INTO `transactions` (`id`, `type`, `title`, `reference`, `client_id`, `sale_id`, `provider_id`, `transfer_id`, `payment_method_id`, `amount`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'income', 'Payment Received from Customer ID: 1', NULL, 1, NULL, NULL, NULL, 1, '4600000.00', 1, '2022-01-06 02:56:27', '2022-01-06 02:56:27'),
(2, 'income', 'Car Bumper Sale', NULL, NULL, NULL, NULL, NULL, 1, '3000.00', 1, '2022-01-06 10:19:22', '2022-01-06 10:19:22'),
(3, 'income', 'Payment Received from Customer ID: 2', NULL, 2, NULL, NULL, NULL, 1, '3000.00', 1, '2022-01-06 10:21:13', '2022-01-06 10:21:13'),
(4, 'income', 'Payment Received from Customer ID: 2', NULL, 2, NULL, NULL, NULL, 1, '3000.00', 1, '2022-01-07 01:55:00', '2022-01-07 01:55:00'),
(5, 'income', 'Payment Received from Customer ID: 2', NULL, 2, NULL, NULL, NULL, 1, '9000.00', 1, '2022-01-07 02:19:16', '2022-01-07 02:19:16'),
(6, 'expense', 'Shop Bill', NULL, NULL, NULL, NULL, NULL, 1, '-10000.00', 1, '2022-01-07 02:20:53', '2022-01-07 02:20:53'),
(7, 'payment', 'Basic Horn payment', NULL, NULL, NULL, 1, NULL, 1, '-20000.00', 1, '2022-01-07 02:46:07', '2022-01-07 02:46:07'),
(8, 'income', 'Payment Received from Customer ID: 1', NULL, 1, NULL, NULL, NULL, 1, '3000.00', 1, '2022-01-07 02:59:14', '2022-01-07 02:59:14'),
(9, 'income', 'Payment Received from Customer ID: 1', NULL, 1, NULL, NULL, NULL, 1, '3000.00', 1, '2022-01-07 02:59:32', '2022-01-07 02:59:32'),
(10, 'expense', 'TransferID: 1', NULL, NULL, NULL, NULL, 1, 1, '-20000.00', 1, '2022-01-07 03:07:28', '2022-01-07 03:07:28'),
(11, 'income', 'TransferID: 1', NULL, NULL, NULL, NULL, 1, 1, '20000.00', 1, '2022-01-07 03:07:28', '2022-01-07 03:07:28'),
(12, 'income', 'Payment Received from Customer ID: 2', NULL, 2, NULL, NULL, NULL, 1, '1400.00', 1, '2022-01-07 08:28:04', '2022-01-07 08:28:04');
-- --------------------------------------------------------
--
-- Table structure for table `transfers`
--
CREATE TABLE `transfers` (
`id` bigint(20) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sender_method_id` bigint(20) UNSIGNED NOT NULL,
`receiver_method_id` bigint(20) UNSIGNED NOT NULL,
`sended_amount` decimal(10,2) NOT NULL,
`received_amount` decimal(10,2) NOT NULL,
`reference` varchar(255) 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 `transfers`
--
INSERT INTO `transfers` (`id`, `title`, `sender_method_id`, `receiver_method_id`, `sended_amount`, `received_amount`, `reference`, `created_at`, `updated_at`) VALUES
(1, 'Salary', 1, 1, '20000.00', '20000.00', NULL, '2022-01-07 03:07:28', '2022-01-07 03:07:28');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) 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`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Hassan Sultan', 'h.hsultan277@gmail.com', NULL, '$2y$10$8uLvzW2y7SXr/rfBvYZD7OZk./XhMq3cHxW0apdZIyzeBlLYYQehq', NULL, '2022-01-05 08:33:25', '2022-01-05 08:33:25', NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `clients_document_id_unique` (`document_id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
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`);
--
-- 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 `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`),
ADD KEY `products_product_category_id_foreign` (`product_category_id`);
--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `providers`
--
ALTER TABLE `providers`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `receipts`
--
ALTER TABLE `receipts`
ADD PRIMARY KEY (`id`),
ADD KEY `receipts_provider_id_foreign` (`provider_id`),
ADD KEY `receipts_user_id_foreign` (`user_id`);
--
-- Indexes for table `received_products`
--
ALTER TABLE `received_products`
ADD PRIMARY KEY (`id`),
ADD KEY `received_products_receipt_id_foreign` (`receipt_id`),
ADD KEY `received_products_product_id_foreign` (`product_id`);
--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
ADD PRIMARY KEY (`id`),
ADD KEY `sales_user_id_foreign` (`user_id`),
ADD KEY `sales_client_id_foreign` (`client_id`);
--
-- Indexes for table `sold_products`
--
ALTER TABLE `sold_products`
ADD PRIMARY KEY (`id`),
ADD KEY `sold_products_sale_id_foreign` (`sale_id`),
ADD KEY `sold_products_product_id_foreign` (`product_id`);
--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
ADD PRIMARY KEY (`id`),
ADD KEY `transactions_payment_method_id_foreign` (`payment_method_id`),
ADD KEY `transactions_client_id_foreign` (`client_id`),
ADD KEY `transactions_sale_id_foreign` (`sale_id`),
ADD KEY `transactions_provider_id_foreign` (`provider_id`),
ADD KEY `transactions_user_id_foreign` (`user_id`),
ADD KEY `transactions_transfer_id_foreign` (`transfer_id`);
--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
ADD PRIMARY KEY (`id`),
ADD KEY `transfers_sender_method_id_foreign` (`sender_method_id`),
ADD KEY `transfers_receiver_method_id_foreign` (`receiver_method_id`);
--
-- 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 `clients`
--
ALTER TABLE `clients`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
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=17;
--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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 `products`
--
ALTER TABLE `products`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `providers`
--
ALTER TABLE `providers`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `receipts`
--
ALTER TABLE `receipts`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `received_products`
--
ALTER TABLE `received_products`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `sold_products`
--
ALTER TABLE `sold_products`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `transfers`
--
ALTER TABLE `transfers`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `products`
--
ALTER TABLE `products`
ADD CONSTRAINT `products_product_category_id_foreign` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`);
--
-- Constraints for table `receipts`
--
ALTER TABLE `receipts`
ADD CONSTRAINT `receipts_provider_id_foreign` FOREIGN KEY (`provider_id`) REFERENCES `providers` (`id`),
ADD CONSTRAINT `receipts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `received_products`
--
ALTER TABLE `received_products`
ADD CONSTRAINT `received_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
ADD CONSTRAINT `received_products_receipt_id_foreign` FOREIGN KEY (`receipt_id`) REFERENCES `receipts` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `sales`
--
ALTER TABLE `sales`
ADD CONSTRAINT `sales_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
ADD CONSTRAINT `sales_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `sold_products`
--
ALTER TABLE `sold_products`
ADD CONSTRAINT `sold_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
ADD CONSTRAINT `sold_products_sale_id_foreign` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
ADD CONSTRAINT `transactions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
ADD CONSTRAINT `transactions_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
ADD CONSTRAINT `transactions_provider_id_foreign` FOREIGN KEY (`provider_id`) REFERENCES `providers` (`id`),
ADD CONSTRAINT `transactions_sale_id_foreign` FOREIGN KEY (`sale_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_transfer_id_foreign` FOREIGN KEY (`transfer_id`) REFERENCES `transfers` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `transfers`
--
ALTER TABLE `transfers`
ADD CONSTRAINT `transfers_receiver_method_id_foreign` FOREIGN KEY (`receiver_method_id`) REFERENCES `payment_methods` (`id`),
ADD CONSTRAINT `transfers_sender_method_id_foreign` FOREIGN KEY (`sender_method_id`) REFERENCES `payment_methods` (`id`);
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 */;