-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 01, 2025 at 11:19 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.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: `ocpos_database`
--

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

--
-- 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 `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_state` varchar(255) DEFAULT NULL,
  `invoice_requet_delete_status` varchar(255) DEFAULT NULL,
  `invoice_deleted_status` varchar(255) NOT NULL DEFAULT '0',
  `invoice_code` varchar(255) DEFAULT NULL,
  `invoice_number` varchar(255) DEFAULT NULL,
  `invoice_obr_status` enum('0','1','2') NOT NULL COMMENT '0:Not Sent, 1:Sent , 2: Cancelled',
  `invoice_is_fa` enum('0','1') NOT NULL COMMENT '0:Not FA, 1:FA',
  `invoice_has_fa` varchar(255) DEFAULT NULL,
  `invoice_fa_motif` varchar(255) DEFAULT NULL,
  `invoice_customer_id` varchar(255) DEFAULT NULL,
  `invoice_customer_currency` varchar(255) DEFAULT NULL,
  `invoice_creator` int(11) DEFAULT NULL,
  `invoice_paid_at` datetime DEFAULT NULL,
  `invoice_deleted_at` datetime DEFAULT NULL,
  `invoice_delete_comment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `reservation_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`id`, `invoice_state`, `invoice_requet_delete_status`, `invoice_deleted_status`, `invoice_code`, `invoice_number`, `invoice_obr_status`, `invoice_is_fa`, `invoice_has_fa`, `invoice_fa_motif`, `invoice_customer_id`, `invoice_customer_currency`, `invoice_creator`, `invoice_paid_at`, `invoice_deleted_at`, `invoice_delete_comment`, `created_at`, `updated_at`, `reservation_id`) VALUES
(1, '1', NULL, '0', 'CD-00001-25', 'FN #00001-2025', '1', '0', NULL, NULL, '1', NULL, 1, '2025-01-30 11:55:53', NULL, NULL, '2025-01-30 09:55:53', '2025-01-30 09:58:25', NULL),
(2, '1', '1', '1', 'CD-00002-25', 'FN #00002-2025', '2', '0', NULL, NULL, '1', NULL, 1, '2025-01-30 11:56:37', NULL, 'Facture Errone', '2025-01-30 09:56:37', '2025-01-30 10:13:41', NULL),
(3, '1', '1', '1', 'CD-00003-25', 'FN #00003-2025', '2', '0', NULL, NULL, '1', NULL, 1, '2025-01-30 12:00:50', NULL, 'Annulation du Facture', '2025-01-30 10:00:50', '2025-01-30 10:11:22', NULL),
(4, '1', NULL, '0', 'CD-00004-25', 'FN #00004-2025', '1', '0', NULL, NULL, '1', NULL, 1, '2025-01-30 12:18:05', NULL, NULL, '2025-01-30 10:18:05', '2025-01-30 10:23:23', NULL);

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

--
-- Table structure for table `invoices_logs`
--

CREATE TABLE `invoices_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_type` enum('FN','FA','RC') NOT NULL DEFAULT 'FN',
  `invoice_number` varchar(255) DEFAULT NULL,
  `invoice_registered_number` varchar(255) DEFAULT NULL,
  `invoice_registered_date` datetime DEFAULT NULL,
  `electronic_signature` text DEFAULT NULL,
  `original_invoice` longtext 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 `invoices_logs`
--

