text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 22, 2020 at 05:44 PM
  -- Server version: 10.4.11-MariaDB
  -- PHP Version: 7.4.5
  
  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: `project`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `carries`
  --
  
  CREATE TABLE `carries` (
    `store_id` int(11) NOT NULL,
    `barcode` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `self` int(11) DEFAULT NULL,
    `aisle` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `carries`
  --
  
  INSERT INTO `carries` (`store_id`, `barcode`, `self`, `aisle`) VALUES
  (1, '002652773', 46, 43),
  (1, '005666342', 39, 3),
  (1, '031118566', 29, 19),
  (1, '036904572', 7, 24),
  (1, '055493685', 43, 10),
  (1, '061299599', 12, 22),
  (1, '066790483', 39, 0),
  (1, '098764800', 45, 34),
  (1, '107525059', 14, 25),
  (1, '134474971', 39, 49),
  (1, '157926444', 48, 4),
  (1, '164296593', 22, 4),
  (1, '169165199', 18, 41),
  (1, '178191875', 19, 5),
  (1, '189831806', 10, 0),
  (1, '193066153', 43, 14),
  (1, '201029065', 1, 10),
  (1, '204463191', 45, 39),
  (1, '208925700', 49, 14),
  (1, '209669373', 30, 43),
  (1, '209905415', 0, 32),
  (1, '216263427', 1, 44),
  (1, '231882891', 38, 18),
  (1, '233875714', 16, 17),
  (1, '261424165', 2, 38),
  (1, '280198860', 31, 10),
  (1, '283528929', 36, 9),
  (1, '287157769', 49, 8),
  (1, '376561556', 4, 22),
  (1, '380985208', 28, 31),
  (1, '430301187', 23, 32),
  (1, '431199250', 21, 17),
  (1, '457169995', 45, 32),
  (1, '486267334', 28, 47),
  (1, '486459501', 44, 12),
  (1, '504940651', 42, 2),
  (1, '505107726', 14, 39),
  (1, '524035300', 27, 41),
  (1, '547919357', 40, 38),
  (1, '573486699', 16, 14),
  (1, '609446507', 12, 9),
  (1, '642819006', 49, 3),
  (1, '680640505', 38, 15),
  (1, '687381982', 5, 43),
  (1, '691272540', 0, 16),
  (1, '702632046', 31, 30),
  (1, '709916670', 32, 33),
  (1, '717651307', 21, 21),
  (1, '724144589', 33, 13),
  (1, '728508341', 4, 15),
  (1, '739707132', 46, 25),
  (1, '779135891', 43, 46),
  (1, '783460026', 34, 18),
  (1, '795120598', 18, 36),
  (1, '849866024', 2, 20),
  (1, '856116961', 42, 41),
  (1, '857669280', 44, 2),
  (1, '896531472', 37, 25),
  (1, '897949103', 25, 6),
  (1, '905524391', 5, 38),
  (1, '909338593', 41, 30),
  (1, '927263424', 9, 4),
  (1, '936204092', 28, 44),
  (1, '946876533', 37, 10),
  (1, '953679781', 26, 12),
  (1, '964622134', 4, 17),
  (1, '977715212', 0, 10),
  (1, '988989417', 22, 48),
  (6, '009996609', 37, 20),
  (6, '031118566', 30, 47),
  (6, '036904572', 9, 25),
  (6, '048370423', 4, 6),
  (6, '055493685', 28, 7),
  (6, '056231385', 3, 28),
  (6, '061299599', 34, 28),
  (6, '084771590', 24, 10),
  (6, '098764800', 2, 17),
  (6, '134474971', 19, 34),
  (6, '157926444', 45, 8),
  (6, '169165199', 45, 34),
  (6, '184362631', 12, 32),
  (6, '189831806', 26, 49),
  (6, '201029065', 13, 16),
  (6, '201213256', 27, 35),
  (6, '209669373', 6, 9),
  (6, '225584755', 18, 40),
  (6, '231882891', 5, 1),
  (6, '233875714', 20, 27),
  (6, '238903937', 36, 1),
  (6, '241611596', 22, 30),
  (6, '248101425', 0, 3),
  (6, '249377237', 19, 40),
  (6, '261424165', 18, 21),
  (6, '267197813', 20, 33),
  (6, '280198860', 46, 4),
  (6, '280500368', 22, 9),
  (6, '287157769', 26, 48),
  (6, '298479518', 44, 23),
  (6, '302879993', 17, 17),
  (6, '376561556', 26, 49),
  (6, '380985208', 17, 42),
  (6, '396539472', 22, 1),
  (6, '406270368', 34, 26),
  (6, '416156097', 39, 1),
  (6, '418223108', 43, 4),
  (6, '430301187', 31, 26),
  (6, '457169995', 33, 13),
  (6, '469226948', 4, 44),
  (6, '478349069', 7, 26),
  (6, '486267334', 16, 30),
  (6, '504940651', 44, 37),
  (6, '545322544', 32, 46),
  (6, '547878485', 24, 28),
  (6, '573486699', 31, 10),
  (6, '575755309', 30, 35),
  (6, '577556219', 34, 20),
  (6, '587993087', 32, 11),
  (6, '605369373', 24, 4),
  (6, '607726716', 40, 9),
  (6, '611383602', 5, 44),
  (6, '624615547', 46, 20),
  (6, '642819006', 4, 10),
  (6, '674568436', 47, 21),
  (6, '676699560', 34, 43),
  (6, '687381982', 24, 33),
  (6, '702632046', 13, 31),
  (6, '709916670', 27, 49),
  (6, '717651307', 44, 4),
  (6, '720640810', 11, 29),
  (6, '724144589', 4, 13),
  (6, '739707132', 1, 33),
  (6, '777375977', 46, 1),
  (6, '779135891', 3, 34),
  (6, '783460026', 31, 34),
  (6, '795120598', 10, 27),
  (6, '799580586', 18, 36),
  (6, '801818241', 27, 17),
  (6, '835135470', 32, 33),
  (6, '857669280', 21, 3),
  (6, '885181140', 25, 12),
  (6, '896531472', 25, 29),
  (6, '904725006', 18, 35),
  (6, '905524391', 42, 33),
  (6, '909338593', 23, 32),
  (6, '916062683', 43, 9),
  (6, '924515166', 17, 10),
  (6, '936204092', 32, 14),
  (6, '970998188', 35, 5),
  (6, '976797521', 33, 21),
  (6, '977715212', 26, 23),
  (6, '984651727', 47, 16),
  (6, '988989417', 1, 48),
  (7, '002652773', 18, 20),
  (7, '005499124', 17, 27),
  (7, '006400954', 3, 0),
  (7, '009996609', 17, 32),
  (7, '031118566', 16, 27),
  (7, '036904572', 22, 1),
  (7, '056231385', 29, 34),
  (7, '061299599', 33, 17),
  (7, '065361062', 1, 45),
  (7, '066790483', 2, 25),
  (7, '071234814', 37, 38),
  (7, '084701003', 9, 25),
  (7, '084771590', 43, 33),
  (7, '107525059', 7, 44),
  (7, '119217710', 5, 31),
  (7, '157926444', 20, 47),
  (7, '158283846', 47, 26),
  (7, '169165199', 37, 33),
  (7, '201213256', 34, 29),
  (7, '204463191', 31, 22),
  (7, '208925700', 38, 9),
  (7, '233875714', 45, 36),
  (7, '234594998', 16, 43),
  (7, '238903937', 29, 34),
  (7, '248101425', 31, 4),
  (7, '248487285', 25, 32),
  (7, '249377237', 9, 0),
  (7, '252905289', 6, 3),
  (7, '261424165', 7, 40),
  (7, '267197813', 24, 2),
  (7, '280198860', 35, 23),
  (7, '280500368', 28, 1),
  (7, '291274969', 2, 46),
  (7, '298479518', 7, 42),
  (7, '302879993', 24, 24),
  (7, '326305135', 25, 1),
  (7, '376561556', 16, 32),
  (7, '380985208', 34, 17),
  (7, '396539472', 46, 17),
  (7, '416156097', 19, 7),
  (7, '418223108', 32, 15),
  (7, '430301187', 20, 35),
  (7, '457169995', 38, 40),
  (7, '458822391', 30, 46),
  (7, '469226948', 15, 11),
  (7, '478349069', 5, 10),
  (7, '486459501', 7, 28),
  (7, '505107726', 15, 44),
  (7, '524035300', 25, 37),
  (7, '547919357', 37, 37),
  (7, '573486699', 6, 0),
  (7, '575755309', 44, 23),
  (7, '577556219', 46, 20),
  (7, '592102591', 6, 11),
  (7, '605369373', 42, 38),
  (7, '607726716', 30, 3),
  (7, '609446507', 26, 23),
  (7, '642819006', 31, 37),
  (7, '674568436', 3, 16),
  (7, '676699560', 9, 27),
  (7, '680640505', 7, 13),
  (7, '691272540', 10, 5),
  (7, '702632046', 9, 17),
  (7, '709916670', 7, 14),
  (7, '717651307', 48, 8),
  (7, '720640810', 27, 37),
  (7, '724144589', 46, 1),
  (7, '730544483', 1, 12),
  (7, '737214189', 31, 16),
  (7, '739707132', 19, 4),
  (7, '740577074', 39, 31),
  (7, '777375977', 32, 18),
  (7, '783460026', 18, 13),
  (7, '835135470', 15, 20),
  (7, '856116961', 46, 19),
  (7, '857669280', 37, 35),
  (7, '896531472', 48, 11),
  (7, '904725006', 14, 0),
  (7, '905524391', 33, 2),
  (7, '909338593', 26, 43),
  (7, '924515166', 4, 37),
  (7, '946876533', 41, 36),
  (7, '953679781', 0, 13),
  (7, '964622134', 9, 45),
  (7, '976797521', 34, 21),
  (7, '977715212', 28, 19),
  (7, '983834414', 39, 40),
  (7, '999980890', 30, 11),
  (8, '006400954', 25, 18),
  (8, '009996609', 38, 40),
  (8, '037639676', 41, 9),
  (8, '055134808', 34, 31),
  (8, '061299599', 46, 7),
  (8, '065361062', 36, 43),
  (8, '066790483', 18, 12),
  (8, '119217710', 28, 31),
  (8, '134474971', 33, 43),
  (8, '139375749', 18, 31),
  (8, '157926444', 3, 8),
  (8, '184362631', 30, 6),
  (8, '189831806', 7, 49),
  (8, '201029065', 14, 44),
  (8, '204463191', 41, 3),
  (8, '208925700', 30, 24),
  (8, '209905415', 37, 10),
  (8, '216263427', 46, 36),
  (8, '225584755', 18, 12),
  (8, '231882891', 45, 42),
  (8, '233875714', 3, 39),
  (8, '248101425', 41, 47),
  (8, '248487285', 23, 15),
  (8, '252905289', 36, 37),
  (8, '265730275', 11, 6),
  (8, '267197813', 42, 0),
  (8, '280198860', 49, 44),
  (8, '291274969', 19, 44),
  (8, '302879993', 23, 33),
  (8, '330085030', 25, 41),
  (8, '380985208', 38, 4),
  (8, '416156097', 43, 37),
  (8, '430301187', 45, 43),
  (8, '458822391', 30, 12),
  (8, '469226948', 46, 41),
  (8, '478349069', 36, 10),
  (8, '504940651', 22, 28),
  (8, '505107726', 45, 33),
  (8, '545322544', 14, 42),
  (8, '547878485', 7, 19),
  (8, '572971346', 3, 9),
  (8, '573486699', 16, 30),
  (8, '577556219', 18, 25),
  (8, '584616019', 25, 19),
  (8, '592102591', 15, 29),
  (8, '605369373', 40, 8),
  (8, '611383602', 34, 14),
  (8, '642819006', 8, 17),
  (8, '647157984', 3, 29),
  (8, '676699560', 14, 25),
  (8, '691272540', 7, 6),
  (8, '702632046', 19, 22),
  (8, '709916670', 10, 42),
  (8, '717651307', 1, 27),
  (8, '720640810', 3, 34),
  (8, '722345523', 31, 45),
  (8, '737214189', 26, 28),
  (8, '779846644', 21, 27),
  (8, '783460026', 10, 46),
  (8, '799580586', 20, 5),
  (8, '849866024', 33, 9),
  (8, '857669280', 20, 3),
  (8, '896531472', 20, 1),
  (8, '897949103', 49, 42),
  (8, '904725006', 8, 4),
  (8, '905524391', 38, 5),
  (8, '916062683', 47, 2),
  (8, '920057796', 19, 0),
  (8, '924515166', 7, 9),
  (8, '946876533', 49, 10),
  (8, '953679781', 23, 27),
  (8, '964622134', 10, 20),
  (8, '983834414', 31, 29),
  (8, '984651727', 19, 32),
  (12, '002652773', 16, 14),
  (12, '005666342', 46, 4),
  (12, '031118566', 8, 8),
  (12, '037639676', 40, 10),
  (12, '048370423', 12, 37),
  (12, '056231385', 44, 18),
  (12, '098764800', 45, 43),
  (12, '107525059', 12, 28),
  (12, '119217710', 16, 6),
  (12, '158283846', 15, 49),
  (12, '164296593', 42, 22),
  (12, '184362631', 5, 9),
  (12, '189831806', 46, 39),
  (12, '204463191', 22, 49),
  (12, '208925700', 22, 31),
  (12, '209669373', 37, 21),
  (12, '209905415', 49, 25),
  (12, '241611596', 49, 6),
  (12, '248487285', 38, 13),
  (12, '249377237', 15, 41),
  (12, '252905289', 5, 26),
  (12, '280198860', 29, 9),
  (12, '283609503', 41, 36),
  (12, '287157769', 46, 37),
  (12, '291274969', 49, 14),
  (12, '298479518', 19, 23),
  (12, '302879993', 9, 5),
  (12, '326305135', 35, 10),
  (12, '330085030', 44, 4),
  (12, '380985208', 1, 14),
  (12, '396539472', 47, 27),
  (12, '418223108', 11, 42),
  (12, '457169995', 25, 26),
  (12, '486459501', 43, 7),
  (12, '504940651', 32, 46),
  (12, '505107726', 44, 36),
  (12, '545322544', 18, 37),
  (12, '547878485', 9, 35),
  (12, '572971346', 47, 45),
  (12, '601419281', 24, 35),
  (12, '624615547', 13, 18),
  (12, '674568436', 42, 13),
  (12, '676699560', 9, 38),
  (12, '702632046', 10, 44),
  (12, '709916670', 10, 20),
  (12, '717651307', 21, 39),
  (12, '728508341', 49, 21),
  (12, '740577074', 2, 32),
  (12, '777375977', 31, 17),
  (12, '779135891', 31, 15),
  (12, '779846644', 45, 41),
  (12, '783460026', 38, 7),
  (12, '801818241', 3, 44),
  (12, '856116961', 27, 3),
  (12, '885181140', 43, 23),
  (12, '896531472', 7, 8),
  (12, '897949103', 36, 33),
  (12, '909338593', 38, 42),
  (12, '916062683', 41, 45),
  (12, '970998188', 32, 24),
  (12, '977715212', 5, 12),
  (12, '983834414', 39, 47),
  (12, '984651727', 38, 6),
  (12, '999980890', 4, 1),
  (13, '002652773', 48, 44),
  (13, '005666342', 43, 1),
  (13, '006400954', 48, 32),
  (13, '009996609', 38, 41),
  (13, '031118566', 26, 46),
  (13, '036904572', 6, 35),
  (13, '055493685', 49, 21),
  (13, '061299599', 14, 33),
  (13, '065361062', 15, 24),
  (13, '066790483', 44, 35),
  (13, '071234814', 3, 1),
  (13, '084701003', 3, 31),
  (13, '084771590', 25, 16),
  (13, '098764800', 15, 48),
  (13, '134474971', 34, 23),
  (13, '158283846', 30, 23),
  (13, '169165199', 30, 39),
  (13, '178191875', 41, 33),
  (13, '184362631', 18, 33),
  (13, '193066153', 46, 14),
  (13, '209905415', 43, 11),
  (13, '216263427', 13, 19),
  (13, '231882891', 45, 38),
  (13, '233875714', 23, 47),
  (13, '234594998', 12, 4),
  (13, '238903937', 21, 5),
  (13, '241611596', 34, 35),
  (13, '248101425', 46, 4),
  (13, '248487285', 11, 10),
  (13, '252905289', 42, 32),
  (13, '265730275', 32, 31),
  (13, '267197813', 20, 34),
  (13, '287157769', 37, 4),
  (13, '291274969', 7, 33),
  (13, '376561556', 39, 27),
  (13, '380985208', 1, 24),
  (13, '396539472', 16, 8),
  (13, '406270368', 32, 15),
  (13, '418223108', 32, 27),
  (13, '431199250', 2, 7),
  (13, '456073283', 0, 28),
  (13, '457169995', 40, 22),
  (13, '458822391', 16, 49),
  (13, '478349069', 7, 7),
  (13, '504940651', 26, 26),
  (13, '505107726', 29, 39),
  (13, '520665628', 14, 42),
  (13, '545322544', 29, 28),
  (13, '547878485', 2, 31),
  (13, '547919357', 39, 23),
  (13, '572971346', 8, 0),
  (13, '575755309', 17, 43),
  (13, '584616019', 35, 43),
  (13, '587993087', 36, 31),
  (13, '601419281', 45, 28),
  (13, '607726716', 14, 21),
  (13, '609446507', 9, 15),
  (13, '611383602', 12, 12),
  (13, '624615547', 42, 4),
  (13, '680640505', 32, 22),
  (13, '691272540', 32, 37),
  (13, '709916670', 42, 24),
  (13, '720640810', 2, 34),
  (13, '722345523', 4, 13),
  (13, '730544483', 29, 23),
  (13, '739707132', 23, 46),
  (13, '740577074', 42, 41),
  (13, '799580586', 16, 34),
  (13, '801818241', 19, 27),
  (13, '849866024', 11, 25),
  (13, '856116961', 2, 7),
  (13, '904725006', 44, 20),
  (13, '905524391', 9, 32),
  (13, '909338593', 8, 37),
  (13, '916062683', 14, 7),
  (13, '920057796', 32, 20),
  (13, '927263424', 5, 32),
  (13, '946876533', 30, 15),
  (13, '964622134', 23, 28),
  (13, '977715212', 3, 20),
  (13, '983834414', 40, 23),
  (13, '984651727', 28, 43),
  (13, '991628649', 16, 47),
  (15, '036904572', 10, 35),
  (15, '037639676', 5, 26),
  (15, '055134808', 48, 14),
  (15, '084701003', 24, 47),
  (15, '084771590', 3, 24),
  (15, '098764800', 21, 37),
  (15, '107525059', 7, 39),
  (15, '169165199', 6, 44),
  (15, '178191875', 17, 34),
  (15, '201029065', 25, 0),
  (15, '204463191', 4, 17),
  (15, '209905415', 28, 19),
  (15, '216263427', 44, 45),
  (15, '225584755', 49, 20),
  (15, '231882891', 48, 12),
  (15, '233875714', 46, 29),
  (15, '248101425', 2, 38),
  (15, '249377237', 38, 20),
  (15, '252905289', 35, 40),
  (15, '287157769', 30, 5),
  (15, '380985208', 41, 34),
  (15, '406270368', 41, 40),
  (15, '431199250', 42, 39),
  (15, '456073283', 12, 49),
  (15, '457169995', 33, 22),
  (15, '478349069', 30, 25),
  (15, '486267334', 37, 26),
  (15, '504940651', 4, 40),
  (15, '575755309', 3, 12),
  (15, '577556219', 25, 9),
  (15, '587993087', 46, 17),
  (15, '605369373', 24, 26),
  (15, '624615547', 20, 29),
  (15, '647157984', 20, 2),
  (15, '687381982', 40, 4),
  (15, '691272540', 15, 19),
  (15, '702632046', 42, 21),
  (15, '739707132', 28, 35),
  (15, '779846644', 42, 42),
  (15, '783460026', 1, 33),
  (15, '857669280', 13, 48),
  (15, '916062683', 10, 34),
  (15, '924515166', 28, 43),
  (15, '927263424', 4, 14),
  (15, '953679781', 41, 41),
  (15, '964622134', 36, 34),
  (15, '970998188', 32, 13),
  (15, '977715212', 44, 14),
  (15, '983834414', 25, 19),
  (15, '991628649', 14, 14),
  (16, '005666342', 7, 19),
  (16, '009996609', 36, 27),
  (16, '036904572', 27, 19),
  (16, '048370423', 36, 37),
  (16, '055134808', 37, 4),
  (16, '055493685', 22, 28),
  (16, '065361062', 11, 36),
  (16, '066790483', 45, 15),
  (16, '107525059', 25, 25),
  (16, '134474971', 17, 30),
  (16, '157926444', 1, 48),
  (16, '164296593', 34, 36),
  (16, '178191875', 37, 15),
  (16, '184362631', 22, 3),
  (16, '189831806', 41, 0),
  (16, '193066153', 29, 20),
  (16, '201029065', 18, 36),
  (16, '204463191', 36, 3),
  (16, '209669373', 44, 46),
  (16, '216263427', 41, 0),
  (16, '248487285', 41, 2),
  (16, '280500368', 1, 20),
  (16, '283528929', 47, 38),
  (16, '283609503', 6, 48),
  (16, '291274969', 29, 22),
  (16, '326305135', 8, 47),
  (16, '376561556', 14, 32),
  (16, '380985208', 41, 35),
  (16, '418223108', 13, 28),
  (16, '457169995', 30, 43),
  (16, '458822391', 45, 8),
  (16, '486459501', 25, 26),
  (16, '505107726', 26, 45),
  (16, '524035300', 27, 11),
  (16, '545322544', 19, 49),
  (16, '547878485', 3, 26),
  (16, '547919357', 32, 1),
  (16, '584616019', 39, 26),
  (16, '587993087', 12, 21),
  (16, '605369373', 33, 5),
  (16, '607726716', 34, 31),
  (16, '611383602', 2, 29),
  (16, '674568436', 0, 7),
  (16, '680640505', 49, 46),
  (16, '720640810', 27, 45),
  (16, '724144589', 1, 47),
  (16, '728508341', 22, 39),
  (16, '737214189', 39, 30),
  (16, '739707132', 10, 39),
  (16, '783460026', 45, 48),
  (16, '795120598', 34, 37),
  (16, '835135470', 4, 24),
  (16, '857669280', 35, 43),
  (16, '896531472', 25, 35),
  (16, '909338593', 30, 45),
  (16, '920057796', 3, 7),
  (16, '964622134', 48, 22),
  (16, '983834414', 44, 13),
  (16, '991628649', 0, 41),
  (17, '005499124', 5, 38),
  (17, '008392650', 27, 2),
  (17, '009996609', 2, 39),
  (17, '036904572', 33, 28),
  (17, '056231385', 44, 23),
  (17, '061299599', 0, 32),
  (17, '065361062', 45, 14),
  (17, '066790483', 2, 21),
  (17, '071234814', 31, 39),
  (17, '084701003', 32, 0),
  (17, '098764800', 32, 36),
  (17, '119217710', 28, 32),
  (17, '157926444', 45, 14),
  (17, '164296593', 29, 14),
  (17, '169165199', 4, 25),
  (17, '178191875', 48, 27),
  (17, '184362631', 11, 19),
  (17, '193066153', 34, 31),
  (17, '201029065', 32, 25),
  (17, '201213256', 1, 5),
  (17, '208925700', 48, 17),
  (17, '209669373', 19, 7),
  (17, '225584755', 38, 16),
  (17, '233875714', 27, 43),
  (17, '252905289', 8, 48),
  (17, '261424165', 37, 17),
  (17, '265730275', 6, 26),
  (17, '280500368', 31, 46),
  (17, '283528929', 17, 24),
  (17, '283609503', 42, 27),
  (17, '287157769', 6, 22),
  (17, '291274969', 23, 22),
  (17, '298479518', 25, 9),
  (17, '380985208', 7, 32),
  (17, '406270368', 47, 23),
  (17, '416156097', 35, 5),
  (17, '418223108', 43, 13),
  (17, '430301187', 2, 5),
  (17, '431199250', 17, 16),
  (17, '457169995', 11, 3),
  (17, '458822391', 22, 46),
  (17, '478349069', 39, 8),
  (17, '486459501', 7, 32),
  (17, '505107726', 11, 5),
  (17, '520665628', 24, 37),
  (17, '524035300', 4, 36),
  (17, '545322544', 38, 4),
  (17, '547919357', 4, 10),
  (17, '572971346', 18, 27),
  (17, '573486699', 49, 14),
  (17, '584616019', 41, 36),
  (17, '587993087', 29, 5),
  (17, '601419281', 11, 8),
  (17, '607726716', 16, 25),
  (17, '611383602', 37, 9),
  (17, '647157984', 24, 21),
  (17, '674568436', 18, 48),
  (17, '691272540', 10, 31),
  (17, '702632046', 18, 40),
  (17, '709916670', 13, 0),
  (17, '720640810', 12, 32),
  (17, '722345523', 44, 40),
  (17, '728508341', 37, 20),
  (17, '737214189', 10, 38),
  (17, '779135891', 43, 44),
  (17, '799580586', 4, 49),
  (17, '801818241', 37, 8),
  (17, '828927742', 27, 47),
  (17, '835135470', 46, 14),
  (17, '856116961', 19, 0),
  (17, '857669280', 2, 5),
  (17, '885181140', 18, 15),
  (17, '897949103', 17, 10),
  (17, '909338593', 19, 0),
  (17, '920057796', 40, 19),
  (17, '927263424', 49, 6),
  (17, '936204092', 12, 12),
  (17, '964622134', 1, 30),
  (17, '983834414', 10, 33),
  (17, '988989417', 8, 48),
  (17, '991628649', 27, 6),
  (17, '999980890', 24, 5),
  (19, '005499124', 42, 14),
  (19, '005666342', 11, 0),
  (19, '031118566', 42, 47),
  (19, '055134808', 22, 35),
  (19, '065361062', 35, 27),
  (19, '066790483', 25, 37),
  (19, '084701003', 5, 43),
  (19, '134889514', 41, 19),
  (19, '157926444', 46, 0),
  (19, '169165199', 36, 9),
  (19, '209905415', 43, 45),
  (19, '234594998', 39, 22),
  (19, '248101425', 30, 33),
  (19, '248487285', 19, 7),
  (19, '252905289', 35, 2),
  (19, '265730275', 7, 27),
  (19, '267197813', 20, 34),
  (19, '280198860', 13, 47),
  (19, '287157769', 0, 38),
  (19, '326305135', 10, 21),
  (19, '376561556', 11, 16),
  (19, '396539472', 39, 18),
  (19, '406270368', 30, 42),
  (19, '418223108', 8, 47),
  (19, '431199250', 35, 5),
  (19, '458822391', 8, 29),
  (19, '486459501', 17, 25),
  (19, '547919357', 21, 18),
  (19, '572971346', 21, 13),
  (19, '573486699', 41, 37),
  (19, '575755309', 41, 45),
  (19, '592102591', 32, 1),
  (19, '601419281', 49, 32),
  (19, '607726716', 0, 13),
  (19, '642819006', 28, 37),
  (19, '647157984', 2, 28),
  (19, '680640505', 14, 26),
  (19, '687381982', 39, 17),
  (19, '717651307', 4, 14),
  (19, '720640810', 2, 49),
  (19, '737214189', 10, 3),
  (19, '740577074', 42, 49),
  (19, '777375977', 0, 2),
  (19, '779846644', 32, 46),
  (19, '783460026', 42, 9),
  (19, '801818241', 32, 33),
  (19, '828927742', 16, 22),
  (19, '856116961', 25, 45),
  (19, '857669280', 22, 2),
  (19, '885181140', 6, 20),
  (19, '896531472', 14, 46),
  (19, '909338593', 26, 19),
  (19, '927263424', 29, 43),
  (19, '936204092', 22, 1),
  (19, '977715212', 37, 4),
  (19, '984651727', 17, 21),
  (19, '988989417', 19, 42),
  (19, '999980890', 18, 22),
  (20, '002652773', 5, 20),
  (20, '005499124', 36, 18),
  (20, '008392650', 3, 46),
  (20, '036904572', 21, 16),
  (20, '061299599', 28, 40),
  (20, '066790483', 47, 38),
  (20, '071234814', 41, 47),
  (20, '134474971', 36, 32),
  (20, '157926444', 49, 34),
  (20, '158283846', 19, 13),
  (20, '201029065', 9, 25),
  (20, '208925700', 14, 2),
  (20, '209905415', 10, 45),
  (20, '225584755', 5, 4),
  (20, '233875714', 30, 22),
  (20, '234594998', 15, 24),
  (20, '238903937', 40, 7),
  (20, '241611596', 1, 15),
  (20, '248101425', 14, 7),
  (20, '248487285', 3, 2),
  (20, '249377237', 22, 14),
  (20, '252905289', 30, 4),
  (20, '261424165', 33, 43),
  (20, '267197813', 43, 29),
  (20, '280500368', 13, 1),
  (20, '283609503', 22, 22),
  (20, '298479518', 42, 11),
  (20, '330085030', 36, 35),
  (20, '380985208', 15, 19),
  (20, '396539472', 19, 44),
  (20, '416156097', 22, 21),
  (20, '430301187', 26, 45),
  (20, '456073283', 43, 47),
  (20, '486267334', 9, 25),
  (20, '505107726', 31, 3),
  (20, '524035300', 33, 21),
  (20, '545322544', 49, 31),
  (20, '573486699', 2, 30),
  (20, '577556219', 7, 27),
  (20, '605369373', 14, 27),
  (20, '611383602', 6, 19),
  (20, '624615547', 15, 1),
  (20, '642819006', 8, 18),
  (20, '647157984', 5, 39),
  (20, '674568436', 37, 42),
  (20, '680640505', 45, 36),
  (20, '687381982', 0, 4),
  (20, '709916670', 11, 32),
  (20, '717651307', 33, 15),
  (20, '722345523', 47, 31),
  (20, '728508341', 34, 19),
  (20, '739707132', 39, 19),
  (20, '740577074', 3, 32),
  (20, '777375977', 46, 39),
  (20, '779135891', 6, 39),
  (20, '779846644', 10, 37),
  (20, '783460026', 36, 37),
  (20, '795120598', 3, 20),
  (20, '799580586', 49, 34),
  (20, '801818241', 42, 21),
  (20, '835135470', 39, 43),
  (20, '849866024', 10, 29),
  (20, '885181140', 23, 28),
  (20, '905524391', 3, 45),
  (20, '920057796', 7, 36),
  (20, '924515166', 32, 23),
  (20, '927263424', 20, 41),
  (20, '946876533', 31, 19),
  (20, '953679781', 16, 32),
  (20, '970998188', 25, 31),
  (20, '983834414', 38, 7),
  (20, '984651727', 48, 4),
  (20, '991628649', 41, 16),
  (22, '005666342', 24, 22),
  (22, '008392650', 26, 6),
  (22, '009996609', 45, 38),
  (22, '031118566', 8, 41),
  (22, '036904572', 24, 28),
  (22, '061299599', 10, 1),
  (22, '066790483', 31, 42),
  (22, '084771590', 14, 27),
  (22, '119217710', 38, 45),
  (22, '134889514', 20, 17),
  (22, '158283846', 14, 36),
  (22, '178191875', 2, 10),
  (22, '238903937', 41, 12),
  (22, '241611596', 3, 41),
  (22, '248487285', 43, 44),
  (22, '261424165', 3, 22),
  (22, '267197813', 24, 4),
  (22, '280198860', 22, 47),
  (22, '283609503', 49, 1),
  (22, '326305135', 13, 20),
  (22, '330085030', 6, 33),
  (22, '457169995', 41, 47),
  (22, '545322544', 2, 37),
  (22, '547878485', 22, 6),
  (22, '547919357', 37, 48),
  (22, '573486699', 19, 19),
  (22, '575755309', 13, 31),
  (22, '577556219', 9, 48),
  (22, '584616019', 3, 8),
  (22, '605369373', 48, 34),
  (22, '624615547', 10, 42),
  (22, '702632046', 14, 44),
  (22, '728508341', 2, 5),
  (22, '737214189', 22, 45),
  (22, '739707132', 0, 10),
  (22, '777375977', 25, 20),
  (22, '799580586', 40, 3),
  (22, '856116961', 33, 5),
  (22, '885181140', 1, 9),
  (22, '896531472', 38, 35),
  (22, '946876533', 22, 39),
  (22, '964622134', 40, 26),
  (22, '976797521', 46, 38),
  (22, '977715212', 8, 0),
  (22, '984651727', 42, 23),
  (23, '005499124', 28, 16),
  (23, '036904572', 47, 36),
  (23, '055134808', 48, 6),
  (23, '071234814', 14, 2),
  (23, '084701003', 25, 41),
  (23, '107525059', 34, 25),
  (23, '119217710', 37, 12),
  (23, '134474971', 9, 5),
  (23, '134889514', 49, 30),
  (23, '178191875', 0, 1),
  (23, '201029065', 19, 36),
  (23, '201213256', 28, 12),
  (23, '208925700', 0, 36),
  (23, '209669373', 4, 1),
  (23, '233875714', 31, 34),
  (23, '234594998', 46, 49),
  (23, '241611596', 40, 0),
  (23, '248101425', 7, 45),
  (23, '248487285', 15, 34),
  (23, '252905289', 22, 36),
  (23, '261424165', 34, 35),
  (23, '280500368', 48, 7),
  (23, '283609503', 9, 17),
  (23, '291274969', 42, 2),
  (23, '298479518', 30, 24),
  (23, '326305135', 21, 31),
  (23, '330085030', 25, 11),
  (23, '376561556', 6, 34),
  (23, '396539472', 16, 39),
  (23, '416156097', 18, 9),
  (23, '456073283', 1, 17),
  (23, '457169995', 32, 1),
  (23, '469226948', 7, 0),
  (23, '486459501', 7, 1),
  (23, '505107726', 3, 43),
  (23, '520665628', 30, 25),
  (23, '524035300', 7, 23),
  (23, '545322544', 45, 19),
  (23, '547919357', 26, 44),
  (23, '573486699', 37, 26),
  (23, '587993087', 6, 3),
  (23, '601419281', 36, 5),
  (23, '605369373', 13, 9),
  (23, '609446507', 44, 33),
  (23, '611383602', 22, 41),
  (23, '680640505', 19, 27),
  (23, '702632046', 30, 27),
  (23, '717651307', 18, 0),
  (23, '720640810', 38, 4),
  (23, '722345523', 18, 18),
  (23, '724144589', 22, 29),
  (23, '739707132', 37, 15),
  (23, '740577074', 38, 14),
  (23, '777375977', 0, 19),
  (23, '795120598', 38, 39),
  (23, '799580586', 5, 12),
  (23, '828927742', 24, 31),
  (23, '849866024', 46, 30),
  (23, '856116961', 10, 42),
  (23, '897949103', 14, 21),
  (23, '904725006', 28, 24),
  (23, '905524391', 36, 49),
  (23, '909338593', 6, 12),
  (23, '927263424', 26, 1),
  (23, '936204092', 8, 44),
  (23, '953679781', 49, 5),
  (23, '977715212', 45, 15),
  (23, '984651727', 28, 8),
  (23, '988989417', 45, 36),
  (24, '002652773', 44, 23),
  (24, '008392650', 18, 32),
  (24, '009996609', 43, 36),
  (24, '031118566', 40, 7),
  (24, '048370423', 21, 26),
  (24, '055134808', 46, 9),
  (24, '084701003', 6, 19),
  (24, '119217710', 20, 24),
  (24, '134889514', 0, 9),
  (24, '139375749', 13, 9),
  (24, '193066153', 7, 4),
  (24, '201029065', 3, 29),
  (24, '201213256', 4, 14),
  (24, '204463191', 14, 4),
  (24, '209669373', 13, 29),
  (24, '216263427', 3, 23),
  (24, '225584755', 18, 38),
  (24, '248101425', 4, 17),
  (24, '249377237', 20, 13),
  (24, '252905289', 34, 13),
  (24, '261424165', 21, 23),
  (24, '265730275', 46, 29),
  (24, '283528929', 26, 16),
  (24, '283609503', 27, 1),
  (24, '302879993', 7, 25),
  (24, '376561556', 17, 9),
  (24, '380985208', 31, 33),
  (24, '396539472', 19, 2),
  (24, '406270368', 32, 34),
  (24, '418223108', 8, 31),
  (24, '430301187', 19, 13),
  (24, '456073283', 3, 42),
  (24, '469226948', 43, 20),
  (24, '478349069', 6, 30),
  (24, '486267334', 35, 32),
  (24, '504940651', 37, 6),
  (24, '524035300', 38, 6),
  (24, '573486699', 46, 10),
  (24, '592102591', 18, 0),
  (24, '601419281', 12, 1),
  (24, '605369373', 16, 33),
  (24, '607726716', 6, 1),
  (24, '642819006', 7, 38),
  (24, '647157984', 23, 22),
  (24, '674568436', 49, 24),
  (24, '687381982', 34, 17),
  (24, '691272540', 33, 34),
  (24, '702632046', 38, 19),
  (24, '728508341', 29, 21),
  (24, '739707132', 5, 18),
  (24, '777375977', 37, 34),
  (24, '779846644', 37, 38),
  (24, '783460026', 9, 10),
  (24, '799580586', 5, 41),
  (24, '835135470', 26, 33),
  (24, '896531472', 2, 16),
  (24, '897949103', 4, 34),
  (24, '904725006', 18, 32),
  (24, '905524391', 28, 45),
  (24, '909338593', 47, 42),
  (24, '916062683', 34, 3),
  (24, '920057796', 3, 12),
  (24, '924515166', 19, 38),
  (24, '927263424', 41, 45),
  (24, '970998188', 7, 20),
  (24, '976797521', 22, 46),
  (24, '977715212', 29, 41),
  (26, '002652773', 46, 46),
  (26, '005666342', 0, 11),
  (26, '008392650', 15, 15),
  (26, '037639676', 14, 4),
  (26, '056231385', 35, 32),
  (26, '065361062', 1, 39),
  (26, '107525059', 12, 46),
  (26, '134474971', 39, 38),
  (26, '157926444', 13, 30),
  (26, '158283846', 5, 42),
  (26, '193066153', 43, 45),
  (26, '201029065', 13, 37),
  (26, '208925700', 0, 33),
  (26, '233875714', 8, 26),
  (26, '248487285', 20, 25),
  (26, '252905289', 1, 9),
  (26, '261424165', 22, 37),
  (26, '280198860', 22, 21),
  (26, '283528929', 30, 16),
  (26, '283609503', 3, 27),
  (26, '298479518', 49, 19),
  (26, '302879993', 7, 2),
  (26, '380985208', 23, 6),
  (26, '396539472', 1, 32),
  (26, '457169995', 17, 44),
  (26, '458822391', 2, 8),
  (26, '469226948', 1, 0),
  (26, '505107726', 28, 25),
  (26, '520665628', 17, 27),
  (26, '545322544', 9, 35),
  (26, '573486699', 4, 33),
  (26, '584616019', 27, 46),
  (26, '587993087', 26, 10),
  (26, '592102591', 28, 11),
  (26, '605369373', 31, 23),
  (26, '607726716', 43, 2),
  (26, '609446507', 2, 31),
  (26, '642819006', 40, 0),
  (26, '680640505', 36, 11),
  (26, '687381982', 45, 13),
  (26, '709916670', 28, 6),
  (26, '717651307', 29, 23),
  (26, '722345523', 26, 27),
  (26, '724144589', 10, 12),
  (26, '777375977', 21, 14),
  (26, '828927742', 39, 6),
  (26, '857669280', 32, 19),
  (26, '885181140', 25, 12),
  (26, '897949103', 14, 20),
  (26, '909338593', 10, 37),
  (26, '920057796', 20, 19),
  (26, '924515166', 8, 45),
  (26, '927263424', 36, 45),
  (26, '964622134', 37, 24),
  (26, '977715212', 21, 46),
  (26, '999980890', 25, 28);
  
  --
  -- Triggers `carries`
  --
  DELIMITER $$
  CREATE TRIGGER `CarriesDelete` AFTER DELETE ON `carries` FOR EACH ROW DELETE FROM provides WHERE(SELECT COUNT(i.category_id)  FROM item as i, carries as c WHERE  provides.category_id = i.category_id && c.barcode = i.Barcode && c.store_id = OLD.store_id ) = 0 && provides.store_id = OLD.store_id
  $$
  DELIMITER ;
  DELIMITER $$
  CREATE TRIGGER `carriesUpdate` AFTER INSERT ON `carries` FOR EACH ROW INSERT INTO provides(store_id,category_id) SELECT DISTINCT s.id,i.category_id FROM supermarkets AS s,item AS i, carries AS c  WHERE c.barcode = i.Barcode && c.store_id = s.id &&  NOT EXISTS(SELECT * FROM provides AS a WHERE a.store_id = s.id && a.category_id = i.category_id)
  $$
  DELIMITER ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `category`
  --
  
  CREATE TABLE `category` (
    `category_id` int(11) NOT NULL,
    `name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `category`
  --
  
  INSERT INTO `category` (`category_id`, `name`) VALUES
  (0, 'Fresh produce'),
  (1, 'Fridge Item'),
  (2, 'Liquor'),
  (3, 'Self Care'),
  (4, 'House Items'),
  (5, 'Pets');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contains`
  --
  
  CREATE TABLE `contains` (
    `transcaction_id` int(11) NOT NULL,
    `barcode` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `amount` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `contains`
  --
  
  INSERT INTO `contains` (`transcaction_id`, `barcode`, `amount`) VALUES
  (1, '184362631', 8),
  (1, '249377237', 9),
  (1, '418223108', 2),
  (1, '457169995', 10),
  (1, '547878485', 3),
  (1, '885181140', 9),
  (2, '055134808', 5),
  (2, '201029065', 2),
  (2, '231882891', 5),
  (2, '573486699', 7),
  (3, '009996609', 1),
  (3, '084771590', 3),
  (3, '169165199', 7),
  (3, '396539472', 6),
  (3, '416156097', 9),
  (3, '605369373', 10),
  (3, '717651307', 7),
  (4, '055134808', 6),
  (4, '298479518', 10),
  (4, '456073283', 2),
  (4, '609446507', 6),
  (4, '953679781', 1),
  (4, '977715212', 9),
  (5, '209905415', 9),
  (5, '216263427', 1),
  (5, '252905289', 10),
  (5, '280198860', 10),
  (5, '605369373', 1),
  (5, '916062683', 3),
  (6, '505107726', 6),
  (6, '702632046', 6),
  (7, '252905289', 5),
  (7, '326305135', 7),
  (7, '486459501', 1),
  (8, '611383602', 9),
  (8, '927263424', 9),
  (8, '984651727', 2),
  (9, '002652773', 1),
  (9, '201029065', 10),
  (9, '209669373', 5),
  (9, '380985208', 7),
  (9, '709916670', 7),
  (9, '953679781', 6),
  (10, '036904572', 10),
  (10, '248101425', 6),
  (10, '287157769', 6),
  (10, '801818241', 1),
  (11, '283609503', 10),
  (11, '970998188', 3),
  (12, '056231385', 5),
  (12, '458822391', 8),
  (12, '777375977', 8),
  (12, '924515166', 8),
  (12, '964622134', 2),
  (13, '071234814', 4),
  (13, '098764800', 1),
  (13, '184362631', 9),
  (13, '201213256', 2),
  (13, '520665628', 9),
  (14, '031118566', 2),
  (14, '298479518', 4),
  (14, '547878485', 7),
  (14, '611383602', 8),
  (14, '924515166', 7),
  (15, '008392650', 4),
  (15, '178191875', 9),
  (15, '280198860', 9),
  (16, '457169995', 6),
  (16, '720640810', 7),
  (16, '799580586', 8),
  (17, '008392650', 8),
  (17, '157926444', 6),
  (17, '380985208', 1),
  (18, '157926444', 1),
  (18, '326305135', 3),
  (18, '418223108', 10),
  (18, '988989417', 8),
  (19, '208925700', 6),
  (20, '280198860', 8),
  (20, '431199250', 7),
  (21, '406270368', 8),
  (21, '611383602', 6),
  (22, '084771590', 4),
  (22, '946876533', 7),
  (23, '157926444', 7),
  (23, '201029065', 9),
  (23, '287157769', 10),
  (23, '380985208', 10),
  (23, '573486699', 4),
  (23, '857669280', 8),
  (23, '983834414', 9),
  (24, '647157984', 1),
  (24, '897949103', 9),
  (25, '396539472', 6),
  (26, '005666342', 1),
  (26, '061299599', 8),
  (26, '486459501', 7),
  (26, '795120598', 2),
  (27, '134889514', 10),
  (27, '524035300', 7),
  (27, '573486699', 7),
  (27, '897949103', 8),
  (28, '897949103', 8),
  (29, '885181140', 10),
  (29, '909338593', 2),
  (29, '977715212', 7),
  (29, '999980890', 6),
  (30, '157926444', 9),
  (30, '680640505', 7),
  (30, '857669280', 9),
  (30, '909338593', 7),
  (31, '201029065', 6),
  (31, '252905289', 4),
  (31, '605369373', 4),
  (31, '687381982', 1),
  (31, '783460026', 10),
  (32, '380985208', 1),
  (33, '201029065', 4),
  (33, '216263427', 7),
  (34, '084701003', 10),
  (34, '193066153', 6),
  (34, '201213256', 10),
  (34, '904725006', 4),
  (34, '909338593', 1),
  (34, '976797521', 7),
  (34, '977715212', 9),
  (35, '283609503', 4),
  (35, '849866024', 1),
  (36, '037639676', 10),
  (36, '572971346', 2),
  (36, '702632046', 8),
  (36, '709916670', 6),
  (37, '037639676', 5),
  (37, '330085030', 9),
  (37, '545322544', 3),
  (37, '691272540', 5),
  (38, '280500368', 2),
  (38, '647157984', 7),
  (38, '953679781', 8),
  (38, '970998188', 6),
  (39, '098764800', 4),
  (39, '680640505', 1),
  (40, '036904572', 9),
  (40, '225584755', 2),
  (40, '577556219', 9),
  (40, '647157984', 3),
  (41, '071234814', 7),
  (41, '084701003', 3),
  (41, '169165199', 6),
  (41, '209669373', 10),
  (41, '728508341', 4),
  (41, '920057796', 2),
  (41, '991628649', 3),
  (42, '280198860', 4),
  (42, '458822391', 7),
  (42, '953679781', 2),
  (42, '983834414', 1),
  (43, '201029065', 7),
  (43, '238903937', 7),
  (43, '469226948', 5),
  (43, '717651307', 9),
  (44, '119217710', 8),
  (44, '241611596', 4),
  (44, '291274969', 8),
  (44, '547919357', 5),
  (44, '601419281', 6),
  (44, '722345523', 9),
  (45, '248101425', 9),
  (45, '545322544', 2),
  (45, '737214189', 1),
  (46, '119217710', 2),
  (46, '157926444', 9),
  (46, '265730275', 1),
  (46, '722345523', 4),
  (47, '061299599', 6),
  (48, '009996609', 5),
  (48, '231882891', 7),
  (48, '577556219', 1),
  (48, '587993087', 7),
  (48, '799580586', 10),
  (49, '048370423', 3),
  (49, '055134808', 2),
  (49, '478349069', 2),
  (49, '486267334', 7),
  (49, '601419281', 3),
  (49, '642819006', 6),
  (49, '739707132', 3),
  (49, '920057796', 4),
  (50, '267197813', 1),
  (50, '545322544', 1),
  (50, '702632046', 1),
  (51, '055134808', 3),
  (51, '178191875', 7),
  (51, '209669373', 5),
  (51, '547919357', 6),
  (52, '055134808', 1),
  (52, '326305135', 7),
  (52, '547919357', 2),
  (52, '587993087', 7),
  (53, '134889514', 8),
  (53, '601419281', 1),
  (53, '605369373', 7),
  (53, '916062683', 6),
  (53, '924515166', 4),
  (54, '233875714', 8),
  (54, '248101425', 5),
  (55, '430301187', 3),
  (55, '988989417', 7),
  (56, '061299599', 1),
  (56, '298479518', 5),
  (56, '330085030', 1),
  (56, '687381982', 3),
  (56, '885181140', 3),
  (57, '584616019', 7),
  (58, '208925700', 9),
  (58, '209905415', 3),
  (58, '248487285', 5),
  (58, '795120598', 5),
  (59, '002652773', 6),
  (59, '592102591', 7),
  (60, '233875714', 9),
  (60, '252905289', 6),
  (60, '280198860', 6),
  (60, '298479518', 6),
  (60, '609446507', 10),
  (61, '006400954', 1),
  (61, '055493685', 7),
  (61, '084771590', 4),
  (61, '601419281', 1),
  (61, '611383602', 8),
  (61, '977715212', 4),
  (62, '084701003', 6),
  (62, '234594998', 6),
  (62, '779846644', 1),
  (62, '896531472', 8),
  (63, '728508341', 10),
  (64, '134889514', 10),
  (64, '248487285', 3),
  (64, '520665628', 4),
  (64, '777375977', 10),
  (64, '856116961', 8),
  (65, '139375749', 8),
  (65, '647157984', 9),
  (65, '702632046', 7),
  (66, '002652773', 2),
  (66, '066790483', 10),
  (67, '201029065', 3),
  (67, '575755309', 2),
  (67, '857669280', 10),
  (68, '055493685', 4),
  (68, '134474971', 5),
  (69, '065361062', 4),
  (69, '283609503', 1),
  (69, '964622134', 1),
  (70, '005499124', 8),
  (70, '936204092', 6),
  (71, '169165199', 5),
  (71, '984651727', 7),
  (72, '252905289', 7),
  (72, '486459501', 10),
  (72, '717651307', 10),
  (72, '728508341', 7),
  (72, '856116961', 2),
  (73, '169165199', 4),
  (73, '849866024', 3),
  (73, '856116961', 7),
  (73, '905524391', 6),
  (74, '005666342', 3),
  (74, '009996609', 2),
  (74, '193066153', 7),
  (74, '799580586', 1),
  (75, '178191875', 2),
  (75, '201029065', 7),
  (75, '702632046', 7),
  (75, '849866024', 7),
  (76, '008392650', 4),
  (76, '248487285', 5),
  (76, '283609503', 9),
  (76, '380985208', 4),
  (76, '545322544', 1),
  (76, '740577074', 10),
  (77, '036904572', 10),
  (77, '478349069', 7),
  (77, '504940651', 7),
  (77, '976797521', 3),
  (77, '988989417', 5),
  (78, '209905415', 9),
  (78, '280198860', 9),
  (79, '169165199', 7),
  (79, '209905415', 6),
  (79, '904725006', 7),
  (79, '991628649', 5),
  (80, '283609503', 7),
  (80, '457169995', 9),
  (81, '458822391', 7),
  (81, '737214189', 3),
  (82, '946876533', 2),
  (83, '036904572', 7),
  (83, '065361062', 10),
  (83, '252905289', 7),
  (83, '577556219', 8),
  (83, '674568436', 10),
  (83, '709916670', 7),
  (84, '702632046', 3),
  (84, '896531472', 7),
  (85, '396539472', 1),
  (85, '611383602', 6),
  (85, '799580586', 8),
  (86, '048370423', 8),
  (86, '280198860', 3),
  (86, '795120598', 8),
  (86, '896531472', 9),
  (87, '231882891', 3),
  (88, '061299599', 8),
  (88, '302879993', 10),
  (88, '457169995', 2),
  (88, '720640810', 9),
  (89, '418223108', 7),
  (89, '545322544', 10),
  (90, '406270368', 1),
  (90, '835135470', 7),
  (91, '158283846', 3),
  (92, '066790483', 3),
  (92, '107525059', 1),
  (92, '779135891', 6),
  (92, '849866024', 10),
  (92, '927263424', 7),
  (92, '977715212', 10),
  (93, '055134808', 1),
  (93, '458822391', 3),
  (93, '605369373', 5),
  (94, '009996609', 1),
  (95, '249377237', 2),
  (95, '380985208', 1),
  (96, '178191875', 2),
  (96, '584616019', 9),
  (96, '728508341', 8),
  (96, '779135891', 10),
  (96, '964622134', 9),
  (97, '037639676', 2),
  (97, '416156097', 10),
  (97, '642819006', 4),
  (97, '722345523', 7),
  (98, '008392650', 4),
  (98, '238903937', 8),
  (99, '055134808', 6),
  (99, '084701003', 3),
  (99, '977715212', 10),
  (100, '674568436', 8),
  (100, '946876533', 6),
  (101, '134474971', 6),
  (101, '267197813', 10),
  (101, '302879993', 7),
  (101, '691272540', 3),
  (101, '717651307', 6),
  (101, '779846644', 9),
  (102, '380985208', 4),
  (103, '157926444', 2),
  (103, '717651307', 1),
  (104, '241611596', 10),
  (104, '946876533', 6),
  (104, '977715212', 6),
  (105, '107525059', 10),
  (105, '607726716', 6),
  (106, '904725006', 10),
  (106, '924515166', 10),
  (106, '983834414', 7),
  (107, '828927742', 6),
  (108, '249377237', 2),
  (108, '486459501', 1),
  (108, '674568436', 6),
  (109, '005499124', 4),
  (109, '486267334', 1),
  (109, '577556219', 10),
  (109, '739707132', 4),
  (110, '298479518', 8),
  (110, '739707132', 3),
  (110, '905524391', 1),
  (111, '458822391', 3),
  (111, '577556219', 2),
  (111, '584616019', 1),
  (111, '905524391', 2),
  (112, '261424165', 6),
  (112, '283528929', 7),
  (112, '584616019', 4),
  (112, '642819006', 9),
  (113, '418223108', 7),
  (113, '777375977', 8),
  (114, '396539472', 6),
  (114, '573486699', 4),
  (114, '739707132', 8),
  (115, '406270368', 7),
  (115, '674568436', 6),
  (115, '717651307', 10),
  (115, '783460026', 5),
  (116, '169165199', 7),
  (116, '248101425', 5),
  (116, '267197813', 9),
  (116, '302879993', 6),
  (116, '478349069', 1),
  (116, '575755309', 10),
  (116, '609446507', 5),
  (116, '857669280', 6),
  (116, '905524391', 8),
  (117, '098764800', 9),
  (117, '248101425', 2),
  (118, '234594998', 1),
  (118, '252905289', 10),
  (118, '261424165', 6),
  (118, '909338593', 8),
  (119, '134889514', 4),
  (119, '739707132', 8),
  (120, '134474971', 2),
  (120, '193066153', 7),
  (120, '252905289', 2),
  (120, '605369373', 2),
  (121, '107525059', 3),
  (122, '504940651', 6),
  (122, '572971346', 9),
  (122, '709916670', 2),
  (122, '720640810', 6),
  (122, '783460026', 6),
  (123, '376561556', 4),
  (123, '572971346', 4),
  (123, '575755309', 5),
  (123, '601419281', 3),
  (124, '283528929', 9),
  (125, '607726716', 3),
  (126, '036904572', 8),
  (126, '169165199', 2),
  (126, '233875714', 3),
  (126, '261424165', 8),
  (126, '909338593', 10),
  (127, '055493685', 5),
  (127, '061299599', 7),
  (127, '241611596', 10),
  (127, '418223108', 5),
  (128, '005499124', 1),
  (128, '055134808', 6),
  (129, '233875714', 1),
  (129, '572971346', 8),
  (129, '740577074', 3),
  (130, '326305135', 10),
  (130, '573486699', 8),
  (130, '964622134', 4),
  (131, '261424165', 6),
  (132, '376561556', 7),
  (132, '730544483', 7),
  (132, '777375977', 5),
  (132, '857669280', 9),
  (132, '896531472', 5),
  (133, '134889514', 7),
  (133, '208925700', 3),
  (133, '283609503', 4),
  (133, '298479518', 10),
  (134, '573486699', 2),
  (134, '801818241', 1),
  (135, '193066153', 1),
  (135, '209905415', 9),
  (135, '233875714', 2),
  (135, '283528929', 7),
  (135, '505107726', 7),
  (135, '691272540', 3),
  (135, '988989417', 8),
  (136, '002652773', 10),
  (136, '061299599', 3),
  (136, '201213256', 1),
  (136, '680640505', 2),
  (136, '739707132', 1),
  (136, '740577074', 2),
  (136, '976797521', 4),
  (137, '061299599', 10),
  (137, '184362631', 10),
  (137, '233875714', 5),
  (137, '406270368', 10),
  (137, '431199250', 1),
  (137, '607726716', 2),
  (137, '835135470', 5),
  (138, '291274969', 10),
  (138, '783460026', 1),
  (138, '983834414', 6),
  (139, '036904572', 7),
  (139, '584616019', 2),
  (139, '856116961', 5),
  (139, '984651727', 5),
  (140, '061299599', 8),
  (140, '430301187', 10),
  (140, '456073283', 5),
  (141, '209905415', 7),
  (141, '728508341', 3),
  (142, '267197813', 8),
  (142, '406270368', 5),
  (142, '458822391', 1),
  (143, '233875714', 4),
  (143, '248487285', 9),
  (143, '524035300', 8),
  (143, '909338593', 3),
  (143, '977715212', 5),
  (144, '098764800', 7),
  (144, '916062683', 3),
  (144, '984651727', 9),
  (145, '009996609', 10),
  (145, '119217710', 1),
  (145, '134889514', 7),
  (145, '248487285', 5),
  (145, '330085030', 2),
  (145, '547878485', 2),
  (146, '193066153', 1),
  (146, '376561556', 4),
  (146, '702632046', 1),
  (146, '728508341', 10),
  (147, '037639676', 5),
  (147, '065361062', 10),
  (147, '904725006', 3),
  (147, '905524391', 4),
  (148, '904725006', 9),
  (149, '036904572', 2),
  (149, '189831806', 5),
  (150, '008392650', 3),
  (150, '601419281', 8),
  (150, '647157984', 7),
  (151, '547919357', 6),
  (151, '927263424', 5),
  (152, '505107726', 3),
  (152, '624615547', 4),
  (153, '036904572', 7),
  (153, '287157769', 8),
  (153, '291274969', 4),
  (153, '801818241', 5),
  (153, '927263424', 6),
  (154, '031118566', 4),
  (154, '504940651', 10),
  (154, '795120598', 5),
  (154, '849866024', 9),
  (155, '157926444', 10),
  (155, '248487285', 3),
  (155, '835135470', 10),
  (155, '983834414', 1),
  (155, '991628649', 4),
  (156, '071234814', 7),
  (157, '055134808', 1),
  (157, '545322544', 9),
  (158, '431199250', 10),
  (158, '575755309', 6),
  (158, '983834414', 8),
  (159, '178191875', 7),
  (159, '573486699', 1),
  (159, '702632046', 10),
  (159, '964622134', 10),
  (160, '031118566', 2),
  (160, '204463191', 8),
  (160, '504940651', 4),
  (160, '505107726', 9),
  (160, '801818241', 1),
  (160, '896531472', 7),
  (161, '005666342', 10),
  (161, '061299599', 4),
  (161, '261424165', 8),
  (161, '964622134', 4),
  (162, '036904572', 10),
  (162, '184362631', 7),
  (162, '857669280', 8),
  (162, '896531472', 9),
  (163, '005666342', 7),
  (163, '291274969', 1),
  (163, '545322544', 3),
  (163, '739707132', 2),
  (163, '909338593', 3),
  (164, '009996609', 3),
  (164, '799580586', 8),
  (165, '066790483', 1),
  (165, '238903937', 1),
  (165, '624615547', 3),
  (165, '739707132', 1),
  (165, '799580586', 7),
  (165, '885181140', 10),
  (166, '376561556', 3),
  (166, '504940651', 6),
  (167, '005499124', 8),
  (167, '107525059', 2),
  (167, '457169995', 7),
  (167, '592102591', 3),
  (167, '691272540', 1),
  (167, '856116961', 1),
  (168, '209669373', 3),
  (168, '739707132', 3),
  (169, '031118566', 9),
  (169, '326305135', 7),
  (170, '486267334', 9),
  (170, '927263424', 9),
  (170, '991628649', 7),
  (171, '037639676', 1),
  (171, '169165199', 1),
  (171, '504940651', 2),
  (172, '036904572', 8),
  (172, '233875714', 2),
  (172, '724144589', 7),
  (173, '158283846', 8),
  (174, '056231385', 6),
  (174, '107525059', 7),
  (174, '298479518', 9),
  (175, '201029065', 7),
  (175, '687381982', 8),
  (175, '717651307', 7),
  (175, '724144589', 10),
  (176, '066790483', 9),
  (176, '216263427', 7),
  (176, '231882891', 5),
  (176, '380985208', 4),
  (176, '909338593', 9),
  (177, '048370423', 6),
  (177, '280198860', 1),
  (177, '326305135', 10),
  (178, '231882891', 7),
  (178, '241611596', 4),
  (178, '835135470', 8),
  (178, '904725006', 4),
  (179, '396539472', 2),
  (179, '717651307', 5),
  (179, '795120598', 2),
  (180, '225584755', 6),
  (180, '280500368', 5),
  (180, '486267334', 7),
  (180, '504940651', 1),
  (180, '739707132', 1),
  (181, '002652773', 10),
  (181, '134474971', 8),
  (181, '545322544', 7),
  (182, '178191875', 5),
  (182, '783460026', 2),
  (182, '916062683', 3),
  (183, '265730275', 1),
  (183, '730544483', 3),
  (184, '189831806', 8),
  (184, '504940651', 1),
  (184, '545322544', 10),
  (184, '674568436', 1),
  (184, '728508341', 9),
  (184, '779135891', 5),
  (184, '897949103', 8),
  (184, '999980890', 9),
  (185, '209669373', 8),
  (185, '225584755', 2),
  (185, '265730275', 9),
  (185, '783460026', 10),
  (186, '056231385', 9),
  (186, '157926444', 9),
  (186, '234594998', 10),
  (186, '261424165', 7),
  (186, '280500368', 1),
  (186, '709916670', 2),
  (186, '924515166', 10),
  (187, '283528929', 4),
  (187, '287157769', 1),
  (187, '587993087', 6),
  (187, '720640810', 7),
  (187, '779135891', 8),
  (188, '084701003', 9),
  (188, '458822391', 6),
  (188, '777375977', 3),
  (188, '999980890', 6),
  (189, '031118566', 9),
  (189, '056231385', 8),
  (189, '249377237', 9),
  (189, '376561556', 7),
  (189, '777375977', 1),
  (189, '835135470', 5),
  (190, '607726716', 7),
  (191, '280500368', 10),
  (192, '061299599', 9),
  (192, '261424165', 3),
  (192, '469226948', 10),
  (192, '575755309', 9),
  (192, '720640810', 1),
  (192, '857669280', 10),
  (192, '924515166', 2),
  (193, '002652773', 5),
  (193, '252905289', 8),
  (194, '119217710', 5),
  (194, '189831806', 5),
  (194, '611383602', 1),
  (194, '647157984', 6),
  (194, '953679781', 4),
  (195, '006400954', 1),
  (195, '248101425', 6),
  (195, '430301187', 10),
  (196, '005666342', 10),
  (196, '204463191', 7),
  (196, '209669373', 9),
  (196, '209905415', 7),
  (196, '241611596', 9),
  (196, '457169995', 8),
  (196, '624615547', 5),
  (197, '036904572', 10),
  (197, '056231385', 4),
  (197, '674568436', 1),
  (197, '885181140', 7),
  (198, '031118566', 2),
  (198, '071234814', 8),
  (198, '084701003', 2),
  (198, '601419281', 10),
  (199, '084771590', 5),
  (200, '119217710', 6),
  (200, '201213256', 3),
  (200, '283528929', 6),
  (201, '184362631', 7),
  (201, '849866024', 9),
  (201, '964622134', 10),
  (202, '298479518', 9),
  (203, '098764800', 2),
  (203, '178191875', 8),
  (203, '520665628', 7),
  (204, '524035300', 7),
  (204, '609446507', 8),
  (204, '642819006', 8),
  (204, '896531472', 5),
  (205, '208925700', 5),
  (205, '252905289', 6),
  (205, '283528929', 2),
  (205, '572971346', 6),
  (206, '231882891', 1),
  (206, '406270368', 5),
  (206, '430301187', 7),
  (206, '457169995', 9),
  (206, '575755309', 4),
  (206, '605369373', 2),
  (207, '209905415', 10),
  (207, '249377237', 9),
  (207, '380985208', 1),
  (207, '927263424', 2),
  (208, '098764800', 1),
  (208, '431199250', 2),
  (209, '066790483', 10),
  (209, '457169995', 3),
  (209, '828927742', 2),
  (209, '999980890', 8),
  (210, '233875714', 6),
  (210, '456073283', 5),
  (210, '457169995', 7),
  (210, '687381982', 4),
  (211, '605369373', 3),
  (211, '856116961', 8),
  (212, '189831806', 7),
  (212, '674568436', 3),
  (213, '037639676', 6),
  (213, '158283846', 8),
  (213, '724144589', 9),
  (214, '601419281', 10),
  (214, '739707132', 6),
  (215, '209905415', 2),
  (215, '406270368', 3),
  (215, '605369373', 10),
  (216, '036904572', 8),
  (216, '066790483', 5),
  (216, '134474971', 3),
  (216, '157926444', 2),
  (216, '720640810', 7),
  (217, '048370423', 5),
  (217, '524035300', 2),
  (217, '795120598', 10),
  (218, '139375749', 6),
  (218, '984651727', 7),
  (219, '709916670', 6),
  (219, '828927742', 1),
  (220, '204463191', 3),
  (220, '283528929', 2),
  (221, '717651307', 6),
  (221, '924515166', 9),
  (221, '991628649', 5),
  (222, '238903937', 7),
  (222, '486459501', 4),
  (222, '724144589', 1),
  (223, '680640505', 10),
  (223, '849866024', 6),
  (224, '261424165', 10),
  (224, '267197813', 8),
  (224, '624615547', 10),
  (224, '801818241', 3),
  (225, '071234814', 10),
  (225, '134474971', 9),
  (225, '722345523', 2),
  (226, '071234814', 10),
  (226, '457169995', 7),
  (226, '587993087', 1),
  (227, '204463191', 6),
  (227, '587993087', 10),
  (228, '071234814', 4),
  (228, '238903937', 8),
  (228, '241611596', 4),
  (228, '416156097', 5),
  (228, '927263424', 1),
  (229, '009996609', 4),
  (229, '204463191', 2),
  (229, '376561556', 5),
  (230, '048370423', 10),
  (230, '193066153', 5),
  (230, '505107726', 5),
  (230, '674568436', 10),
  (230, '680640505', 9),
  (231, '006400954', 3),
  (231, '984651727', 6),
  (232, '119217710', 7),
  (232, '204463191', 3),
  (232, '376561556', 10),
  (232, '418223108', 10),
  (232, '717651307', 2),
  (232, '904725006', 7),
  (233, '084701003', 1),
  (233, '702632046', 9),
  (233, '953679781', 2),
  (234, '209669373', 6),
  (234, '298479518', 7),
  (234, '302879993', 3),
  (234, '783460026', 4),
  (235, '983834414', 9),
  (236, '184362631', 1),
  (236, '302879993', 10),
  (236, '547878485', 2),
  (236, '676699560', 1),
  (236, '777375977', 8),
  (236, '909338593', 6),
  (236, '983834414', 3),
  (237, '457169995', 7),
  (237, '575755309', 2),
  (237, '777375977', 6),
  (238, '201213256', 6),
  (238, '248101425', 4),
  (239, '119217710', 4),
  (239, '396539472', 8),
  (239, '624615547', 2),
  (240, '291274969', 8),
  (240, '547878485', 1),
  (240, '607726716', 6),
  (240, '783460026', 5),
  (240, '896531472', 8),
  (241, '291274969', 4),
  (241, '380985208', 4),
  (241, '783460026', 10),
  (241, '885181140', 3),
  (242, '587993087', 10),
  (242, '724144589', 6),
  (242, '909338593', 10),
  (242, '927263424', 9),
  (243, '065361062', 3),
  (243, '592102591', 8),
  (243, '885181140', 8),
  (243, '924515166', 2),
  (243, '977715212', 7),
  (244, '225584755', 8),
  (244, '252905289', 5),
  (244, '575755309', 6),
  (244, '924515166', 1),
  (245, '584616019', 1),
  (246, '056231385', 6),
  (246, '084701003', 3),
  (247, '002652773', 8),
  (247, '280500368', 10),
  (247, '396539472', 10),
  (247, '505107726', 9),
  (248, '545322544', 4),
  (248, '905524391', 5),
  (248, '936204092', 2),
  (249, '189831806', 4),
  (249, '505107726', 6),
  (249, '724144589', 7),
  (249, '856116961', 4),
  (249, '946876533', 1),
  (250, '008392650', 1),
  (250, '249377237', 6),
  (250, '573486699', 6),
  (251, '216263427', 10),
  (251, '231882891', 2),
  (251, '457169995', 7),
  (251, '573486699', 6),
  (252, '283609503', 1),
  (252, '458822391', 5),
  (252, '478349069', 5),
  (252, '779135891', 4),
  (252, '857669280', 6),
  (253, '158283846', 1),
  (253, '504940651', 1),
  (253, '609446507', 1),
  (253, '611383602', 2),
  (254, '680640505', 6),
  (255, '098764800', 9),
  (255, '287157769', 6),
  (255, '486267334', 10),
  (256, '036904572', 4),
  (256, '071234814', 9),
  (256, '233875714', 8),
  (256, '486267334', 4),
  (256, '524035300', 1),
  (256, '984651727', 4),
  (257, '134474971', 9),
  (257, '724144589', 2),
  (257, '857669280', 3),
  (258, '722345523', 5),
  (259, '267197813', 3),
  (259, '642819006', 8),
  (259, '801818241', 9),
  (260, '592102591', 1),
  (260, '647157984', 5),
  (260, '687381982', 10),
  (261, '065361062', 2),
  (261, '234594998', 10),
  (261, '396539472', 1),
  (261, '545322544', 10),
  (261, '607726716', 3),
  (261, '904725006', 6),
  (261, '984651727', 4),
  (262, '927263424', 7),
  (263, '970998188', 9),
  (264, '107525059', 1),
  (264, '380985208', 1),
  (264, '486459501', 8),
  (265, '031118566', 9),
  (265, '248101425', 7),
  (265, '418223108', 4),
  (266, '178191875', 6),
  (266, '456073283', 2),
  (267, '201029065', 8),
  (267, '524035300', 1),
  (267, '702632046', 6),
  (267, '983834414', 6),
  (268, '193066153', 4),
  (268, '897949103', 6),
  (268, '936204092', 7),
  (269, '119217710', 10),
  (269, '157926444', 7),
  (269, '545322544', 7),
  (269, '547878485', 10),
  (270, '055493685', 2),
  (270, '066790483', 4),
  (270, '291274969', 2),
  (270, '456073283', 6),
  (270, '624615547', 9),
  (271, '216263427', 5),
  (271, '265730275', 7),
  (272, '418223108', 1),
  (272, '728508341', 8),
  (273, '248101425', 6),
  (273, '376561556', 9),
  (273, '988989417', 1),
  (274, '676699560', 6),
  (274, '777375977', 7),
  (274, '779135891', 8),
  (274, '984651727', 1),
  (275, '164296593', 2),
  (275, '209905415', 5),
  (276, '547919357', 6),
  (276, '739707132', 7),
  (276, '799580586', 7),
  (276, '905524391', 5),
  (276, '983834414', 1),
  (277, '009996609', 5),
  (277, '208925700', 8),
  (277, '225584755', 8),
  (277, '469226948', 10),
  (277, '676699560', 3),
  (277, '779846644', 2),
  (278, '204463191', 9),
  (278, '430301187', 10),
  (279, '005666342', 5),
  (279, '208925700', 7),
  (279, '573486699', 6),
  (279, '857669280', 2),
  (279, '885181140', 2),
  (280, '248487285', 1),
  (280, '283609503', 8),
  (280, '330085030', 7),
  (280, '740577074', 8),
  (280, '977715212', 9),
  (281, '084771590', 9),
  (281, '098764800', 3),
  (281, '977715212', 6),
  (282, '280500368', 8),
  (282, '680640505', 8),
  (282, '777375977', 10),
  (282, '779846644', 8),
  (283, '055493685', 9),
  (283, '611383602', 2),
  (283, '691272540', 5),
  (283, '709916670', 7),
  (284, '265730275', 3),
  (284, '431199250', 10),
  (284, '607726716', 3),
  (285, '478349069', 10),
  (285, '607726716', 6),
  (286, '248487285', 4),
  (286, '252905289', 1),
  (286, '592102591', 4),
  (286, '691272540', 5),
  (286, '799580586', 2),
  (286, '946876533', 2),
  (287, '169165199', 4),
  (287, '261424165', 5),
  (287, '916062683', 9),
  (288, '231882891', 8),
  (288, '233875714', 9),
  (288, '302879993', 10),
  (288, '396539472', 10),
  (288, '416156097', 1),
  (289, '298479518', 3),
  (289, '936204092', 3),
  (290, '248101425', 7),
  (290, '430301187', 9),
  (290, '524035300', 8),
  (290, '674568436', 8),
  (290, '739707132', 9),
  (290, '835135470', 7),
  (290, '909338593', 9),
  (290, '927263424', 1),
  (291, '547919357', 10),
  (291, '609446507', 1),
  (291, '828927742', 6),
  (292, '737214189', 1),
  (293, '005499124', 9),
  (293, '326305135', 3),
  (294, '002652773', 5),
  (295, '607726716', 7),
  (296, '238903937', 5),
  (296, '577556219', 1),
  (297, '066790483', 9),
  (298, '326305135', 3),
  (298, '330085030', 2),
  (299, '037639676', 3),
  (300, '065361062', 8),
  (301, '048370423', 8),
  (301, '157926444', 6),
  (301, '201029065', 9),
  (301, '478349069', 8),
  (301, '607726716', 1),
  (301, '896531472', 8),
  (302, '418223108', 8),
  (302, '587993087', 10),
  (302, '856116961', 5),
  (303, '098764800', 2),
  (303, '291274969', 2),
  (303, '416156097', 3),
  (303, '505107726', 5),
  (303, '545322544', 7),
  (303, '856116961', 4),
  (304, '201029065', 9),
  (304, '204463191', 7),
  (304, '946876533', 10),
  (305, '280500368', 1),
  (305, '298479518', 3),
  (305, '601419281', 4),
  (305, '647157984', 10),
  (305, '674568436', 6),
  (305, '737214189', 4),
  (306, '036904572', 1),
  (306, '084701003', 10),
  (306, '486459501', 6),
  (306, '547919357', 5),
  (306, '691272540', 1),
  (306, '909338593', 9),
  (307, '006400954', 10),
  (307, '233875714', 8),
  (307, '291274969', 5),
  (307, '478349069', 9),
  (307, '896531472', 8),
  (307, '905524391', 8),
  (308, '248487285', 5),
  (308, '283528929', 4),
  (308, '469226948', 1),
  (308, '505107726', 5),
  (308, '520665628', 6),
  (308, '709916670', 1),
  (308, '897949103', 7),
  (308, '999980890', 5),
  (309, '005666342', 5),
  (309, '065361062', 5),
  (309, '783460026', 8),
  (310, '456073283', 10),
  (310, '680640505', 2),
  (310, '739707132', 7),
  (311, '456073283', 10),
  (312, '380985208', 1),
  (312, '676699560', 8),
  (312, '709916670', 8),
  (312, '905524391', 2),
  (313, '066790483', 4),
  (313, '647157984', 7),
  (314, '209905415', 4),
  (314, '248487285', 2),
  (315, '201029065', 5),
  (315, '248101425', 5),
  (315, '573486699', 2),
  (315, '605369373', 2),
  (315, '674568436', 9),
  (315, '905524391', 8),
  (315, '946876533', 4),
  (316, '231882891', 10),
  (316, '624615547', 3),
  (317, '469226948', 3),
  (317, '592102591', 7),
  (317, '691272540', 7),
  (318, '061299599', 6),
  (318, '577556219', 1),
  (318, '624615547', 1),
  (318, '976797521', 3),
  (319, '164296593', 7),
  (319, '486459501', 5),
  (320, '201213256', 1),
  (320, '376561556', 3),
  (320, '396539472', 5),
  (320, '418223108', 8),
  (320, '909338593', 8),
  (321, '061299599', 8),
  (321, '547878485', 7),
  (321, '904725006', 9),
  (321, '916062683', 3),
  (322, '291274969', 8),
  (323, '193066153', 6),
  (323, '225584755', 7),
  (323, '252905289', 4),
  (323, '261424165', 3),
  (323, '265730275', 10),
  (323, '280500368', 3),
  (323, '857669280', 6),
  (323, '964622134', 3),
  (324, '252905289', 6),
  (324, '380985208', 10),
  (324, '728508341', 5),
  (324, '920057796', 7),
  (324, '984651727', 4),
  (325, '055493685', 7),
  (325, '611383602', 9),
  (325, '624615547', 3),
  (326, '857669280', 2),
  (327, '031118566', 4),
  (327, '283528929', 6),
  (328, '084701003', 6),
  (328, '457169995', 3),
  (328, '709916670', 5),
  (329, '055493685', 9),
  (329, '486459501', 3),
  (330, '486459501', 6),
  (330, '717651307', 9),
  (331, '248487285', 10),
  (331, '469226948', 2),
  (331, '885181140', 6),
  (332, '835135470', 6),
  (332, '953679781', 7),
  (333, '248101425', 6),
  (333, '298479518', 8),
  (333, '486459501', 3),
  (333, '547919357', 2),
  (333, '587993087', 9),
  (333, '601419281', 5),
  (334, '241611596', 5),
  (334, '326305135', 6),
  (334, '896531472', 3),
  (335, '005666342', 8),
  (336, '208925700', 6),
  (336, '676699560', 4),
  (336, '702632046', 9),
  (337, '505107726', 9),
  (337, '647157984', 8),
  (338, '134889514', 7),
  (338, '287157769', 7),
  (338, '418223108', 7),
  (339, '252905289', 3),
  (339, '431199250', 1),
  (339, '587993087', 10),
  (340, '248487285', 9),
  (340, '601419281', 10),
  (340, '885181140', 9),
  (341, '225584755', 1),
  (341, '261424165', 6),
  (341, '283609503', 6),
  (341, '396539472', 4),
  (341, '504940651', 6),
  (341, '687381982', 10),
  (341, '777375977', 2),
  (342, '208925700', 3),
  (342, '430301187', 9),
  (342, '431199250', 4),
  (342, '457169995', 4),
  (342, '783460026', 9),
  (342, '857669280', 8),
  (343, '248487285', 9),
  (343, '261424165', 6),
  (343, '330085030', 3),
  (343, '416156097', 7),
  (344, '107525059', 10),
  (344, '737214189', 6),
  (345, '009996609', 8),
  (345, '248487285', 7),
  (345, '920057796', 2),
  (346, '520665628', 2),
  (346, '920057796', 6),
  (347, '505107726', 8),
  (347, '642819006', 7),
  (348, '098764800', 3),
  (348, '216263427', 7),
  (348, '287157769', 10),
  (348, '478349069', 9),
  (348, '577556219', 4),
  (348, '779846644', 5),
  (348, '970998188', 1),
  (349, '066790483', 3),
  (349, '248487285', 4),
  (349, '376561556', 9),
  (349, '720640810', 10),
  (350, '287157769', 7),
  (350, '396539472', 7),
  (350, '779846644', 1),
  (350, '783460026', 4),
  (350, '916062683', 1),
  (350, '984651727', 2),
  (351, '071234814', 1),
  (351, '486267334', 1),
  (351, '783460026', 6),
  (352, '084701003', 3),
  (352, '107525059', 4),
  (352, '249377237', 8),
  (352, '605369373', 6),
  (352, '964622134', 10),
  (353, '066790483', 8),
  (353, '779135891', 10),
  (353, '835135470', 5),
  (353, '924515166', 3),
  (354, '048370423', 7),
  (354, '249377237', 9),
  (354, '687381982', 4),
  (354, '977715212', 4),
  (355, '418223108', 4),
  (356, '302879993', 1),
  (356, '920057796', 10),
  (357, '431199250', 6),
  (357, '739707132', 7),
  (357, '983834414', 5),
  (358, '234594998', 4),
  (358, '642819006', 6),
  (358, '709916670', 6),
  (359, '201213256', 6),
  (359, '406270368', 1),
  (359, '524035300', 6),
  (359, '896531472', 2),
  (360, '065361062', 9),
  (360, '717651307', 1),
  (360, '828927742', 7),
  (361, '158283846', 4),
  (361, '505107726', 1),
  (361, '611383602', 4),
  (361, '720640810', 5),
  (361, '722345523', 2),
  (361, '849866024', 9),
  (362, '157926444', 6),
  (362, '225584755', 8),
  (362, '249377237', 8),
  (362, '396539472', 9),
  (362, '779846644', 9),
  (363, '225584755', 9),
  (363, '904725006', 10),
  (364, '216263427', 3),
  (364, '252905289', 4),
  (364, '897949103', 5),
  (364, '905524391', 7),
  (365, '084701003', 3),
  (365, '248487285', 9),
  (365, '280500368', 8),
  (365, '601419281', 5),
  (365, '605369373', 1),
  (365, '856116961', 1),
  (366, '071234814', 2),
  (366, '547919357', 3),
  (366, '607726716', 9),
  (366, '777375977', 5),
  (367, '056231385', 9),
  (367, '184362631', 10),
  (367, '545322544', 7),
  (367, '575755309', 10),
  (368, '005499124', 4),
  (368, '572971346', 10),
  (368, '680640505', 1),
  (368, '740577074', 2),
  (368, '828927742', 8),
  (368, '999980890', 2),
  (369, '002652773', 10),
  (369, '158283846', 5),
  (369, '674568436', 1),
  (369, '977715212', 3),
  (370, '055493685', 5),
  (370, '298479518', 1),
  (370, '607726716', 10),
  (371, '031118566', 1),
  (371, '098764800', 1),
  (371, '520665628', 3),
  (371, '720640810', 1),
  (371, '964622134', 4),
  (372, '691272540', 1),
  (372, '991628649', 6),
  (373, '164296593', 5),
  (373, '298479518', 4),
  (373, '722345523', 8),
  (373, '856116961', 7),
  (373, '897949103', 1),
  (374, '134474971', 8),
  (374, '134889514', 8),
  (374, '740577074', 3),
  (374, '984651727', 8),
  (375, '084701003', 6),
  (375, '380985208', 6),
  (375, '799580586', 8),
  (375, '835135470', 4),
  (375, '904725006', 2),
  (376, '036904572', 9),
  (376, '267197813', 5),
  (376, '458822391', 8),
  (376, '624615547', 7),
  (376, '680640505', 10),
  (377, '201213256', 2),
  (378, '005666342', 1),
  (378, '376561556', 4),
  (378, '504940651', 9),
  (379, '430301187', 10),
  (379, '547919357', 1),
  (379, '687381982', 1),
  (379, '739707132', 5),
  (380, '201213256', 9),
  (380, '505107726', 5),
  (381, '061299599', 9),
  (381, '283609503', 2),
  (381, '545322544', 1),
  (381, '547878485', 4),
  (381, '573486699', 10),
  (381, '946876533', 3),
  (381, '976797521', 6),
  (382, '009996609', 8),
  (382, '283528929', 2),
  (382, '302879993', 2),
  (382, '779846644', 6),
  (382, '970998188', 2),
  (383, '248487285', 1),
  (383, '545322544', 4),
  (383, '680640505', 6),
  (384, '330085030', 6),
  (384, '469226948', 5),
  (385, '158283846', 2),
  (385, '547919357', 5),
  (385, '977715212', 10),
  (386, '065361062', 2),
  (386, '225584755', 8),
  (386, '233875714', 7),
  (386, '691272540', 6),
  (386, '722345523', 6),
  (386, '857669280', 5),
  (386, '920057796', 8),
  (387, '380985208', 5),
  (387, '457169995', 6),
  (387, '611383602', 8),
  (387, '724144589', 8),
  (388, '291274969', 2),
  (389, '184362631', 3),
  (389, '238903937', 5),
  (389, '265730275', 4),
  (389, '478349069', 4),
  (389, '920057796', 3),
  (389, '977715212', 2),
  (390, '164296593', 8),
  (390, '178191875', 9),
  (390, '280500368', 9),
  (390, '283528929', 7),
  (391, '055134808', 2),
  (391, '642819006', 2),
  (392, '158283846', 7),
  (392, '209905415', 6),
  (392, '584616019', 1),
  (393, '280500368', 9),
  (393, '283528929', 9),
  (393, '909338593', 2),
  (394, '169165199', 3),
  (394, '261424165', 5),
  (394, '505107726', 3),
  (394, '611383602', 7),
  (395, '396539472', 1),
  (395, '647157984', 10),
  (395, '737214189', 10),
  (395, '856116961', 2),
  (395, '936204092', 6),
  (395, '988989417', 3),
  (396, '739707132', 1),
  (396, '856116961', 7),
  (397, '406270368', 4),
  (397, '739707132', 8),
  (398, '573486699', 3),
  (399, '287157769', 4),
  (400, '238903937', 3),
  (400, '885181140', 9);
  
  --
  -- Triggers `contains`
  --
  DELIMITER $$
  CREATE TRIGGER `AddItemToTranscaction` AFTER INSERT ON `contains` FOR EACH ROW UPDATE transcaction SET total_price = total_price + (SELECT item.current_price*NEW.amount FROM item AS item WHERE item.Barcode =  NEW.barcode LIMIT 1), total_pieces = total_pieces + (NEW.amount) WHERE transcaction.id = NEW.transcaction_id
  $$
  DELIMITER ;
  DELIMITER $$
  CREATE TRIGGER `RemoveItemTranscation` AFTER DELETE ON `contains` FOR EACH ROW UPDATE transcaction SET total_price = total_price - (SELECT item.current_price*OLD.amount FROM item AS item WHERE item.Barcode = OLD.barcode LIMIT 1), total_pieces = total_pieces - OLD.amount WHERE id = OLD.transcaction_id
  $$
  DELIMITER ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `customer`
  --
  
  CREATE TABLE `customer` (
    `card_id` int(11) NOT NULL,
    `points` int(11) DEFAULT 0,
    `first_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `street_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `street_number` smallint(6) DEFAULT NULL,
    `city` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `state` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `zipcode` int(11) DEFAULT NULL,
    `birth_date` date DEFAULT '0000-00-00',
    `married` tinyint(4) DEFAULT 0,
    `children` tinyint(4) DEFAULT 0,
    `pets` tinyint(4) DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `customer`
  --
  
  INSERT INTO `customer` (`card_id`, `points`, `first_name`, `last_name`, `street_name`, `street_number`, `city`, `state`, `zipcode`, `birth_date`, `married`, `children`, `pets`) VALUES
  (0, 9142, 'Rodger', 'Mueller', 'et', 634, 'New Kaneshire', 'NewYork', 66624, '1994-10-26', 1, 13, 1),
  (1, 83780, 'Zack', 'Ratke', 'natus', 7664, 'North Syble', 'Louisiana', 86892, '1978-06-13', 1, 13, 0),
  (2, 56971, 'Rubie', 'Murazik', 'atque', 50, 'East Merritt', 'Virginia', 83008, '2006-01-01', 0, 9, 0),
  (3, 298, 'Kaleb', 'Kutch', 'nihil', 32767, 'Trantowshire', 'Maine', 47217, '1972-03-26', 1, 19, 0),
  (4, 62181, 'Annabel', 'Cummerata', 'explicabo', 32767, 'Davisshire', 'District of Columbia', 3102, '2001-10-07', 1, 8, 1),
  (5, 20979, 'Francesco', 'Stracke', 'occaecati', 0, 'Lylafurt', 'NorthDakota', 48951, '2011-12-12', 1, 14, 0),
  (6, 85195, 'Margie', 'Olson', 'sed', 6261, 'North Wendellshire', 'Mississippi', 36394, '1999-11-21', 0, 0, 1),
  (7, 93845, 'Miles', 'Volkman', 'laudantium', 7207, 'North Scottiefurt', 'Illinois', 24648, '1996-07-17', 0, 18, 0),
  (8, 17916, 'Roma', 'Beatty', 'dolorem', 32767, 'Derricktown', 'Arkansas', 32100, '2018-02-16', 0, 16, 1),
  (9, 10558, 'Jessyca', 'Williamson', 'harum', 6, 'North Heberport', 'Kentucky', 18965, '1996-06-16', 0, 8, 1),
  (10, 57947, 'Alexys', 'Wiegand', 'itaque', 27, 'South Freida', 'Indiana', 82193, '2009-03-01', 1, 6, 1),
  (11, 82273, 'Cara', 'Haley', 'perferendis', 32767, 'Colechester', 'Delaware', 21808, '1979-01-01', 1, 16, 1),
  (12, 11172, 'Yasmin', 'Gibson', 'quae', 0, 'Douglasburgh', 'California', 24773, '2003-02-25', 1, 16, 0),
  (13, 51589, 'Sasha', 'Medhurst', 'dolores', 3347, 'Ziemeview', 'Maryland', 13818, '1994-05-16', 0, 3, 0),
  (14, 38758, 'Marjorie', 'Sipes', 'ut', 3340, 'North Laron', 'Nebraska', 59749, '1988-10-26', 0, 14, 0),
  (15, 30669, 'Marley', 'Zemlak', 'qui', 32767, 'Lake Davestad', 'Oklahoma', 20559, '1977-07-27', 0, 3, 0),
  (16, 54407, 'Brandon', 'Wyman', 'voluptas', 32767, 'Noemyhaven', 'Montana', 90029, '2002-02-07', 0, 3, 1),
  (17, 85662, 'Daphne', 'Bergstrom', 'nemo', 0, 'Garrymouth', 'Oklahoma', 98510, '2013-05-29', 0, 0, 0),
  (18, 57558, 'Guy', 'Kertzmann', 'ullam', 0, 'North Humberto', 'Montana', 4478, '1980-02-19', 1, 5, 0),
  (19, 72806, 'Gage', 'Halvorson', 'rerum', 8, 'O\'Connellville', 'Indiana', 11287, '2018-08-17', 1, 9, 0),
  (20, 36068, 'Anabelle', 'King', 'et', 32767, 'New Peytonton', 'Indiana', 62247, '2013-04-24', 0, 6, 1),
  (21, 43943, 'Arlo', 'Barton', 'non', 32767, 'Gleasonhaven', 'Alabama', 96316, '2011-03-29', 1, 20, 0),
  (22, 5149, 'Sedrick', 'Boyer', 'voluptate', 23, 'South Maximillianborough', 'Texas', 27495, '1976-10-28', 0, 4, 0),
  (23, 11014, 'Kiarra', 'Ledner', 'itaque', 214, 'Muellershire', 'Washington', 65273, '1970-07-12', 0, 15, 0),
  (24, 479, 'Merle', 'Powlowski', 'mollitia', 5392, 'Lake Ginochester', 'Colorado', 80676, '1997-12-14', 1, 1, 1),
  (25, 79492, 'Deondre', 'Thompson', 'explicabo', 32767, 'Bergstrommouth', 'Wyoming', 1266, '2010-11-30', 0, 20, 1),
  (26, 14834, 'Liza', 'Anderson', 'minima', 32767, 'East Alexandra', 'Montana', 96821, '1974-10-09', 0, 3, 1),
  (27, 11625, 'Sienna', 'Shields', 'sint', 6, 'North Belle', 'Arizona', 67967, '2014-09-18', 1, 5, 1),
  (28, 55020, 'Dale', 'Wilderman', 'repellendus', 2947, 'Goyetteport', 'Idaho', 80024, '1972-10-15', 1, 0, 0),
  (29, 43657, 'Troy', 'Dicki', 'neque', 2, 'Jadenport', 'Arkansas', 89418, '2003-09-23', 1, 20, 1),
  (30, 88472, 'Selina', 'Heller', 'sit', 32767, 'West Santina', 'Hawaii', 17304, '1976-12-15', 0, 12, 0),
  (31, 92127, 'Noemy', 'Bosco', 'ut', 5377, 'South Earlinetown', 'Kentucky', 14499, '2012-04-08', 1, 4, 1),
  (32, 93852, 'German', 'Schultz', 'ducimus', 2, 'East Simeon', 'Nevada', 33052, '2000-10-14', 1, 7, 1),
  (33, 76768, 'Bettie', 'Harber', 'non', 0, 'Paucekmouth', 'Virginia', 49177, '1984-01-14', 1, 7, 1),
  (34, 87271, 'Dax', 'O\'Conner', 'ipsa', 25990, 'Vladimirberg', 'Missouri', 71080, '2015-09-13', 0, 13, 1),
  (35, 27859, 'Donna', 'Lind', 'sapiente', 38, 'New Rainaberg', 'Missouri', 54287, '1996-07-04', 0, 1, 0),
  (36, 82452, 'Audreanne', 'Huels', 'consequuntur', 64, 'New Hollyborough', 'NewJersey', 62107, '2005-04-26', 1, 8, 0),
  (37, 90161, 'Doris', 'Veum', 'nam', 32767, 'New Alanis', 'Utah', 7037, '1988-04-28', 1, 7, 0),
  (38, 48225, 'Shirley', 'Romaguera', 'consequatur', 0, 'Steubershire', 'Mississippi', 61011, '2019-06-13', 0, 5, 0),
  (39, 40992, 'Dejah', 'Torphy', 'atque', 32767, 'Howellshire', 'Indiana', 42048, '2009-08-26', 1, 3, 0),
  (40, 30493, 'Jared', 'Smith', 'et', 36, 'Bayerberg', 'Iowa', 64826, '1974-02-01', 1, 18, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Stand-in structure for view `customer_details`
  -- (See below for the actual view)
  --
  CREATE TABLE `customer_details` (
  `name` varchar(91)
  ,`adrress` varchar(156)
  ,`birth_date` date
  ,`married` tinyint(4)
  ,`children` tinyint(4)
  ,`pets` tinyint(4)
  );
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `item`
  --
  
  CREATE TABLE `item` (
    `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `Barcode` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `category_id` int(11) DEFAULT NULL,
    `signature_item` tinyint(4) DEFAULT 0,
    `current_price` float DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `item`
  --
  
  INSERT INTO `item` (`name`, `Barcode`, `category_id`, `signature_item`, `current_price`) VALUES
  ('3c630ae5', '002652773', 3, 0, 87.65),
  ('4c5ba88b', '005499124', 2, 0, 61.61),
  ('53c823ba', '005666342', 4, 1, 2.21),
  ('096ac5f3', '006400954', 3, 0, 31.71),
  ('22c355a8', '008392650', 5, 0, 97.83),
  ('1de33ff9', '009996609', 0, 1, 5.32),
  ('656309ac', '031118566', 3, 0, 35.85),
  ('9c009e0b', '036904572', 2, 0, 63.21),
  ('d8c99a69', '037639676', 1, 1, 99.58),
  ('b593e77a', '048370423', 0, 1, 23.5),
  ('68875a39', '055134808', 1, 1, 36.14),
  ('bda40651', '055493685', 0, 1, 86.87),
  ('6f8550de', '056231385', 3, 1, 65.33),
  ('bf6dc9d3', '061299599', 3, 0, 26.02),
  ('4b40b6c0', '065361062', 2, 1, 62.13),
  ('8040328e', '066790483', 5, 1, 58.64),
  ('94a032f9', '071234814', 5, 0, 16.17),
  ('976327d7', '084701003', 4, 0, 17.26),
  ('3ee6668b', '084771590', 1, 1, 72.75),
  ('ceda6317', '098764800', 2, 0, 37.42),
  ('1be6a82c', '107525059', 5, 0, 12.66),
  ('d9bf83a3', '119217710', 0, 0, 72.5),
  ('ee962f48', '134474971', 5, 1, 42.76),
  ('b54df792', '134889514', 4, 0, 5.94),
  ('77699985', '139375749', 4, 0, 49.11),
  ('53a301e9', '157926444', 3, 1, 8.28),
  ('3fdc5e17', '158283846', 4, 0, 71.57),
  ('9bbc811d', '164296593', 2, 0, 16.57),
  ('9066c232', '169165199', 3, 1, 70.08),
  ('f78fa17b', '178191875', 2, 0, 33.06),
  ('ba5a41fc', '184362631', 5, 0, 55.79),
  ('3c2cb0aa', '189831806', 1, 1, 0.05),
  ('28f6de70', '193066153', 0, 0, 15.13),
  ('7e139c66', '201029065', 2, 0, 78.67),
  ('9e9dc24f', '201213256', 3, 0, 79.22),
  ('a6ffe692', '204463191', 5, 0, 73.1),
  ('ffacf5c5', '208925700', 4, 0, 70.07),
  ('70659de9', '209669373', 5, 0, 49.94),
  ('5a945f88', '209905415', 2, 1, 93.28),
  ('3bcb306b', '216263427', 1, 0, 89.68),
  ('ffceed02', '225584755', 1, 0, 71.62),
  ('b7473c2a', '231882891', 5, 0, 73.56),
  ('311bb361', '233875714', 1, 0, 94.86),
  ('7ca83c9f', '234594998', 0, 1, 61.61),
  ('111d1af7', '238903937', 0, 0, 38.92),
  ('d77a83d4', '241611596', 0, 0, 68.04),
  ('aeeca732', '248101425', 2, 1, 62.74),
  ('27015ed4', '248487285', 1, 1, 63.27),
  ('db1c033f', '249377237', 1, 1, 26.92),
  ('2cea0b03', '252905289', 4, 0, 94.97),
  ('4dac007f', '261424165', 5, 0, 74.54),
  ('17303ab2', '265730275', 2, 0, 46.06),
  ('4781a651', '267197813', 5, 1, 28.69),
  ('9ed3756b', '280198860', 1, 0, 92.95),
  ('0e4beb67', '280500368', 0, 0, 99.87),
  ('fd932feb', '283528929', 1, 1, 5.7),
  ('7a706295', '283609503', 5, 0, 1.12),
  ('1db9fd4b', '287157769', 1, 0, 25.99),
  ('85048a98', '291274969', 0, 0, 65.96),
  ('f91982c6', '298479518', 2, 0, 66.54),
  ('2f406c3f', '302879993', 1, 0, 35.81),
  ('af2e2fdf', '326305135', 0, 0, 19.91),
  ('5d0ba160', '330085030', 0, 0, 48.01),
  ('d5c3dfe8', '376561556', 1, 0, 56.59),
  ('fd003c5e', '380985208', 1, 0, 65.61),
  ('a5cd80c4', '396539472', 0, 0, 91.75),
  ('47b75e22', '406270368', 2, 0, 78.64),
  ('3da5a0b1', '416156097', 4, 1, 12.97),
  ('d013fd4c', '418223108', 3, 0, 46.02),
  ('8fd8c7a9', '430301187', 0, 0, 29.34),
  ('20ef8d12', '431199250', 1, 0, 25.06),
  ('877db9bf', '456073283', 0, 1, 58.84),
  ('0b86e5e7', '457169995', 1, 0, 68.71),
  ('f731152f', '458822391', 5, 1, 82.56),
  ('0e9a6ef0', '469226948', 1, 1, 14.98),
  ('e6eede84', '478349069', 5, 0, 99.32),
  ('18f18590', '486267334', 4, 0, 44.2),
  ('15a723b7', '486459501', 3, 0, 37.42),
  ('be876b68', '504940651', 0, 0, 99.78),
  ('2f5a8317', '505107726', 3, 0, 97.54),
  ('01a61abf', '520665628', 0, 1, 27.89),
  ('4cd0fb30', '524035300', 2, 0, 40.62),
  ('8178c062', '545322544', 1, 0, 39.03),
  ('f41b1bb1', '547878485', 4, 1, 52.33),
  ('a6fd7a6d', '547919357', 0, 0, 95.44),
  ('ff2283dd', '572971346', 5, 1, 95.41),
  ('90067645', '573486699', 4, 0, 27.58),
  ('b001cd85', '575755309', 2, 1, 96.99),
  ('9bb37c6c', '577556219', 2, 0, 76.48),
  ('c390fb26', '584616019', 5, 1, 14.86),
  ('58c41c92', '587993087', 3, 0, 94.19),
  ('6b34527e', '592102591', 5, 0, 32.78),
  ('3ba3e07c', '601419281', 0, 0, 22.26),
  ('7f84a88a', '605369373', 2, 0, 26.7),
  ('b5a7238a', '607726716', 0, 0, 85.95),
  ('bf9819d4', '609446507', 0, 0, 28.85),
  ('31773d86', '611383602', 5, 1, 17.41),
  ('4fe5cca2', '624615547', 0, 0, 34.5),
  ('92e82abd', '642819006', 2, 1, 58.41),
  ('f8b3b932', '647157984', 5, 1, 11.93),
  ('ecc15885', '674568436', 0, 0, 81.07),
  ('efb10cdc', '676699560', 5, 0, 87.28),
  ('a195607e', '680640505', 1, 1, 75.55),
  ('824130da', '687381982', 2, 0, 11.19),
  ('e79f96f4', '691272540', 5, 0, 60.44),
  ('3872e58b', '702632046', 5, 0, 1.73),
  ('9d40e628', '709916670', 2, 1, 18.91),
  ('c3f694c7', '717651307', 2, 0, 49.38),
  ('29ca8e12', '720640810', 2, 0, 91.06),
  ('2087f50a', '722345523', 5, 0, 97.68),
  ('8871d9a2', '724144589', 0, 0, 55.53),
  ('6384f1bf', '728508341', 2, 0, 2.01),
  ('e589616d', '730544483', 3, 0, 40.55),
  ('cad2c9fc', '737214189', 1, 0, 86.73),
  ('2b4cc87e', '739707132', 0, 0, 4),
  ('97043e61', '740577074', 2, 1, 13.95),
  ('5df046bf', '777375977', 1, 0, 72.86),
  ('2cc863ac', '779135891', 1, 0, 84.09),
  ('54d6cb85', '779846644', 0, 0, 67.62),
  ('27cc8e23', '783460026', 5, 0, 34.49),
  ('bf923f1d', '795120598', 3, 0, 69.53),
  ('63b12080', '799580586', 0, 0, 82.1),
  ('e4971161', '801818241', 3, 1, 9.54),
  ('fc249172', '828927742', 5, 0, 71.55),
  ('cd6939f7', '835135470', 5, 1, 60.58),
  ('bd69922e', '849866024', 0, 0, 81.57),
  ('3f8d7b04', '856116961', 2, 0, 83.12),
  ('89463cda', '857669280', 1, 0, 46.91),
  ('d24b5b13', '885181140', 1, 0, 47.83),
  ('4fec80f3', '896531472', 2, 0, 92.01),
  ('0d80491f', '897949103', 1, 0, 50.25),
  ('d55d811c', '904725006', 4, 0, 81.59),
  ('d577a47f', '905524391', 4, 0, 16.41),
  ('1b420bd6', '909338593', 0, 1, 74.27),
  ('0856aa98', '916062683', 2, 1, 77.15),
  ('91c9d79a', '920057796', 0, 0, 92.34),
  ('fc63c93a', '924515166', 1, 1, 34.43),
  ('c644cb50', '927263424', 3, 0, 68.84),
  ('94f17ba4', '936204092', 2, 0, 0.3),
  ('0da7f372', '946876533', 5, 1, 46.98),
  ('ebf231a0', '953679781', 3, 1, 98.6),
  ('4037956e', '964622134', 0, 0, 52.43),
  ('b6c34b4a', '970998188', 3, 0, 23.25),
  ('1b8dc4bb', '976797521', 3, 1, 44.26),
  ('f0682ef1', '977715212', 4, 1, 95.46),
  ('f22c9f26', '983834414', 5, 1, 44.41),
  ('27b4f20d', '984651727', 0, 0, 93.89),
  ('bdb50218', '988989417', 5, 0, 93.28),
  ('c5471e94', '991628649', 2, 0, 26.02),
  ('8a2ca2ba', '999980890', 0, 0, 93.67);
  
  --
  -- Triggers `item`
  --
  DELIMITER $$
  CREATE TRIGGER `ItemCatChange` AFTER UPDATE ON `item` FOR EACH ROW IF NEW.category_id != OLD.category_id THEN
  DELETE FROM provides WHERE (SELECT COUNT(i.category_id) FROM item as i, carries as c WHERE provides.category_id = category_id && c.barcode = i.Barcode && provides.store_id = c.store_id) = 0;
  END IF
  $$
  DELIMITER ;
  DELIMITER $$
  CREATE TRIGGER `ItemCatChange2` AFTER UPDATE ON `item` FOR EACH ROW IF NEW.category_id != OLD.category_id THEN
  INSERT INTO provides(store_id,category_id) SELECT DISTINCT s.id,NEW.category_id FROM supermarkets AS s, carries AS c WHERE c.barcode = NEW.Barcode && c.store_id = s.id && NOT EXISTS(SELECT * FROM provides AS a WHERE a.store_id = s.id && a.category_id = NEW.category_id);
  END IF
  $$
  DELIMITER ;
  DELIMITER $$
  CREATE TRIGGER `ItemPriceUpdate` BEFORE UPDATE ON `item` FOR EACH ROW IF NEW.current_price != OLD.current_price && NEW.current_price >= 0 THEN
  INSERT INTO price_change(date,barcode,old_price,new_price) VALUES (CURRENT_TIMESTAMP,NEW.Barcode,OLD.current_price,NEW.current_price);
  ELSEIF NEW.current_price < 0 THEN
  SET NEW.current_price = 0;
  IF OLD.current_price != 0 THEN
  INSERT INTO price_change(date,barcode,old_price,new_price) VALUES (CURRENT_TIMESTAMP,NEW.Barcode,OLD.current_price,0);
  END IF;
  END IF
  $$
  DELIMITER ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `price_change`
  --
  
  CREATE TABLE `price_change` (
    `date` datetime NOT NULL,
    `barcode` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `old_price` float DEFAULT NULL,
    `new_price` float DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `price_change`
  --
  
  INSERT INTO `price_change` (`date`, `barcode`, `old_price`, `new_price`) VALUES
  ('1990-01-13 10:13:07', '005499124', 0, 96.54),
  ('1990-03-03 19:16:51', '178191875', 0, 21.12),
  ('1990-05-06 20:10:12', '469226948', 0, 54.71),
  ('1990-06-09 10:29:25', '584616019', 0, 81.79),
  ('1990-07-10 19:42:45', '036904572', 0, 30.21),
  ('1991-01-18 12:05:03', '976797521', 0, 9.91),
  ('1991-07-17 16:30:10', '231882891', 0, 87.55),
  ('1991-09-25 10:33:51', '577556219', 0, 11.3),
  ('1991-11-12 18:05:18', '241611596', 0, 67.95),
  ('1991-12-26 10:35:31', '779846644', 0, 70.21),
  ('1992-01-31 09:28:40', '988989417', 0, 42.26),
  ('1992-01-31 16:07:54', '009996609', 0, 14.2),
  ('1992-06-30 09:56:42', '055493685', 0, 13.62),
  ('1992-08-13 14:54:56', '430301187', 0, 67.95),
  ('1992-09-30 11:31:40', '575755309', 0, 36.75),
  ('1992-12-06 16:26:09', '098764800', 0, 70.39),
  ('1993-01-05 11:44:38', '418223108', 0, 63.19),
  ('1993-03-22 09:42:24', '717651307', 0, 77.01),
  ('1993-04-22 14:36:38', '702632046', 0, 7.74),
  ('1993-06-14 13:05:57', '330085030', 0, 17.8),
  ('1994-03-06 16:47:01', '169165199', 0, 78.6),
  ('1994-05-21 16:04:15', '287157769', 0, 25.09),
  ('1994-05-26 20:31:57', '999980890', 0, 73.89),
  ('1994-06-28 12:06:49', '737214189', 0, 1.62),
  ('1994-07-01 13:11:19', '486459501', 0, 25.47),
  ('1994-07-23 13:36:16', '920057796', 0, 2.84),
  ('1994-09-06 15:48:25', '201213256', 0, 45.21),
  ('1994-09-07 09:52:49', '740577074', 0, 13.58),
  ('1994-09-21 15:10:52', '545322544', 0, 23.14),
  ('1994-12-07 20:06:46', '897949103', 0, 27),
  ('1995-06-13 19:13:05', '261424165', 0, 62.55),
  ('1995-11-05 12:07:02', '066790483', 0, 99.08),
  ('1995-11-12 10:27:53', '592102591', 0, 71.36),
  ('1995-12-06 14:15:19', '828927742', 0, 43.4),
  ('1996-01-11 18:43:05', '795120598', 0, 38.69),
  ('1996-01-22 09:00:57', '674568436', 0, 40.02),
  ('1997-01-02 15:16:01', '380985208', 0, 85.58),
  ('1997-02-23 12:27:10', '376561556', 0, 84.84),
  ('1997-03-31 12:50:05', '406270368', 0, 3.58),
  ('1997-04-10 12:24:32', '953679781', 0, 80.96),
  ('1997-09-27 10:22:45', '801818241', 0, 13.37),
  ('1997-11-23 19:14:00', '724144589', 0, 26.55),
  ('1997-12-05 14:10:36', '720640810', 0, 34.67),
  ('1997-12-09 11:10:35', '008392650', 0, 75.63),
  ('1998-03-05 13:42:21', '896531472', 0, 15.73),
  ('1998-05-15 15:46:47', '265730275', 0, 56.97),
  ('1998-05-24 20:16:38', '909338593', 0, 77.22),
  ('1998-09-01 09:49:05', '991628649', 0, 96.04),
  ('1998-11-17 08:04:41', '547919357', 0, 30.86),
  ('1999-01-23 09:05:30', '002652773', 0, 46.4),
  ('1999-01-25 09:35:56', '031118566', 0, 52.01),
  ('1999-02-21 14:52:02', '037639676', 0, 46.4),
  ('1999-05-11 09:00:03', '134474971', 0, 54.02),
  ('1999-05-30 08:31:19', '457169995', 0, 55.11),
  ('1999-06-05 12:53:55', '977715212', 0, 63.03),
  ('1999-06-24 11:03:32', '524035300', 0, 15.97),
  ('1999-08-07 15:33:09', '904725006', 0, 35.92),
  ('1999-08-17 09:18:49', '478349069', 0, 73.42),
  ('1999-09-24 12:17:54', '601419281', 0, 93.18),
  ('2000-02-18 12:35:05', '055134808', 0, 53.81),
  ('2000-04-10 08:35:09', '396539472', 0, 48.04),
  ('2000-04-10 13:18:33', '139375749', 0, 27.46),
  ('2000-07-12 09:00:04', '248487285', 0, 52.87),
  ('2000-08-26 08:25:31', '065361062', 0, 4.25),
  ('2000-12-04 12:44:03', '005666342', 0, 52.81),
  ('2001-04-21 20:21:48', '193066153', 0, 9.83),
  ('2001-10-13 18:26:06', '547878485', 0, 80.23),
  ('2002-07-31 08:41:52', '326305135', 0, 28.82),
  ('2002-08-09 15:09:53', '184362631', 0, 38.84),
  ('2002-12-01 17:48:27', '225584755', 0, 91.71),
  ('2003-03-23 08:44:54', '573486699', 0, 74.26),
  ('2003-05-12 17:56:37', '856116961', 0, 61.38),
  ('2003-07-24 15:50:56', '676699560', 0, 48.57),
  ('2003-11-10 16:05:19', '691272540', 0, 99.16),
  ('2004-03-05 15:05:04', '071234814', 0, 88.91),
  ('2004-04-02 12:43:01', '119217710', 0, 59.05),
  ('2004-06-25 08:20:26', '238903937', 0, 55.14),
  ('2005-11-08 20:57:31', '298479518', 0, 31.36),
  ('2006-01-10 12:17:30', '835135470', 0, 44.97),
  ('2006-02-25 10:49:38', '885181140', 0, 46.79),
  ('2006-05-02 15:34:35', '486267334', 0, 5.92),
  ('2006-07-23 12:55:47', '779135891', 0, 10.55),
  ('2006-12-06 16:40:29', '084771590', 0, 57.84),
  ('2007-04-17 13:38:37', '777375977', 0, 77.18),
  ('2007-06-06 16:09:01', '624615547', 0, 53.09),
  ('2007-08-03 10:55:02', '216263427', 0, 75.71),
  ('2007-11-29 15:43:46', '291274969', 0, 77.54),
  ('2008-01-02 14:22:56', '201029065', 0, 73.8),
  ('2008-01-14 17:26:40', '234594998', 0, 20.17),
  ('2008-07-09 09:24:03', '458822391', 0, 54.49),
  ('2008-07-13 12:18:44', '709916670', 0, 26.76),
  ('2008-08-09 20:19:19', '964622134', 0, 40.77),
  ('2008-08-29 15:15:23', '520665628', 0, 21.12),
  ('2008-11-16 08:10:47', '302879993', 0, 51.72),
  ('2008-12-27 18:22:32', '107525059', 0, 56.69),
  ('2008-12-30 11:38:30', '456073283', 0, 62.25),
  ('2009-02-02 10:49:33', '283528929', 0, 51.18),
  ('2009-02-27 18:57:00', '280500368', 0, 78.06),
  ('2009-05-21 14:58:20', '267197813', 0, 28.76),
  ('2009-05-22 17:49:10', '739707132', 0, 29.92),
  ('2009-06-20 13:26:45', '680640505', 0, 92.48),
  ('2009-08-21 15:29:15', '084701003', 0, 26.77),
  ('2009-09-06 13:07:15', '916062683', 0, 72.79),
  ('2009-11-17 10:03:06', '056231385', 0, 44.98),
  ('2009-12-08 15:41:17', '061299599', 0, 3.26),
  ('2009-12-25 17:56:07', '431199250', 0, 71.28),
  ('2010-02-05 16:19:11', '204463191', 0, 73.99),
  ('2010-07-16 14:41:10', '587993087', 0, 49.83),
  ('2010-08-17 18:07:27', '006400954', 0, 43.54),
  ('2010-11-17 14:03:32', '209669373', 0, 98.69),
  ('2011-02-25 12:50:15', '783460026', 0, 5.48),
  ('2012-07-26 14:27:20', '970998188', 0, 37.1),
  ('2012-08-25 08:05:01', '849866024', 0, 14.36),
  ('2012-10-11 12:11:56', '233875714', 0, 82.31),
  ('2013-03-09 11:42:11', '687381982', 0, 69.66),
  ('2013-09-10 16:17:12', '605369373', 0, 31.8),
  ('2013-11-02 08:05:58', '730544483', 0, 22.7),
  ('2013-12-15 13:08:49', '572971346', 0, 27.08),
  ('2014-02-13 16:23:05', '611383602', 0, 44.66),
  ('2014-04-29 11:03:21', '134889514', 0, 7.5),
  ('2014-07-12 08:09:19', '157926444', 0, 64.32),
  ('2014-08-05 16:29:57', '642819006', 0, 23.32),
  ('2014-10-23 08:05:47', '283609503', 0, 53.47),
  ('2015-01-15 20:17:40', '280198860', 0, 64.69),
  ('2015-05-15 20:03:12', '189831806', 0, 80.88),
  ('2015-06-06 17:25:44', '946876533', 0, 15.23),
  ('2015-11-03 09:53:06', '505107726', 0, 71.42),
  ('2015-12-11 18:39:13', '504940651', 0, 70.48),
  ('2016-02-06 16:45:18', '728508341', 0, 44.16),
  ('2016-02-20 18:52:40', '905524391', 0, 60.1),
  ('2016-04-16 14:33:06', '722345523', 0, 38.81),
  ('2016-08-23 18:21:04', '158283846', 0, 11.81),
  ('2016-08-24 12:36:08', '208925700', 0, 33.99),
  ('2016-08-27 09:56:28', '607726716', 0, 40.02),
  ('2016-09-11 13:32:45', '209905415', 0, 87.85),
  ('2016-09-12 16:57:35', '164296593', 0, 7.87),
  ('2016-12-24 10:39:34', '927263424', 0, 41.93),
  ('2017-01-06 20:20:29', '647157984', 0, 4.54),
  ('2017-02-10 13:40:38', '416156097', 0, 29.98),
  ('2017-03-15 14:42:36', '248101425', 0, 49.62),
  ('2017-03-28 20:14:35', '799580586', 0, 50.33),
  ('2017-05-31 18:17:42', '609446507', 0, 97.73),
  ('2017-07-12 10:56:00', '983834414', 0, 85.55),
  ('2017-09-15 19:35:40', '984651727', 0, 31.35),
  ('2018-01-13 16:28:20', '857669280', 0, 85.11),
  ('2018-01-19 19:10:56', '048370423', 0, 65.39),
  ('2018-10-06 09:42:24', '252905289', 0, 9.42),
  ('2019-04-24 11:47:29', '936204092', 0, 69.78),
  ('2019-06-12 12:03:32', '924515166', 0, 15.34),
  ('2019-12-10 18:58:03', '249377237', 0, 24.15),
  ('2020-01-01 08:05:47', '977715212', 63.03, 95.46),
  ('2020-01-01 12:26:32', '084771590', 57.84, 72.75),
  ('2020-01-02 19:19:01', '976797521', 9.91, 44.26),
  ('2020-01-02 19:38:17', '849866024', 14.36, 81.57),
  ('2020-01-04 11:29:27', '575755309', 36.75, 96.99),
  ('2020-01-04 19:45:22', '988989417', 42.26, 93.28),
  ('2020-01-07 11:16:01', '674568436', 40.02, 81.07),
  ('2020-01-07 20:25:58', '547878485', 80.23, 52.33),
  ('2020-01-10 17:45:02', '283609503', 53.47, 1.12),
  ('2020-01-10 19:06:18', '572971346', 27.08, 95.41),
  ('2020-01-11 10:45:56', '225584755', 91.71, 71.62),
  ('2020-01-11 15:24:18', '249377237', 24.15, 26.92),
  ('2020-01-11 18:51:27', '178191875', 21.12, 33.06),
  ('2020-01-13 12:04:45', '209669373', 98.69, 49.94),
  ('2020-01-13 19:42:17', '936204092', 69.78, 0.3),
  ('2020-01-14 16:34:58', '241611596', 67.95, 68.04),
  ('2020-01-14 18:07:45', '119217710', 59.05, 72.5),
  ('2020-01-15 10:37:10', '573486699', 74.26, 27.58),
  ('2020-01-15 14:17:17', '624615547', 53.09, 34.5),
  ('2020-01-16 08:02:19', '065361062', 4.25, 62.13),
  ('2020-01-16 20:19:00', '486267334', 5.92, 44.2),
  ('2020-01-19 11:10:55', '905524391', 60.1, 16.41),
  ('2020-01-19 18:13:28', '946876533', 15.23, 46.98),
  ('2020-01-19 20:09:23', '520665628', 21.12, 27.89),
  ('2020-01-21 09:11:52', '717651307', 77.01, 49.38),
  ('2020-01-22 12:04:07', '031118566', 52.01, 35.85),
  ('2020-01-23 11:31:44', '298479518', 31.36, 66.54),
  ('2020-01-23 13:44:37', '584616019', 81.79, 14.86),
  ('2020-01-24 11:42:15', '265730275', 56.97, 46.06),
  ('2020-01-25 11:48:11', '545322544', 23.14, 39.03),
  ('2020-01-25 17:10:09', '676699560', 48.57, 87.28),
  ('2020-01-25 17:40:10', '139375749', 27.46, 49.11),
  ('2020-01-26 13:25:00', '008392650', 75.63, 97.83),
  ('2020-01-26 17:07:00', '953679781', 80.96, 98.6),
  ('2020-01-26 20:32:47', '158283846', 11.81, 71.57),
  ('2020-01-27 09:33:25', '169165199', 78.6, 70.08),
  ('2020-01-27 11:39:24', '691272540', 99.16, 60.44),
  ('2020-01-27 15:52:58', '098764800', 70.39, 37.42),
  ('2020-01-28 12:52:40', '587993087', 49.83, 94.19),
  ('2020-01-28 14:09:08', '061299599', 3.26, 26.02),
  ('2020-01-28 14:22:02', '795120598', 38.69, 69.53),
  ('2020-01-29 15:03:10', '469226948', 54.71, 14.98),
  ('2020-01-29 15:31:27', '234594998', 20.17, 61.61),
  ('2020-01-29 19:44:47', '547919357', 30.86, 95.44),
  ('2020-01-30 18:20:42', '607726716', 40.02, 85.95),
  ('2020-01-30 19:39:19', '970998188', 37.1, 23.25),
  ('2020-02-02 11:58:15', '204463191', 73.99, 73.1),
  ('2020-02-02 14:31:12', '430301187', 67.95, 29.34),
  ('2020-02-02 16:39:45', '779846644', 70.21, 67.62),
  ('2020-02-03 14:17:22', '857669280', 85.11, 46.91),
  ('2020-02-05 08:45:14', '107525059', 56.69, 12.66),
  ('2020-02-05 14:26:29', '233875714', 82.31, 94.86),
  ('2020-02-06 13:57:01', '066790483', 99.08, 58.64),
  ('2020-02-06 14:38:47', '380985208', 85.58, 65.61),
  ('2020-02-07 13:27:42', '071234814', 88.91, 16.17),
  ('2020-02-09 13:34:45', '984651727', 31.35, 93.89),
  ('2020-02-09 16:19:26', '376561556', 84.84, 56.59),
  ('2020-02-10 12:22:37', '248101425', 49.62, 62.74),
  ('2020-02-10 14:36:07', '164296593', 7.87, 16.57),
  ('2020-02-10 17:58:46', '779135891', 10.55, 84.09),
  ('2020-02-13 13:49:41', '261424165', 62.55, 74.54),
  ('2020-02-13 18:58:18', '287157769', 25.09, 25.99),
  ('2020-02-15 10:21:26', '964622134', 40.77, 52.43),
  ('2020-02-15 19:20:35', '924515166', 15.34, 34.43),
  ('2020-02-17 09:53:27', '458822391', 54.49, 82.56),
  ('2020-02-18 08:22:58', '238903937', 55.14, 38.92),
  ('2020-02-18 12:37:03', '291274969', 77.54, 65.96),
  ('2020-02-18 17:07:31', '983834414', 85.55, 44.41),
  ('2020-02-20 13:05:11', '330085030', 17.8, 48.01),
  ('2020-02-20 18:09:49', '722345523', 38.81, 97.68),
  ('2020-02-22 08:40:52', '801818241', 13.37, 9.54),
  ('2020-02-22 10:17:32', '055493685', 13.62, 86.87),
  ('2020-02-23 17:02:32', '456073283', 62.25, 58.84),
  ('2020-02-25 09:28:55', '280500368', 78.06, 99.87),
  ('2020-02-26 08:10:03', '730544483', 22.7, 40.55),
  ('2020-02-26 18:43:27', '055134808', 53.81, 36.14),
  ('2020-02-28 08:26:39', '737214189', 1.62, 86.73),
  ('2020-02-28 20:38:09', '252905289', 9.42, 94.97),
  ('2020-02-29 11:03:22', '601419281', 93.18, 22.26),
  ('2020-02-29 13:21:15', '201029065', 73.8, 78.67),
  ('2020-02-29 15:23:06', '505107726', 71.42, 97.54),
  ('2020-03-01 11:46:11', '201213256', 45.21, 79.22),
  ('2020-03-01 17:07:23', '193066153', 9.83, 15.13),
  ('2020-03-04 11:04:04', '048370423', 65.39, 23.5),
  ('2020-03-04 17:53:57', '739707132', 29.92, 4),
  ('2020-03-06 19:54:32', '592102591', 71.36, 32.78),
  ('2020-03-07 15:58:34', '647157984', 4.54, 11.93),
  ('2020-03-08 14:10:09', '005666342', 52.81, 2.21),
  ('2020-03-09 17:22:52', '991628649', 96.04, 26.02),
  ('2020-03-11 09:18:56', '036904572', 30.21, 63.21),
  ('2020-03-11 11:19:06', '611383602', 44.66, 17.41),
  ('2020-03-11 13:44:18', '835135470', 44.97, 60.58),
  ('2020-03-11 18:57:11', '283528929', 51.18, 5.7),
  ('2020-03-12 11:50:13', '231882891', 87.55, 73.56),
  ('2020-03-12 18:21:19', '856116961', 61.38, 83.12),
  ('2020-03-12 20:40:46', '134889514', 7.5, 5.94),
  ('2020-03-13 11:41:19', '927263424', 41.93, 68.84),
  ('2020-03-13 20:23:12', '724144589', 26.55, 55.53),
  ('2020-03-15 12:10:10', '326305135', 28.82, 19.91),
  ('2020-03-15 17:08:17', '709916670', 26.76, 18.91),
  ('2020-03-16 10:14:37', '799580586', 50.33, 82.1),
  ('2020-03-17 16:34:46', '189831806', 80.88, 0.05),
  ('2020-03-18 13:21:06', '006400954', 43.54, 31.71),
  ('2020-03-18 15:33:26', '478349069', 73.42, 99.32),
  ('2020-03-19 18:01:53', '037639676', 46.4, 99.58),
  ('2020-03-20 16:32:38', '184362631', 38.84, 55.79),
  ('2020-03-21 10:25:01', '904725006', 35.92, 81.59),
  ('2020-03-21 13:22:40', '267197813', 28.76, 28.69),
  ('2020-03-21 16:52:44', '896531472', 15.73, 92.01),
  ('2020-03-22 15:31:48', '302879993', 51.72, 35.81),
  ('2020-03-23 09:02:08', '909338593', 77.22, 74.27),
  ('2020-03-23 10:36:07', '157926444', 64.32, 8.28),
  ('2020-03-24 18:13:50', '248487285', 52.87, 63.27),
  ('2020-03-25 08:16:06', '418223108', 63.19, 46.02),
  ('2020-03-25 15:31:31', '916062683', 72.79, 77.15),
  ('2020-03-26 15:11:04', '999980890', 73.89, 93.67),
  ('2020-03-26 15:35:30', '524035300', 15.97, 40.62),
  ('2020-03-27 12:28:36', '002652773', 46.4, 87.65),
  ('2020-03-27 17:46:22', '486459501', 25.47, 37.42),
  ('2020-03-27 19:44:13', '457169995', 55.11, 68.71),
  ('2020-03-28 08:06:55', '740577074', 13.58, 13.95),
  ('2020-03-28 08:24:16', '687381982', 69.66, 11.19),
  ('2020-03-28 10:02:12', '056231385', 44.98, 65.33),
  ('2020-03-28 11:07:15', '609446507', 97.73, 28.85),
  ('2020-03-30 08:16:00', '216263427', 75.71, 89.68),
  ('2020-03-31 15:38:58', '642819006', 23.32, 58.41),
  ('2020-03-31 20:00:34', '720640810', 34.67, 91.06),
  ('2020-04-01 15:52:18', '728508341', 44.16, 2.01),
  ('2020-04-02 08:55:25', '134474971', 54.02, 42.76),
  ('2020-04-02 20:11:20', '897949103', 27, 50.25),
  ('2020-04-04 15:03:18', '396539472', 48.04, 91.75),
  ('2020-04-06 09:12:46', '828927742', 43.4, 71.55),
  ('2020-04-08 20:55:40', '431199250', 71.28, 25.06),
  ('2020-04-11 20:45:03', '009996609', 14.2, 5.32),
  ('2020-04-12 11:51:06', '885181140', 46.79, 47.83),
  ('2020-04-15 16:06:40', '280198860', 64.69, 92.95),
  ('2020-04-15 20:07:53', '702632046', 7.74, 1.73),
  ('2020-04-16 15:26:09', '605369373', 31.8, 26.7),
  ('2020-04-20 18:26:26', '084701003', 26.77, 17.26),
  ('2020-04-21 08:37:22', '920057796', 2.84, 92.34),
  ('2020-04-21 16:37:12', '209905415', 87.85, 93.28),
  ('2020-04-23 08:52:09', '777375977', 77.18, 72.86),
  ('2020-04-23 13:18:49', '680640505', 92.48, 75.55),
  ('2020-04-24 10:39:06', '406270368', 3.58, 78.64),
  ('2020-04-24 13:50:39', '208925700', 33.99, 70.07),
  ('2020-04-25 14:20:57', '504940651', 70.48, 99.78),
  ('2020-04-26 10:40:02', '416156097', 29.98, 12.97),
  ('2020-04-26 17:19:50', '005499124', 96.54, 61.61),
  ('2020-04-28 15:30:49', '783460026', 5.48, 34.49),
  ('2020-04-28 16:51:39', '577556219', 11.3, 76.48);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `provides`
  --
  
  CREATE TABLE `provides` (
    `store_id` int(11) NOT NULL,
    `category_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `provides`
  --
  
  INSERT INTO `provides` (`store_id`, `category_id`) VALUES
  (1, 0),
  (1, 1),
  (1, 2),
  (1, 3),
  (1, 4),
  (1, 5),
  (6, 0),
  (6, 1),
  (6, 2),
  (6, 3),
  (6, 4),
  (6, 5),
  (7, 0),
  (7, 1),
  (7, 2),
  (7, 3),
  (7, 4),
  (7, 5),
  (8, 0),
  (8, 1),
  (8, 2),
  (8, 3),
  (8, 4),
  (8, 5),
  (12, 0),
  (12, 1),
  (12, 2),
  (12, 3),
  (12, 4),
  (12, 5),
  (13, 0),
  (13, 1),
  (13, 2),
  (13, 3),
  (13, 4),
  (13, 5),
  (15, 0),
  (15, 1),
  (15, 2),
  (15, 3),
  (15, 4),
  (15, 5),
  (16, 0),
  (16, 1),
  (16, 2),
  (16, 3),
  (16, 4),
  (16, 5),
  (17, 0),
  (17, 1),
  (17, 2),
  (17, 3),
  (17, 4),
  (17, 5),
  (19, 0),
  (19, 1),
  (19, 2),
  (19, 3),
  (19, 4),
  (19, 5),
  (20, 0),
  (20, 1),
  (20, 2),
  (20, 3),
  (20, 4),
  (20, 5),
  (22, 0),
  (22, 1),
  (22, 2),
  (22, 3),
  (22, 4),
  (22, 5),
  (23, 0),
  (23, 1),
  (23, 2),
  (23, 3),
  (23, 4),
  (23, 5),
  (24, 0),
  (24, 1),
  (24, 2),
  (24, 3),
  (24, 4),
  (24, 5),
  (26, 0),
  (26, 1),
  (26, 2),
  (26, 3),
  (26, 4),
  (26, 5);
  
  -- --------------------------------------------------------
  
  --
  -- Stand-in structure for view `sales`
  -- (See below for the actual view)
  --
  CREATE TABLE `sales` (
  `id` int(11)
  ,`name` varchar(45)
  ,`sales` bigint(21)
  );
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `supermarkets`
  --
  
  CREATE TABLE `supermarkets` (
    `id` int(11) NOT NULL,
    `square_meters` int(11) DEFAULT 0,
    `days_open` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'everyday',
    `times` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT '00:00-00:00',
    `street_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `street_number` smallint(6) DEFAULT NULL,
    `city` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `state` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `zipcode` int(6) DEFAULT NULL,
    `phone_number` bigint(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `supermarkets`
  --
  
  INSERT INTO `supermarkets` (`id`, `square_meters`, `days_open`, `times`, `street_name`, `street_number`, `city`, `state`, `zipcode`, `phone_number`) VALUES
  (1, 126, 'everyday', '8:00-20:00', 'Fuga non deleniti.', 57, 'Andreanestad', 'Maine', 92996, 1463139784),
  (6, 103, 'daily', '8:00-20:00', 'Cum ut quo odio.', 62, 'North Icie', 'Oklahoma', 87438, 1591426593),
  (7, 478, 'everyday', '8:00-20:00', 'Rerum magnam ab.', 47, 'East Maxiemouth', 'Minnesota', 89903, 1517754866),
  (8, 381, 'daily', '8:00-20:00', 'Akualo De Pringle', 90, 'Susiemouth', 'NewJersey', 15122, 2105426987),
  (12, 145, 'everyday', '8:00-20:00', 'Possum', 34, 'Sugarland', 'Austin', 15122, 21054639874),
  (13, 255, 'dailysaturday', '8:00-20:00', 'Sugarland', 198, 'Austin', 'Texas', 15122, 9653217484),
  (15, 23, 'dailysaturday', '8:00-20:00', 'Εθνικής Αντιστάσεως', 1234, 'Chalkida', 'Nea Artaki', 34600, 22213654866),
  (16, 457, 'dailyandsaturaday', '8:00-20:00', 'Animi repellat quia.', 10, 'Faheyton', 'Virginia', 36042, 1450925389),
  (17, 746, 'dailyandsaturaday', '8:00-20:00', 'Enim ad velit.', 66, 'Declanchester', 'Minnesota', 65404, 1681407848),
  (19, 440, 'daily', '8:00-20:00', 'Ut et quisquam.', 71, 'Swaniawskitown', 'NewMexico', 96854, 1028011930),
  (20, 107, 'everyday', '8:00-20:00', 'Ut ipsam hic quis.', 43, 'East Reidside', 'Hawaii', 61284, 1411349470),
  (22, 912, 'everyday', '8:00-20:00', 'Cumque similique.', 61, 'Cummingsside', 'Maine', 69764, 1920197315),
  (23, 245, 'daily', '8:00-20:00', 'oij ouk anak', 34, 'oij', 'akata', 11512, 23333),
  (24, 267, 'everyday', '8:00-20:00', 'Sapiente earum.', 10, 'Bradlytown', 'Oregon', 15667, 1903540356),
  (26, 520, 'everyday', '8:00-20:00', 'Non nam rem nam est.', 94, 'Lolitamouth', 'Idaho', 57779, 1734184449);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transcaction`
  --
  
  CREATE TABLE `transcaction` (
    `id` int(11) NOT NULL,
    `payment_method` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash',
    `card_id` int(11) DEFAULT NULL,
    `date` datetime DEFAULT NULL,
    `store_id` int(11) DEFAULT NULL,
    `total_price` float NOT NULL DEFAULT 0,
    `total_pieces` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `transcaction`
  --
  
  INSERT INTO `transcaction` (`id`, `payment_method`, `card_id`, `date`, `store_id`, `total_price`, `total_pieces`) VALUES
  (1, 'credit', 19, '2004-12-31 19:29:55', 12, 2055.2, 41),
  (2, 'debit', 11, '2003-12-09 14:21:55', 8, 898.9, 19),
  (3, 'debit', 38, '2008-05-31 16:40:58', 7, 1994.02, 43),
  (4, 'debit', 35, '2016-09-24 18:12:22', 23, 2130.76, 34),
  (5, 'credit', 38, '2011-05-30 09:24:47', 8, 3066.55, 34),
  (6, 'credit', 20, '2015-10-29 18:14:00', 8, 595.62, 12),
  (7, 'debit', 26, '2003-09-22 14:11:57', 19, 651.64, 13),
  (8, 'cash', 5, '2019-06-06 08:30:28', 23, 964.03, 20),
  (9, 'credit', 23, '2009-07-02 18:36:15', 1, 2307.29, 36),
  (10, 'cash', 23, '2014-04-23 13:20:20', 13, 1174.02, 23),
  (11, 'cash', 4, '1991-06-18 17:51:41', 12, 80.95, 13),
  (12, 'debit', 19, '1991-04-14 10:28:36', 26, 1950.31, 31),
  (13, 'cash', 11, '1990-12-23 13:43:49', 17, 1013.66, 25),
  (14, 'credit', 29, '2013-04-02 15:55:41', 6, 1084.46, 28),
  (15, 'cash', 5, '2014-02-20 08:27:11', 22, 1525.41, 22),
  (16, 'credit', 24, '2002-12-18 18:28:21', 23, 1706.48, 21),
  (17, 'credit', 4, '2016-11-09 09:37:26', 26, 897.93, 15),
  (18, 'debit', 39, '2002-11-02 11:50:30', 19, 1274.45, 22),
  (19, 'cash', 15, '2014-11-26 20:07:18', 12, 420.42, 6),
  (20, 'cash', 10, '2014-02-09 08:29:29', 1, 919.02, 15),
  (21, 'cash', 11, '1997-07-11 16:25:00', 13, 733.58, 14),
  (22, 'debit', 35, '2018-10-29 16:00:05', 22, 619.86, 11),
  (23, 'credit', 26, '2017-05-22 19:25:23', 17, 2567.28, 57),
  (24, 'credit', 40, '2006-01-19 18:05:08', 8, 464.18, 10),
  (25, 'cash', 30, '2017-10-13 11:37:52', 26, 550.5, 6),
  (26, 'credit', 26, '2013-03-13 19:22:46', 1, 611.37, 18),
  (27, 'cash', 30, '2002-09-08 09:41:23', 23, 938.8, 32),
  (28, 'cash', 3, '2008-07-02 15:22:17', 8, 402, 8),
  (29, 'debit', 39, '2005-12-01 18:26:46', 19, 1857.08, 25),
  (30, 'credit', 18, '2019-11-24 18:39:44', 1, 1545.45, 32),
  (31, 'cash', 2, '1993-06-15 16:47:13', 24, 1314.79, 25),
  (32, 'cash', 9, '2008-09-16 12:10:45', 8, 65.61, 1),
  (33, 'credit', 0, '1993-01-08 10:32:52', 16, 942.44, 11),
  (34, 'debit', 28, '2013-09-06 15:09:11', 24, 2625.17, 47),
  (35, 'credit', 11, '2003-09-16 14:49:18', 20, 86.05, 5),
  (36, 'debit', 8, '2006-09-17 08:35:50', 12, 1313.92, 26),
  (37, 'debit', 18, '2011-02-19 10:24:52', 8, 1349.28, 22),
  (38, 'credit', 38, '1995-01-24 16:51:20', 20, 1211.55, 23),
  (39, 'cash', 39, '1999-11-17 19:44:26', 13, 225.23, 5),
  (40, 'credit', 15, '2008-12-10 15:21:06', 15, 1436.24, 23),
  (41, 'credit', 5, '2015-10-11 14:29:10', 17, 1355.63, 35),
  (42, 'debit', 13, '2018-10-31 18:00:30', 7, 1191.33, 14),
  (43, 'cash', 13, '2002-09-26 19:11:10', 6, 1342.45, 28),
  (44, 'debit', 11, '2018-09-19 14:52:34', 23, 2869.72, 40),
  (45, 'credit', 40, '2002-08-08 19:56:11', 8, 729.45, 12),
  (46, 'debit', 0, '2007-03-20 16:22:12', 17, 656.3, 16),
  (47, 'cash', 24, '2017-02-25 13:26:16', 8, 156.12, 6),
  (48, 'credit', 7, '1997-05-16 14:40:16', 6, 2098.33, 30),
  (49, 'debit', 3, '2005-10-07 11:47:58', 24, 1449.42, 30),
  (50, 'debit', 26, '2020-01-09 14:48:40', 22, 69.45, 3),
  (51, 'credit', 4, '1997-05-07 13:32:24', 23, 1162.18, 21),
  (52, 'credit', 21, '2009-10-02 16:31:27', 16, 1025.72, 17),
  (53, 'credit', 39, '1990-04-01 13:38:44', 24, 857.3, 26),
  (54, 'debit', 16, '2007-12-09 08:33:27', 15, 1072.58, 13),
  (55, 'credit', 27, '2013-12-11 16:33:35', 17, 740.98, 10),
  (56, 'debit', 23, '2009-06-24 13:02:00', 20, 583.79, 13),
  (57, 'debit', 5, '2007-11-26 18:56:05', 13, 104.02, 7),
  (58, 'cash', 33, '2019-12-15 18:25:20', 20, 1574.47, 22),
  (59, 'debit', 0, '1999-11-16 09:39:10', 24, 755.36, 13),
  (60, 'cash', 18, '1999-07-05 09:37:15', 26, 2669, 37),
  (61, 'credit', 5, '2006-01-07 11:00:33', 13, 1474.18, 25),
  (62, 'credit', 3, '2007-07-15 10:28:00', 19, 1276.92, 21),
  (63, 'debit', 9, '2017-09-25 12:10:05', 22, 20.1, 10),
  (64, 'debit', 27, '2004-12-14 13:15:50', 23, 1754.33, 35),
  (65, 'debit', 17, '2016-05-25 15:48:28', 24, 512.36, 24),
  (66, 'debit', 25, '2003-10-21 11:19:46', 7, 761.7, 12),
  (67, 'cash', 1, '1996-09-11 20:07:03', 15, 899.09, 15),
  (68, 'credit', 38, '1999-06-17 18:40:57', 1, 561.28, 9),
  (69, 'debit', 2, '2012-05-05 12:10:22', 16, 302.07, 6),
  (70, 'debit', 14, '2011-02-11 10:13:41', 17, 494.68, 14),
  (71, 'credit', 17, '2013-07-11 16:01:43', 19, 1007.63, 12),
  (72, 'debit', 21, '2004-01-17 08:09:09', 12, 1713.1, 36),
  (73, 'credit', 11, '2019-01-11 19:03:31', 1, 1205.33, 20),
  (74, 'debit', 1, '1990-12-25 10:22:11', 13, 205.28, 13),
  (75, 'cash', 8, '2006-03-12 16:09:42', 23, 1199.91, 23),
  (76, 'cash', 0, '2006-01-10 20:46:17', 20, 1158.72, 33),
  (77, 'cash', 10, '2005-06-02 20:50:55', 6, 2624.98, 32),
  (78, 'credit', 28, '2011-10-15 13:24:38', 19, 1676.07, 18),
  (79, 'cash', 24, '1999-08-13 12:22:12', 13, 1751.47, 25),
  (80, 'credit', 5, '1995-01-22 13:40:40', 26, 626.23, 16),
  (81, 'cash', 40, '2009-07-26 12:23:31', 7, 838.11, 10),
  (82, 'credit', 25, '2018-03-19 09:15:03', 7, 93.96, 2),
  (83, 'debit', 5, '1991-06-02 20:39:52', 7, 3283.47, 49),
  (84, 'cash', 37, '2000-10-31 12:50:46', 6, 649.26, 10),
  (85, 'debit', 35, '1998-03-02 13:12:07', 20, 853.01, 15),
  (86, 'cash', 26, '1999-05-26 19:20:27', 6, 1851.18, 28),
  (87, 'cash', 19, '1997-09-22 13:11:54', 15, 220.68, 3),
  (88, 'credit', 4, '2006-12-08 17:50:55', 6, 1523.22, 29),
  (89, 'credit', 28, '2005-10-05 18:33:19', 16, 712.44, 17),
  (90, 'debit', 37, '1990-11-16 08:02:03', 24, 502.7, 8),
  (91, 'credit', 0, '1993-03-02 10:12:52', 20, 214.71, 3),
  (92, 'credit', 1, '2011-10-27 13:34:45', 1, 2945.3, 37),
  (93, 'credit', 13, '2009-05-21 19:30:42', 16, 417.32, 9),
  (94, 'cash', 31, '2005-08-18 13:34:25', 17, 5.32, 1),
  (95, 'debit', 10, '2000-03-02 13:02:44', 15, 119.45, 3),
  (96, 'cash', 40, '2019-09-06 08:48:00', 17, 1528.71, 38),
  (97, 'credit', 22, '2007-01-17 13:36:34', 8, 1246.26, 23),
  (98, 'cash', 37, '1999-09-02 18:09:49', 22, 702.68, 12),
  (99, 'cash', 20, '2008-09-23 11:02:11', 15, 1223.22, 19),
  (100, 'cash', 16, '1998-10-27 15:54:49', 7, 930.44, 14),
  (101, 'credit', 3, '2007-07-27 16:10:02', 8, 1880.31, 41),
  (102, 'debit', 15, '1992-05-24 10:22:44', 24, 262.44, 4),
  (103, 'cash', 14, '2018-04-19 11:13:21', 6, 65.94, 3),
  (104, 'cash', 38, '1990-06-08 08:28:43', 13, 1535.04, 22),
  (105, 'cash', 22, '1991-09-26 20:44:48', 26, 642.3, 16),
  (106, 'cash', 5, '1997-06-22 18:29:23', 8, 1471.07, 27),
  (107, 'cash', 30, '2014-05-13 11:56:50', 26, 429.3, 6),
  (108, 'cash', 31, '2006-11-30 19:50:34', 7, 577.68, 9),
  (109, 'debit', 15, '2015-12-28 19:36:39', 20, 1071.44, 19),
  (110, 'credit', 7, '1990-07-10 12:06:12', 7, 560.73, 12),
  (111, 'cash', 37, '2006-08-30 10:45:29', 8, 448.32, 8),
  (112, 'credit', 10, '1999-12-06 17:42:40', 26, 1072.27, 26),
  (113, 'credit', 36, '2016-04-18 09:53:13', 19, 905.02, 15),
  (114, 'debit', 18, '1992-10-08 18:34:16', 6, 692.82, 18),
  (115, 'debit', 11, '2013-03-09 16:34:44', 6, 1703.15, 28),
  (116, 'credit', 20, '2002-02-10 19:08:01', 7, 2903.54, 57),
  (117, 'credit', 9, '2008-04-25 20:33:13', 6, 462.26, 11),
  (118, 'cash', 1, '2006-09-05 08:08:54', 23, 2052.71, 25),
  (119, 'credit', 37, '2007-03-16 14:01:50', 22, 55.76, 12),
  (120, 'cash', 23, '1999-11-27 14:03:05', 26, 434.77, 13),
  (121, 'cash', 40, '2008-05-02 11:34:24', 23, 37.98, 3),
  (122, 'cash', 24, '2009-11-23 11:10:09', 8, 2248.49, 29),
  (123, 'debit', 33, '2010-07-11 09:45:13', 19, 1159.73, 16),
  (124, 'credit', 1, '2009-10-18 13:18:45', 16, 51.3, 9),
  (125, 'cash', 7, '2010-01-27 20:01:18', 13, 257.85, 3),
  (126, 'credit', 30, '2006-06-20 12:35:17', 1, 2269.44, 31),
  (127, 'credit', 37, '2013-10-06 20:32:56', 13, 1526.99, 27),
  (128, 'debit', 25, '2019-07-28 08:17:17', 19, 278.45, 7),
  (129, 'debit', 35, '2006-03-28 17:20:56', 13, 899.99, 12),
  (130, 'credit', 25, '2007-07-11 14:03:51', 7, 629.46, 22),
  (131, 'credit', 36, '2014-12-05 18:23:44', 24, 447.24, 6),
  (132, 'cash', 22, '2003-06-25 10:56:12', 7, 1926.52, 33),
  (133, 'debit', 31, '1996-07-16 10:37:33', 23, 921.67, 24),
  (134, 'debit', 15, '2007-07-22 15:10:26', 19, 64.7, 3),
  (135, 'cash', 28, '2019-06-09 18:32:07', 1, 2694.61, 37),
  (136, 'credit', 3, '1993-06-18 10:54:15', 7, 1393.82, 23),
  (137, 'debit', 34, '1999-06-12 13:57:54', 17, 2578.66, 43),
  (138, 'cash', 12, '2018-07-19 13:16:02', 7, 960.55, 17),
  (139, 'credit', 32, '2018-03-13 19:33:58', 22, 1357.24, 19),
  (140, 'cash', 31, '1996-08-27 08:03:31', 20, 795.76, 23),
  (141, 'credit', 20, '2013-06-26 13:49:52', 1, 658.99, 10),
  (142, 'credit', 10, '1997-09-07 19:19:40', 19, 705.28, 14),
  (143, 'cash', 17, '2004-06-18 09:12:15', 7, 1973.94, 29),
  (144, 'debit', 26, '2010-10-09 20:42:12', 12, 1338.4, 19),
  (145, 'cash', 34, '1995-02-10 10:33:21', 22, 684.31, 27),
  (146, 'debit', 29, '2009-10-27 18:17:10', 24, 263.32, 16),
  (147, 'credit', 34, '1999-07-29 13:36:27', 8, 1429.61, 22),
  (148, 'debit', 9, '2014-04-24 12:05:43', 23, 734.31, 9),
  (149, 'credit', 23, '2014-11-19 17:45:56', 16, 126.67, 7),
  (150, 'cash', 11, '2013-01-26 19:55:40', 17, 555.08, 18),
  (151, 'credit', 22, '2016-04-10 10:14:46', 19, 916.84, 11),
  (152, 'debit', 26, '2006-03-05 18:45:07', 20, 430.62, 7),
  (153, 'cash', 13, '1993-04-11 17:29:19', 17, 1374.97, 30),
  (154, 'cash', 21, '2013-05-24 19:29:53', 1, 2222.98, 28),
  (155, 'credit', 13, '2004-07-20 13:21:19', 16, 1026.9, 28),
  (156, 'cash', 39, '1992-08-30 13:05:41', 23, 113.19, 7),
  (157, 'credit', 8, '1995-11-21 15:14:33', 23, 387.41, 10),
  (158, 'debit', 13, '2008-04-04 12:44:30', 13, 1187.82, 24),
  (159, 'cash', 29, '2012-04-25 17:44:54', 1, 800.6, 28),
  (160, 'cash', 3, '2001-05-20 13:02:58', 12, 2587.09, 31),
  (161, 'debit', 11, '2000-02-16 16:25:25', 22, 932.22, 26),
  (162, 'cash', 15, '1990-03-23 18:13:00', 16, 2226, 34),
  (163, 'credit', 31, '1994-05-13 20:54:02', 16, 429.33, 16),
  (164, 'debit', 40, '2007-07-15 16:45:33', 17, 672.76, 11),
  (165, 'cash', 31, '1999-09-04 15:40:57', 22, 1258.06, 23),
  (166, 'debit', 17, '2019-05-07 19:15:04', 1, 768.45, 9),
  (167, 'credit', 19, '2017-07-03 12:32:19', 7, 1241.07, 22),
  (168, 'cash', 30, '1993-08-02 14:07:15', 16, 161.82, 6),
  (169, 'debit', 7, '1995-04-14 17:38:41', 22, 462.02, 16),
  (170, 'debit', 10, '1997-03-01 10:52:02', 15, 1199.5, 25),
  (171, 'cash', 25, '2018-09-30 13:34:42', 15, 369.22, 4),
  (172, 'credit', 38, '2013-01-14 08:35:51', 23, 1084.11, 17),
  (173, 'credit', 15, '2012-03-04 08:13:32', 12, 572.56, 8),
  (174, 'cash', 16, '1990-02-20 11:14:18', 12, 1079.46, 22),
  (175, 'debit', 31, '1999-10-03 08:54:08', 26, 1541.17, 32),
  (176, 'cash', 16, '1995-03-14 17:43:06', 13, 2454.19, 34),
  (177, 'credit', 20, '2016-03-19 11:02:34', 12, 433.05, 17),
  (178, 'debit', 27, '2016-06-28 19:09:50', 6, 1598.08, 23),
  (179, 'credit', 36, '1994-11-06 08:15:41', 23, 569.46, 9),
  (180, 'debit', 20, '1996-04-13 19:30:06', 6, 1342.25, 20),
  (181, 'debit', 6, '1995-12-03 11:09:05', 13, 1491.79, 25),
  (182, 'credit', 14, '2000-12-19 17:22:33', 15, 465.73, 10),
  (183, 'debit', 40, '2020-04-04 17:34:34', 13, 167.71, 4),
  (184, 'cash', 9, '2010-11-18 19:24:36', 12, 2255.12, 51),
  (185, 'debit', 39, '2019-12-22 17:25:01', 24, 1302.2, 29),
  (186, 'cash', 18, '2018-11-11 09:15:42', 7, 2282.36, 48),
  (187, 'cash', 10, '1996-02-13 15:25:28', 17, 1924.07, 26),
  (188, 'debit', 35, '2000-10-12 09:30:22', 7, 1431.3, 24),
  (189, 'cash', 2, '2011-07-27 12:36:28', 7, 1859.46, 39),
  (190, 'debit', 36, '2010-10-10 20:47:51', 7, 601.65, 7),
  (191, 'cash', 36, '1994-02-18 12:26:14', 20, 998.7, 10),
  (192, 'debit', 27, '2016-03-08 15:27:05', 7, 2109.53, 44),
  (193, 'cash', 35, '1995-09-24 19:53:15', 12, 1198.01, 13),
  (194, 'debit', 33, '2019-05-26 15:56:35', 8, 846.14, 21),
  (195, 'credit', 12, '1997-06-25 16:27:15', 7, 701.55, 17),
  (196, 'cash', 8, '1997-06-16 19:06:32', 12, 2970.76, 55),
  (197, 'debit', 29, '2019-10-20 14:17:50', 17, 1309.3, 22),
  (198, 'cash', 29, '1995-02-20 16:19:38', 13, 458.18, 22),
  (199, 'cash', 6, '2013-12-25 12:36:12', 6, 363.75, 5),
  (200, 'debit', 2, '2000-12-18 19:50:05', 24, 706.86, 15),
  (201, 'credit', 4, '2019-11-13 19:05:33', 8, 1648.96, 26),
  (202, 'debit', 4, '2007-10-20 18:10:52', 20, 598.86, 9),
  (203, 'debit', 27, '2011-02-06 08:00:32', 13, 534.55, 17),
  (204, 'debit', 22, '1997-05-04 12:38:21', 1, 1442.47, 28),
  (205, 'credit', 19, '2016-10-10 08:41:16', 17, 1504.03, 19),
  (206, 'debit', 13, '2010-11-28 20:42:39', 6, 1731.89, 28),
  (207, 'credit', 26, '1992-02-19 17:14:22', 20, 1378.37, 22),
  (208, 'debit', 23, '1992-11-27 13:03:26', 17, 87.54, 3),
  (209, 'cash', 19, '2004-11-18 08:55:39', 17, 1684.99, 23),
  (210, 'debit', 19, '1991-08-04 18:39:31', 15, 1389.09, 22),
  (211, 'debit', 38, '2016-01-01 16:57:30', 22, 745.06, 11),
  (212, 'credit', 25, '2004-07-10 13:04:48', 6, 243.56, 10),
  (213, 'debit', 23, '2010-05-21 08:42:37', 26, 1669.81, 23),
  (214, 'debit', 27, '1999-08-29 13:58:10', 24, 246.6, 16),
  (215, 'cash', 36, '1990-05-21 15:08:48', 15, 689.48, 15),
  (216, 'credit', 9, '1993-08-08 18:32:13', 16, 1581.14, 25),
  (217, 'debit', 28, '2013-02-06 20:28:45', 16, 894.04, 17),
  (218, 'debit', 26, '2007-09-02 08:58:40', 8, 951.89, 13),
  (219, 'credit', 40, '1991-03-11 16:45:36', 26, 185.01, 7),
  (220, 'cash', 39, '2002-11-14 14:52:29', 24, 230.7, 5),
  (221, 'credit', 21, '2010-05-12 12:56:46', 20, 736.25, 20),
  (222, 'credit', 31, '2000-11-10 18:27:49', 7, 477.65, 12),
  (223, 'credit', 10, '2005-11-29 17:00:47', 13, 1244.92, 16),
  (224, 'debit', 35, '1990-02-03 12:56:44', 20, 1348.54, 31),
  (225, 'debit', 10, '2009-04-27 17:55:38', 20, 741.9, 21),
  (226, 'cash', 0, '2017-07-25 17:28:27', 13, 736.86, 18),
  (227, 'credit', 29, '2002-04-18 19:41:12', 15, 1380.5, 16),
  (228, 'debit', 32, '1994-04-24 14:06:11', 20, 781.89, 22),
  (229, 'credit', 16, '1997-10-04 13:31:46', 16, 450.43, 11),
  (230, 'debit', 29, '2014-12-02 09:29:46', 16, 2289, 39),
  (231, 'credit', 20, '2008-08-19 15:27:42', 13, 658.47, 9),
  (232, 'credit', 24, '2004-10-29 09:38:32', 7, 2422.79, 39),
  (233, 'debit', 36, '2016-07-09 14:40:47', 15, 230.03, 12),
  (234, 'debit', 20, '2019-11-19 20:29:10', 6, 1010.81, 20),
  (235, 'cash', 35, '1997-05-28 16:54:48', 20, 399.69, 9),
  (236, 'debit', 32, '1997-08-25 15:18:22', 12, 1767.56, 31),
  (237, 'credit', 20, '2018-06-10 20:20:50', 22, 1112.11, 15),
  (238, 'debit', 4, '2007-04-17 19:10:16', 23, 726.28, 10),
  (239, 'credit', 37, '2015-12-14 08:06:08', 12, 1093, 14),
  (240, 'cash', 28, '2012-03-06 11:54:30', 16, 2004.24, 28),
  (241, 'cash', 8, '2003-05-13 14:15:26', 12, 1014.67, 21),
  (242, 'cash', 13, '2015-09-21 14:37:19', 26, 2637.34, 35),
  (243, 'cash', 24, '2010-01-24 10:05:45', 26, 1568.35, 28),
  (244, 'debit', 15, '2003-05-18 15:01:30', 15, 1664.18, 20),
  (245, 'cash', 40, '2005-09-07 08:10:09', 16, 14.86, 1),
  (246, 'cash', 5, '2020-05-13 16:08:26', 7, 443.76, 9),
  (247, 'debit', 13, '1995-07-02 13:27:42', 20, 3495.26, 37),
  (248, 'credit', 9, '1990-03-15 15:36:17', 23, 238.77, 11),
  (249, 'cash', 2, '2017-08-17 13:36:39', 1, 1353.61, 22),
  (250, 'credit', 11, '2014-05-03 08:43:48', 24, 424.83, 13),
  (251, 'debit', 5, '2013-05-27 08:23:19', 1, 1690.37, 25),
  (252, 'credit', 3, '2012-04-17 10:34:44', 17, 1528.34, 21),
  (253, 'debit', 25, '2018-12-30 13:07:29', 13, 235.02, 5),
  (254, 'debit', 28, '2014-05-10 09:15:23', 1, 453.3, 6),
  (255, 'cash', 27, '2019-06-07 15:03:05', 1, 934.72, 25),
  (256, 'credit', 10, '2014-02-04 11:38:01', 20, 1750.23, 30),
  (257, 'debit', 32, '2007-03-10 08:52:32', 6, 636.63, 14),
  (258, 'debit', 2, '2006-11-04 20:13:55', 26, 488.4, 5),
  (259, 'credit', 7, '2012-07-10 13:04:54', 6, 639.21, 20),
  (260, 'credit', 4, '2013-12-30 10:54:54', 19, 204.33, 16),
  (261, 'debit', 12, '2018-03-09 12:21:11', 13, 2345.36, 36),
  (262, 'credit', 9, '2010-12-25 12:57:00', 13, 481.88, 7),
  (263, 'cash', 4, '1999-11-16 20:20:16', 6, 209.25, 9),
  (264, 'credit', 1, '1995-07-08 17:58:31', 7, 377.63, 10),
  (265, 'debit', 1, '1997-01-21 17:57:35', 19, 945.91, 20),
  (266, 'cash', 21, '2017-11-30 09:12:14', 13, 316.04, 8),
  (267, 'credit', 17, '2001-11-22 18:48:53', 17, 946.82, 21),
  (268, 'debit', 18, '1994-03-11 14:42:54', 1, 364.12, 17),
  (269, 'credit', 15, '1994-07-21 19:21:16', 8, 1579.47, 34),
  (270, 'cash', 11, '1994-03-15 20:31:24', 13, 1203.76, 23),
  (271, 'cash', 9, '1993-02-28 15:17:45', 8, 770.82, 12),
  (272, 'credit', 23, '2014-05-28 19:22:45', 16, 62.1, 9),
  (273, 'credit', 35, '1999-04-30 11:43:39', 23, 979.03, 16),
  (274, 'cash', 38, '1991-01-02 20:51:09', 6, 1800.31, 22),
  (275, 'credit', 23, '2016-06-12 10:38:24', 12, 499.54, 7),
  (276, 'cash', 2, '2012-07-09 20:42:03', 13, 1301.8, 26),
  (277, 'credit', 3, '1996-01-04 20:39:41', 8, 1707, 36),
  (278, 'credit', 37, '2012-02-27 15:40:04', 8, 951.3, 19),
  (279, 'debit', 37, '1998-03-23 14:53:54', 26, 856.5, 22),
  (280, 'credit', 35, '2011-10-07 18:31:36', 12, 1379.04, 33),
  (281, 'credit', 31, '1996-08-19 12:38:29', 15, 1339.77, 18),
  (282, 'credit', 23, '1999-01-25 11:50:57', 20, 2672.92, 34),
  (283, 'cash', 14, '2019-12-01 17:31:24', 13, 1251.22, 23),
  (284, 'credit', 20, '2008-03-24 14:18:21', 19, 646.63, 16),
  (285, 'cash', 12, '1994-08-10 14:20:13', 6, 1508.9, 16),
  (286, 'debit', 16, '2020-02-14 14:12:29', 8, 1039.53, 18),
  (287, 'credit', 18, '2010-04-04 16:25:22', 6, 1347.37, 18),
  (288, 'credit', 9, '1997-01-29 09:48:11', 6, 2730.79, 38),
  (289, 'cash', 25, '2012-03-13 11:33:50', 6, 200.52, 6),
  (290, 'debit', 13, '1990-05-23 09:51:56', 24, 2874.09, 58),
  (291, 'debit', 25, '1992-05-26 12:42:25', 23, 1412.55, 17),
  (292, 'debit', 23, '2009-12-08 15:00:35', 22, 86.73, 1),
  (293, 'credit', 23, '2017-07-31 09:01:49', 23, 614.22, 12),
  (294, 'cash', 31, '2009-11-16 09:17:46', 26, 438.25, 5),
  (295, 'debit', 20, '1993-06-22 19:33:43', 24, 601.65, 7),
  (296, 'cash', 33, '1998-02-27 11:34:46', 22, 271.08, 6),
  (297, 'cash', 5, '1995-03-20 11:07:31', 7, 527.76, 9),
  (298, 'credit', 3, '2007-02-04 18:39:48', 23, 155.75, 5),
  (299, 'debit', 21, '2017-02-13 18:48:50', 8, 298.74, 3),
  (300, 'cash', 30, '1991-11-13 20:38:34', 17, 497.04, 8),
  (301, 'credit', 28, '2007-11-26 16:33:16', 6, 2562.3, 40),
  (302, 'debit', 23, '2004-08-06 14:23:02', 17, 1725.66, 23),
  (303, 'cash', 11, '2018-11-17 09:30:52', 17, 1339.06, 23),
  (304, 'cash', 20, '2003-06-30 20:24:24', 1, 1689.53, 26),
  (305, 'debit', 8, '1994-12-22 18:12:41', 17, 1341.17, 28),
  (306, 'cash', 31, '2007-11-26 08:28:21', 17, 1666.4, 32),
  (307, 'debit', 2, '1996-12-03 19:49:47', 8, 3167.02, 48),
  (308, 'cash', 4, '2020-04-18 08:44:02', 26, 1848.18, 34),
  (309, 'debit', 14, '2019-11-03 18:28:48', 19, 597.62, 18),
  (310, 'credit', 13, '2000-09-14 12:09:24', 23, 767.5, 19),
  (311, 'credit', 23, '1996-01-09 11:09:06', 24, 588.4, 10),
  (312, 'credit', 18, '1991-01-13 12:06:33', 6, 947.95, 19),
  (313, 'debit', 34, '2000-02-02 19:46:39', 8, 318.07, 11),
  (314, 'cash', 20, '2004-05-13 20:06:24', 13, 499.66, 6),
  (315, 'cash', 38, '2013-09-13 12:28:33', 20, 1864.44, 35),
  (316, 'cash', 34, '2019-08-26 15:20:16', 15, 839.1, 13),
  (317, 'cash', 12, '1997-04-14 15:33:31', 24, 697.48, 17),
  (318, 'debit', 34, '2015-03-23 12:08:13', 6, 399.88, 11),
  (319, 'cash', 38, '2001-01-16 09:31:35', 1, 303.09, 12),
  (320, 'cash', 11, '2007-07-12 08:42:18', 6, 1670.06, 25),
  (321, 'credit', 36, '1999-11-15 10:09:20', 13, 1540.23, 27),
  (322, 'credit', 27, '1998-06-29 18:37:34', 13, 527.68, 8),
  (323, 'debit', 11, '2001-11-24 11:31:51', 17, 2394.58, 42),
  (324, 'credit', 32, '2001-03-31 17:29:58', 20, 2257.91, 32),
  (325, 'cash', 12, '2001-09-02 16:53:34', 13, 868.28, 19),
  (326, 'debit', 15, '2011-01-16 09:47:28', 19, 93.82, 2),
  (327, 'cash', 31, '1994-05-05 20:51:13', 24, 177.6, 10),
  (328, 'cash', 22, '1996-12-04 08:57:11', 17, 404.24, 14),
  (329, 'debit', 25, '1991-04-06 19:14:58', 16, 894.09, 12),
  (330, 'credit', 7, '1996-06-09 16:01:01', 1, 668.94, 15),
  (331, 'debit', 28, '2015-07-10 12:19:07', 26, 949.64, 18),
  (332, 'cash', 31, '2018-11-10 10:19:03', 20, 1053.68, 13),
  (333, 'credit', 7, '1999-03-21 14:41:43', 23, 2170.91, 33),
  (334, 'debit', 35, '2001-05-05 13:26:42', 22, 735.69, 14),
  (335, 'debit', 13, '2018-09-05 08:41:38', 1, 17.68, 8),
  (336, 'debit', 27, '1995-10-04 16:02:05', 7, 785.11, 19),
  (337, 'credit', 7, '2003-02-05 18:42:29', 8, 973.3, 17),
  (338, 'cash', 8, '2000-08-31 19:28:01', 19, 545.65, 21),
  (339, 'cash', 5, '1995-07-24 15:20:21', 13, 1251.87, 14),
  (340, 'credit', 4, '2015-09-06 12:08:17', 12, 1222.5, 28),
  (341, 'credit', 24, '2017-01-20 09:39:32', 24, 1748.88, 35),
  (342, 'credit', 38, '2017-10-06 12:33:54', 1, 1535.04, 37),
  (343, 'debit', 40, '2005-12-18 16:25:27', 23, 1251.49, 25),
  (344, 'credit', 21, '2006-05-12 15:39:26', 16, 646.98, 16),
  (345, 'cash', 19, '1995-04-02 11:39:53', 16, 670.13, 17),
  (346, 'credit', 25, '1996-10-09 12:27:30', 17, 609.82, 8),
  (347, 'cash', 37, '2013-07-31 14:11:42', 7, 1189.19, 15),
  (348, 'credit', 19, '1999-09-27 19:24:45', 15, 2561.07, 39),
  (349, 'cash', 5, '2000-06-09 14:36:56', 19, 1848.91, 26),
  (350, 'credit', 23, '1993-02-16 10:51:53', 12, 1294.69, 22),
  (351, 'cash', 2, '2012-10-24 16:43:16', 20, 267.31, 8),
  (352, 'debit', 34, '2019-11-12 13:25:20', 15, 1002.28, 31),
  (353, 'debit', 10, '1994-11-06 10:44:58', 20, 1716.21, 26),
  (354, 'cash', 21, '1998-03-26 17:47:58', 6, 833.38, 24),
  (355, 'credit', 12, '1991-02-23 11:29:09', 24, 184.08, 4),
  (356, 'debit', 26, '2007-02-20 15:57:29', 26, 959.21, 11),
  (357, 'debit', 24, '2019-08-09 17:27:44', 15, 400.41, 18),
  (358, 'credit', 36, '2019-10-21 17:25:27', 20, 710.36, 16),
  (359, 'debit', 26, '2012-04-15 20:27:33', 24, 981.7, 15),
  (360, 'credit', 23, '1991-07-25 18:31:47', 19, 1109.4, 17),
  (361, 'debit', 0, '2006-07-21 17:37:44', 13, 1838.25, 25),
  (362, 'credit', 39, '1995-07-06 15:29:32', 20, 2272.33, 40),
  (363, 'cash', 3, '2018-01-10 17:26:07', 24, 1460.48, 19),
  (364, 'credit', 34, '2004-03-12 16:53:14', 24, 1015.04, 19),
  (365, 'credit', 7, '2015-07-05 16:00:17', 23, 1641.29, 27),
  (366, 'debit', 13, '1999-01-11 09:50:43', 7, 1456.51, 19),
  (367, 'debit', 33, '2016-07-01 14:05:55', 6, 2388.98, 36),
  (368, 'cash', 4, '2011-08-21 09:08:42', 19, 2063.73, 27),
  (369, 'cash', 16, '2018-07-31 10:58:57', 7, 1601.8, 19),
  (370, 'cash', 7, '2014-05-22 14:34:46', 6, 1360.39, 16),
  (371, 'debit', 19, '2001-01-28 08:48:07', 13, 457.72, 10),
  (372, 'credit', 3, '2013-08-18 18:31:43', 15, 216.56, 7),
  (373, 'credit', 9, '2001-10-08 17:13:28', 17, 1762.54, 25),
  (374, 'debit', 12, '2020-04-26 09:12:35', 23, 1182.57, 27),
  (375, 'debit', 14, '2001-07-05 10:26:43', 24, 1559.52, 26),
  (376, 'credit', 38, '2003-01-26 17:01:39', 13, 2369.82, 39),
  (377, 'debit', 6, '1995-11-14 08:50:41', 24, 158.44, 2),
  (378, 'credit', 0, '2008-05-23 10:07:41', 13, 1126.59, 14),
  (379, 'credit', 25, '2019-06-01 15:37:12', 1, 420.03, 17),
  (380, 'credit', 2, '1996-03-01 20:33:39', 23, 1200.68, 14),
  (381, 'credit', 10, '2020-04-25 13:37:30', 22, 1167.07, 35),
  (382, 'credit', 25, '2002-07-15 08:04:25', 24, 577.8, 20),
  (383, 'debit', 8, '1996-03-03 20:00:42', 26, 672.69, 11),
  (384, 'cash', 27, '1994-11-16 14:07:32', 23, 362.96, 11),
  (385, 'cash', 22, '1998-05-30 20:54:20', 22, 1574.94, 17),
  (386, 'cash', 1, '2000-04-20 15:09:28', 8, 3283.23, 42),
  (387, 'cash', 4, '1996-09-03 08:15:42', 16, 1323.83, 27),
  (388, 'debit', 22, '1992-09-29 16:00:46', 23, 131.92, 2),
  (389, 'debit', 18, '2011-10-09 11:29:51', 13, 1411.43, 21),
  (390, 'credit', 37, '2019-06-14 12:35:01', 16, 1368.83, 33),
  (391, 'credit', 8, '2000-04-21 08:56:28', 19, 189.1, 4),
  (392, 'credit', 34, '1995-12-17 11:46:08', 13, 1075.53, 14),
  (393, 'cash', 15, '2014-07-29 11:27:43', 17, 1098.67, 20),
  (394, 'debit', 9, '2002-03-02 10:20:09', 17, 997.43, 18),
  (395, 'cash', 33, '2015-04-23 13:14:13', 19, 1526.23, 32),
  (396, 'credit', 31, '2003-07-03 09:01:02', 13, 585.84, 8),
  (397, 'debit', 30, '1995-02-09 15:12:10', 15, 346.56, 12),
  (398, 'credit', 15, '2008-09-24 10:49:56', 20, 82.74, 3),
  (399, 'cash', 3, '1992-11-26 16:21:36', 6, 103.96, 4),
  (400, 'debit', 33, '2006-08-12 13:56:27', 6, 547.23, 12);
  
  --
  -- Triggers `transcaction`
  --
  DELIMITER $$
  CREATE TRIGGER `TotalPriceCheck` BEFORE UPDATE ON `transcaction` FOR EACH ROW IF NEW.total_price < 0 THEN
  SET NEW.total_price =0;
  END IF
  $$
  DELIMITER ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure for view `customer_details`
  --
  DROP TABLE IF EXISTS `customer_details`;
  
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `customer_details`  AS  select concat(`customer`.`first_name`,' ',`customer`.`last_name`) AS `name`,concat(`customer`.`street_name`,' ',`customer`.`street_number`,' ',`customer`.`city`,' ',`customer`.`state`,' ',`customer`.`zipcode`) AS `adrress`,`customer`.`birth_date` AS `birth_date`,`customer`.`married` AS `married`,`customer`.`children` AS `children`,`customer`.`pets` AS `pets` from `customer` order by `customer`.`birth_date` ;
  
  -- --------------------------------------------------------
  
  --
  -- Structure for view `sales`
  --
  DROP TABLE IF EXISTS `sales`;
  
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sales`  AS  select `s`.`id` AS `id`,`c`.`name` AS `name`,count(0) AS `sales` from ((((`contains` `tc` join `item` `i`) join `category` `c` on(`c`.`category_id` = `i`.`category_id` and `tc`.`barcode` = `i`.`Barcode`)) join `transcaction` `t`) join `supermarkets` `s`) where `t`.`store_id` = `s`.`id` and `tc`.`transcaction_id` = `t`.`id` group by `s`.`id`,`c`.`name` ;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `carries`
  --
  ALTER TABLE `carries`
    ADD PRIMARY KEY (`store_id`,`barcode`),
    ADD UNIQUE KEY `Unique` (`store_id`,`barcode`),
    ADD KEY `barcode_index` (`barcode`),
    ADD KEY `store_index` (`store_id`);
  
  --
  -- Indexes for table `category`
  --
  ALTER TABLE `category`
    ADD PRIMARY KEY (`category_id`),
    ADD UNIQUE KEY `catidx` (`category_id`);
  
  --
  -- Indexes for table `contains`
  --
  ALTER TABLE `contains`
    ADD PRIMARY KEY (`transcaction_id`,`barcode`),
    ADD UNIQUE KEY `Unique` (`transcaction_id`,`barcode`),
    ADD KEY `item_idx` (`barcode`);
  
  --
  -- Indexes for table `customer`
  --
  ALTER TABLE `customer`
    ADD PRIMARY KEY (`card_id`),
    ADD UNIQUE KEY `card_id_UNIQUE` (`card_id`);
  
  --
  -- Indexes for table `item`
  --
  ALTER TABLE `item`
    ADD PRIMARY KEY (`Barcode`),
    ADD UNIQUE KEY `Barcode_UNIQUE` (`Barcode`),
    ADD KEY `category_id_idx` (`category_id`);
  
  --
  -- Indexes for table `price_change`
  --
  ALTER TABLE `price_change`
    ADD PRIMARY KEY (`date`,`barcode`),
    ADD UNIQUE KEY `Unique` (`date`,`barcode`),
    ADD KEY `barcode_idx` (`barcode`);
  
  --
  -- Indexes for table `provides`
  --
  ALTER TABLE `provides`
    ADD PRIMARY KEY (`store_id`,`category_id`),
    ADD UNIQUE KEY `Unique` (`store_id`,`category_id`),
    ADD KEY `category_id_idx` (`category_id`);
  
  --
  -- Indexes for table `supermarkets`
  --
  ALTER TABLE `supermarkets`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `supermarket_id_UNIQUE` (`id`);
  
  --
  -- Indexes for table `transcaction`
  --
  ALTER TABLE `transcaction`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `transcaction_id_UNIQUE` (`id`),
    ADD KEY `customer_fk_idx` (`card_id`),
    ADD KEY `store_fk_idx` (`store_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `contains`
  --
  ALTER TABLE `contains`
    MODIFY `transcaction_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=401;
  
  --
  -- AUTO_INCREMENT for table `transcaction`
  --
  ALTER TABLE `transcaction`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=401;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `carries`
  --
  ALTER TABLE `carries`
    ADD CONSTRAINT `item` FOREIGN KEY (`barcode`) REFERENCES `item` (`Barcode`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `store` FOREIGN KEY (`store_id`) REFERENCES `supermarkets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `contains`
  --
  ALTER TABLE `contains`
    ADD CONSTRAINT `item_fk` FOREIGN KEY (`barcode`) REFERENCES `item` (`Barcode`) ON DELETE CASCADE,
    ADD CONSTRAINT `transcaction` FOREIGN KEY (`transcaction_id`) REFERENCES `transcaction` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `item`
  --
  ALTER TABLE `item`
    ADD CONSTRAINT `category` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ON DELETE SET NULL ON UPDATE SET NULL;
  
  --
  -- Constraints for table `price_change`
  --
  ALTER TABLE `price_change`
    ADD CONSTRAINT `barcode` FOREIGN KEY (`barcode`) REFERENCES `item` (`Barcode`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `provides`
  --
  ALTER TABLE `provides`
    ADD CONSTRAINT `category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `store_id` FOREIGN KEY (`store_id`) REFERENCES `supermarkets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `transcaction`
  --
  ALTER TABLE `transcaction`
    ADD CONSTRAINT `customer_fk` FOREIGN KEY (`card_id`) REFERENCES `customer` (`card_id`) ON DELETE SET NULL ON UPDATE SET NULL,
    ADD CONSTRAINT `store_fk` FOREIGN KEY (`store_id`) REFERENCES `supermarkets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  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 */;
  