-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 07, 2026 at 04:06 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.1.25

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: `barcode`
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT 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` varchar(255) NOT NULL,
  `queue` varchar(255) 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 `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company` varchar(60) NOT NULL,
  `product` varchar(60) NOT NULL,
  `item_code` varchar(120) NOT NULL,
  `total` int(10) UNSIGNED DEFAULT NULL,
  `pecahan` int(10) UNSIGNED DEFAULT NULL,
  `barcode_value` varchar(190) NOT NULL,
  `title` varchar(120) NOT NULL,
  `custom_code_text` varchar(200) DEFAULT NULL,
  `barcode_type` varchar(30) NOT NULL DEFAULT 'code128',
  `qty` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `notes` text DEFAULT NULL,
  `import_batch` varchar(32) 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 `labels`
--

INSERT INTO `labels` (`id`, `company`, `product`, `item_code`, `total`, `pecahan`, `barcode_value`, `title`, `custom_code_text`, `barcode_type`, `qty`, `notes`, `import_batch`, `created_at`, `updated_at`) VALUES
(4045, 'BPD', 'BS', '5G213TH26', NULL, NULL, 'BPDBS5G213TH26', 'BETA PHARMACON * DBS', 'BPDBS5G213TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4046, 'BPD', 'BS', '5G214TH26', NULL, NULL, 'BPDBS5G214TH26', 'BETA PHARMACON * DBS', 'BPDBS5G214TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4047, 'BPD', 'BS', '5G215TH26', NULL, NULL, 'BPDBS5G215TH26', 'BETA PHARMACON * DBS', 'BPDBS5G215TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4048, 'BPD', 'BS', '5G216TH26', NULL, NULL, 'BPDBS5G216TH26', 'BETA PHARMACON * DBS', 'BPDBS5G216TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4049, 'BPD', 'BS', '5G217TH26', NULL, NULL, 'BPDBS5G217TH26', 'BETA PHARMACON * DBS', 'BPDBS5G217TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4050, 'BPD', 'BS', '5G218TH26', NULL, NULL, 'BPDBS5G218TH26', 'BETA PHARMACON * DBS', 'BPDBS5G218TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4051, 'BPD', 'BS', '5G219TH26', NULL, NULL, 'BPDBS5G219TH26', 'BETA PHARMACON * DBS', 'BPDBS5G219TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4052, 'BPD', 'BS', '5G220TH26', NULL, NULL, 'BPDBS5G220TH26', 'BETA PHARMACON * DBS', 'BPDBS5G220TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4053, 'BPD', 'BS', '5G221TH26', NULL, NULL, 'BPDBS5G221TH26', 'BETA PHARMACON * DBS', 'BPDBS5G221TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4054, 'BPD', 'BS', '5G222TH26', NULL, NULL, 'BPDBS5G222TH26', 'BETA PHARMACON * DBS', 'BPDBS5G222TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4055, 'BPD', 'BS', '5G223TH26', NULL, NULL, 'BPDBS5G223TH26', 'BETA PHARMACON * DBS', 'BPDBS5G223TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4056, 'BPD', 'BS', '5G224TH26', NULL, NULL, 'BPDBS5G224TH26', 'BETA PHARMACON * DBS', 'BPDBS5G224TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4057, 'BPD', 'BS', '5G225TH26', NULL, NULL, 'BPDBS5G225TH26', 'BETA PHARMACON * DBS', 'BPDBS5G225TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4058, 'BPD', 'BS', '5G226TH26', NULL, NULL, 'BPDBS5G226TH26', 'BETA PHARMACON * DBS', 'BPDBS5G226TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4059, 'BPD', 'BS', '5G227TH26', NULL, NULL, 'BPDBS5G227TH26', 'BETA PHARMACON * DBS', 'BPDBS5G227TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4060, 'BPD', 'BS', '5G228TH26', NULL, NULL, 'BPDBS5G228TH26', 'BETA PHARMACON * DBS', 'BPDBS5G228TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4061, 'BPD', 'BS', '5G229TH26', NULL, NULL, 'BPDBS5G229TH26', 'BETA PHARMACON * DBS', 'BPDBS5G229TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4062, 'BPD', 'BS', '5G230TH26', NULL, NULL, 'BPDBS5G230TH26', 'BETA PHARMACON * DBS', 'BPDBS5G230TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4063, 'BPD', 'BS', '5G231TH26', NULL, NULL, 'BPDBS5G231TH26', 'BETA PHARMACON * DBS', 'BPDBS5G231TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4064, 'BPD', 'BS', '5G232TH26', NULL, NULL, 'BPDBS5G232TH26', 'BETA PHARMACON * DBS', 'BPDBS5G232TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4065, 'BPD', 'BS', '5G233TH26', NULL, NULL, 'BPDBS5G233TH26', 'BETA PHARMACON * DBS', 'BPDBS5G233TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4066, 'BPD', 'BS', '5G234TH26', NULL, NULL, 'BPDBS5G234TH26', 'BETA PHARMACON * DBS', 'BPDBS5G234TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4067, 'BPD', 'BS', '5G235TH26', NULL, NULL, 'BPDBS5G235TH26', 'BETA PHARMACON * DBS', 'BPDBS5G235TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4068, 'BPD', 'BS', '5G236TH26', NULL, NULL, 'BPDBS5G236TH26', 'BETA PHARMACON * DBS', 'BPDBS5G236TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4069, 'BPD', 'BS', '5G237TH26', NULL, NULL, 'BPDBS5G237TH26', 'BETA PHARMACON * DBS', 'BPDBS5G237TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4070, 'BPD', 'BS', '5G238TH26', NULL, NULL, 'BPDBS5G238TH26', 'BETA PHARMACON * DBS', 'BPDBS5G238TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4071, 'BPD', 'BS', '5G239TH26', NULL, NULL, 'BPDBS5G239TH26', 'BETA PHARMACON * DBS', 'BPDBS5G239TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4072, 'BPD', 'BS', '5G240TH26', NULL, NULL, 'BPDBS5G240TH26', 'BETA PHARMACON * DBS', 'BPDBS5G240TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4073, 'BPD', 'BS', '5G241TH26', NULL, NULL, 'BPDBS5G241TH26', 'BETA PHARMACON * DBS', 'BPDBS5G241TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4074, 'BPD', 'BS', '5G242TH26', NULL, NULL, 'BPDBS5G242TH26', 'BETA PHARMACON * DBS', 'BPDBS5G242TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4075, 'BPD', 'BS', '5G243TH26', NULL, NULL, 'BPDBS5G243TH26', 'BETA PHARMACON * DBS', 'BPDBS5G243TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4076, 'BPD', 'BS', '10G186TH26', NULL, NULL, 'BPDBS10G186TH26', 'BETA PHARMACON * DBS', 'BPDBS10G186TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4077, 'BPD', 'BS', '10G187TH26', NULL, NULL, 'BPDBS10G187TH26', 'BETA PHARMACON * DBS', 'BPDBS10G187TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4078, 'BPD', 'BS', '10G188TH26', NULL, NULL, 'BPDBS10G188TH26', 'BETA PHARMACON * DBS', 'BPDBS10G188TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4079, 'BPD', 'BS', '10G189TH26', NULL, NULL, 'BPDBS10G189TH26', 'BETA PHARMACON * DBS', 'BPDBS10G189TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4080, 'BPD', 'BS', '10G190TH26', NULL, NULL, 'BPDBS10G190TH26', 'BETA PHARMACON * DBS', 'BPDBS10G190TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4081, 'BPD', 'BS', '10G191TH26', NULL, NULL, 'BPDBS10G191TH26', 'BETA PHARMACON * DBS', 'BPDBS10G191TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4082, 'BPD', 'BS', '10G192TH26', NULL, NULL, 'BPDBS10G192TH26', 'BETA PHARMACON * DBS', 'BPDBS10G192TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4083, 'BPD', 'BS', '10G193TH26', NULL, NULL, 'BPDBS10G193TH26', 'BETA PHARMACON * DBS', 'BPDBS10G193TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05'),
(4084, 'BPD', 'BS', '10G194TH26', NULL, NULL, 'BPDBS10G194TH26', 'BETA PHARMACON * DBS', 'BPDBS10G194TH26', 'code128', 1, 'BETA PHARMACON * DBS', 'bulk20260806085205', '2026-08-06 01:52:05', '2026-08-06 01:52:05');

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

--
-- 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_07_30_000000_create_labels_table', 1),
(5, '2026_07_30_100000_add_total_and_pecahan_to_labels_table', 1),
(6, '2026_07_30_110000_add_import_batch_to_labels_table', 1),
(7, '2026_07_30_120000_sync_label_title_with_ket', 2),
(8, '2026_08_04_040237_add_custom_code_text_to_labels_table', 3);

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('5K4GZ2KWVspKU1xV4IBl7WePtA0AZTmnVByJZh4u', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJYb2Y2dkx6Y0VSd3FiVVlUeGZrZDRoSVE5bXUydGpjem9JdUZzZ1hOIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9sYWJlbHNcL3ByaW50P2lkcyU1QjAlNUQ9NDA4NCZpZHMlNUIxJTVEPTQwODMmaWRzJTVCMiU1RD00MDgyJmlkcyU1QjMlNUQ9NDA4MSZpZHMlNUI0JTVEPTQwODAmaWRzJTVCNSU1RD00MDc5JmlkcyU1QjYlNUQ9NDA3OCZpZHMlNUI3JTVEPTQwNzcmaWRzJTVCOCU1RD00MDc2JmlkcyU1QjklNUQ9NDA3NSZpZHMlNUIxMCU1RD00MDc0JmlkcyU1QjExJTVEPTQwNzMmaWRzJTVCMTIlNUQ9NDA3MiZpZHMlNUIxMyU1RD00MDcxJmlkcyU1QjE0JTVEPTQwNzAmaWRzJTVCMTUlNUQ9NDA2OSZpZHMlNUIxNiU1RD00MDY4JmlkcyU1QjE3JTVEPTQwNjcmaWRzJTVCMTglNUQ9NDA2NiZpZHMlNUIxOSU1RD00MDY1JmlkcyU1QjIwJTVEPTQwNjQmaWRzJTVCMjElNUQ9NDA2MyZpZHMlNUIyMiU1RD00MDYyJmlkcyU1QjIzJTVEPTQwNjEmaWRzJTVCMjQlNUQ9NDA2MCZpZHMlNUIyNSU1RD00MDU5JmlkcyU1QjI2JTVEPTQwNTgmaWRzJTVCMjclNUQ9NDA1NyZpZHMlNUIyOCU1RD00MDU2JmlkcyU1QjI5JTVEPTQwNTUmaWRzJTVCMzAlNUQ9NDA1NCZpZHMlNUIzMSU1RD00MDUzJmlkcyU1QjMyJTVEPTQwNTImaWRzJTVCMzMlNUQ9NDA1MSZpZHMlNUIzNCU1RD00MDUwJmlkcyU1QjM1JTVEPTQwNDkmaWRzJTVCMzYlNUQ9NDA0OCZpZHMlNUIzNyU1RD00MDQ3JmlkcyU1QjM4JTVEPTQwNDYmaWRzJTVCMzklNUQ9NDA0NSIsInJvdXRlIjoibGFiZWxzLnByaW50In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1786006333),
('JJpZXPcPzhO5LUoFLy6PcTPOQFlG4ireaHAx7Gx9', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJROW5PUFY1OEdFTWMwaVhXUTE3MzY1ZkNxU2t2VjJubktTbFZTNzRiIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9sYWJlbHMiLCJyb3V0ZSI6ImxhYmVscy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1786068345);

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

--
-- 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,
  `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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `labels`
--
ALTER TABLE `labels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `labels_barcode_value_unique` (`barcode_value`),
  ADD KEY `labels_company_index` (`company`),
  ADD KEY `labels_item_code_index` (`item_code`),
  ADD KEY `labels_import_batch_index` (`import_batch`);

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

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

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

--
-- 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 `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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