-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `laravelpos`
--

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

--
-- Table structure for table `absences`
--

CREATE TABLE `absences` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `login_at` time NOT NULL,
  `logout_at` time 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 `absences`
--

INSERT INTO `absences` (`id`, `user_id`, `login_at`, `logout_at`, `created_at`, `updated_at`) VALUES
(1, 11, '13:29:00', '13:31:00', '2025-01-19 06:29:25', '2025-01-19 06:31:11'),
(2, 9, '13:31:00', '13:32:00', '2025-01-19 06:31:17', '2025-01-19 06:32:08'),
(3, 11, '13:32:00', NULL, '2025-01-19 06:32:13', '2025-01-19 06:32:13');

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `qty` int(11) NOT NULL,
  `subtotal` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'esse', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(2, 'excepturi', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(3, 'architecto', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(4, 'nobis', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(5, 'molestiae', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(6, 'consequatur', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(7, 'consequuntur', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(8, 'ut', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(9, 'sit', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(10, 'optio', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(11, 'dolores', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(12, 'et', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(13, 'voluptas', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(14, 'eum', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(15, 'magni', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(16, 'voluptatum', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(17, 'eius', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(18, 'iste', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(19, 'aut', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(20, 'veniam', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` 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 `customers`
--

INSERT INTO `customers` (`id`, `name`, `phone`, `address`, `created_at`, `updated_at`) VALUES
(1, 'Claud Bednar', '+1 (586) 934-6130', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(2, 'Mrs. Marian Lindgren', '+1-651-808-8388', '62742 Crooks Crest\nSouth Winnifred, IN 21490', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(3, 'Miss Trisha Champlin', '661-703-3354', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(4, 'Jermaine Hoeger', '+1.985.953.6839', '786 Feil Garden\nBartonstad, NE 30812-6220', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(5, 'Toney Lakin', '(520) 604-8738', '654 Stanton Cliff Apt. 819\nHuelsborough, WA 84661', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(6, 'Florencio Fahey', '+1.814.734.4981', '5730 Isac Light Suite 759\nLake Tobin, MT 77569', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(7, 'Tyra Murray I', '419-692-6180', '68465 Sipes Coves\nNorth Ebonymouth, OH 65115', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(8, 'Birdie Doyle', '234.792.2666', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(9, 'Dr. Anjali Goldner', '+1.646.732.3896', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(10, 'Miss Bria Marquardt DVM', '+1.848.982.6155', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(11, 'Dr. Weldon Connelly', '980-876-3012', '85289 Doyle Bridge\nFredyfort, OK 73365', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(12, 'Miss Alexane Fahey', '870.427.8921', '77982 Justice Islands Apt. 999\nLorenzatown, DE 77127', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(13, 'Hilma Christiansen', '912-692-0234', '46288 D\'Amore Shoals\nCarterview, UT 27259', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(14, 'Enola Champlin II', '+1-470-787-7282', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(15, 'Kyla Durgan', '(220) 273-1016', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(16, 'Dr. Alfonzo Hansen', '(678) 958-4153', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(17, 'Christa Casper', '+1-571-764-2670', '78081 Arno Tunnel Apt. 851\nCormierport, AK 15664', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(18, 'Kadin Ferry', '706.565.4514', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(19, 'Rory Mayer', '908-234-6650', '59866 Kling Squares Suite 564\nLake Mariahborough, AK 01138-2902', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(20, 'Maryse O\'Hara', '(279) 657-3636', '8575 Pollich Path Suite 667\nSouth Billie, WV 40181-5588', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(21, 'Loyal Turcotte', '1-956-666-0300', '475 Tamara Forks Suite 253\nJeraldberg, MI 12293-8657', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(22, 'Misty Carter I', '352-714-6763', '3510 Ruecker Junctions\nLaneport, MT 46489-3252', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(23, 'Ewald Feest', '1-785-492-2316', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(24, 'Dr. Kasandra Hahn II', '+18705059752', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(25, 'Royal Hane', '380.200.2284', NULL, '2025-01-19 06:28:46', '2025-01-19 06:28:46');

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

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

CREATE TABLE `items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `cost_price` int(11) NOT NULL,
  `selling_price` int(11) NOT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `picture` varchar(255) NOT NULL DEFAULT 'default.png',
  `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 `items`
--

INSERT INTO `items` (`id`, `name`, `code`, `category_id`, `cost_price`, `selling_price`, `stock`, `picture`, `created_at`, `updated_at`) VALUES
(1, 'Off--\' \'Nonsense!\' said.', 'REXE2104', 13, 4847, 7317, 63, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(2, 'Footman continued in.', 'IFHJ6081', 20, 3842, 9088, 96, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(3, 'Hatter: \'as the things.', 'PXFB8034', 9, 5166, 1917, 19, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(4, 'Twinkle, twinkle--\"\'.', 'NCDC0248', 2, 5005, 6023, 9, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(5, 'Gryphon, and, taking.', 'JZMX2376', 2, 9643, 5754, 89, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(6, 'Alice did not come the.', 'TMDA1225', 3, 8480, 6176, 98, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(7, 'An enormous puppy was.', 'OTXJ6849', 1, 2351, 8927, 51, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(8, 'Who Stole the Tarts?.', 'JKNH6456', 2, 1885, 4881, 1, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(9, 'Alice. \'It must have.', 'JXQI6653', 5, 7296, 2106, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(10, 'Alice, \'or perhaps they.', 'BXTI2114', 14, 1213, 1593, 49, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(11, 'Alice thought decidedly.', 'CUOD8211', 10, 2262, 5954, 52, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(12, 'Alice thought she might.', 'LEFE5383', 1, 6120, 9176, 52, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(13, 'Father William,\' the.', 'YZWF0811', 8, 5818, 5243, 77, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(14, 'Hatter was the Rabbit.', 'OIPL7024', 16, 1707, 8355, 58, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(15, 'White Rabbit, \'but it.', 'XIAW4419', 10, 7226, 8065, 86, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(16, 'Alice could only see.', 'CHEN5222', 16, 2151, 1104, 46, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(17, 'Duchess said to itself.', 'UTXU2197', 1, 2832, 3378, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(18, 'Which shall sing?\' \'Oh.', 'GDWY7198', 14, 7356, 1128, 35, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(19, 'There was nothing on it.', 'ILCQ5006', 20, 7554, 6386, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(20, 'King, \'and don\'t look.', 'AMJN8085', 19, 1943, 5614, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(21, 'Alice could only hear.', 'BIYC6097', 19, 2968, 7674, 78, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(22, 'She went on for some.', 'JVTJ6619', 15, 1996, 3108, 20, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(23, 'Mock Turtle in a deep.', 'ZOIL0834', 14, 2211, 6688, 29, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(24, 'I can\'t tell you more.', 'AFQR6417', 9, 6993, 5408, 72, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(25, 'Alice\'s, and they went.', 'ISEP3416', 4, 6459, 5627, 10, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(26, 'While she was dozing.', 'GBJK9523', 8, 6444, 6544, 99, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(27, 'Cat, \'or you wouldn\'t.', 'HPZW9676', 6, 7512, 4084, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(28, 'I mentioned before, And.', 'OCKT5266', 18, 8290, 1616, 5, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(29, 'There are no mice in.', 'HUAP9355', 17, 4382, 8292, 42, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(30, 'Alice. The poor little.', 'ISKD9626', 20, 7411, 5414, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(31, 'By this time with one.', 'LCST4782', 13, 5018, 1295, 80, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(32, 'Gryphon at the bottom.', 'QYSU6439', 6, 9653, 2463, 33, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(33, 'As she said to itself.', 'LNRG8576', 1, 7270, 2741, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(34, 'It\'s by far the most.', 'WFDL7118', 10, 1821, 7385, 84, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(35, 'King. \'It began with.', 'ZJWW6087', 12, 9929, 6655, 96, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(36, 'Alice hastily, afraid.', 'KUFF1039', 14, 1657, 2222, 31, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(37, 'They all made of solid.', 'VERX9215', 3, 9961, 8744, 20, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(38, 'Alice, \'and why it is I.', 'GZML2115', 14, 8114, 1907, 81, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(39, 'Dinah my dear! I shall.', 'BYQH2140', 12, 9590, 3283, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(40, 'I say--that\'s the same.', 'UOVJ7818', 16, 3200, 7299, 9, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(41, 'Rabbit\'s voice; and the.', 'QSPF6178', 6, 4139, 2875, 44, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(42, 'Cat went on, \'if you.', 'DZCO7759', 7, 2710, 7433, 25, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(43, 'Gryphon, with a sudden.', 'EHGJ1346', 1, 3620, 1536, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(44, 'March Hare. Alice was a.', 'XYIU6392', 4, 5378, 8734, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(45, 'But here, to Alice\'s.', 'CREU1919', 14, 4705, 5826, 88, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(46, 'Alice for protection.', 'MTZR3558', 14, 3196, 6635, 8, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(47, 'The great question is.', 'ZSMV3380', 4, 2446, 9317, 18, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(48, 'Off--\' \'Nonsense!\' said.', 'SRTM9952', 6, 2638, 8043, 13, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(49, 'Queen in front of them.', 'PBUX1604', 19, 1032, 9030, 63, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(50, 'Alice went on muttering.', 'SVUK7559', 13, 3673, 4430, 73, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(51, 'Mouse, who was sitting.', 'DPYT3978', 18, 4388, 1531, 79, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(52, 'VERY turn-up nose, much.', 'PYKR3999', 8, 8383, 2479, 62, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(53, 'The March Hare will be.', 'PTUO3645', 6, 8095, 3202, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(54, 'White Rabbit: it was.', 'RYPY2335', 10, 5953, 6384, 36, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(55, 'Just then her head down.', 'NOUU2660', 7, 7017, 1628, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(56, 'King; and as the jury.', 'IMNB9421', 4, 2449, 9588, 24, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(57, 'The Dormouse had closed.', 'EZIM3705', 1, 3991, 3265, 52, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(58, 'Alice. \'Come on, then,\'.', 'UOIH0003', 6, 3896, 8457, 56, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(59, 'Yet you balanced an eel.', 'CCBM1905', 8, 8276, 6457, 84, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(60, 'Hatter said, turning to.', 'VJSY9537', 13, 2083, 7163, 8, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(61, 'Mock Turtle; \'but it.', 'QWZA8537', 12, 1879, 6494, 33, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(62, 'Alice. \'Who\'s making.', 'ULUZ4703', 3, 9641, 2407, 47, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(63, 'I am! But I\'d better.', 'UUXN6207', 4, 3748, 8951, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(64, 'WAS a narrow escape!\'.', 'JEBU2745', 17, 6513, 3094, 47, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(65, 'Mabel! I\'ll try if I.', 'FPIH5565', 14, 3796, 3017, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(66, 'Hatter\'s remark seemed.', 'CPVD3542', 6, 4765, 9639, 41, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(67, 'But if I\'m not used to.', 'WCCB0987', 16, 1532, 9291, 86, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(68, 'Antipathies, I think--\'.', 'FNNI1733', 9, 8876, 5198, 69, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(69, 'As she said to herself.', 'OWDL7857', 6, 4290, 2902, 58, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(70, 'Time!\' \'Perhaps not,\'.', 'IKBA8546', 20, 2799, 2381, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(71, 'Alice)--\'and perhaps.', 'BEOG9849', 8, 5379, 1748, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(72, 'Queen to play croquet.', 'QNNW0101', 16, 2291, 1912, 47, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(73, 'Alice: \'I don\'t think.', 'LPXZ3422', 6, 7373, 7161, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(74, 'Hatter. Alice felt a.', 'EAXC1935', 12, 3010, 8638, 44, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(75, 'Queen! The Queen!\' and.', 'MDZU2524', 20, 3841, 8410, 28, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(76, 'Tell her to carry it.', 'OIKQ6019', 6, 1667, 7773, 50, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(77, 'Duchess. An invitation.', 'MUXB2050', 20, 1645, 7817, 58, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(78, 'King hastily said, and.', 'ZUFI6203', 1, 9923, 9904, 10, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(79, 'The judge, by the fire.', 'YDYB6901', 4, 7204, 1186, 2, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(80, 'Alice alone with the.', 'WPHV5012', 13, 8677, 9618, 63, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(81, 'There was no time she\'d.', 'GIMM4845', 16, 8767, 6508, 73, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(82, 'Duck. \'Found IT,\' the.', 'TZWB5170', 13, 1338, 8204, 17, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(83, 'The Dormouse shook its.', 'JGCD1956', 6, 9050, 5384, 83, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(84, 'Oh, my dear Dinah! I.', 'EOTB9687', 5, 4045, 3076, 29, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(85, 'And Alice was silent.', 'OTOX7045', 20, 1623, 3005, 76, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(86, 'Alice waited till the.', 'HVLP8834', 1, 6590, 4881, 45, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(87, 'Alice had been for some.', 'GUDT5154', 18, 2408, 9350, 22, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(88, 'King repeated angrily.', 'KTIV0284', 16, 9906, 3721, 50, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(89, 'For some minutes the.', 'WRSE8291', 8, 7961, 6456, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(90, 'Gryphon, before Alice.', 'HDBH2567', 6, 6417, 1806, 58, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(91, 'Alice remarked. \'Right.', 'ZCUD4127', 8, 8438, 1750, 7, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(92, 'Alice, timidly; \'some.', 'VOJN7375', 14, 8404, 8824, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(93, 'Queen. \'Never!\' said.', 'MBIR3791', 7, 8665, 9486, 10, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(94, 'I\'ll set Dinah at you!\'.', 'PBVS3246', 11, 5145, 8244, 32, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(95, 'This time Alice waited.', 'ZOFC3367', 6, 5192, 1079, 30, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(96, 'Alice; \'living at the.', 'CSYE2010', 17, 7650, 6055, 24, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(97, 'Alice waited a little.', 'ORZK7260', 20, 6976, 7335, 48, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(98, 'I don\'t think,\' Alice.', 'MRLL3197', 18, 8909, 4125, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(99, 'Wonderland, though she.', 'WLSV7334', 5, 3480, 6360, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(100, 'CHAPTER V. Advice from.', 'DKWI5519', 9, 6264, 7506, 18, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(101, 'Has lasted the rest of.', 'PWXB6093', 19, 2133, 8455, 92, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(102, 'Lizard, who seemed to.', 'CZPK4751', 17, 2054, 7129, 30, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(103, 'How puzzling all these.', 'SMJY0626', 9, 2392, 4363, 55, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(104, 'First, because I\'m on.', 'RFSZ5090', 2, 3058, 7808, 49, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(105, 'Duchess, \'and that\'s a.', 'YXSU2230', 13, 9534, 3018, 24, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(106, 'Gryphon, the squeaking.', 'PGSR4300', 16, 3957, 7114, 40, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(107, 'Knave \'Turn them over!\'.', 'HQRI1220', 2, 2479, 6860, 31, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(108, 'Dormouse said--\' the.', 'OJNQ1770', 16, 4171, 1712, 87, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(109, 'Alice for protection.', 'NHTO5564', 12, 9291, 1062, 35, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(110, 'Alice, very much what.', 'LRRG0512', 5, 8701, 2892, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(111, 'Miss, we\'re doing our.', 'IDAE4304', 6, 7864, 3928, 34, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(112, 'By the time when she.', 'ELKI4052', 1, 6253, 1638, 93, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(113, 'Lizard\'s slate-pencil.', 'SZRY1012', 11, 8127, 8297, 25, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(114, 'Alice. \'Of course not,\'.', 'RLJP4749', 10, 9250, 5009, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(115, 'At last the Caterpillar.', 'HGTI6929', 3, 2670, 8661, 14, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(116, 'THE LITTLE BUSY BEE,\".', 'CTBN9754', 4, 4952, 3089, 55, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(117, 'King repeated angrily.', 'SINI7980', 17, 2708, 3527, 23, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(118, 'King repeated angrily.', 'YMQI1704', 17, 8171, 4407, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(119, 'Mock Turtle said with.', 'QTFH0231', 3, 4751, 7962, 67, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(120, 'Some of the garden: the.', 'UWHF9953', 9, 1900, 9131, 13, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(121, 'Mock Turtle said with.', 'EQJO7825', 8, 2511, 4569, 7, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(122, 'The Dormouse had closed.', 'TARM7799', 15, 3996, 1571, 43, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(123, 'So she set to work very.', 'XWXM7891', 6, 1827, 8706, 33, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(124, 'Half-past one, time for.', 'HWXN0748', 11, 9670, 7249, 12, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(125, 'Alice was so long that.', 'TWNS5233', 20, 8159, 3380, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(126, 'The Dormouse again took.', 'PYDZ0522', 10, 2828, 8757, 5, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(127, 'WILL do next! As for.', 'KDRR7828', 9, 8773, 2444, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(128, 'King, \'that only makes.', 'SFVC3997', 2, 4217, 2297, 25, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(129, 'I will tell you how it.', 'YHJB0491', 17, 2055, 4734, 97, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(130, 'Queen, in a Little Bill.', 'YJBA7571', 5, 7567, 9578, 85, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(131, 'Some of the shepherd.', 'SHSD1585', 4, 2444, 4714, 8, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(132, 'I grow at a king,\' said.', 'MHZR5816', 15, 3351, 9186, 17, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(133, 'Mouse, who seemed to.', 'TRTJ8070', 5, 5779, 1233, 82, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(134, 'What happened to me!.', 'RZOA4264', 9, 5966, 6391, 81, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(135, 'Queen. \'Can you play.', 'BVQA0052', 11, 5831, 7732, 34, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(136, 'I? Ah, THAT\'S the great.', 'DZUO8479', 9, 5009, 2508, 77, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(137, 'Alice ventured to taste.', 'AZPN4247', 8, 3467, 1639, 70, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(138, 'Alice could think of.', 'LMFO7309', 4, 6504, 6216, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(139, 'Queen had ordered. They.', 'HYDA0486', 10, 4920, 2216, 59, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(140, 'I can\'t get out again.', 'WBOI6356', 2, 7067, 9443, 97, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(141, 'Dormouse shall!\' they.', 'SRAS3813', 11, 5563, 9762, 86, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(142, 'By this time it all is!.', 'NDWG6182', 1, 2437, 5900, 99, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(143, 'I know who I am! But.', 'GSFN5362', 16, 9510, 5508, 8, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(144, 'DON\'T know,\' said Alice.', 'FQQD4669', 2, 5942, 4274, 62, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(145, 'Come on!\' So they got.', 'RVET4094', 4, 3832, 7655, 7, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(146, 'I suppose I ought to.', 'TDNM9530', 16, 3299, 4026, 7, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(147, 'HAVE their tails fast.', 'GRBC5721', 15, 7221, 5902, 48, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(148, 'I think I should think.', 'DFOA7753', 15, 7916, 9453, 31, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(149, 'Queen had ordered. They.', 'IRTY4889', 13, 7034, 9516, 40, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(150, 'May it won\'t be raving.', 'VEBZ2824', 17, 7270, 5678, 31, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(151, 'CAN all that stuff,\'.', 'JPVN1189', 16, 1766, 6227, 98, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(152, 'Queen\'s voice in the.', 'IPAX1633', 2, 7314, 9257, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(153, 'Mouse replied rather.', 'OOTR3717', 2, 9442, 2437, 53, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(154, 'At last the Caterpillar.', 'ICJD7715', 9, 2769, 7703, 51, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(155, 'Alice; \'it\'s laid for a.', 'JYCW0788', 10, 9856, 5338, 34, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(156, 'However, she got used.', 'CFRG5884', 20, 7123, 2454, 49, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(157, 'Alice began to tremble.', 'EPZP6142', 17, 6025, 2203, 28, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(158, 'For the Mouse to tell.', 'MMGZ1438', 8, 2080, 1334, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(159, 'Paris, and Paris is the.', 'YJIG6621', 11, 9718, 8926, 6, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(160, 'Alice could see, when.', 'GTOZ8283', 1, 8208, 3412, 61, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(161, 'Gryphon. Alice did not.', 'LYGV6708', 5, 2683, 1352, 96, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(162, 'Alice, (she had kept a.', 'WBMG5137', 12, 1567, 8875, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(163, 'King, the Queen, \'and.', 'HMRV4851', 13, 2456, 9211, 55, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(164, 'And so it was not much.', 'VDAS3806', 6, 4626, 6139, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(165, 'The master was an old.', 'ZWBN0412', 2, 9898, 8446, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(166, 'Alice; \'I can\'t explain.', 'AHVS0123', 10, 2702, 7494, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(167, 'Alice laughed so much.', 'YUOJ4859', 14, 3708, 3392, 49, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(168, 'Mock Turtle said with.', 'YDFE5494', 14, 5284, 7734, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(169, 'Alice to herself, in a.', 'FKTI2311', 13, 6370, 5017, 2, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(170, 'It\'s enough to try the.', 'KPMD1975', 6, 6067, 1470, 46, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(171, 'Caterpillar. \'Not QUITE.', 'VVIN1741', 13, 6553, 1684, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(172, 'I had not attended to.', 'EHGX0083', 16, 1564, 1281, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(173, 'So she sat still just.', 'JZAM3149', 1, 7024, 2828, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(174, 'This time Alice waited.', 'HJCM1713', 9, 1451, 9660, 84, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(175, 'Gryphon, before Alice.', 'JAUX9089', 5, 7224, 7518, 78, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(176, 'Alice, (she had kept a.', 'VIGW9832', 8, 5025, 8861, 67, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(177, 'Duchess: \'and the moral.', 'GXNU0504', 20, 9456, 4896, 61, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(178, 'Queen said to herself.', 'EVHQ9842', 17, 7287, 8966, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(179, 'CHAPTER V. Advice from.', 'SOMS2955', 2, 4347, 9526, 2, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(180, 'Alice herself, and once.', 'CYHY7358', 14, 5848, 9567, 47, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(181, 'Tell me that first, and.', 'ZTBY0830', 1, 4387, 6512, 25, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(182, 'Mock Turtle sang this.', 'NSUJ8307', 5, 3797, 7984, 5, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(183, 'Said his father; \'don\'t.', 'FSMG6349', 19, 6511, 7794, 99, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(184, 'Queen\'s hedgehog just.', 'NPBE0759', 18, 9963, 1159, 40, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(185, 'QUEEN OF HEARTS. Alice.', 'ZVPE9216', 2, 4587, 8851, 86, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(186, 'The baby grunted again.', 'LQMI7392', 10, 2197, 1386, 46, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(187, 'However, I\'ve got back.', 'UPGU5252', 10, 5265, 8101, 38, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(188, 'Alice. \'And ever since.', 'PCHB1042', 16, 1017, 7099, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(189, 'Queen?\' said the Mouse.', 'OPYQ8205', 20, 9976, 3005, 97, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(190, 'Queen said to the table.', 'CEIA3382', 7, 4911, 6180, 99, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(191, 'Mock Turtle, capering.', 'ZLPU4258', 13, 8843, 2850, 23, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(192, 'Prizes!\' Alice had got.', 'ZHRU2366', 11, 5964, 7158, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(193, 'Alice, \'shall I NEVER.', 'BCHQ1522', 4, 9247, 7268, 67, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(194, 'First, because I\'m on.', 'DKEL1985', 1, 9856, 7481, 50, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(195, 'WOULD always get into.', 'OMSO9391', 7, 6160, 3261, 20, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(196, 'What would become of.', 'ZLQS8220', 10, 9178, 4909, 6, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(197, 'There was exactly one.', 'YIYI7337', 16, 1286, 1935, 91, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(198, 'The long grass rustled.', 'HPFU5890', 2, 3063, 1208, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(199, 'Do you think, at your.', 'WSUN3737', 20, 9127, 5235, 23, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(200, 'Dormouse into the sea.', 'OCVH7095', 6, 2339, 6671, 20, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(201, 'But there seemed to be.', 'QGPU8215', 19, 4118, 4432, 80, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(202, 'Mock Turtle, and to her.', 'EXNY7987', 16, 7672, 4625, 17, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(203, 'Rabbit in a deep voice.', 'DMPF1178', 6, 9210, 2441, 91, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(204, 'CHAPTER IX. The Mock.', 'ISYD6025', 6, 2359, 7497, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(205, 'I shall see it quite.', 'RMVR7688', 7, 8598, 9634, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(206, 'Lobster Quadrille, that.', 'YCFN4551', 8, 4412, 6597, 91, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(207, 'Alice began, in rather.', 'CFOT4490', 12, 9373, 9065, 51, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(208, 'And beat him when he.', 'YBGW7431', 10, 2722, 3591, 76, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(209, 'Dormouse, not choosing.', 'DPEJ8199', 18, 6567, 5116, 42, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(210, 'I will just explain to.', 'OYVK0243', 17, 2769, 5843, 21, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(211, 'But do cats eat bats, I.', 'DFFE6618', 18, 5376, 1324, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(212, 'Bill It was so full of.', 'MATH9949', 8, 3632, 8515, 35, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(213, 'He says it kills all.', 'WWFV3276', 2, 3849, 7178, 52, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(214, 'Mouse was swimming away.', 'RRDT9352', 18, 4198, 1836, 97, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(215, 'BEST butter, you know.\'.', 'AUEI3509', 12, 4495, 5693, 68, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(216, 'The Dormouse shook its.', 'JVZD6742', 14, 4692, 6820, 74, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(217, 'How puzzling all these.', 'QTDW4363', 11, 4511, 3674, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(218, 'MINE.\' The Queen had.', 'DLRD2078', 19, 6161, 9396, 23, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(219, 'In a minute or two she.', 'TRRS9466', 2, 9413, 1157, 94, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(220, 'Gryphon, before Alice.', 'KUHR6851', 12, 6011, 6610, 100, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(221, 'At last the Caterpillar.', 'GVSQ4831', 11, 6493, 7554, 77, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(222, 'I\'ll just see what this.', 'ACPX5395', 12, 9374, 6821, 65, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(223, 'Duchess said to herself.', 'GURQ9680', 10, 6126, 9847, 66, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(224, 'ONE with such sudden.', 'MZAF2005', 10, 5132, 5303, 21, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(225, 'Rabbit came up to the.', 'NVWG4932', 12, 5506, 1790, 93, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(226, 'Why, I do so like that.', 'VRPN9388', 20, 4645, 4281, 27, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(227, 'Majesty!\' the Duchess.', 'XFJY6142', 15, 6088, 3579, 49, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(228, 'Do you think you could.', 'FMQK2787', 9, 9872, 2636, 34, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(229, 'Alice was beginning to.', 'TDUH0493', 2, 2541, 1091, 63, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(230, 'LESS,\' said the Cat, as.', 'TDBK7640', 2, 1937, 2199, 14, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(231, 'HIM TWO--\" why, that.', 'RIOL9098', 19, 2557, 7851, 56, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(232, 'Cheshire Cat, she was.', 'MYKH9462', 13, 7804, 1561, 53, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(233, 'Gryphon in an undertone.', 'ANHZ3251', 20, 4801, 4617, 33, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(234, 'Alice had not the right.', 'RROJ4883', 3, 3229, 8559, 69, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(235, 'Dormouse\'s place, and.', 'UGSQ6493', 7, 9963, 1389, 7, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(236, 'The further off from.', 'PXZF7445', 8, 3381, 7415, 53, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(237, 'It was high time you.', 'ZELW1543', 6, 5906, 3240, 8, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(238, 'Alice like the three.', 'LJCF7790', 1, 7310, 2930, 60, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(239, 'Don\'t let me help to.', 'GIPH0079', 8, 7551, 7936, 24, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(240, 'Tell her to carry it.', 'AKRX9367', 5, 5364, 1767, 10, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(241, 'She was walking hand in.', 'QUGU1380', 20, 4978, 7676, 70, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(242, 'I shall think nothing.', 'JFJN7350', 3, 1344, 4990, 90, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(243, 'VERY long claws and a.', 'MXQQ4107', 11, 8092, 7368, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(244, 'Never heard of one,\'.', 'DMOE0484', 17, 3621, 1547, 86, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(245, 'As soon as look at me.', 'QULD1859', 1, 6729, 4432, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(246, 'But she did it so VERY.', 'EEJI8581', 4, 8995, 6031, 74, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(247, 'However, she soon made.', 'HDQH6710', 13, 6717, 1531, 48, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(248, 'KNOW IT TO BE TRUE--\".', 'RGKC6835', 14, 6177, 2363, 42, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(249, 'Alice did not venture.', 'STRB5782', 11, 9822, 8157, 6, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(250, 'And so she felt certain.', 'JOMZ3813', 2, 5914, 4589, 34, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(251, 'I could show you our.', 'LFXH8933', 1, 3782, 5276, 74, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(252, 'Lory, who at last she.', 'BLFS3807', 9, 1895, 8123, 79, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(253, 'In the very tones of.', 'YLFK4114', 4, 3728, 8435, 94, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(254, 'Duchess; \'I never was.', 'BGQP3967', 1, 6287, 6000, 87, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(255, 'This time there were.', 'MZGQ6267', 18, 9295, 5813, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(256, 'Alice, in a confused.', 'PFZY4514', 19, 8324, 9717, 53, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(257, 'Off with his nose Trims.', 'HBCZ8725', 10, 2163, 4571, 14, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(258, 'Alice said to itself.', 'KSXL5771', 8, 6340, 2459, 47, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(259, 'VERY long claws and a.', 'OKJD7395', 18, 1516, 3641, 57, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(260, 'Trims his belt and his.', 'OAZN1497', 9, 9494, 5615, 76, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(261, 'And in she went. Once.', 'AAZU1640', 1, 5397, 2387, 42, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(262, 'Mock Turtle, \'but if.', 'QADZ9631', 17, 4797, 7257, 55, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(263, 'Alice. \'Come on, then!\'.', 'OUAM3547', 17, 1092, 6126, 71, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(264, 'I chose,\' the Duchess.', 'VPXC1318', 12, 6203, 6330, 76, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(265, 'Hatter. \'Nor I,\' said.', 'MEZI7172', 9, 1152, 5088, 42, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(266, 'I shall have some fun.', 'SACD8059', 20, 8446, 3995, 73, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(267, 'Five, in a wondering.', 'XDOC5474', 10, 4009, 9286, 55, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(268, 'Alice to herself, as.', 'GGUW2043', 10, 6223, 4962, 17, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(269, 'Alice heard it before,\'.', 'IMKX9813', 11, 5973, 7599, 39, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(270, 'I breathe\"!\' \'It IS a.', 'XVWR4706', 12, 8638, 1091, 91, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(271, 'Alice. \'Come on, then!\'.', 'JELO9367', 17, 3123, 5617, 21, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(272, 'I only wish they COULD!.', 'QYHF0737', 13, 5318, 5032, 18, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(273, 'Mock Turtle. \'Hold your.', 'MSPE2795', 7, 5940, 5546, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(274, 'White Rabbit. She was.', 'IGUM0308', 6, 6280, 2248, 36, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(275, 'Time, and round goes.', 'ROIV8360', 18, 2546, 3133, 93, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(276, 'THE BOOTS AND SHOES.\'.', 'DQFP1095', 7, 1011, 6522, 18, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(277, 'Duchess was sitting on.', 'AXBP8298', 2, 5630, 8980, 73, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(278, 'That he met in the same.', 'NIYJ1637', 11, 7613, 9106, 75, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(279, 'Seven flung down his.', 'ZEJX1931', 7, 9475, 4987, 69, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(280, 'Alice, and sighing. \'It.', 'SQDY4284', 5, 9962, 4333, 4, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(281, 'King. \'Shan\'t,\' said.', 'PYSF0365', 10, 7683, 3585, 3, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(282, 'THIS witness.\' \'Well.', 'GIBG7144', 9, 5886, 2457, 16, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(283, 'Miss, this here ought.', 'FWZL8525', 13, 5849, 8610, 36, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(284, 'Alice started to her.', 'NCKG1082', 8, 4209, 7953, 73, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(285, 'It was so small as this.', 'RCAB5043', 17, 6374, 3403, 5, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(286, 'King. Here one of the.', 'VGMA8706', 6, 6748, 3128, 24, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(287, 'I\'ve finished.\' So they.', 'USTY6294', 2, 8710, 5478, 12, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(288, 'Mock Turtle. \'Certainly.', 'BVLF3686', 3, 4142, 2792, 95, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(289, 'Then it got down off.', 'FFWK5416', 7, 1922, 1158, 80, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(290, 'THE SLUGGARD,\"\' said.', 'FQQM3791', 4, 1209, 4039, 1, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(291, 'The players all played.', 'TBBI4104', 3, 3785, 9050, 85, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(292, 'Queen merely remarking.', 'NLZK6888', 11, 9245, 9996, 94, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(293, 'White Rabbit cried out.', 'BNBI0594', 13, 4396, 2268, 60, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(294, 'Do cats eat bats? Do.', 'ZVFH8994', 5, 9081, 7285, 93, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(295, 'I almost wish I hadn\'t.', 'RKEL4213', 4, 8379, 9915, 53, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(296, 'And yet you incessantly.', 'LFPM3527', 15, 7138, 8189, 36, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(297, 'WOULD put their heads.', 'FPKW8448', 9, 2331, 2110, 78, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(298, 'Dormouse crossed the.', 'KFSJ4621', 6, 3874, 3283, 62, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(299, 'I get it home?\' when it.', 'AFRX2938', 12, 3394, 6618, 14, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(300, 'Alice knew it was out.', 'TAWC5820', 18, 9735, 7864, 68, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(301, 'Beras', '0001', 1, 85000, 120000, 100, 'default.png', '2025-01-19 06:28:46', '2025-01-19 06:28:46');

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

--
-- Table structure for table `item_supplier`
--

CREATE TABLE `item_supplier` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `supplier_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) 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 `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, '2024_05_21_174125_create_categories_table', 1),
(5, '2024_05_21_174227_create_customers_table', 1),
(6, '2024_05_21_174511_create_payment_methods_table', 1),
(7, '2024_05_21_175122_create_item_supplier_table', 1),
(8, '2024_05_21_175123_create_wholesale_prices_table', 1),
(9, '2024_05_21_182615_create_carts_table', 1),
(10, '2024_05_22_030109_create_transactions_table', 1),
(11, '2024_05_22_030902_create_transaction_details_table', 1),
(12, '2024_05_27_072011_create_absences_table', 1);

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT 'Tunai',
  `description` 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 `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Tunai', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(2, 'Debit', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(3, 'Kredit', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(4, 'Transfer', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(5, 'OVO', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(6, 'GoPay', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(7, 'Dana', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45'),
(8, 'QRIS', NULL, '2025-01-19 06:28:45', '2025-01-19 06:28:45');

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

--
-- 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
('tdOPXhWoUZBCqRptgEb7NiwVI5v2eRfh3P23jGec', 11, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUkE4QnJtcE9QVVpFTWNrYUlTMm5sZzhQeDdsRzZ1QVFQbmpZNjBadCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQwOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvcmVwb3J0L3RyYW5zYWN0aW9uIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTE7fQ==', 1737293574);

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `description` 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 `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `phone`, `address`, `email`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Schumm-Schumm', '1-531-624-4475', '415 Braun Causeway\nRobertsfurt, WY 47867-1936', 'drew.white@example.net', 'Esse doloremque delectus quaerat voluptatem dicta harum sint.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(2, 'Gottlieb-Wunsch', '234.329.1802', '4665 Gutkowski Place\nNew Elouiseland, WV 76625-2374', 'stacey48@example.net', 'Soluta et temporibus nemo dolore corrupti nihil.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(3, 'Thompson, Nicolas and Yost', '1-304-315-4407', '2009 Ramon Port Apt. 583\nVirgieport, IL 69634-9016', 'thompson.percy@example.org', 'Corporis et minima id ratione quis excepturi sit.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(4, 'Hagenes Ltd', '906.701.7466', '3873 Gusikowski Brook\nHammesshire, KY 18916', 'furman.abshire@example.net', 'Eum qui beatae illum voluptatem voluptatem.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(5, 'Stanton-Labadie', '+13607328219', '93590 Dessie Valley\nEast Zechariah, NE 48982', 'leonardo.jacobs@example.net', 'Vero aut possimus adipisci esse ratione.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(6, 'Schimmel, Ebert and Rohan', '+14436522920', '5422 Lenora Village\nAliyaborough, NM 49391-9777', 'qjohns@example.org', 'Inventore qui voluptatem et mollitia occaecati.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(7, 'King-Wiegand', '661.694.2214', '995 Nikki Fields\nEast Gunnar, DC 95192-7754', 'clark.corkery@example.com', 'A sint ut hic sint ipsum explicabo.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(8, 'Hettinger LLC', '+13394934176', '71508 Bosco Mews Apt. 583\nWest Keshawnton, ND 53594', 'chill@example.net', 'Deleniti illum eos blanditiis quam impedit quas.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(9, 'Kirlin, Dooley and Walker', '469.799.9413', '296 Clark Burgs Suite 167\nClarissafurt, RI 81856', 'russell.nikolaus@example.com', 'Explicabo labore ut aut quo debitis placeat et.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(10, 'Block Group', '(678) 688-9805', '65798 White Green\nLake Weldonberg, CO 00106', 'julian61@example.org', 'Ducimus perferendis modi laudantium eos assumenda.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(11, 'McDermott Ltd', '380.430.2828', '49478 Kennedy Groves\nJaquelinville, SD 87344-7141', 'smurphy@example.net', 'Ducimus cupiditate suscipit cupiditate dolores.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(12, 'Kris and Sons', '678.238.0843', '290 Aurelia Plains Apt. 598\nKirlinport, AL 65339-1503', 'lexi.jerde@example.net', 'Omnis inventore aut maxime alias ullam ea.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(13, 'Lesch PLC', '+1 (504) 508-2711', '4914 Robel Pass\nDouglasfurt, FL 27399-1504', 'trowe@example.net', 'Odit dolorem omnis non voluptates.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(14, 'Grady LLC', '1-279-276-7808', '4204 Purdy Knoll Suite 291\nDannieport, NV 75068', 'cullen.tremblay@example.com', 'Sed ut fugiat debitis odit ut nihil.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(15, 'Ebert and Sons', '+1-832-521-9941', '59495 Everardo Fall Suite 007\nDavinview, OK 11664', 'anne.nienow@example.com', 'Eos suscipit velit voluptas.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(16, 'Jacobson, Schulist and Cole', '1-757-691-2979', '287 Reynolds Island\nWest Oniefurt, ID 49657', 'jast.rachel@example.net', 'Nisi voluptas nihil amet ex.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(17, 'Moen PLC', '1-520-959-1426', '678 Esmeralda Point Suite 885\nMarquardthaven, NE 53298', 'zmoen@example.org', 'Consectetur quas explicabo odit possimus vel dolorum.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(18, 'Schaefer, Cremin and Kulas', '603.852.6512', '80789 Alberto Summit\nEast Hester, MS 44638', 'angelica.legros@example.org', 'Alias corporis excepturi et aut ut quisquam tenetur.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(19, 'Barton, Vandervort and Schaden', '561-847-6701', '9741 Minnie Rue Suite 763\nNorth Melissa, MN 86816-9221', 'tromp.presley@example.org', 'Ut quod labore perspiciatis.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(20, 'Ondricka-Walsh', '+1 (843) 963-4479', '295 Kessler Views\nSkilesmouth, LA 50684-8444', 'qpollich@example.net', 'Voluptates qui omnis illum maiores.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(21, 'Kuhic, Schinner and Kuhlman', '754.201.3049', '1662 Terry Flats Suite 513\nNew Cooperfurt, KY 69853', 'wlubowitz@example.org', 'Sit nostrum libero similique.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(22, 'Green Group', '+1-478-770-5403', '516 Skye Plaza\nPort Leopoldoview, MT 85180-9919', 'ulises99@example.com', 'Vel minus est veniam voluptas excepturi illo.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(23, 'Robel, Tremblay and Gibson', '+1.316.259.3193', '191 Alessia Square\nBorisfort, MT 79348', 'ydouglas@example.com', 'Et quaerat vero iusto delectus aut et libero.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(24, 'Hauck, Daugherty and Quigley', '508.762.7083', '14015 Jerde Locks Suite 398\nEichmannbury, WI 66489-9280', 'grayce47@example.com', 'Consectetur pariatur vel sit.', '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(25, 'Ernser, Bernhard and Hyatt', '828-998-0050', '697 Antonia Stravenue\nWest Erickmouth, PA 07386', 'mason48@example.com', 'Et consequatur nemo quam odit in velit.', '2025-01-19 06:28:46', '2025-01-19 06:28:46');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `invoice` varchar(255) NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `total` int(11) NOT NULL,
  `discount` int(11) NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `change` int(11) NOT NULL DEFAULT 0,
  `status` enum('paid','debt') NOT NULL DEFAULT 'paid',
  `note` 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 `transaction_details`
--

CREATE TABLE `transaction_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `qty` int(11) NOT NULL,
  `item_price` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wholesale_prices`
--

CREATE TABLE `wholesale_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `min_qty` int(11) NOT NULL,
  `price` 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 `wholesale_prices`
--

INSERT INTO `wholesale_prices` (`id`, `item_id`, `min_qty`, `price`, `created_at`, `updated_at`) VALUES
(1, 301, 10, 100000, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(2, 301, 15, 95000, '2025-01-19 06:28:46', '2025-01-19 06:28:46'),
(3, 301, 20, 90000, '2025-01-19 06:28:46', '2025-01-19 06:28:46');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absences`
--
ALTER TABLE `absences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `absences_user_id_foreign` (`user_id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`),
  ADD KEY `carts_item_id_foreign` (`item_id`);

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

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

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

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `items_code_unique` (`code`),
  ADD KEY `items_category_id_foreign` (`category_id`);

--
-- Indexes for table `item_supplier`
--
ALTER TABLE `item_supplier`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_supplier_item_id_foreign` (`item_id`),
  ADD KEY `item_supplier_supplier_id_foreign` (`supplier_id`);

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`),
  ADD KEY `transactions_customer_id_foreign` (`customer_id`),
  ADD KEY `transactions_payment_method_id_foreign` (`payment_method_id`);

--
-- Indexes for table `transaction_details`
--
ALTER TABLE `transaction_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_details_transaction_id_foreign` (`transaction_id`),
  ADD KEY `transaction_details_item_id_foreign` (`item_id`);

--
-- Indexes for table `wholesale_prices`
--
ALTER TABLE `wholesale_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wholesale_prices_item_id_foreign` (`item_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `item_supplier`
--
ALTER TABLE `item_supplier`
  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 `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `absences`
--
ALTER TABLE `absences`
  ADD CONSTRAINT `absences_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `items`
--
ALTER TABLE `items`
  ADD CONSTRAINT `items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `item_supplier`
--
ALTER TABLE `item_supplier`
  ADD CONSTRAINT `item_supplier_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `item_supplier_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transaction_details`
--
ALTER TABLE `transaction_details`
  ADD CONSTRAINT `transaction_details_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_details_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wholesale_prices`
--
ALTER TABLE `wholesale_prices`
  ADD CONSTRAINT `wholesale_prices_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE;
COMMIT;