INSERT INTO `invoices_logs` (`id`, `invoice_type`, `invoice_number`, `invoice_registered_number`, `invoice_registered_date`, `electronic_signature`, `original_invoice`, `created_at`, `updated_at`) VALUES
(1, 'FN', 'FN #00001-2025', '21917024', '2025-01-30 11:57:47', 'CrtRLsTrcwyW7pc3rAautBc/VRkmLi024RG5oQoUVWM7xkg245Tj2oK79GguBiwMBquKvT/QIXzEc8cgx4UOlsZHd2YOmjCWx7b7Cv4VU0DGFHQ3JguOxeyFE8Y03O2bAWiC1GQw+FIG1ElJ6MTEymIKMZ8GdnuUD14eQRRph0EBnjHhRZKz36tjKWXbRTLvcE0TGCEk60INljqDSwkMtRVbiaaFLbaIa8quZxxvEjAldCiaCeA7kzjkKyJ4iVWBV4YbJZn6Pki6w3/FVnjwDhu0rvF5XSA3hnihmy6eWTwvgELedJ7ZlMgovfjvBI1C1i0VjKf92yvrB8N4OBunDQ==', '{\"tp_name\":\"SOCOFOUMA\",\"tp_type\":2,\"tp_TIN\":\"4000802530\",\"tp_trade_number\":\"08509\",\"tp_postal_number\":null,\"tp_email\":\"socofoumaburundi@gmail.com\",\"etat_tva\":null,\"tp_phone_number\":\"61193884\",\"tp_address_province\":\"Bujumbura\",\"tp_address_avenue\":\"Boulevard de l\\\"Uprona\",\"tp_address_quartier\":\"Rohero\",\"tp_address_commune\":\"MUKAZA\",\"tp_address_rue\":\"Amitie\",\"tp_address_number\":\"30\",\"vat_taxpayer\":\"1\",\"ct_taxpayer\":\"0\",\"tl_taxpayer\":\"0\",\"tp_fiscal_center\":\"DMC\",\"tp_activity_sector\":\"Construction et Fourniture\",\"tp_legal_form\":\"SPRL\",\"invoice_number\":\"FN #00001-2025\",\"invoice_type\":\"FN\",\"invoice_date\":\"2025-01-30 11:55:53\",\"customer_name\":\"SOCOTRAPE\",\"customer_TIN\":\"4000002107\",\"custom_address\":null,\"vat_customer_payer\":0,\"payment_type\":\"1\",\"invoice_identifier\":\"4000802530\\/ws400080253000500\\/20250130115553\\/FN #00001-2025\",\"invoice_signature_date\":\"2025-01-30 11:55:53\",\"invoice_items\":[{\"item_designation\":\"Fourniture des Materiaux\",\"item_quantity\":1,\"item_ct\":0,\"item_tl\":0,\"item_price\":16949152.542373,\"item_price_nvat\":16949152.542373,\"vat\":3050847.4576271,\"item_price_wvat\":20000000.0000001,\"item_total_amount\":20000000.0000001},{\"item_designation\":\"Construction des Infrastructures Publics et Prives\",\"item_quantity\":1,\"item_ct\":0,\"item_tl\":0,\"item_price\":338983050.84746,\"item_price_nvat\":338983050.84746,\"vat\":61016949.152542,\"item_price_wvat\":400000000.00000197,\"item_total_amount\":400000000.00000197}]}', '2025-01-30 09:58:19', '2025-01-30 09:58:19'),
(2, 'FN', 'FN #00002-2025', '21917025', '2025-01-30 11:57:53', 'Nl/EtfZvGsfZLbwcF/jfS6hkQ8teTNYCDFB8oZ7M/oZiRyU7PvtCmu/b458oANXmxLWUPNJ9of5s6kRV5OSydWie34VfT/lWZwB/f94YF/u1haggTTKzo2tpmZUp4TZhSgp5phcDHS9kZ8+sge65bceXmNvnOKD38w0dvAVKlrxvvI9kMyEZOe/T+evsP8Swgb3xCTLufKog1+EmOpSklqnYp867QUJjZS/mpCmo7oPfYOQYT5s/wZjaPLj/5gGdUQSR8TQTPYq5/CnSpiMytM5DUlPihNrggotPjo3heD6Z2ITven5so9+DBa9z3FU92xFSvx5WaWDWWHkOFThJng==', '{\"tp_name\":\"SOCOFOUMA\",\"tp_type\":2,\"tp_TIN\":\"4000802530\",\"tp_trade_number\":\"08509\",\"tp_postal_number\":null,\"tp_email\":\"socofoumaburundi@gmail.com\",\"etat_tva\":null,\"tp_phone_number\":\"61193884\",\"tp_address_province\":\"Bujumbura\",\"tp_address_avenue\":\"Boulevard de l\\\"Uprona\",\"tp_address_quartier\":\"Rohero\",\"tp_address_commune\":\"MUKAZA\",\"tp_address_rue\":\"Amitie\",\"tp_address_number\":\"30\",\"vat_taxpayer\":\"1\",\"ct_taxpayer\":\"0\",\"tl_taxpayer\":\"0\",\"tp_fiscal_center\":\"DMC\",\"tp_activity_sector\":\"Construction et Fourniture\",\"tp_legal_form\":\"SPRL\",\"invoice_number\":\"FN #00002-2025\",\"invoice_type\":\"FN\",\"invoice_date\":\"2025-01-30 11:56:37\",\"customer_name\":\"SOCOTRAPE\",\"customer_TIN\":\"4000002107\",\"custom_address\":null,\"vat_customer_payer\":0,\"payment_type\":\"1\",\"invoice_identifier\":\"4000802530\\/ws400080253000500\\/20250130115637\\/FN #00002-2025\",\"invoice_signature_date\":\"2025-01-30 11:56:37\",\"invoice_items\":[{\"item_designation\":\"Construction des Infrastructures Publics et Prives\",\"item_quantity\":1,\"item_ct\":0,\"item_tl\":0,\"item_price\":338983050.84746,\"item_price_nvat\":338983050.84746,\"vat\":61016949.152542,\"item_price_wvat\":400000000.00000197,\"item_total_amount\":400000000.00000197},{\"item_designation\":\"Fourniture des Materiaux\",\"item_quantity\":1,\"item_ct\":0,\"item_tl\":0,\"item_price\":16949152.542373,\"item_price_nvat\":16949152.542373,\"vat\":3050847.4576271,\"item_price_wvat\":20000000.0000001,\"item_total_amount\":20000000.0000001}]}', '2025-01-30 09:58:25', '2025-01-30 09:58:25'),
(3, 'FN', 'FN #00003-2025', '21917041', '2025-01-30 12:07:29', 'fNNLrTWGS/kyvxb/odgDX4hZnLtiljUeXIYpcPluQq25GdS8GB+zxpzvXJroDx4xUXDxyTNB/FEeKGcoClMXbF+K7r65kzATnHV41jEUhFuIQEOblfsKPoo2gqGEgKYx14Qr/orf6Wvd9VKBehDrTQRZrNIKDjeQsoRSjggsLQCNRWr0gjQ7mBmP08fPHVz1fJlc4UerTO7jri5tLr4eKQbS04Nr+hqbpEiS1YXmVfpSP7xZQzTPPoXThiaIVf9K9yMjaBxYPn9c3+b+YTrZvJdHWY40JkFUnHpUr9mmPMzOS/1RiOflRg1bOoNPZfnjqRyRTcOgQR0EtitHLsMN7A==', '{\"tp_name\":\"SOCOFOUMA\",\"tp_type\":2,\"tp_TIN\":\"4000802530\",\"tp_trade_number\":\"08509\",\"tp_postal_number\":null,\"tp_email\":\"socofoumaburundi@gmail.com\",\"etat_tva\":null,\"tp_phone_number\":\"61193884\",\"tp_address_province\":\"Bujumbura\",\"tp_address_avenue\":\"Boulevard de l\\\"Uprona\",\"tp_address_quartier\":\"Rohero\",\"tp_address_commune\":\"MUKAZA\",\"tp_address_rue\":\"Amitie\",\"tp_address_number\":\"30\",\"vat_taxpayer\":\"1\",\"ct_taxpayer\":\"0\",\"tl_taxpayer\":\"0\",\"tp_fiscal_center\":\"DMC\",\"tp_activity_sector\":\"Construction et Fourniture\",\"tp_legal_form\":\"SPRL\",\"invoice_number\":\"FN #00003-2025\",\"invoice_type\":\"FN\",\"invoice_date\":\"2025-01-30 12:00:50\",\"customer_name\":\"SOCOTRAPE\",\"customer_TIN\":\"4000002107\",\"custom_address\":null,\"vat_customer_payer\":0,\"payment_type\":\"1\",\"invoice_identifier\":\"4000802530\\/ws400080253000500\\/20250130120050\\/FN #00003-2025\",\"invoice_signature_date\":\"2025-01-30 12:00:50\",\"invoice_items\":[{\"item_designation\":\"Construction des Infrastructures Publics et Prives\",\"item_quantity\":2,\"item_ct\":0,\"item_tl\":0,\"item_price\":338983050.84746,\"item_price_nvat\":677966101.69492,\"vat\":122033898.305084,\"item_price_wvat\":800000000.0000039,\"item_total_amount\":800000000.0000039}]}', '2025-01-30 10:08:01', '2025-01-30 10:08:01'),
(4, 'FN', 'FN #00004-2025', '21917048', '2025-01-30 12:22:51', 'VFI/Nf0oZJXNk86vv5UgIjjJGFiSy0vZ6KRTUqfRIM35Rw7DRz0Vj2DfgSlN7jjrLoT2Gba2aGUTXypOHd+dK6jdJjQjBekxxTJor2xCR8CnIH3FLkCndg9eAsutqW1yQduOQ3m/+caEm7f7YenVxRpf69jut4qDXBCyN2GWl2vK2TzZ1cq8J0rEcrx4iGmcDD0HEG1BRVRwL7IOcYAXuv6wrSOkme442utMgrl4Panby2n53+3rOdnkILriLu0edyVVy/gmQHJSlKNceGMO4minppl0UmU9eo63yAblT2pGSOV4fQWMILrdq3niCkZ2l5GzcosGOeuGikvCkhkohQ==', '{\"tp_name\":\"SOCOFOUMA\",\"tp_type\":2,\"tp_TIN\":\"4000802530\",\"tp_trade_number\":\"08509\",\"tp_postal_number\":null,\"tp_email\":\"socofoumaburundi@gmail.com\",\"etat_tva\":null,\"tp_phone_number\":\"61193884\",\"tp_address_province\":\"Bujumbura\",\"tp_address_avenue\":\"Boulevard de l\\\"Uprona\",\"tp_address_quartier\":\"Rohero\",\"tp_address_commune\":\"MUKAZA\",\"tp_address_rue\":\"Amitie\",\"tp_address_number\":\"30\",\"vat_taxpayer\":\"1\",\"ct_taxpayer\":\"0\",\"tl_taxpayer\":\"0\",\"tp_fiscal_center\":\"DMC\",\"tp_activity_sector\":\"Construction et Fourniture\",\"tp_legal_form\":\"SPRL\",\"invoice_number\":\"FN #00004-2025\",\"invoice_type\":\"FN\",\"invoice_date\":\"2025-01-30 12:18:05\",\"customer_name\":\"SOCOTRAPE\",\"customer_TIN\":\"4000002107\",\"custom_address\":null,\"vat_customer_payer\":0,\"payment_type\":\"1\",\"invoice_identifier\":\"4000802530\\/ws400080253000500\\/20250130121805\\/FN #00004-2025\",\"invoice_signature_date\":\"2025-01-30 12:18:05\",\"invoice_items\":[{\"item_designation\":\"Fourniture des Materiaux\",\"item_quantity\":2,\"item_ct\":0,\"item_tl\":0,\"item_price\":16949152.542373,\"item_price_nvat\":33898305.084746,\"vat\":6101694.9152542,\"item_price_wvat\":40000000.0000002,\"item_total_amount\":40000000.0000002}]}', '2025-01-30 10:23:23', '2025-01-30 10:23:23');

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

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_items_product_code` varchar(255) DEFAULT NULL,
  `invoice_code_ref` varchar(255) DEFAULT NULL,
  `invoice_items_quantity` varchar(255) DEFAULT NULL,
  `invoice_items_sellprice` varchar(255) DEFAULT NULL,
  `invoice_items_price` varchar(255) DEFAULT NULL,
  `invoice_items_tva` varchar(255) DEFAULT NULL,
  `invoice_items_single_htva` varchar(255) DEFAULT NULL,
  `invoice_items_single_tc` varchar(255) DEFAULT NULL,
  `invoice_items_single_pf` varchar(255) DEFAULT NULL,
  `invoice_items_name_product` varchar(255) DEFAULT NULL,
  `invoice_items_created_at` datetime DEFAULT NULL,
  `invoice_items_categorie_id` datetime DEFAULT NULL,
  `invoice_delete_comment` 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;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` (`id`, `invoice_items_product_code`, `invoice_code_ref`, `invoice_items_quantity`, `invoice_items_sellprice`, `invoice_items_price`, `invoice_items_tva`, `invoice_items_single_htva`, `invoice_items_single_tc`, `invoice_items_single_pf`, `invoice_items_name_product`, `invoice_items_created_at`, `invoice_items_categorie_id`, `invoice_delete_comment`, `created_at`, `updated_at`) VALUES
