-- 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 */;