(1, 'PR0100002', 'CD-00001-25', '1', '20000000', '20000000', '3050847.4576271', '16949152.542373', '0', '0', 'Fourniture des Materiaux', '2025-01-30 11:55:53', NULL, NULL, NULL, NULL),
(2, 'PR0100001', 'CD-00001-25', '1', '400000000', '400000000', '61016949.152542', '338983050.84746', '0', '0', 'Construction des Infrastructures Publics et Prives', '2025-01-30 11:55:53', NULL, NULL, NULL, NULL),
(3, 'PR0100001', 'CD-00002-25', '1', '400000000', '400000000', '61016949.152542', '338983050.84746', '0', '0', 'Construction des Infrastructures Publics et Prives', '2025-01-30 11:56:38', NULL, 'Facture Errone', NULL, '2025-01-30 10:13:36'),
(4, 'PR0100002', 'CD-00002-25', '1', '20000000', '20000000', '3050847.4576271', '16949152.542373', '0', '0', 'Fourniture des Materiaux', '2025-01-30 11:56:38', NULL, 'Facture Errone', NULL, '2025-01-30 10:13:36'),
(5, 'PR0100001', 'CD-00003-25', '2', '400000000', '400000000', '61016949.152542', '338983050.84746', '0', '0', 'Construction des Infrastructures Publics et Prives', '2025-01-30 12:00:50', NULL, 'Annulation du Facture', NULL, '2025-01-30 10:09:46'),
(6, 'PR0100002', 'CD-00004-25', '2', '20000000', '20000000', '3050847.4576271', '16949152.542373', '0', '0', 'Fourniture des Materiaux', '2025-01-30 12:18:05', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `invoice_paiements`
--

CREATE TABLE `invoice_paiements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_code` varchar(255) DEFAULT NULL,
  `invoice_amount` varchar(255) DEFAULT NULL,
  `invoice_mode` varchar(255) DEFAULT NULL,
  `invoice_avance` varchar(255) DEFAULT NULL,
  `invoice_rabais` varchar(255) DEFAULT NULL,
  `invoice_type` varchar(255) DEFAULT NULL,
  `invoice_client` varchar(255) DEFAULT NULL,
  `invoice_created_by` varchar(255) DEFAULT NULL,
  `invoice_deleted_comment` varchar(255) DEFAULT NULL,
  `invoice_deleted_status` varchar(255) NOT NULL DEFAULT '0',
  `invoice_deleted_at` datetime 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 `invoice_paiements`
--

INSERT INTO `invoice_paiements` (`id`, `invoice_code`, `invoice_amount`, `invoice_mode`, `invoice_avance`, `invoice_rabais`, `invoice_type`, `invoice_client`, `invoice_created_by`, `invoice_deleted_comment`, `invoice_deleted_status`, `invoice_deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'CD-00001-25', '484067796', '1', '484067796', '0', '1', '1', '1', NULL, '0', NULL, '2025-01-30 09:55:54', '2025-01-30 09:55:54'),
(2, 'CD-00002-25', '484067796', '1', '484067796', '0', '1', '1', '1', NULL, '0', NULL, '2025-01-30 09:56:38', '2025-01-30 09:56:38'),
(3, 'CD-00003-25', '922033898', '1', '922033898', '0', '1', '1', '1', NULL, '0', NULL, '2025-01-30 10:00:51', '2025-01-30 10:00:51'),
(4, 'CD-00004-25', '46101695', '1', '46101695', '0', '1', '1', '1', NULL, '0', NULL, '2025-01-30 10:18:05', '2025-01-30 10:18:05');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `route_name` varchar(255) DEFAULT NULL,
  `icon_name` varchar(255) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `group_access` text 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 `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_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_07_23_115322_create_clients_table', 1),
(6, '2024_07_23_142109_create_companies_table', 1),
(7, '2024_07_23_150730_create_products_table', 1),
(8, '2024_07_23_183021_create_categories_table', 1),
(9, '2024_07_23_183252_create_unities_table', 1),
(10, '2024_07_31_095926_create_menus_table', 1),
(11, '2024_08_05_072305_create_pos_groups_table', 1),
(12, '2024_08_14_130858_create_supplies_table', 1),
(13, '2024_08_22_073458_create_stock_flows_table', 1),
(14, '2024_08_22_115254_create_sorties_table', 1),
(15, '2024_08_22_124058_create_invoices_table', 1),
(16, '2024_08_22_124222_create_invoice_items_table', 1),
(17, '2024_08_23_074625_create_inventories_table', 1),
(18, '2024_08_23_133431_create_rooms_table', 1),
(19, '2024_08_23_134815_create_invoice_paiements_table', 1),
(20, '2024_08_24_084802_create_mode_paies_table', 1),
(21, '2024_09_14_083353_create_reservations_table', 1),
(22, '2024_09_20_135222_add_column_reservation_id_to_invoices_table', 1),
(23, '2024_10_10_085826_create_invoices_logs_table', 1),
(24, '2025_01_28_100829_roles_migration', 2),
(25, '2025_01_28_100930_roles_user_migration', 2);

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

--
-- Table structure for table `mode_paies`
--

CREATE TABLE `mode_paies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `created_by` 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 `mode_paies`
--

INSERT INTO `mode_paies` (`id`, `title`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Cash', 1, '2025-01-25 13:26:14', '2025-01-25 13:26:14'),
(2, 'Credit', 1, '2025-01-25 13:26:25', '2025-01-25 13:26:25');

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

--
-- Table structure for table `ocpos_categories`
--

CREATE TABLE `ocpos_categories` (
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_by` 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;

--
-- Dumping data for table `ocpos_categories`
--

INSERT INTO `ocpos_categories` (`category_id`, `title`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Services', 1, '2025-01-30 09:04:20', '2025-01-30 09:04:20');

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

--
-- Table structure for table `ocpos_company`
--

CREATE TABLE `ocpos_company` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `tp_name` varchar(255) NOT NULL,
  `tp_type` int(11) NOT NULL COMMENT '1:Personne Physique,2:Personne Morale',
  `tp_TIN` varchar(255) NOT NULL,
  `tp_logo` varchar(255) DEFAULT NULL,
  `tp_trade_number` varchar(255) DEFAULT NULL,
  `tp_postal_number` varchar(255) DEFAULT NULL,
  `tp_email` varchar(255) DEFAULT NULL,
  `etat_tva` varchar(255) DEFAULT NULL,
  `tp_phone_number` varchar(255) DEFAULT NULL,
  `tp_address_province` varchar(255) DEFAULT NULL,
  `tp_address_avenue` varchar(255) DEFAULT NULL,
  `tp_address_quartier` varchar(255) DEFAULT NULL,
  `tp_address_commune` varchar(255) DEFAULT NULL,
  `tp_address_rue` varchar(255) DEFAULT NULL,
  `tp_address_number` varchar(255) DEFAULT NULL,
  `vat_taxpayer` varchar(255) DEFAULT NULL,
  `ct_taxpayer` varchar(255) DEFAULT NULL,
  `tl_taxpayer` varchar(255) DEFAULT NULL,
  `tp_fiscal_center` enum('DPMC','DMC','DGC') NOT NULL DEFAULT 'DPMC',
  `tp_activity_sector` varchar(255) DEFAULT NULL,
  `tp_legal_form` varchar(255) DEFAULT NULL,
  `vat_type` int(11) NOT NULL DEFAULT 0 COMMENT '0:tva inclus,1:tva exlus',
  `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 `ocpos_company`
--

INSERT INTO `ocpos_company` (`id`, `username`, `password`, `tp_name`, `tp_type`, `tp_TIN`, `tp_logo`, `tp_trade_number`, `tp_postal_number`, `tp_email`, `etat_tva`, `tp_phone_number`, `tp_address_province`, `tp_address_avenue`, `tp_address_quartier`, `tp_address_commune`, `tp_address_rue`, `tp_address_number`, `vat_taxpayer`, `ct_taxpayer`, `tl_taxpayer`, `tp_fiscal_center`, `tp_activity_sector`, `tp_legal_form`, `vat_type`, `created_at`, `updated_at`) VALUES
(1, 'ws400080253000500', 'n~K|2>F\"', 'SOCOFOUMA', 2, '4000802530', NULL, '08509', NULL, 'socofoumaburundi@gmail.com', NULL, '61193884', 'Bujumbura', 'Boulevard de l\"Uprona', 'Rohero', 'MUKAZA', 'Amitie', '30', '1', '0', '0', 'DMC', 'Construction et Fourniture', 'SPRL', 0, '2025-01-25 13:14:55', '2025-01-30 09:19:50');

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

--
-- Table structure for table `ocpos_customers`
--

CREATE TABLE `ocpos_customers` (
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_tin` varchar(255) DEFAULT NULL,
  `customer_address` varchar(255) DEFAULT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `customer_file` varchar(255) DEFAULT NULL,
  `customer_type` int(11) NOT NULL DEFAULT 1,
  `customer_status` int(11) NOT NULL DEFAULT 0,
  `customer_vatpayer` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `modified_by` 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;

--
-- Dumping data for table `ocpos_customers`
--

INSERT INTO `ocpos_customers` (`customer_id`, `customer_name`, `customer_tin`, `customer_address`, `customer_phone`, `customer_file`, `customer_type`, `customer_status`, `customer_vatpayer`, `created_by`, `modified_by`, `created_at`, `updated_at`) VALUES
(1, 'SOCOTRAPE', '4000002107', 'Buja', '8548745', NULL, 1, 0, 0, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `ocpos_products`
--

CREATE TABLE `ocpos_products` (
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `item_codebar` varchar(255) DEFAULT NULL,
  `item_sellprice` double DEFAULT NULL,
  `item_costprice` double DEFAULT NULL,
  `item_corprice` double DEFAULT NULL COMMENT 'prix de reviens',
  `item_quantity` double(15,5) DEFAULT 0.00000,
  `item_tva` double DEFAULT NULL,
  `item_tc` double DEFAULT NULL,
  `item_pf` double DEFAULT NULL,
  `item_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:actif,1:desactif',
  `item_type` int(11) NOT NULL DEFAULT 0 COMMENT '0:stockable,1:non stockable',
  `item_isSellable` int(11) NOT NULL DEFAULT 0 COMMENT '0:yes,1:non',
  `item_category` int(11) DEFAULT NULL,
  `item_unity` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `modified_by` 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;

--
-- Dumping data for table `ocpos_products`
--

INSERT INTO `ocpos_products` (`item_id`, `item_name`, `item_codebar`, `item_sellprice`, `item_costprice`, `item_corprice`, `item_quantity`, `item_tva`, `item_tc`, `item_pf`, `item_status`, `item_type`, `item_isSellable`, `item_category`, `item_unity`, `created_by`, `modified_by`, `created_at`, `updated_at`) VALUES
(1, 'Construction des Infrastructures Publics et Prives', 'PR0100001', 400000000, 0, 0, 0.00000, 1.18, 0, 0, 0, 1, 0, 1, '1', 1, NULL, '2025-01-30 09:12:31', '2025-01-30 09:12:31'),
(2, 'Fourniture des Materiaux', 'PR0100002', 20000000, 0, 0, 0.00000, 1.18, 0, 0, 0, 1, 0, 1, '1', 1, 1, '2025-01-30 09:16:00', '2025-01-30 09:16:56');

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

--
-- Table structure for table `ocpos_product_inventories`
--

CREATE TABLE `ocpos_product_inventories` (
  `inventory_id` bigint(20) UNSIGNED NOT NULL,
  `inventory_title` varchar(255) DEFAULT NULL,
  `inventory_code` varchar(255) DEFAULT NULL,
  `inventory_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:onhold,1:confirmed',
  `created_by` int(11) DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `confirmed_by` int(11) DEFAULT NULL,
  `confirmed_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 `ocpos_product_inventory_items`
--

CREATE TABLE `ocpos_product_inventory_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_inventory_code` varchar(255) DEFAULT NULL,
  `ref_product_code` varchar(255) DEFAULT NULL,
  `item_inventory_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:onhold,1:confirmed',
  `item_inventory_name` varchar(255) DEFAULT NULL,
  `item_system_quantity` double(15,5) DEFAULT NULL,
  `item_physic_quantity` double(15,5) DEFAULT NULL,
  `item_inventory_price` double(15,5) 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 `ocpos_product_sorties`
--

CREATE TABLE `ocpos_product_sorties` (
  `sortie_id` bigint(20) UNSIGNED NOT NULL,
  `sortie_title` varchar(255) DEFAULT NULL,
  `sortie_code` varchar(255) DEFAULT NULL,
  `sortie_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:onhold,1:confirmed',
  `sortie_type` varchar(255) DEFAULT 'SN',
  `created_by` int(11) DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `confirmed_by` int(11) DEFAULT NULL,
  `confirmed_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 `ocpos_product_sortie_items`
--

CREATE TABLE `ocpos_product_sortie_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_sortie_code` varchar(255) DEFAULT NULL,
  `ref_product_code` varchar(255) DEFAULT NULL,
  `sortie_type` varchar(255) DEFAULT 'SN',
  `item_sortie_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:onhold,1:confirmed',
  `item_sortie_name` varchar(255) DEFAULT NULL,
  `item_sortie_quantity` double(15,5) DEFAULT NULL,
  `item_sortie_price` double(15,5) 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 `ocpos_product_supplies`
--

CREATE TABLE `ocpos_product_supplies` (
  `supply_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `supply_code` varchar(255) DEFAULT NULL,
  `supply_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:onhold,1:confirmed,2:rejected',
  `supply_type` enum('EN','ET','EAJ') NOT NULL DEFAULT 'EN' COMMENT '0:EN:normal,1:ET:transfert',
  `created_by` int(11) DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  `confirmed_or_rejected_by` int(11) DEFAULT NULL,
  `confirmed_or_rejected_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 `ocpos_product_supplies`
--

INSERT INTO `ocpos_product_supplies` (`supply_id`, `title`, `supply_code`, `supply_status`, `supply_type`, `created_by`, `modified_by`, `confirmed_or_rejected_by`, `confirmed_or_rejected_at`, `created_at`, `updated_at`) VALUES
(2, 'Approvisionnements Principale', 'SP0100002', 1, 'EN', 1, NULL, 1, '2025-01-27 13:59:27', '2025-01-27 13:58:37', '2025-01-27 13:59:27');

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

--
-- Table structure for table `ocpos_rooms`
--

CREATE TABLE `ocpos_rooms` (
  `room_id` bigint(20) UNSIGNED NOT NULL,
  `room_code` varchar(255) NOT NULL,
  `room_name` varchar(255) DEFAULT NULL,
  `room_price` double(15,5) DEFAULT NULL,
  `room_vat` double(15,5) DEFAULT NULL,
  `room_tc` double(15,5) DEFAULT NULL,
  `room_capacity` int(11) DEFAULT NULL,
  `room_status` int(11) NOT NULL DEFAULT 0 COMMENT '0:free,1:occupe,2:reserved',
  `delete_status` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_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 `ocpos_room_reservations`
--

CREATE TABLE `ocpos_room_reservations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `ref_room_id` int(11) DEFAULT NULL,
  `people_number` int(11) DEFAULT NULL,
  `cancel_status` int(11) DEFAULT 0,
  `cancel_date` date DEFAULT NULL,
  `checkin_date` date DEFAULT NULL,
  `checkout_date` date DEFAULT NULL,
  `type` enum('checkin','reservation','checkout') DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `modified_by` 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;

--
-- Dumping data for table `ocpos_room_reservations`
--

INSERT INTO `ocpos_room_reservations` (`id`, `customer_id`, `ref_room_id`, `people_number`, `cancel_status`, `cancel_date`, `checkin_date`, `checkout_date`, `type`, `created_by`, `modified_by`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 2, 0, NULL, '2024-12-31', '2025-03-13', 'checkout', 1, 1, '2025-01-27 17:20:01', '2025-01-27 17:20:14'),
(2, 2, 1, 3, 0, NULL, '2025-01-27', '2025-01-31', 'checkout', 1, 1, '2025-01-27 17:35:32', '2025-01-27 17:35:46');

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

--
-- Table structure for table `ocpos_stock_flow_movements`
--

CREATE TABLE `ocpos_stock_flow_movements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `mov_ref_code` varchar(255) DEFAULT NULL,
  `mov_ref_product_code` varchar(255) DEFAULT NULL,
  `mov_type` enum('EN','ET','EI','ER','EAJ','EAU','SN','ST','SAJ','SP','SV','SD','SC','SAU') DEFAULT NULL,
  `mov_item_previous_qty` double(15,5) NOT NULL DEFAULT 0.00000,
  `mov_item_quantity` double(15,5) NOT NULL DEFAULT 0.00000,
  `mov_item_price` double(15,5) NOT NULL DEFAULT 0.00000,
  `mov_created_by` int(11) DEFAULT NULL,
  `mov_obr_status` int(11) DEFAULT 0,
  `mov_obr_sent_date` 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 `ocpos_supplies_details`
--

CREATE TABLE `ocpos_supplies_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_supply_code` varchar(255) DEFAULT NULL,
  `ref_product_code` varchar(255) DEFAULT NULL,
  `supply_type` varchar(255) NOT NULL DEFAULT 'EN' COMMENT '0:EN:normal,1:ET:transfert',
  `product_name` varchar(255) DEFAULT NULL,
  `item_quantity` double DEFAULT NULL,
  `purchase_price` double DEFAULT NULL,
  `modified_by` 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 `ocpos_unities`
--

CREATE TABLE `ocpos_unities` (
  `unity_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_by` 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;

--
-- Dumping data for table `ocpos_unities`
--

INSERT INTO `ocpos_unities` (`unity_id`, `title`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Pieces', 1, '2025-01-25 13:17:26', '2025-01-25 13:17:26'),
(2, 'sacs', 1, '2025-01-27 15:08:58', '2025-01-27 15:08:58'),
(3, 'KG', 1, '2025-01-27 15:09:12', '2025-01-27 15:09:12'),
(4, 'Cartons', 1, '2025-01-27 15:09:21', '2025-01-27 15:09:21');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `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 `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,
  `expires_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 `pos_groups`
--

CREATE TABLE `pos_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_group` varchar(255) DEFAULT NULL,
  `description_group` 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 `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ADMIN', NULL, NULL, NULL, NULL),
(2, 'STOCK MANAGER', NULL, NULL, NULL, NULL),
(3, 'WAITER', NULL, NULL, NULL, NULL),
(4, 'CASHIER', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role_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 `role_users`
--

INSERT INTO `role_users` (`id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 2, 1, '2025-01-31 09:38:15', '2025-01-31 09:38:15'),
(3, 3, 2, '2025-01-31 09:52:20', '2025-01-31 09:52:20'),
(4, 3, 2, '2025-02-01 09:06:42', '2025-02-01 09:06:42'),
(5, 3, 2, '2025-02-01 09:08:49', '2025-02-01 09:08:49'),
(6, 3, 2, '2025-02-01 09:11:21', '2025-02-01 09:11:21');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(40) NOT NULL,
  `aboutMe` text NOT NULL,
  `profilePath` varchar(50) NOT NULL,
  `adresse` varchar(50) NOT NULL,
  `isBanned` int(11) NOT NULL DEFAULT 0,
  `pin_code` varchar(60) DEFAULT NULL,
  `user_status` int(11) NOT NULL DEFAULT 0,
  `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;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `phone`, `aboutMe`, `profilePath`, `adresse`, `isBanned`, `pin_code`, `user_status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Irakoze', 'chrisirak95@gmail.com', NULL, '$2y$10$EW8F/OMq53jkQHdpMho40.1fGIGrVbdijmnwo14Gpgerwc5WDDmU2', '', '', '', '', 0, '5875', 0, NULL, '2025-01-25 13:12:17', '2025-01-25 13:12:17'),
(2, 'Scott Saunders', 'bifo@mailinator.com', NULL, '$2y$10$6WPEciw1BBLiiiDZcFbFk.rbAwAnVwXEN1zl.955J/m3sNbsJYP8S', '+1 (341) 256-7292', 'Dolore quidem odit e', '1738316295.webp', 'Vitae consectetur ni', 0, '345346', 0, NULL, NULL, NULL),
(3, 'Kaferas Bigno', 'jirei@gmail.com', NULL, '$2y$10$ETEYNxKCoWp.ryExrbK7iu.Dq4L4WnKBKYKqEZkeCPwebdnxVAhJK', '4345547', 'Conference Internationale', '', 'Kinama', 0, '41213', 0, NULL, NULL, '2025-02-01 09:11:21');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `ocpos_categories`
--
ALTER TABLE `ocpos_categories`
  ADD PRIMARY KEY (`category_id`);

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

--
-- Indexes for table `ocpos_customers`
--
ALTER TABLE `ocpos_customers`
  ADD PRIMARY KEY (`customer_id`);

--
-- Indexes for table `ocpos_products`
--
ALTER TABLE `ocpos_products`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `idx_barcode` (`item_codebar`);

--
-- Indexes for table `ocpos_product_inventories`
--
ALTER TABLE `ocpos_product_inventories`
  ADD PRIMARY KEY (`inventory_id`),
  ADD UNIQUE KEY `unx_ivcode` (`inventory_code`);

--
-- Indexes for table `ocpos_product_inventory_items`
--
ALTER TABLE `ocpos_product_inventory_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ivdcode` (`ref_inventory_code`),
  ADD KEY `idx_ivrcode` (`ref_product_code`);

--
-- Indexes for table `ocpos_product_sorties`
--
ALTER TABLE `ocpos_product_sorties`
  ADD PRIMARY KEY (`sortie_id`),
  ADD UNIQUE KEY `unx_srcode` (`sortie_code`);

--
-- Indexes for table `ocpos_product_sortie_items`
--
ALTER TABLE `ocpos_product_sortie_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_srdcode` (`ref_sortie_code`),
  ADD KEY `idx_sprcode` (`ref_product_code`);

--
-- Indexes for table `ocpos_product_supplies`
--
ALTER TABLE `ocpos_product_supplies`
  ADD PRIMARY KEY (`supply_id`),
  ADD UNIQUE KEY `unx_spcode` (`supply_code`);

--
-- Indexes for table `ocpos_rooms`
--
ALTER TABLE `ocpos_rooms`
  ADD PRIMARY KEY (`room_id`),
  ADD UNIQUE KEY `unx_room` (`room_code`);

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

--
-- Indexes for table `ocpos_stock_flow_movements`
--
ALTER TABLE `ocpos_stock_flow_movements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_refcodeflow` (`mov_ref_code`),
  ADD KEY `idx_barcodeflow` (`mov_ref_product_code`);

--
-- Indexes for table `ocpos_supplies_details`
--
ALTER TABLE `ocpos_supplies_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_spdcode` (`ref_supply_code`),
  ADD KEY `idx_prdcode` (`ref_product_code`);

--
-- Indexes for table `ocpos_unities`
--
ALTER TABLE `ocpos_unities`
  ADD PRIMARY KEY (`unity_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- 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 `pos_groups`
--
ALTER TABLE `pos_groups`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `role_users`
--
ALTER TABLE `role_users`
  ADD PRIMARY KEY (`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 `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  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=26;

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

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

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

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

--
-- AUTO_INCREMENT for table `ocpos_products`
--
ALTER TABLE `ocpos_products`
  MODIFY `item_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

--
-- AUTO_INCREMENT for table `ocpos_product_supplies`
--
ALTER TABLE `ocpos_product_supplies`
  MODIFY `supply_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

--
-- AUTO_INCREMENT for table `ocpos_unities`
--
ALTER TABLE `ocpos_unities`
  MODIFY `unity_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 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 `pos_groups`
--
ALTER TABLE `pos_groups`
  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=5;

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
