eatlog.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Change password 'eatlog', OR if you see error message "Unknown system variable 'validate_password.policy'"
-- Try execute in mysql terminal:
-- for unix: install plugin validate_password soname 'validate_password.so';
-- for windows: install plugin validate_password soname 'validate_password.dll';
-- Info from https://stackoverflow.com/questions/55237257/mysql-validate-password-policy-unknown-system-variable
SET GLOBAL validate_password_policy=LOW;
SET GLOBAL validate_password_length=4;
DROP USER IF EXISTS `eatlog`@`%`;
CREATE USER `eatlog`@`%` IDENTIFIED WITH 'caching_sha2_password' by 'eatlog' REQUIRE NONE PASSWORD EXPIRE NEVER ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT;

GRANT USAGE ON *.* TO `eatlog`@`%`;
GRANT ALL PRIVILEGES ON `eatlog`.* TO `eatlog`@`%`;
GRANT ALL PRIVILEGES ON `eatlog_maxmind_city`.* TO `eatlog`@`%`;

FLUSH PRIVILEGES;

DROP DATABASE IF EXISTS `eatlog`;
CREATE DATABASE `eatlog` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci';

USE eatlog;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastauth_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_sub` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `google_picture_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `locale_segments` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'ru' COMMENT 'Example value: \'ru\' or \'en\' or \'en_US\' or others languages with/without country',
  `roles` json NULL,
  `geoname_id` int UNSIGNED NULL DEFAULT NULL,
  `is_banned` tinyint UNSIGNED NULL DEFAULT NULL,
  `banned_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `grade_eatlog` smallint UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `google_sub`(`google_sub` ASC) USING BTREE,
  INDEX `created_at`(`created_at` ASC) USING BTREE,
  INDEX `lastauth_at`(`lastauth_at` ASC) USING BTREE,
  INDEX `geoname_id`(`geoname_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES (1, '2023-04-01 12:00:00', '2025-01-17 18:03:35', 'body', '108555958097693113620', 'https://lh3.googleusercontent.com/a/ACg8ocJdCfgsq2fi0WkLOEY42EofGWfH3s7Ih-1kz8uzGpjmnauygEg=s96-c', 'ru', '[\"admin\", \"owner\"]', 2750405, NULL, NULL, 5);
INSERT INTO `account` VALUES (14, '2023-06-23 11:55:58', '2024-03-08 17:08:07', 'Владимир', '105346260561202878690', 'https://lh3.googleusercontent.com/a/ACg8ocKxEUE1pJ3um_jRH_E0hzaxuLt4WNgf0deQjH2BjuRx8Seg=s96-c', 'ru', NULL, 2750405, NULL, NULL, 5);
INSERT INTO `account` VALUES (15, '2023-11-25 16:23:26', '2023-11-25 16:23:26', 'Саид Кудбидинов', '110099714203060209487', 'https://lh3.googleusercontent.com/a/ACg8ocIPWEzPHlBtkjzNDajYV6jEHr-AVB1yFOkmOka5Wt7Qgg=s96-c', 'ru', NULL, 524901, NULL, NULL, NULL);
INSERT INTO `account` VALUES (16, '2024-10-06 18:53:36', '2024-10-06 18:53:36', 'Dmitry Novikov', '111460759223973712285', 'https://lh3.googleusercontent.com/a/ACg8ocIjxyVv4m90acphrz9NdX9EfNfdfJiKFmC1q1G7hhPrEzvAwFO4=s96-c', 'ru', NULL, 2017370, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for consumed
-- ----------------------------
DROP TABLE IF EXISTS `consumed`;
CREATE TABLE `consumed`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `gram` decimal(4, 0) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `consumed_product_product_id_fk`(`product_id` ASC) USING BTREE,
  INDEX `date`(`date` ASC) USING BTREE,
  CONSTRAINT `consumed_product_product_id_fk` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1881 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of consumed
-- ----------------------------
INSERT INTO `consumed` VALUES (1, '2023-04-04', 12, 290);
INSERT INTO `consumed` VALUES (2, '2023-04-04', 13, 150);
INSERT INTO `consumed` VALUES (3, '2023-04-04', 7, 300);
INSERT INTO `consumed` VALUES (4, '2023-04-04', 9, 200);
INSERT INTO `consumed` VALUES (5, '2023-04-04', 2, 245);
INSERT INTO `consumed` VALUES (6, '2023-04-04', 1, 100);
INSERT INTO `consumed` VALUES (7, '2023-04-05', 12, 290);
INSERT INTO `consumed` VALUES (8, '2023-04-05', 13, 150);
INSERT INTO `consumed` VALUES (9, '2023-04-05', 7, 150);
INSERT INTO `consumed` VALUES (10, '2023-04-05', 9, 200);
INSERT INTO `consumed` VALUES (11, '2023-04-05', 2, 245);
INSERT INTO `consumed` VALUES (12, '2023-04-05', 1, 100);
INSERT INTO `consumed` VALUES (13, '2023-04-06', 3, 200);
INSERT INTO `consumed` VALUES (14, '2023-04-06', 13, 150);
INSERT INTO `consumed` VALUES (15, '2023-04-06', 7, 150);
INSERT INTO `consumed` VALUES (16, '2023-04-06', 9, 200);
INSERT INTO `consumed` VALUES (17, '2023-04-06', 2, 245);
INSERT INTO `consumed` VALUES (18, '2023-04-06', 1, 200);
INSERT INTO `consumed` VALUES (19, '2023-04-06', 8, 180);
INSERT INTO `consumed` VALUES (21, '2023-04-07', 3, 200);
INSERT INTO `consumed` VALUES (22, '2023-04-07', 13, 300);
INSERT INTO `consumed` VALUES (23, '2023-04-07', 7, 150);
INSERT INTO `consumed` VALUES (24, '2023-04-07', 9, 200);
INSERT INTO `consumed` VALUES (25, '2023-04-07', 2, 245);
INSERT INTO `consumed` VALUES (26, '2023-04-07', 1, 200);
INSERT INTO `consumed` VALUES (27, '2023-04-07', 8, 180);
INSERT INTO `consumed` VALUES (28, '2023-04-07', 11, 195);
INSERT INTO `consumed` VALUES (29, '2023-04-08', 14, 265);
INSERT INTO `consumed` VALUES (30, '2023-04-08', 13, 150);
INSERT INTO `consumed` VALUES (31, '2023-04-08', 4, 200);
INSERT INTO `consumed` VALUES (32, '2023-04-08', 9, 200);
INSERT INTO `consumed` VALUES (33, '2023-04-08', 2, 245);
INSERT INTO `consumed` VALUES (34, '2023-04-08', 1, 200);
INSERT INTO `consumed` VALUES (35, '2023-04-08', 5, 180);
INSERT INTO `consumed` VALUES (36, '2023-04-08', 10, 130);
INSERT INTO `consumed` VALUES (37, '2023-04-09', 6, 155);
INSERT INTO `consumed` VALUES (38, '2023-04-09', 13, 300);
INSERT INTO `consumed` VALUES (39, '2023-04-09', 4, 200);
INSERT INTO `consumed` VALUES (40, '2023-04-09', 9, 200);
INSERT INTO `consumed` VALUES (41, '2023-04-09', 2, 245);
INSERT INTO `consumed` VALUES (42, '2023-04-09', 1, 200);
INSERT INTO `consumed` VALUES (43, '2023-04-09', 8, 180);
INSERT INTO `consumed` VALUES (44, '2023-04-10', 3, 200);
INSERT INTO `consumed` VALUES (45, '2023-04-10', 13, 150);
INSERT INTO `consumed` VALUES (46, '2023-04-10', 7, 150);
INSERT INTO `consumed` VALUES (47, '2023-04-10', 5, 180);
INSERT INTO `consumed` VALUES (48, '2023-04-10', 9, 200);
INSERT INTO `consumed` VALUES (49, '2023-04-10', 2, 245);
INSERT INTO `consumed` VALUES (50, '2023-04-10', 1, 200);
INSERT INTO `consumed` VALUES (51, '2023-04-10', 10, 130);
INSERT INTO `consumed` VALUES (52, '2023-04-11', 3, 200);
INSERT INTO `consumed` VALUES (53, '2023-04-11', 13, 150);
INSERT INTO `consumed` VALUES (54, '2023-04-11', 5, 180);
INSERT INTO `consumed` VALUES (55, '2023-04-11', 7, 150);
INSERT INTO `consumed` VALUES (56, '2023-04-11', 9, 200);
INSERT INTO `consumed` VALUES (57, '2023-04-11', 2, 245);
INSERT INTO `consumed` VALUES (58, '2023-04-11', 1, 200);
INSERT INTO `consumed` VALUES (59, '2023-04-11', 8, 180);
INSERT INTO `consumed` VALUES (60, '2023-04-12', 15, 220);
INSERT INTO `consumed` VALUES (61, '2023-04-12', 5, 180);
INSERT INTO `consumed` VALUES (62, '2023-04-12', 7, 150);
INSERT INTO `consumed` VALUES (63, '2023-04-12', 9, 200);
INSERT INTO `consumed` VALUES (64, '2023-04-12', 2, 245);
INSERT INTO `consumed` VALUES (65, '2023-04-12', 1, 200);
INSERT INTO `consumed` VALUES (66, '2023-04-12', 13, 150);
INSERT INTO `consumed` VALUES (67, '2023-04-13', 14, 265);
INSERT INTO `consumed` VALUES (68, '2023-04-13', 7, 150);
INSERT INTO `consumed` VALUES (69, '2023-04-13', 16, 200);
INSERT INTO `consumed` VALUES (70, '2023-04-13', 17, 220);
INSERT INTO `consumed` VALUES (72, '2023-04-13', 1, 200);
INSERT INTO `consumed` VALUES (73, '2023-04-14', 14, 265);
INSERT INTO `consumed` VALUES (74, '2023-04-14', 5, 180);
INSERT INTO `consumed` VALUES (75, '2023-04-14', 4, 200);
INSERT INTO `consumed` VALUES (76, '2023-04-14', 13, 300);
INSERT INTO `consumed` VALUES (77, '2023-04-14', 9, 200);
INSERT INTO `consumed` VALUES (78, '2023-04-14', 2, 245);
INSERT INTO `consumed` VALUES (80, '2023-04-14', 1, 200);
INSERT INTO `consumed` VALUES (81, '2023-04-15', 14, 265);
INSERT INTO `consumed` VALUES (86, '2023-04-15', 17, 220);
INSERT INTO `consumed` VALUES (87, '2023-04-15', 7, 150);
INSERT INTO `consumed` VALUES (88, '2023-04-15', 9, 200);
INSERT INTO `consumed` VALUES (97, '2023-04-15', 2, 245);
INSERT INTO `consumed` VALUES (98, '2023-04-15', 1, 200);
INSERT INTO `consumed` VALUES (112, '2023-04-16', 24, 200);
INSERT INTO `consumed` VALUES (113, '2023-04-16', 7, 150);
INSERT INTO `consumed` VALUES (114, '2023-04-16', 5, 180);
INSERT INTO `consumed` VALUES (115, '2023-04-16', 17, 220);
INSERT INTO `consumed` VALUES (119, '2023-04-16', 2, 245);
INSERT INTO `consumed` VALUES (120, '2023-04-16', 1, 200);
INSERT INTO `consumed` VALUES (145, '2023-04-16', 13, 300);
INSERT INTO `consumed` VALUES (219, '2023-04-17', 14, 265);
INSERT INTO `consumed` VALUES (232, '2023-04-17', 7, 150);
INSERT INTO `consumed` VALUES (233, '2023-04-17', 17, 220);
INSERT INTO `consumed` VALUES (234, '2023-04-17', 9, 200);
INSERT INTO `consumed` VALUES (235, '2023-04-17', 2, 245);
INSERT INTO `consumed` VALUES (236, '2023-04-17', 13, 150);
INSERT INTO `consumed` VALUES (237, '2023-04-17', 1, 200);
INSERT INTO `consumed` VALUES (238, '2023-04-18', 24, 200);
INSERT INTO `consumed` VALUES (240, '2023-04-18', 4, 200);
INSERT INTO `consumed` VALUES (241, '2023-04-18', 5, 180);
INSERT INTO `consumed` VALUES (242, '2023-04-18', 16, 200);
INSERT INTO `consumed` VALUES (244, '2023-04-18', 13, 300);
INSERT INTO `consumed` VALUES (245, '2023-04-18', 1, 200);
INSERT INTO `consumed` VALUES (246, '2023-04-18', 2, 245);
INSERT INTO `consumed` VALUES (247, '2023-04-19', 14, 265);
INSERT INTO `consumed` VALUES (248, '2023-04-19', 8, 180);
INSERT INTO `consumed` VALUES (249, '2023-04-19', 25, 150);
INSERT INTO `consumed` VALUES (250, '2023-04-19', 13, 300);
INSERT INTO `consumed` VALUES (251, '2023-04-19', 16, 200);
INSERT INTO `consumed` VALUES (253, '2023-04-19', 1, 200);
INSERT INTO `consumed` VALUES (254, '2023-04-19', 26, 200);
INSERT INTO `consumed` VALUES (255, '2023-04-20', 6, 155);
INSERT INTO `consumed` VALUES (256, '2023-04-20', 5, 180);
INSERT INTO `consumed` VALUES (257, '2023-04-20', 25, 150);
INSERT INTO `consumed` VALUES (258, '2023-04-20', 16, 200);
INSERT INTO `consumed` VALUES (259, '2023-04-20', 26, 200);
INSERT INTO `consumed` VALUES (260, '2023-04-20', 1, 200);
INSERT INTO `consumed` VALUES (261, '2023-04-20', 10, 130);
INSERT INTO `consumed` VALUES (262, '2023-04-21', 24, 200);
INSERT INTO `consumed` VALUES (263, '2023-04-21', 27, 270);
INSERT INTO `consumed` VALUES (264, '2023-04-21', 25, 150);
INSERT INTO `consumed` VALUES (265, '2023-04-21', 13, 300);
INSERT INTO `consumed` VALUES (266, '2023-04-21', 9, 200);
INSERT INTO `consumed` VALUES (268, '2023-04-21', 1, 200);
INSERT INTO `consumed` VALUES (269, '2023-04-21', 8, 180);
INSERT INTO `consumed` VALUES (270, '2023-04-21', 26, 200);
INSERT INTO `consumed` VALUES (271, '2023-04-22', 14, 265);
INSERT INTO `consumed` VALUES (272, '2023-04-22', 5, 180);
INSERT INTO `consumed` VALUES (273, '2023-04-22', 4, 200);
INSERT INTO `consumed` VALUES (275, '2023-04-22', 16, 200);
INSERT INTO `consumed` VALUES (276, '2023-04-22', 26, 200);
INSERT INTO `consumed` VALUES (277, '2023-04-22', 1, 200);
INSERT INTO `consumed` VALUES (278, '2023-04-22', 10, 130);
INSERT INTO `consumed` VALUES (279, '2023-04-23', 24, 200);
INSERT INTO `consumed` VALUES (280, '2023-04-23', 27, 270);
INSERT INTO `consumed` VALUES (281, '2023-04-23', 4, 200);
INSERT INTO `consumed` VALUES (282, '2023-04-23', 28, 220);
INSERT INTO `consumed` VALUES (284, '2023-04-24', 6, 155);
INSERT INTO `consumed` VALUES (285, '2023-04-24', 5, 180);
INSERT INTO `consumed` VALUES (286, '2023-04-24', 25, 150);
INSERT INTO `consumed` VALUES (287, '2023-04-24', 13, 150);
INSERT INTO `consumed` VALUES (288, '2023-04-24', 16, 200);
INSERT INTO `consumed` VALUES (289, '2023-04-24', 26, 200);
INSERT INTO `consumed` VALUES (290, '2023-04-24', 1, 200);
INSERT INTO `consumed` VALUES (291, '2023-04-25', 14, 265);
INSERT INTO `consumed` VALUES (292, '2023-04-25', 25, 150);
INSERT INTO `consumed` VALUES (293, '2023-04-25', 27, 540);
INSERT INTO `consumed` VALUES (294, '2023-04-25', 11, 195);
INSERT INTO `consumed` VALUES (295, '2023-04-25', 26, 200);
INSERT INTO `consumed` VALUES (296, '2023-04-26', 24, 200);
INSERT INTO `consumed` VALUES (297, '2023-04-26', 29, 200);
INSERT INTO `consumed` VALUES (298, '2023-04-26', 5, 180);
INSERT INTO `consumed` VALUES (299, '2023-04-26', 16, 200);
INSERT INTO `consumed` VALUES (300, '2023-04-26', 26, 200);
INSERT INTO `consumed` VALUES (301, '2023-04-26', 1, 200);
INSERT INTO `consumed` VALUES (302, '2023-04-26', 8, 180);
INSERT INTO `consumed` VALUES (303, '2023-04-27', 24, 200);
INSERT INTO `consumed` VALUES (304, '2023-04-27', 26, 200);
INSERT INTO `consumed` VALUES (305, '2023-04-27', 29, 200);
INSERT INTO `consumed` VALUES (306, '2023-04-27', 1, 200);
INSERT INTO `consumed` VALUES (307, '2023-04-27', 13, 300);
INSERT INTO `consumed` VALUES (308, '2023-04-27', 27, 540);
INSERT INTO `consumed` VALUES (309, '2023-04-28', 24, 200);
INSERT INTO `consumed` VALUES (310, '2023-04-28', 8, 180);
INSERT INTO `consumed` VALUES (311, '2023-04-28', 25, 150);
INSERT INTO `consumed` VALUES (312, '2023-04-28', 1, 200);
INSERT INTO `consumed` VALUES (313, '2023-04-28', 13, 300);
INSERT INTO `consumed` VALUES (314, '2023-04-28', 26, 200);
INSERT INTO `consumed` VALUES (315, '2023-04-29', 12, 290);
INSERT INTO `consumed` VALUES (316, '2023-04-29', 29, 200);
INSERT INTO `consumed` VALUES (317, '2023-04-29', 8, 180);
INSERT INTO `consumed` VALUES (318, '2023-04-29', 30, 200);
INSERT INTO `consumed` VALUES (319, '2023-04-30', 12, 290);
INSERT INTO `consumed` VALUES (320, '2023-04-30', 45, 330);
INSERT INTO `consumed` VALUES (321, '2023-04-30', 4, 200);
INSERT INTO `consumed` VALUES (322, '2023-04-30', 8, 180);
INSERT INTO `consumed` VALUES (323, '2023-04-30', 1, 200);
INSERT INTO `consumed` VALUES (325, '2023-04-30', 26, 200);
INSERT INTO `consumed` VALUES (326, '2023-05-01', 46, 327);
INSERT INTO `consumed` VALUES (327, '2023-05-01', 47, 200);
INSERT INTO `consumed` VALUES (328, '2023-05-01', 49, 390);
INSERT INTO `consumed` VALUES (329, '2023-05-01', 50, 236);
INSERT INTO `consumed` VALUES (330, '2023-05-01', 48, 300);
INSERT INTO `consumed` VALUES (331, '2023-05-01', 8, 180);
INSERT INTO `consumed` VALUES (332, '2023-05-01', 1, 200);
INSERT INTO `consumed` VALUES (334, '2023-05-02', 24, 200);
INSERT INTO `consumed` VALUES (335, '2023-05-02', 5, 180);
INSERT INTO `consumed` VALUES (336, '2023-05-02', 47, 200);
INSERT INTO `consumed` VALUES (337, '2023-05-02', 30, 200);
INSERT INTO `consumed` VALUES (338, '2023-05-02', 26, 200);
INSERT INTO `consumed` VALUES (339, '2023-05-02', 1, 200);
INSERT INTO `consumed` VALUES (340, '2023-05-03', 14, 265);
INSERT INTO `consumed` VALUES (341, '2023-05-03', 51, 25);
INSERT INTO `consumed` VALUES (342, '2023-05-03', 16, 200);
INSERT INTO `consumed` VALUES (343, '2023-05-03', 25, 150);
INSERT INTO `consumed` VALUES (344, '2023-05-03', 27, 270);
INSERT INTO `consumed` VALUES (345, '2023-05-03', 26, 200);
INSERT INTO `consumed` VALUES (346, '2023-05-03', 1, 200);
INSERT INTO `consumed` VALUES (347, '2023-05-04', 24, 200);
INSERT INTO `consumed` VALUES (348, '2023-05-04', 51, 25);
INSERT INTO `consumed` VALUES (349, '2023-05-04', 5, 180);
INSERT INTO `consumed` VALUES (350, '2023-05-04', 25, 150);
INSERT INTO `consumed` VALUES (351, '2023-05-04', 26, 200);
INSERT INTO `consumed` VALUES (352, '2023-05-04', 1, 200);
INSERT INTO `consumed` VALUES (353, '2023-05-05', 12, 290);
INSERT INTO `consumed` VALUES (354, '2023-05-04', 52, 200);
INSERT INTO `consumed` VALUES (355, '2023-05-03', 52, 200);
INSERT INTO `consumed` VALUES (356, '2023-05-02', 52, 100);
INSERT INTO `consumed` VALUES (357, '2023-05-05', 51, 50);
INSERT INTO `consumed` VALUES (358, '2023-05-05', 29, 200);
INSERT INTO `consumed` VALUES (359, '2023-05-05', 27, 540);
INSERT INTO `consumed` VALUES (360, '2023-05-05', 26, 200);
INSERT INTO `consumed` VALUES (361, '2023-05-05', 1, 200);
INSERT INTO `consumed` VALUES (362, '2023-05-05', 13, 150);
INSERT INTO `consumed` VALUES (394, '2023-06-23', 260, 180);
INSERT INTO `consumed` VALUES (395, '2023-06-25', 12, 290);
INSERT INTO `consumed` VALUES (396, '2023-06-25', 5, 540);
INSERT INTO `consumed` VALUES (397, '2023-06-25', 29, 200);
INSERT INTO `consumed` VALUES (398, '2023-06-25', 1, 200);
INSERT INTO `consumed` VALUES (399, '2023-06-25', 27, 540);
INSERT INTO `consumed` VALUES (400, '2023-06-25', 52, 200);
INSERT INTO `consumed` VALUES (401, '2023-06-26', 14, 265);
INSERT INTO `consumed` VALUES (402, '2023-06-26', 261, 290);
INSERT INTO `consumed` VALUES (403, '2023-06-26', 29, 200);
INSERT INTO `consumed` VALUES (404, '2023-06-26', 5, 180);
INSERT INTO `consumed` VALUES (405, '2023-06-26', 13, 450);
INSERT INTO `consumed` VALUES (406, '2023-04-13', 26, 200);
INSERT INTO `consumed` VALUES (407, '2023-06-27', 14, 265);
INSERT INTO `consumed` VALUES (408, '2023-06-27', 5, 180);
INSERT INTO `consumed` VALUES (409, '2023-06-27', 29, 200);
INSERT INTO `consumed` VALUES (410, '2023-06-27', 27, 540);
INSERT INTO `consumed` VALUES (411, '2023-06-27', 1, 200);
INSERT INTO `consumed` VALUES (412, '2023-06-28', 12, 290);
INSERT INTO `consumed` VALUES (413, '2023-06-28', 5, 360);
INSERT INTO `consumed` VALUES (414, '2023-06-28', 29, 200);
INSERT INTO `consumed` VALUES (415, '2023-06-28', 9, 200);
INSERT INTO `consumed` VALUES (416, '2023-06-28', 8, 180);
INSERT INTO `consumed` VALUES (417, '2023-06-28', 1, 200);
INSERT INTO `consumed` VALUES (418, '2023-06-29', 14, 265);
INSERT INTO `consumed` VALUES (419, '2023-06-29', 13, 300);
INSERT INTO `consumed` VALUES (420, '2023-06-29', 29, 200);
INSERT INTO `consumed` VALUES (421, '2023-06-29', 5, 180);
INSERT INTO `consumed` VALUES (422, '2023-06-29', 27, 270);
INSERT INTO `consumed` VALUES (423, '2023-06-29', 26, 200);
INSERT INTO `consumed` VALUES (424, '2023-06-29', 1, 200);
INSERT INTO `consumed` VALUES (425, '2023-06-29', 8, 180);
INSERT INTO `consumed` VALUES (426, '2023-06-30', 14, 265);
INSERT INTO `consumed` VALUES (427, '2023-06-30', 29, 200);
INSERT INTO `consumed` VALUES (428, '2023-06-30', 27, 270);
INSERT INTO `consumed` VALUES (429, '2023-06-30', 5, 180);
INSERT INTO `consumed` VALUES (430, '2023-06-30', 13, 300);
INSERT INTO `consumed` VALUES (431, '2023-06-30', 26, 200);
INSERT INTO `consumed` VALUES (432, '2023-06-30', 1, 200);
INSERT INTO `consumed` VALUES (433, '2023-07-01', 14, 265);
INSERT INTO `consumed` VALUES (434, '2023-07-01', 5, 180);
INSERT INTO `consumed` VALUES (435, '2023-07-01', 29, 200);
INSERT INTO `consumed` VALUES (436, '2023-07-01', 27, 270);
INSERT INTO `consumed` VALUES (437, '2023-07-01', 13, 450);
INSERT INTO `consumed` VALUES (438, '2023-07-01', 1, 200);
INSERT INTO `consumed` VALUES (439, '2023-07-01', 8, 180);
INSERT INTO `consumed` VALUES (440, '2023-07-02', 14, 265);
INSERT INTO `consumed` VALUES (441, '2023-07-02', 29, 200);
INSERT INTO `consumed` VALUES (442, '2023-07-02', 27, 270);
INSERT INTO `consumed` VALUES (443, '2023-07-02', 8, 360);
INSERT INTO `consumed` VALUES (444, '2023-07-02', 13, 450);
INSERT INTO `consumed` VALUES (445, '2023-07-02', 1, 200);
INSERT INTO `consumed` VALUES (446, '2023-07-03', 12, 290);
INSERT INTO `consumed` VALUES (447, '2023-07-03', 52, 400);
INSERT INTO `consumed` VALUES (448, '2023-07-03', 29, 200);
INSERT INTO `consumed` VALUES (449, '2023-07-03', 27, 270);
INSERT INTO `consumed` VALUES (450, '2023-07-03', 8, 360);
INSERT INTO `consumed` VALUES (451, '2023-07-03', 1, 200);
INSERT INTO `consumed` VALUES (452, '2023-07-04', 14, 265);
INSERT INTO `consumed` VALUES (453, '2023-07-04', 262, 190);
INSERT INTO `consumed` VALUES (454, '2023-07-04', 29, 200);
INSERT INTO `consumed` VALUES (455, '2023-07-04', 13, 300);
INSERT INTO `consumed` VALUES (457, '2023-07-04', 1, 200);
INSERT INTO `consumed` VALUES (458, '2023-07-04', 26, 200);
INSERT INTO `consumed` VALUES (459, '2023-07-04', 52, 100);
INSERT INTO `consumed` VALUES (460, '2023-07-05', 14, 265);
INSERT INTO `consumed` VALUES (461, '2023-07-05', 29, 200);
INSERT INTO `consumed` VALUES (462, '2023-07-05', 262, 190);
INSERT INTO `consumed` VALUES (463, '2023-07-05', 52, 300);
INSERT INTO `consumed` VALUES (464, '2023-07-05', 27, 270);
INSERT INTO `consumed` VALUES (465, '2023-07-05', 1, 200);
INSERT INTO `consumed` VALUES (466, '2023-07-05', 26, 200);
INSERT INTO `consumed` VALUES (467, '2023-07-06', 14, 265);
INSERT INTO `consumed` VALUES (468, '2023-07-06', 29, 200);
INSERT INTO `consumed` VALUES (469, '2023-07-06', 262, 190);
INSERT INTO `consumed` VALUES (470, '2023-07-06', 26, 200);
INSERT INTO `consumed` VALUES (471, '2023-07-06', 1, 200);
INSERT INTO `consumed` VALUES (472, '2023-07-06', 13, 300);
INSERT INTO `consumed` VALUES (473, '2023-07-07', 14, 265);
INSERT INTO `consumed` VALUES (474, '2023-07-07', 29, 200);
INSERT INTO `consumed` VALUES (475, '2023-07-07', 27, 270);
INSERT INTO `consumed` VALUES (476, '2023-07-07', 262, 190);
INSERT INTO `consumed` VALUES (477, '2023-07-07', 13, 450);
INSERT INTO `consumed` VALUES (478, '2023-07-07', 26, 200);
INSERT INTO `consumed` VALUES (479, '2023-07-07', 1, 200);
INSERT INTO `consumed` VALUES (480, '2023-07-08', 12, 290);
INSERT INTO `consumed` VALUES (481, '2023-07-08', 29, 200);
INSERT INTO `consumed` VALUES (482, '2023-07-08', 262, 190);
INSERT INTO `consumed` VALUES (483, '2023-07-08', 27, 270);
INSERT INTO `consumed` VALUES (484, '2023-07-08', 8, 180);
INSERT INTO `consumed` VALUES (485, '2023-07-08', 1, 200);
INSERT INTO `consumed` VALUES (486, '2023-07-09', 12, 290);
INSERT INTO `consumed` VALUES (487, '2023-07-08', 52, 300);
INSERT INTO `consumed` VALUES (488, '2023-07-09', 29, 200);
INSERT INTO `consumed` VALUES (489, '2023-07-09', 27, 270);
INSERT INTO `consumed` VALUES (491, '2023-07-09', 1, 200);
INSERT INTO `consumed` VALUES (492, '2023-07-09', 13, 150);
INSERT INTO `consumed` VALUES (493, '2023-07-09', 26, 200);
INSERT INTO `consumed` VALUES (495, '2023-07-10', 12, 290);
INSERT INTO `consumed` VALUES (497, '2023-07-10', 29, 200);
INSERT INTO `consumed` VALUES (498, '2023-07-10', 262, 190);
INSERT INTO `consumed` VALUES (499, '2023-07-10', 27, 270);
INSERT INTO `consumed` VALUES (500, '2023-07-10', 8, 180);
INSERT INTO `consumed` VALUES (501, '2023-07-10', 1, 200);
INSERT INTO `consumed` VALUES (502, '2023-07-10', 13, 300);
INSERT INTO `consumed` VALUES (503, '2023-07-10', 52, 100);
INSERT INTO `consumed` VALUES (504, '2023-07-11', 14, 265);
INSERT INTO `consumed` VALUES (505, '2023-07-11', 29, 200);
INSERT INTO `consumed` VALUES (506, '2023-07-11', 27, 270);
INSERT INTO `consumed` VALUES (507, '2023-07-11', 5, 180);
INSERT INTO `consumed` VALUES (508, '2023-07-11', 262, 190);
INSERT INTO `consumed` VALUES (509, '2023-07-11', 26, 200);
INSERT INTO `consumed` VALUES (510, '2023-07-11', 13, 450);
INSERT INTO `consumed` VALUES (511, '2023-07-12', 14, 265);
INSERT INTO `consumed` VALUES (512, '2023-07-12', 262, 190);
INSERT INTO `consumed` VALUES (513, '2023-07-12', 29, 200);
INSERT INTO `consumed` VALUES (514, '2023-07-12', 5, 180);
INSERT INTO `consumed` VALUES (515, '2023-07-12', 27, 270);
INSERT INTO `consumed` VALUES (516, '2023-07-12', 8, 180);
INSERT INTO `consumed` VALUES (517, '2023-07-12', 13, 300);
INSERT INTO `consumed` VALUES (518, '2023-07-13', 12, 290);
INSERT INTO `consumed` VALUES (519, '2023-07-13', 262, 190);
INSERT INTO `consumed` VALUES (520, '2023-07-13', 29, 200);
INSERT INTO `consumed` VALUES (521, '2023-07-13', 27, 270);
INSERT INTO `consumed` VALUES (523, '2023-07-13', 13, 300);
INSERT INTO `consumed` VALUES (524, '2023-07-13', 26, 200);
INSERT INTO `consumed` VALUES (525, '2023-07-14', 14, 265);
INSERT INTO `consumed` VALUES (526, '2023-07-14', 29, 200);
INSERT INTO `consumed` VALUES (527, '2023-07-15', 12, 290);
INSERT INTO `consumed` VALUES (528, '2023-07-15', 29, 200);
INSERT INTO `consumed` VALUES (529, '2023-07-15', 262, 190);
INSERT INTO `consumed` VALUES (530, '2023-07-15', 27, 270);
INSERT INTO `consumed` VALUES (531, '2023-07-15', 26, 200);
INSERT INTO `consumed` VALUES (532, '2023-07-15', 13, 300);
INSERT INTO `consumed` VALUES (533, '2023-07-16', 14, 265);
INSERT INTO `consumed` VALUES (534, '2023-07-16', 29, 200);
INSERT INTO `consumed` VALUES (535, '2023-07-16', 13, 450);
INSERT INTO `consumed` VALUES (536, '2023-07-16', 5, 180);
INSERT INTO `consumed` VALUES (537, '2023-07-16', 262, 190);
INSERT INTO `consumed` VALUES (538, '2023-07-16', 26, 200);
INSERT INTO `consumed` VALUES (539, '2023-07-17', 12, 290);
INSERT INTO `consumed` VALUES (540, '2023-07-17', 29, 200);
INSERT INTO `consumed` VALUES (541, '2023-07-17', 262, 190);
INSERT INTO `consumed` VALUES (542, '2023-07-17', 27, 270);
INSERT INTO `consumed` VALUES (543, '2023-07-17', 8, 180);
INSERT INTO `consumed` VALUES (544, '2023-07-17', 52, 200);
INSERT INTO `consumed` VALUES (545, '2023-07-17', 1, 200);
INSERT INTO `consumed` VALUES (546, '2023-07-18', 14, 265);
INSERT INTO `consumed` VALUES (547, '2023-07-18', 29, 200);
INSERT INTO `consumed` VALUES (548, '2023-07-18', 27, 270);
INSERT INTO `consumed` VALUES (549, '2023-07-18', 262, 190);
INSERT INTO `consumed` VALUES (550, '2023-07-18', 26, 200);
INSERT INTO `consumed` VALUES (551, '2023-07-18', 13, 300);
INSERT INTO `consumed` VALUES (552, '2023-07-18', 1, 200);
INSERT INTO `consumed` VALUES (553, '2023-07-19', 14, 265);
INSERT INTO `consumed` VALUES (554, '2023-07-19', 12, 290);
INSERT INTO `consumed` VALUES (555, '2023-07-19', 27, 270);
INSERT INTO `consumed` VALUES (556, '2023-07-19', 29, 200);
INSERT INTO `consumed` VALUES (557, '2023-07-19', 5, 180);
INSERT INTO `consumed` VALUES (558, '2023-07-19', 262, 190);
INSERT INTO `consumed` VALUES (559, '2023-07-19', 8, 180);
INSERT INTO `consumed` VALUES (560, '2023-07-19', 1, 200);
INSERT INTO `consumed` VALUES (561, '2023-07-19', 13, 150);
INSERT INTO `consumed` VALUES (565, '2023-07-20', 14, 265);
INSERT INTO `consumed` VALUES (566, '2023-07-20', 27, 270);
INSERT INTO `consumed` VALUES (567, '2023-07-20', 29, 200);
INSERT INTO `consumed` VALUES (568, '2023-07-20', 5, 180);
INSERT INTO `consumed` VALUES (569, '2023-07-19', 264, 930);
INSERT INTO `consumed` VALUES (570, '2023-07-19', 263, 440);
INSERT INTO `consumed` VALUES (571, '2023-07-19', 52, 200);
INSERT INTO `consumed` VALUES (572, '2023-07-20', 262, 190);
INSERT INTO `consumed` VALUES (573, '2023-07-20', 8, 180);
INSERT INTO `consumed` VALUES (574, '2023-07-20', 13, 300);
INSERT INTO `consumed` VALUES (575, '2023-07-21', 14, 530);
INSERT INTO `consumed` VALUES (576, '2023-07-21', 29, 200);
INSERT INTO `consumed` VALUES (577, '2023-07-21', 27, 270);
INSERT INTO `consumed` VALUES (578, '2023-07-21', 262, 190);
INSERT INTO `consumed` VALUES (579, '2023-07-21', 26, 200);
INSERT INTO `consumed` VALUES (580, '2023-07-21', 13, 300);
INSERT INTO `consumed` VALUES (581, '2023-07-21', 1, 200);
INSERT INTO `consumed` VALUES (582, '2023-07-22', 12, 290);
INSERT INTO `consumed` VALUES (583, '2023-07-22', 27, 270);
INSERT INTO `consumed` VALUES (584, '2023-07-22', 29, 200);
INSERT INTO `consumed` VALUES (585, '2023-07-22', 5, 180);
INSERT INTO `consumed` VALUES (586, '2023-07-22', 262, 190);
INSERT INTO `consumed` VALUES (587, '2023-07-22', 13, 300);
INSERT INTO `consumed` VALUES (588, '2023-07-22', 26, 200);
INSERT INTO `consumed` VALUES (589, '2023-07-22', 1, 200);
INSERT INTO `consumed` VALUES (590, '2023-07-23', 14, 265);
INSERT INTO `consumed` VALUES (591, '2023-07-23', 29, 200);
INSERT INTO `consumed` VALUES (592, '2023-07-23', 13, 450);
INSERT INTO `consumed` VALUES (593, '2023-07-23', 262, 190);
INSERT INTO `consumed` VALUES (594, '2023-07-23', 27, 270);
INSERT INTO `consumed` VALUES (595, '2023-07-23', 8, 180);
INSERT INTO `consumed` VALUES (597, '2023-07-24', 12, 290);
INSERT INTO `consumed` VALUES (598, '2023-07-24', 27, 270);
INSERT INTO `consumed` VALUES (599, '2023-07-24', 29, 200);
INSERT INTO `consumed` VALUES (600, '2023-07-24', 262, 190);
INSERT INTO `consumed` VALUES (601, '2023-07-24', 5, 180);
INSERT INTO `consumed` VALUES (602, '2023-07-24', 8, 180);
INSERT INTO `consumed` VALUES (603, '2023-07-24', 1, 200);
INSERT INTO `consumed` VALUES (604, '2023-07-24', 13, 300);
INSERT INTO `consumed` VALUES (605, '2023-07-25', 12, 290);
INSERT INTO `consumed` VALUES (606, '2023-07-25', 29, 200);
INSERT INTO `consumed` VALUES (607, '2023-07-25', 27, 270);
INSERT INTO `consumed` VALUES (608, '2023-07-25', 5, 180);
INSERT INTO `consumed` VALUES (609, '2023-07-25', 262, 190);
INSERT INTO `consumed` VALUES (610, '2023-07-25', 26, 200);
INSERT INTO `consumed` VALUES (611, '2023-07-25', 1, 200);
INSERT INTO `consumed` VALUES (612, '2023-07-25', 13, 600);
INSERT INTO `consumed` VALUES (613, '2023-07-26', 12, 290);
INSERT INTO `consumed` VALUES (614, '2023-07-26', 29, 200);
INSERT INTO `consumed` VALUES (615, '2023-07-26', 27, 540);
INSERT INTO `consumed` VALUES (616, '2023-07-26', 5, 180);
INSERT INTO `consumed` VALUES (617, '2023-07-26', 26, 200);
INSERT INTO `consumed` VALUES (618, '2023-07-26', 1, 400);
INSERT INTO `consumed` VALUES (619, '2023-07-26', 52, 200);
INSERT INTO `consumed` VALUES (620, '2023-07-27', 12, 290);
INSERT INTO `consumed` VALUES (621, '2023-07-27', 5, 360);
INSERT INTO `consumed` VALUES (622, '2023-07-27', 29, 200);
INSERT INTO `consumed` VALUES (623, '2023-07-27', 27, 540);
INSERT INTO `consumed` VALUES (624, '2023-07-27', 13, 150);
INSERT INTO `consumed` VALUES (625, '2023-07-27', 26, 200);
INSERT INTO `consumed` VALUES (626, '2023-07-28', 12, 290);
INSERT INTO `consumed` VALUES (627, '2023-07-28', 29, 200);
INSERT INTO `consumed` VALUES (628, '2023-07-28', 262, 190);
INSERT INTO `consumed` VALUES (629, '2023-07-28', 13, 450);
INSERT INTO `consumed` VALUES (630, '2023-07-28', 27, 270);
INSERT INTO `consumed` VALUES (631, '2023-07-28', 8, 180);
INSERT INTO `consumed` VALUES (632, '2023-07-28', 1, 200);
INSERT INTO `consumed` VALUES (633, '2023-07-29', 12, 290);
INSERT INTO `consumed` VALUES (634, '2023-07-29', 27, 270);
INSERT INTO `consumed` VALUES (635, '2023-07-29', 29, 200);
INSERT INTO `consumed` VALUES (636, '2023-07-29', 262, 190);
INSERT INTO `consumed` VALUES (637, '2023-07-29', 26, 200);
INSERT INTO `consumed` VALUES (638, '2023-07-29', 1, 200);
INSERT INTO `consumed` VALUES (639, '2023-07-29', 265, 930);
INSERT INTO `consumed` VALUES (640, '2023-07-29', 13, 150);
INSERT INTO `consumed` VALUES (641, '2023-07-30', 12, 290);
INSERT INTO `consumed` VALUES (642, '2023-07-30', 262, 190);
INSERT INTO `consumed` VALUES (643, '2023-07-30', 29, 200);
INSERT INTO `consumed` VALUES (644, '2023-07-30', 27, 270);
INSERT INTO `consumed` VALUES (645, '2023-07-30', 5, 180);
INSERT INTO `consumed` VALUES (646, '2023-07-30', 265, 930);
INSERT INTO `consumed` VALUES (647, '2023-07-30', 13, 300);
INSERT INTO `consumed` VALUES (648, '2023-07-30', 26, 200);
INSERT INTO `consumed` VALUES (649, '2023-07-30', 1, 200);
INSERT INTO `consumed` VALUES (650, '2023-07-31', 12, 290);
INSERT INTO `consumed` VALUES (651, '2023-07-31', 29, 200);
INSERT INTO `consumed` VALUES (652, '2023-07-31', 13, 150);
INSERT INTO `consumed` VALUES (653, '2023-07-31', 5, 360);
INSERT INTO `consumed` VALUES (654, '2023-07-31', 27, 540);
INSERT INTO `consumed` VALUES (655, '2023-08-01', 12, 290);
INSERT INTO `consumed` VALUES (656, '2023-08-01', 29, 200);
INSERT INTO `consumed` VALUES (657, '2023-08-01', 27, 540);
INSERT INTO `consumed` VALUES (658, '2023-08-01', 5, 180);
INSERT INTO `consumed` VALUES (659, '2023-08-01', 8, 180);
INSERT INTO `consumed` VALUES (660, '2023-08-01', 1, 200);
INSERT INTO `consumed` VALUES (661, '2023-08-02', 12, 290);
INSERT INTO `consumed` VALUES (662, '2023-08-02', 29, 200);
INSERT INTO `consumed` VALUES (663, '2023-08-02', 27, 270);
INSERT INTO `consumed` VALUES (664, '2023-08-02', 266, 130);
INSERT INTO `consumed` VALUES (665, '2023-08-02', 26, 200);
INSERT INTO `consumed` VALUES (666, '2023-08-02', 13, 300);
INSERT INTO `consumed` VALUES (667, '2023-08-03', 12, 290);
INSERT INTO `consumed` VALUES (668, '2023-08-03', 29, 200);
INSERT INTO `consumed` VALUES (669, '2023-08-03', 27, 270);
INSERT INTO `consumed` VALUES (670, '2023-08-03', 1, 150);
INSERT INTO `consumed` VALUES (671, '2023-08-03', 267, 245);
INSERT INTO `consumed` VALUES (672, '2023-08-03', 8, 180);
INSERT INTO `consumed` VALUES (673, '2023-08-03', 13, 600);
INSERT INTO `consumed` VALUES (674, '2023-08-04', 12, 290);
INSERT INTO `consumed` VALUES (675, '2023-08-04', 29, 200);
INSERT INTO `consumed` VALUES (676, '2023-08-04', 266, 260);
INSERT INTO `consumed` VALUES (677, '2023-08-04', 27, 540);
INSERT INTO `consumed` VALUES (678, '2023-08-04', 13, 450);
INSERT INTO `consumed` VALUES (679, '2023-08-04', 265, 930);
INSERT INTO `consumed` VALUES (680, '2023-08-04', 26, 200);
INSERT INTO `consumed` VALUES (681, '2023-08-05', 12, 290);
INSERT INTO `consumed` VALUES (682, '2023-08-05', 29, 200);
INSERT INTO `consumed` VALUES (683, '2023-08-05', 27, 540);
INSERT INTO `consumed` VALUES (684, '2023-08-05', 266, 260);
INSERT INTO `consumed` VALUES (685, '2023-08-05', 13, 750);
INSERT INTO `consumed` VALUES (686, '2023-08-05', 8, 180);
INSERT INTO `consumed` VALUES (687, '2023-08-06', 12, 290);
INSERT INTO `consumed` VALUES (688, '2023-08-06', 29, 200);
INSERT INTO `consumed` VALUES (689, '2023-08-06', 13, 750);
INSERT INTO `consumed` VALUES (690, '2023-08-06', 27, 270);
INSERT INTO `consumed` VALUES (691, '2023-08-06', 266, 260);
INSERT INTO `consumed` VALUES (692, '2023-08-06', 26, 200);
INSERT INTO `consumed` VALUES (693, '2023-08-07', 12, 290);
INSERT INTO `consumed` VALUES (694, '2023-08-07', 29, 200);
INSERT INTO `consumed` VALUES (695, '2023-08-07', 266, 260);
INSERT INTO `consumed` VALUES (696, '2023-08-07', 27, 270);
INSERT INTO `consumed` VALUES (697, '2023-08-07', 8, 180);
INSERT INTO `consumed` VALUES (698, '2023-08-08', 12, 290);
INSERT INTO `consumed` VALUES (699, '2023-08-08', 27, 270);
INSERT INTO `consumed` VALUES (700, '2023-08-08', 29, 200);
INSERT INTO `consumed` VALUES (701, '2023-08-08', 269, 200);
INSERT INTO `consumed` VALUES (702, '2023-08-08', 5, 180);
INSERT INTO `consumed` VALUES (703, '2023-08-08', 26, 200);
INSERT INTO `consumed` VALUES (704, '2023-08-08', 13, 450);
INSERT INTO `consumed` VALUES (705, '2023-08-07', 13, 300);
INSERT INTO `consumed` VALUES (706, '2023-08-09', 12, 290);
INSERT INTO `consumed` VALUES (707, '2023-08-09', 29, 200);
INSERT INTO `consumed` VALUES (708, '2023-08-09', 27, 270);
INSERT INTO `consumed` VALUES (709, '2023-08-09', 269, 200);
INSERT INTO `consumed` VALUES (710, '2023-08-09', 8, 180);
INSERT INTO `consumed` VALUES (711, '2023-08-09', 13, 300);
INSERT INTO `consumed` VALUES (712, '2023-08-09', 52, 300);
INSERT INTO `consumed` VALUES (713, '2023-08-09', 265, 930);
INSERT INTO `consumed` VALUES (714, '2023-08-10', 12, 290);
INSERT INTO `consumed` VALUES (715, '2023-08-10', 29, 200);
INSERT INTO `consumed` VALUES (716, '2023-08-10', 27, 270);
INSERT INTO `consumed` VALUES (717, '2023-08-10', 266, 260);
INSERT INTO `consumed` VALUES (718, '2023-08-10', 26, 200);
INSERT INTO `consumed` VALUES (719, '2023-08-10', 13, 600);
INSERT INTO `consumed` VALUES (720, '2023-08-11', 12, 290);
INSERT INTO `consumed` VALUES (721, '2023-08-11', 29, 200);
INSERT INTO `consumed` VALUES (722, '2023-08-11', 27, 270);
INSERT INTO `consumed` VALUES (723, '2023-08-11', 266, 260);
INSERT INTO `consumed` VALUES (724, '2023-08-11', 8, 180);
INSERT INTO `consumed` VALUES (726, '2023-08-12', 12, 290);
INSERT INTO `consumed` VALUES (727, '2023-08-12', 29, 200);
INSERT INTO `consumed` VALUES (728, '2023-08-12', 27, 270);
INSERT INTO `consumed` VALUES (729, '2023-08-12', 5, 180);
INSERT INTO `consumed` VALUES (730, '2023-08-12', 266, 260);
INSERT INTO `consumed` VALUES (731, '2023-08-12', 8, 180);
INSERT INTO `consumed` VALUES (732, '2023-08-12', 52, 300);
INSERT INTO `consumed` VALUES (733, '2023-08-13', 12, 290);
INSERT INTO `consumed` VALUES (734, '2023-08-14', 12, 290);
INSERT INTO `consumed` VALUES (735, '2023-08-14', 27, 270);
INSERT INTO `consumed` VALUES (736, '2023-08-14', 29, 200);
INSERT INTO `consumed` VALUES (737, '2023-08-14', 13, 300);
INSERT INTO `consumed` VALUES (738, '2023-08-14', 266, 260);
INSERT INTO `consumed` VALUES (739, '2023-08-13', 29, 200);
INSERT INTO `consumed` VALUES (740, '2023-08-13', 27, 270);
INSERT INTO `consumed` VALUES (741, '2023-08-13', 266, 260);
INSERT INTO `consumed` VALUES (742, '2023-08-13', 8, 180);
INSERT INTO `consumed` VALUES (743, '2023-08-14', 8, 180);
INSERT INTO `consumed` VALUES (744, '2023-08-15', 12, 290);
INSERT INTO `consumed` VALUES (745, '2023-08-15', 29, 200);
INSERT INTO `consumed` VALUES (746, '2023-08-15', 27, 270);
INSERT INTO `consumed` VALUES (747, '2023-08-15', 13, 450);
INSERT INTO `consumed` VALUES (748, '2023-08-15', 26, 200);
INSERT INTO `consumed` VALUES (749, '2023-08-15', 266, 260);
INSERT INTO `consumed` VALUES (750, '2023-08-16', 12, 290);
INSERT INTO `consumed` VALUES (751, '2023-08-16', 27, 270);
INSERT INTO `consumed` VALUES (752, '2023-08-16', 29, 200);
INSERT INTO `consumed` VALUES (753, '2023-08-16', 8, 180);
INSERT INTO `consumed` VALUES (754, '2023-08-16', 266, 260);
INSERT INTO `consumed` VALUES (755, '2023-08-16', 52, 400);
INSERT INTO `consumed` VALUES (756, '2023-08-17', 12, 290);
INSERT INTO `consumed` VALUES (757, '2023-08-17', 27, 270);
INSERT INTO `consumed` VALUES (758, '2023-08-17', 29, 200);
INSERT INTO `consumed` VALUES (759, '2023-08-17', 26, 200);
INSERT INTO `consumed` VALUES (760, '2023-08-17', 266, 260);
INSERT INTO `consumed` VALUES (761, '2023-08-17', 52, 300);
INSERT INTO `consumed` VALUES (762, '2023-08-18', 12, 290);
INSERT INTO `consumed` VALUES (763, '2023-08-18', 27, 270);
INSERT INTO `consumed` VALUES (764, '2023-08-18', 29, 200);
INSERT INTO `consumed` VALUES (765, '2023-08-18', 266, 260);
INSERT INTO `consumed` VALUES (766, '2023-08-18', 26, 200);
INSERT INTO `consumed` VALUES (767, '2023-08-18', 52, 200);
INSERT INTO `consumed` VALUES (768, '2023-08-18', 13, 300);
INSERT INTO `consumed` VALUES (769, '2023-08-19', 12, 290);
INSERT INTO `consumed` VALUES (770, '2023-08-19', 29, 200);
INSERT INTO `consumed` VALUES (771, '2023-08-19', 5, 180);
INSERT INTO `consumed` VALUES (772, '2023-08-19', 27, 270);
INSERT INTO `consumed` VALUES (773, '2023-08-19', 266, 260);
INSERT INTO `consumed` VALUES (774, '2023-08-19', 26, 200);
INSERT INTO `consumed` VALUES (775, '2023-08-19', 13, 750);
INSERT INTO `consumed` VALUES (776, '2023-08-20', 12, 290);
INSERT INTO `consumed` VALUES (777, '2023-08-20', 13, 600);
INSERT INTO `consumed` VALUES (778, '2023-08-20', 29, 200);
INSERT INTO `consumed` VALUES (779, '2023-08-20', 27, 270);
INSERT INTO `consumed` VALUES (780, '2023-08-20', 26, 200);
INSERT INTO `consumed` VALUES (781, '2023-08-20', 266, 260);
INSERT INTO `consumed` VALUES (782, '2023-08-21', 12, 290);
INSERT INTO `consumed` VALUES (783, '2023-08-21', 27, 270);
INSERT INTO `consumed` VALUES (784, '2023-08-21', 29, 200);
INSERT INTO `consumed` VALUES (785, '2023-08-21', 267, 245);
INSERT INTO `consumed` VALUES (786, '2023-08-21', 13, 600);
INSERT INTO `consumed` VALUES (788, '2023-08-21', 266, 130);
INSERT INTO `consumed` VALUES (789, '2023-08-21', 8, 180);
INSERT INTO `consumed` VALUES (790, '2023-08-21', 265, 930);
INSERT INTO `consumed` VALUES (791, '2023-08-22', 12, 290);
INSERT INTO `consumed` VALUES (792, '2023-08-22', 27, 270);
INSERT INTO `consumed` VALUES (793, '2023-08-22', 29, 200);
INSERT INTO `consumed` VALUES (794, '2023-08-22', 266, 260);
INSERT INTO `consumed` VALUES (795, '2023-08-22', 5, 180);
INSERT INTO `consumed` VALUES (796, '2023-08-22', 26, 200);
INSERT INTO `consumed` VALUES (797, '2023-08-22', 13, 1050);
INSERT INTO `consumed` VALUES (798, '2023-08-23', 12, 290);
INSERT INTO `consumed` VALUES (799, '2023-08-23', 29, 200);
INSERT INTO `consumed` VALUES (800, '2023-08-23', 27, 270);
INSERT INTO `consumed` VALUES (801, '2023-08-23', 266, 260);
INSERT INTO `consumed` VALUES (802, '2023-08-23', 8, 180);
INSERT INTO `consumed` VALUES (803, '2023-08-23', 52, 500);
INSERT INTO `consumed` VALUES (804, '2023-08-24', 12, 290);
INSERT INTO `consumed` VALUES (805, '2023-08-24', 29, 200);
INSERT INTO `consumed` VALUES (806, '2023-08-24', 27, 270);
INSERT INTO `consumed` VALUES (807, '2023-08-24', 266, 260);
INSERT INTO `consumed` VALUES (808, '2023-08-24', 270, 1000);
INSERT INTO `consumed` VALUES (809, '2023-08-24', 13, 900);
INSERT INTO `consumed` VALUES (810, '2023-08-24', 26, 200);
INSERT INTO `consumed` VALUES (811, '2023-08-25', 12, 290);
INSERT INTO `consumed` VALUES (812, '2023-08-25', 29, 200);
INSERT INTO `consumed` VALUES (813, '2023-08-25', 27, 270);
INSERT INTO `consumed` VALUES (814, '2023-08-25', 5, 180);
INSERT INTO `consumed` VALUES (815, '2023-08-25', 266, 260);
INSERT INTO `consumed` VALUES (816, '2023-08-25', 13, 600);
INSERT INTO `consumed` VALUES (817, '2023-08-25', 8, 180);
INSERT INTO `consumed` VALUES (818, '2023-08-25', 52, 200);
INSERT INTO `consumed` VALUES (819, '2023-08-26', 12, 290);
INSERT INTO `consumed` VALUES (820, '2023-08-26', 270, 1000);
INSERT INTO `consumed` VALUES (821, '2023-08-26', 29, 200);
INSERT INTO `consumed` VALUES (822, '2023-08-26', 27, 270);
INSERT INTO `consumed` VALUES (823, '2023-08-26', 266, 260);
INSERT INTO `consumed` VALUES (824, '2023-08-26', 13, 900);
INSERT INTO `consumed` VALUES (825, '2023-08-26', 8, 180);
INSERT INTO `consumed` VALUES (826, '2023-08-27', 12, 290);
INSERT INTO `consumed` VALUES (827, '2023-08-27', 29, 200);
INSERT INTO `consumed` VALUES (828, '2023-08-27', 27, 270);
INSERT INTO `consumed` VALUES (829, '2023-08-27', 266, 130);
INSERT INTO `consumed` VALUES (830, '2023-08-27', 13, 600);
INSERT INTO `consumed` VALUES (831, '2023-08-27', 5, 180);
INSERT INTO `consumed` VALUES (833, '2023-08-27', 270, 1000);
INSERT INTO `consumed` VALUES (834, '2023-08-27', 8, 180);
INSERT INTO `consumed` VALUES (835, '2023-08-28', 12, 290);
INSERT INTO `consumed` VALUES (836, '2023-08-28', 27, 270);
INSERT INTO `consumed` VALUES (837, '2023-08-28', 29, 200);
INSERT INTO `consumed` VALUES (838, '2023-08-28', 266, 130);
INSERT INTO `consumed` VALUES (839, '2023-08-28', 52, 300);
INSERT INTO `consumed` VALUES (840, '2023-08-28', 8, 180);
INSERT INTO `consumed` VALUES (841, '2023-08-29', 12, 290);
INSERT INTO `consumed` VALUES (842, '2023-08-29', 29, 200);
INSERT INTO `consumed` VALUES (843, '2023-08-29', 266, 130);
INSERT INTO `consumed` VALUES (844, '2023-08-29', 13, 600);
INSERT INTO `consumed` VALUES (845, '2023-08-29', 27, 270);
INSERT INTO `consumed` VALUES (846, '2023-08-29', 8, 180);
INSERT INTO `consumed` VALUES (847, '2023-08-30', 12, 290);
INSERT INTO `consumed` VALUES (848, '2023-08-30', 27, 270);
INSERT INTO `consumed` VALUES (849, '2023-08-30', 29, 200);
INSERT INTO `consumed` VALUES (850, '2023-08-30', 266, 130);
INSERT INTO `consumed` VALUES (851, '2023-08-30', 13, 600);
INSERT INTO `consumed` VALUES (852, '2023-08-30', 8, 180);
INSERT INTO `consumed` VALUES (853, '2023-08-31', 12, 290);
INSERT INTO `consumed` VALUES (854, '2023-08-31', 29, 200);
INSERT INTO `consumed` VALUES (855, '2023-08-31', 27, 270);
INSERT INTO `consumed` VALUES (856, '2023-08-31', 266, 130);
INSERT INTO `consumed` VALUES (857, '2023-08-31', 8, 180);
INSERT INTO `consumed` VALUES (858, '2023-08-31', 52, 600);
INSERT INTO `consumed` VALUES (859, '2023-09-01', 12, 290);
INSERT INTO `consumed` VALUES (860, '2023-09-01', 29, 200);
INSERT INTO `consumed` VALUES (861, '2023-09-01', 13, 750);
INSERT INTO `consumed` VALUES (862, '2023-09-01', 27, 270);
INSERT INTO `consumed` VALUES (863, '2023-09-01', 266, 130);
INSERT INTO `consumed` VALUES (864, '2023-09-02', 12, 290);
INSERT INTO `consumed` VALUES (865, '2023-09-02', 29, 200);
INSERT INTO `consumed` VALUES (866, '2023-09-02', 27, 270);
INSERT INTO `consumed` VALUES (867, '2023-09-02', 8, 180);
INSERT INTO `consumed` VALUES (868, '2023-09-02', 266, 130);
INSERT INTO `consumed` VALUES (869, '2023-09-02', 13, 450);
INSERT INTO `consumed` VALUES (870, '2023-09-03', 12, 290);
INSERT INTO `consumed` VALUES (871, '2023-09-03', 29, 200);
INSERT INTO `consumed` VALUES (872, '2023-09-03', 27, 270);
INSERT INTO `consumed` VALUES (873, '2023-09-03', 266, 130);
INSERT INTO `consumed` VALUES (874, '2023-09-03', 8, 180);
INSERT INTO `consumed` VALUES (875, '2023-09-03', 13, 750);
INSERT INTO `consumed` VALUES (876, '2023-09-04', 12, 290);
INSERT INTO `consumed` VALUES (877, '2023-09-04', 29, 200);
INSERT INTO `consumed` VALUES (878, '2023-09-04', 27, 270);
INSERT INTO `consumed` VALUES (879, '2023-09-04', 266, 130);
INSERT INTO `consumed` VALUES (880, '2023-09-04', 13, 300);
INSERT INTO `consumed` VALUES (881, '2023-09-05', 271, 305);
INSERT INTO `consumed` VALUES (882, '2023-09-05', 29, 200);
INSERT INTO `consumed` VALUES (883, '2023-09-05', 27, 270);
INSERT INTO `consumed` VALUES (884, '2023-09-05', 5, 180);
INSERT INTO `consumed` VALUES (885, '2023-09-05', 266, 130);
INSERT INTO `consumed` VALUES (886, '2023-09-05', 8, 180);
INSERT INTO `consumed` VALUES (887, '2023-09-05', 13, 600);
INSERT INTO `consumed` VALUES (888, '2023-09-06', 271, 305);
INSERT INTO `consumed` VALUES (889, '2023-09-06', 27, 270);
INSERT INTO `consumed` VALUES (890, '2023-09-06', 29, 200);
INSERT INTO `consumed` VALUES (891, '2023-09-06', 266, 130);
INSERT INTO `consumed` VALUES (892, '2023-09-06', 13, 600);
INSERT INTO `consumed` VALUES (893, '2023-09-06', 26, 200);
INSERT INTO `consumed` VALUES (894, '2023-09-07', 12, 290);
INSERT INTO `consumed` VALUES (895, '2023-09-07', 29, 200);
INSERT INTO `consumed` VALUES (896, '2023-09-07', 13, 750);
INSERT INTO `consumed` VALUES (897, '2023-09-07', 26, 200);
INSERT INTO `consumed` VALUES (898, '2023-09-07', 27, 270);
INSERT INTO `consumed` VALUES (899, '2023-09-07', 266, 130);
INSERT INTO `consumed` VALUES (901, '2023-09-08', 29, 200);
INSERT INTO `consumed` VALUES (902, '2023-09-08', 27, 270);
INSERT INTO `consumed` VALUES (903, '2023-09-08', 266, 130);
INSERT INTO `consumed` VALUES (904, '2023-09-08', 8, 180);
INSERT INTO `consumed` VALUES (905, '2023-09-08', 13, 750);
INSERT INTO `consumed` VALUES (906, '2023-09-09', 12, 290);
INSERT INTO `consumed` VALUES (907, '2023-09-09', 29, 200);
INSERT INTO `consumed` VALUES (908, '2023-09-09', 27, 270);
INSERT INTO `consumed` VALUES (909, '2023-09-09', 5, 180);
INSERT INTO `consumed` VALUES (910, '2023-09-09', 26, 200);
INSERT INTO `consumed` VALUES (911, '2023-09-09', 52, 600);
INSERT INTO `consumed` VALUES (912, '2023-09-09', 266, 130);
INSERT INTO `consumed` VALUES (913, '2023-09-10', 272, 305);
INSERT INTO `consumed` VALUES (914, '2023-09-08', 272, 305);
INSERT INTO `consumed` VALUES (915, '2023-09-10', 273, 320);
INSERT INTO `consumed` VALUES (916, '2023-09-10', 29, 200);
INSERT INTO `consumed` VALUES (917, '2023-09-10', 266, 130);
INSERT INTO `consumed` VALUES (918, '2023-09-10', 26, 200);
INSERT INTO `consumed` VALUES (919, '2023-09-10', 52, 900);
INSERT INTO `consumed` VALUES (920, '2023-09-11', 12, 290);
INSERT INTO `consumed` VALUES (921, '2023-09-11', 27, 270);
INSERT INTO `consumed` VALUES (922, '2023-09-11', 29, 200);
INSERT INTO `consumed` VALUES (923, '2023-09-11', 26, 200);
INSERT INTO `consumed` VALUES (924, '2023-09-11', 52, 400);
INSERT INTO `consumed` VALUES (925, '2023-09-11', 266, 130);
INSERT INTO `consumed` VALUES (926, '2023-09-12', 12, 290);
INSERT INTO `consumed` VALUES (927, '2023-09-12', 27, 270);
INSERT INTO `consumed` VALUES (928, '2023-09-12', 29, 200);
INSERT INTO `consumed` VALUES (929, '2023-09-12', 266, 130);
INSERT INTO `consumed` VALUES (930, '2023-09-12', 26, 200);
INSERT INTO `consumed` VALUES (931, '2023-09-12', 13, 900);
INSERT INTO `consumed` VALUES (932, '2023-09-14', 272, 305);
INSERT INTO `consumed` VALUES (933, '2023-09-13', 272, 305);
INSERT INTO `consumed` VALUES (934, '2023-09-13', 29, 200);
INSERT INTO `consumed` VALUES (935, '2023-09-13', 27, 270);
INSERT INTO `consumed` VALUES (936, '2023-09-13', 266, 130);
INSERT INTO `consumed` VALUES (937, '2023-09-13', 26, 200);
INSERT INTO `consumed` VALUES (938, '2023-09-13', 13, 750);
INSERT INTO `consumed` VALUES (939, '2023-09-14', 29, 200);
INSERT INTO `consumed` VALUES (940, '2023-09-14', 27, 270);
INSERT INTO `consumed` VALUES (941, '2023-09-14', 10, 130);
INSERT INTO `consumed` VALUES (942, '2023-09-14', 266, 130);
INSERT INTO `consumed` VALUES (943, '2023-09-14', 13, 900);
INSERT INTO `consumed` VALUES (944, '2023-09-15', 12, 290);
INSERT INTO `consumed` VALUES (945, '2023-09-15', 29, 200);
INSERT INTO `consumed` VALUES (946, '2023-09-15', 27, 270);
INSERT INTO `consumed` VALUES (947, '2023-09-15', 26, 200);
INSERT INTO `consumed` VALUES (948, '2023-09-15', 266, 130);
INSERT INTO `consumed` VALUES (949, '2023-09-15', 13, 900);
INSERT INTO `consumed` VALUES (950, '2023-09-16', 12, 290);
INSERT INTO `consumed` VALUES (951, '2023-09-16', 29, 200);
INSERT INTO `consumed` VALUES (952, '2023-09-16', 27, 270);
INSERT INTO `consumed` VALUES (953, '2023-09-16', 26, 200);
INSERT INTO `consumed` VALUES (954, '2023-09-16', 266, 130);
INSERT INTO `consumed` VALUES (955, '2023-09-16', 5, 180);
INSERT INTO `consumed` VALUES (956, '2023-09-16', 52, 600);
INSERT INTO `consumed` VALUES (957, '2023-09-17', 12, 290);
INSERT INTO `consumed` VALUES (958, '2023-09-17', 274, 200);
INSERT INTO `consumed` VALUES (959, '2023-09-17', 27, 270);
INSERT INTO `consumed` VALUES (960, '2023-09-17', 266, 130);
INSERT INTO `consumed` VALUES (961, '2023-09-17', 10, 130);
INSERT INTO `consumed` VALUES (962, '2023-09-17', 52, 200);
INSERT INTO `consumed` VALUES (963, '2023-09-18', 12, 290);
INSERT INTO `consumed` VALUES (964, '2023-09-18', 29, 200);
INSERT INTO `consumed` VALUES (965, '2023-09-18', 27, 270);
INSERT INTO `consumed` VALUES (966, '2023-09-18', 266, 130);
INSERT INTO `consumed` VALUES (967, '2023-09-18', 52, 800);
INSERT INTO `consumed` VALUES (968, '2023-09-18', 26, 200);
INSERT INTO `consumed` VALUES (969, '2023-09-19', 272, 305);
INSERT INTO `consumed` VALUES (970, '2023-09-19', 29, 200);
INSERT INTO `consumed` VALUES (971, '2023-09-19', 27, 270);
INSERT INTO `consumed` VALUES (972, '2023-09-19', 266, 130);
INSERT INTO `consumed` VALUES (973, '2023-09-19', 10, 130);
INSERT INTO `consumed` VALUES (974, '2023-09-19', 52, 600);
INSERT INTO `consumed` VALUES (975, '2023-09-19', 5, 180);
INSERT INTO `consumed` VALUES (976, '2023-09-20', 271, 305);
INSERT INTO `consumed` VALUES (977, '2023-09-20', 29, 200);
INSERT INTO `consumed` VALUES (978, '2023-09-20', 27, 270);
INSERT INTO `consumed` VALUES (979, '2023-09-20', 26, 200);
INSERT INTO `consumed` VALUES (980, '2023-09-20', 266, 130);
INSERT INTO `consumed` VALUES (981, '2023-09-20', 52, 400);
INSERT INTO `consumed` VALUES (982, '2023-09-20', 5, 180);
INSERT INTO `consumed` VALUES (983, '2023-09-21', 272, 305);
INSERT INTO `consumed` VALUES (984, '2023-09-21', 29, 200);
INSERT INTO `consumed` VALUES (985, '2023-09-21', 27, 270);
INSERT INTO `consumed` VALUES (986, '2023-09-21', 266, 130);
INSERT INTO `consumed` VALUES (987, '2023-09-21', 52, 600);
INSERT INTO `consumed` VALUES (988, '2023-09-21', 26, 200);
INSERT INTO `consumed` VALUES (989, '2023-09-22', 272, 305);
INSERT INTO `consumed` VALUES (991, '2023-09-22', 274, 200);
INSERT INTO `consumed` VALUES (992, '2023-09-22', 27, 270);
INSERT INTO `consumed` VALUES (993, '2023-09-22', 266, 130);
INSERT INTO `consumed` VALUES (994, '2023-09-22', 10, 130);
INSERT INTO `consumed` VALUES (995, '2023-09-22', 52, 500);
INSERT INTO `consumed` VALUES (997, '2023-09-22', 12, 290);
INSERT INTO `consumed` VALUES (998, '2023-09-23', 52, 200);
INSERT INTO `consumed` VALUES (999, '2023-09-23', 12, 290);
INSERT INTO `consumed` VALUES (1000, '2023-09-23', 275, 170);
INSERT INTO `consumed` VALUES (1001, '2023-09-23', 29, 200);
INSERT INTO `consumed` VALUES (1002, '2023-09-23', 27, 270);
INSERT INTO `consumed` VALUES (1003, '2023-09-23', 266, 130);
INSERT INTO `consumed` VALUES (1004, '2023-09-24', 12, 290);
INSERT INTO `consumed` VALUES (1005, '2023-09-24', 29, 100);
INSERT INTO `consumed` VALUES (1006, '2023-09-24', 27, 270);
INSERT INTO `consumed` VALUES (1007, '2023-09-24', 266, 65);
INSERT INTO `consumed` VALUES (1009, '2023-09-24', 52, 200);
INSERT INTO `consumed` VALUES (1010, '2023-09-24', 26, 200);
INSERT INTO `consumed` VALUES (1011, '2023-09-25', 12, 290);
INSERT INTO `consumed` VALUES (1012, '2023-09-25', 29, 200);
INSERT INTO `consumed` VALUES (1013, '2023-09-25', 27, 270);
INSERT INTO `consumed` VALUES (1014, '2023-09-25', 266, 130);
INSERT INTO `consumed` VALUES (1015, '2023-09-25', 52, 500);
INSERT INTO `consumed` VALUES (1016, '2023-09-25', 10, 130);
INSERT INTO `consumed` VALUES (1017, '2023-09-26', 12, 290);
INSERT INTO `consumed` VALUES (1018, '2023-09-26', 29, 200);
INSERT INTO `consumed` VALUES (1019, '2023-09-26', 27, 270);
INSERT INTO `consumed` VALUES (1020, '2023-09-26', 266, 130);
INSERT INTO `consumed` VALUES (1021, '2023-09-26', 52, 400);
INSERT INTO `consumed` VALUES (1022, '2023-09-26', 8, 180);
INSERT INTO `consumed` VALUES (1023, '2023-09-26', 276, 950);
INSERT INTO `consumed` VALUES (1025, '2023-09-27', 271, 305);
INSERT INTO `consumed` VALUES (1027, '2023-09-27', 27, 270);
INSERT INTO `consumed` VALUES (1028, '2023-09-27', 275, 170);
INSERT INTO `consumed` VALUES (1029, '2023-09-27', 10, 130);
INSERT INTO `consumed` VALUES (1030, '2023-09-27', 52, 300);
INSERT INTO `consumed` VALUES (1032, '2023-09-28', 274, 200);
INSERT INTO `consumed` VALUES (1033, '2023-09-28', 27, 270);
INSERT INTO `consumed` VALUES (1034, '2023-09-28', 266, 130);
INSERT INTO `consumed` VALUES (1035, '2023-09-28', 272, 305);
INSERT INTO `consumed` VALUES (1036, '2023-09-28', 8, 180);
INSERT INTO `consumed` VALUES (1037, '2023-09-28', 52, 200);
INSERT INTO `consumed` VALUES (1038, '2023-09-29', 272, 305);
INSERT INTO `consumed` VALUES (1039, '2023-09-29', 274, 200);
INSERT INTO `consumed` VALUES (1040, '2023-09-29', 27, 270);
INSERT INTO `consumed` VALUES (1041, '2023-09-29', 266, 130);
INSERT INTO `consumed` VALUES (1042, '2023-09-27', 274, 200);
INSERT INTO `consumed` VALUES (1043, '2023-09-29', 277, 140);
INSERT INTO `consumed` VALUES (1044, '2023-09-29', 278, 300);
INSERT INTO `consumed` VALUES (1045, '2023-09-30', 279, 300);
INSERT INTO `consumed` VALUES (1046, '2023-09-30', 274, 200);
INSERT INTO `consumed` VALUES (1047, '2023-09-30', 27, 270);
INSERT INTO `consumed` VALUES (1048, '2023-09-30', 266, 130);
INSERT INTO `consumed` VALUES (1049, '2023-09-30', 277, 140);
INSERT INTO `consumed` VALUES (1050, '2023-09-30', 278, 300);
INSERT INTO `consumed` VALUES (1051, '2023-10-01', 279, 300);
INSERT INTO `consumed` VALUES (1052, '2023-10-01', 27, 270);
INSERT INTO `consumed` VALUES (1053, '2023-10-01', 274, 200);
INSERT INTO `consumed` VALUES (1054, '2023-10-01', 266, 130);
INSERT INTO `consumed` VALUES (1055, '2023-10-01', 52, 400);
INSERT INTO `consumed` VALUES (1056, '2023-10-01', 8, 180);
INSERT INTO `consumed` VALUES (1057, '2023-10-02', 12, 290);
INSERT INTO `consumed` VALUES (1058, '2023-10-02', 274, 200);
INSERT INTO `consumed` VALUES (1059, '2023-10-02', 27, 270);
INSERT INTO `consumed` VALUES (1060, '2023-10-02', 266, 130);
INSERT INTO `consumed` VALUES (1061, '2023-10-02', 8, 180);
INSERT INTO `consumed` VALUES (1063, '2023-10-02', 278, 500);
INSERT INTO `consumed` VALUES (1064, '2023-10-03', 12, 290);
INSERT INTO `consumed` VALUES (1065, '2023-10-03', 274, 200);
INSERT INTO `consumed` VALUES (1066, '2023-10-03', 266, 130);
INSERT INTO `consumed` VALUES (1067, '2023-10-03', 27, 270);
INSERT INTO `consumed` VALUES (1068, '2023-10-03', 8, 180);
INSERT INTO `consumed` VALUES (1069, '2023-10-03', 278, 200);
INSERT INTO `consumed` VALUES (1070, '2023-10-04', 12, 290);
INSERT INTO `consumed` VALUES (1071, '2023-10-04', 266, 130);
INSERT INTO `consumed` VALUES (1072, '2023-10-04', 27, 270);
INSERT INTO `consumed` VALUES (1073, '2023-10-04', 274, 200);
INSERT INTO `consumed` VALUES (1074, '2023-10-04', 8, 180);
INSERT INTO `consumed` VALUES (1075, '2023-10-04', 13, 600);
INSERT INTO `consumed` VALUES (1076, '2023-10-05', 12, 290);
INSERT INTO `consumed` VALUES (1077, '2023-10-05', 27, 270);
INSERT INTO `consumed` VALUES (1078, '2023-10-05', 266, 130);
INSERT INTO `consumed` VALUES (1079, '2023-10-05', 274, 200);
INSERT INTO `consumed` VALUES (1080, '2023-10-05', 8, 180);
INSERT INTO `consumed` VALUES (1081, '2023-10-05', 52, 300);
INSERT INTO `consumed` VALUES (1082, '2023-10-06', 12, 290);
INSERT INTO `consumed` VALUES (1083, '2023-10-06', 274, 200);
INSERT INTO `consumed` VALUES (1084, '2023-10-06', 27, 270);
INSERT INTO `consumed` VALUES (1085, '2023-10-06', 8, 180);
INSERT INTO `consumed` VALUES (1086, '2023-10-06', 266, 130);
INSERT INTO `consumed` VALUES (1087, '2023-10-06', 52, 300);
INSERT INTO `consumed` VALUES (1088, '2023-10-07', 12, 290);
INSERT INTO `consumed` VALUES (1089, '2023-10-07', 274, 200);
INSERT INTO `consumed` VALUES (1090, '2023-10-07', 266, 130);
INSERT INTO `consumed` VALUES (1091, '2023-10-07', 27, 270);
INSERT INTO `consumed` VALUES (1092, '2023-10-07', 8, 180);
INSERT INTO `consumed` VALUES (1093, '2023-10-07', 52, 300);
INSERT INTO `consumed` VALUES (1094, '2023-10-08', 12, 290);
INSERT INTO `consumed` VALUES (1095, '2023-10-08', 27, 270);
INSERT INTO `consumed` VALUES (1096, '2023-10-08', 274, 200);
INSERT INTO `consumed` VALUES (1097, '2023-10-08', 266, 130);
INSERT INTO `consumed` VALUES (1098, '2023-10-08', 8, 180);
INSERT INTO `consumed` VALUES (1099, '2023-10-08', 52, 300);
INSERT INTO `consumed` VALUES (1100, '2023-10-09', 12, 290);
INSERT INTO `consumed` VALUES (1101, '2023-10-09', 274, 200);
INSERT INTO `consumed` VALUES (1102, '2023-10-09', 266, 130);
INSERT INTO `consumed` VALUES (1103, '2023-10-09', 27, 270);
INSERT INTO `consumed` VALUES (1104, '2023-10-09', 5, 200);
INSERT INTO `consumed` VALUES (1105, '2023-10-09', 8, 180);
INSERT INTO `consumed` VALUES (1106, '2023-10-09', 52, 300);
INSERT INTO `consumed` VALUES (1107, '2023-10-10', 12, 290);
INSERT INTO `consumed` VALUES (1108, '2023-10-10', 266, 130);
INSERT INTO `consumed` VALUES (1109, '2023-10-10', 274, 200);
INSERT INTO `consumed` VALUES (1110, '2023-10-10', 27, 270);
INSERT INTO `consumed` VALUES (1111, '2023-10-10', 8, 180);
INSERT INTO `consumed` VALUES (1112, '2023-10-10', 52, 300);
INSERT INTO `consumed` VALUES (1113, '2023-10-11', 12, 290);
INSERT INTO `consumed` VALUES (1114, '2023-10-11', 274, 200);
INSERT INTO `consumed` VALUES (1115, '2023-10-11', 266, 130);
INSERT INTO `consumed` VALUES (1116, '2023-10-11', 27, 270);
INSERT INTO `consumed` VALUES (1117, '2023-10-11', 8, 180);
INSERT INTO `consumed` VALUES (1118, '2023-10-11', 52, 300);
INSERT INTO `consumed` VALUES (1121, '2023-10-12', 279, 300);
INSERT INTO `consumed` VALUES (1123, '2023-10-12', 27, 270);
INSERT INTO `consumed` VALUES (1124, '2023-10-12', 274, 200);
INSERT INTO `consumed` VALUES (1125, '2023-10-12', 266, 130);
INSERT INTO `consumed` VALUES (1126, '2023-10-12', 277, 140);
INSERT INTO `consumed` VALUES (1127, '2023-10-13', 272, 305);
INSERT INTO `consumed` VALUES (1128, '2023-10-13', 274, 200);
INSERT INTO `consumed` VALUES (1129, '2023-10-13', 27, 270);
INSERT INTO `consumed` VALUES (1130, '2023-10-13', 266, 130);
INSERT INTO `consumed` VALUES (1131, '2023-10-13', 277, 140);
INSERT INTO `consumed` VALUES (1132, '2023-10-13', 278, 300);
INSERT INTO `consumed` VALUES (1133, '2023-10-14', 279, 300);
INSERT INTO `consumed` VALUES (1134, '2023-10-14', 274, 200);
INSERT INTO `consumed` VALUES (1135, '2023-10-14', 266, 130);
INSERT INTO `consumed` VALUES (1136, '2023-10-14', 27, 270);
INSERT INTO `consumed` VALUES (1137, '2023-10-14', 278, 150);
INSERT INTO `consumed` VALUES (1138, '2023-10-15', 279, 300);
INSERT INTO `consumed` VALUES (1139, '2023-10-15', 274, 200);
INSERT INTO `consumed` VALUES (1140, '2023-10-15', 27, 270);
INSERT INTO `consumed` VALUES (1141, '2023-10-15', 266, 130);
INSERT INTO `consumed` VALUES (1142, '2023-10-15', 8, 180);
INSERT INTO `consumed` VALUES (1143, '2023-10-16', 12, 290);
INSERT INTO `consumed` VALUES (1144, '2023-10-16', 274, 200);
INSERT INTO `consumed` VALUES (1145, '2023-10-16', 266, 130);
INSERT INTO `consumed` VALUES (1146, '2023-10-16', 27, 270);
INSERT INTO `consumed` VALUES (1147, '2023-10-16', 8, 180);
INSERT INTO `consumed` VALUES (1148, '2023-10-16', 278, 200);
INSERT INTO `consumed` VALUES (1149, '2023-10-17', 279, 300);
INSERT INTO `consumed` VALUES (1150, '2023-10-17', 274, 200);
INSERT INTO `consumed` VALUES (1151, '2023-10-17', 27, 270);
INSERT INTO `consumed` VALUES (1152, '2023-10-17', 266, 130);
INSERT INTO `consumed` VALUES (1153, '2023-10-17', 8, 180);
INSERT INTO `consumed` VALUES (1154, '2023-10-17', 278, 300);
INSERT INTO `consumed` VALUES (1155, '2023-10-18', 279, 300);
INSERT INTO `consumed` VALUES (1156, '2023-10-18', 274, 200);
INSERT INTO `consumed` VALUES (1157, '2023-10-18', 27, 270);
INSERT INTO `consumed` VALUES (1158, '2023-10-18', 266, 130);
INSERT INTO `consumed` VALUES (1159, '2023-10-18', 8, 180);
INSERT INTO `consumed` VALUES (1160, '2023-10-18', 278, 300);
INSERT INTO `consumed` VALUES (1161, '2023-10-19', 279, 300);
INSERT INTO `consumed` VALUES (1162, '2023-10-19', 274, 200);
INSERT INTO `consumed` VALUES (1163, '2023-10-19', 266, 130);
INSERT INTO `consumed` VALUES (1164, '2023-10-19', 27, 270);
INSERT INTO `consumed` VALUES (1165, '2023-10-19', 8, 180);
INSERT INTO `consumed` VALUES (1166, '2023-10-19', 278, 300);
INSERT INTO `consumed` VALUES (1167, '2023-10-20', 12, 290);
INSERT INTO `consumed` VALUES (1168, '2023-10-20', 27, 270);
INSERT INTO `consumed` VALUES (1169, '2023-10-20', 274, 200);
INSERT INTO `consumed` VALUES (1170, '2023-10-20', 266, 130);
INSERT INTO `consumed` VALUES (1171, '2023-10-20', 8, 180);
INSERT INTO `consumed` VALUES (1172, '2023-10-20', 278, 300);
INSERT INTO `consumed` VALUES (1173, '2023-10-21', 279, 300);
INSERT INTO `consumed` VALUES (1174, '2023-10-21', 274, 200);
INSERT INTO `consumed` VALUES (1175, '2023-10-21', 266, 130);
INSERT INTO `consumed` VALUES (1176, '2023-10-21', 27, 270);
INSERT INTO `consumed` VALUES (1177, '2023-10-21', 8, 180);
INSERT INTO `consumed` VALUES (1178, '2023-10-21', 278, 300);
INSERT INTO `consumed` VALUES (1179, '2023-10-22', 279, 300);
INSERT INTO `consumed` VALUES (1181, '2023-10-22', 274, 200);
INSERT INTO `consumed` VALUES (1182, '2023-10-22', 266, 130);
INSERT INTO `consumed` VALUES (1184, '2023-10-22', 8, 180);
INSERT INTO `consumed` VALUES (1186, '2023-10-22', 13, 150);
INSERT INTO `consumed` VALUES (1187, '2023-10-23', 279, 300);
INSERT INTO `consumed` VALUES (1188, '2023-10-23', 27, 270);
INSERT INTO `consumed` VALUES (1189, '2023-10-23', 274, 200);
INSERT INTO `consumed` VALUES (1191, '2023-10-23', 8, 180);
INSERT INTO `consumed` VALUES (1192, '2023-10-23', 13, 300);
INSERT INTO `consumed` VALUES (1193, '2023-10-24', 12, 290);
INSERT INTO `consumed` VALUES (1194, '2023-10-24', 280, 130);
INSERT INTO `consumed` VALUES (1195, '2023-10-23', 280, 130);
INSERT INTO `consumed` VALUES (1196, '2023-10-24', 274, 200);
INSERT INTO `consumed` VALUES (1197, '2023-10-24', 27, 270);
INSERT INTO `consumed` VALUES (1198, '2023-10-24', 52, 300);
INSERT INTO `consumed` VALUES (1199, '2023-10-25', 12, 290);
INSERT INTO `consumed` VALUES (1200, '2023-10-25', 274, 200);
INSERT INTO `consumed` VALUES (1201, '2023-10-25', 27, 270);
INSERT INTO `consumed` VALUES (1203, '2023-10-25', 280, 130);
INSERT INTO `consumed` VALUES (1204, '2023-10-25', 10, 130);
INSERT INTO `consumed` VALUES (1205, '2023-10-25', 52, 300);
INSERT INTO `consumed` VALUES (1206, '2023-10-26', 6, 155);
INSERT INTO `consumed` VALUES (1207, '2023-10-26', 274, 200);
INSERT INTO `consumed` VALUES (1208, '2023-10-26', 280, 130);
INSERT INTO `consumed` VALUES (1209, '2023-10-26', 27, 270);
INSERT INTO `consumed` VALUES (1210, '2023-10-26', 10, 130);
INSERT INTO `consumed` VALUES (1211, '2023-10-26', 52, 300);
INSERT INTO `consumed` VALUES (1212, '2023-10-27', 12, 290);
INSERT INTO `consumed` VALUES (1213, '2023-10-27', 27, 270);
INSERT INTO `consumed` VALUES (1214, '2023-10-27', 274, 200);
INSERT INTO `consumed` VALUES (1215, '2023-10-27', 280, 130);
INSERT INTO `consumed` VALUES (1216, '2023-10-27', 52, 300);
INSERT INTO `consumed` VALUES (1217, '2023-10-27', 10, 130);
INSERT INTO `consumed` VALUES (1218, '2023-10-28', 12, 290);
INSERT INTO `consumed` VALUES (1219, '2023-10-28', 274, 200);
INSERT INTO `consumed` VALUES (1220, '2023-10-28', 27, 270);
INSERT INTO `consumed` VALUES (1221, '2023-10-28', 280, 130);
INSERT INTO `consumed` VALUES (1222, '2023-10-28', 8, 180);
INSERT INTO `consumed` VALUES (1223, '2023-10-28', 52, 300);
INSERT INTO `consumed` VALUES (1224, '2023-10-29', 12, 290);
INSERT INTO `consumed` VALUES (1225, '2023-10-29', 280, 130);
INSERT INTO `consumed` VALUES (1226, '2023-10-29', 274, 200);
INSERT INTO `consumed` VALUES (1227, '2023-10-29', 27, 270);
INSERT INTO `consumed` VALUES (1228, '2023-10-29', 10, 130);
INSERT INTO `consumed` VALUES (1229, '2023-10-29', 52, 300);
INSERT INTO `consumed` VALUES (1230, '2023-10-30', 12, 290);
INSERT INTO `consumed` VALUES (1231, '2023-10-30', 274, 200);
INSERT INTO `consumed` VALUES (1232, '2023-10-30', 266, 130);
INSERT INTO `consumed` VALUES (1233, '2023-10-30', 27, 270);
INSERT INTO `consumed` VALUES (1234, '2023-10-30', 10, 130);
INSERT INTO `consumed` VALUES (1235, '2023-10-30', 52, 300);
INSERT INTO `consumed` VALUES (1236, '2023-10-31', 12, 290);
INSERT INTO `consumed` VALUES (1237, '2023-10-31', 274, 200);
INSERT INTO `consumed` VALUES (1238, '2023-10-31', 280, 130);
INSERT INTO `consumed` VALUES (1239, '2023-10-31', 27, 270);
INSERT INTO `consumed` VALUES (1240, '2023-10-31', 10, 130);
INSERT INTO `consumed` VALUES (1241, '2023-10-31', 52, 300);
INSERT INTO `consumed` VALUES (1242, '2023-11-01', 12, 290);
INSERT INTO `consumed` VALUES (1243, '2023-11-01', 274, 200);
INSERT INTO `consumed` VALUES (1244, '2023-11-01', 27, 270);
INSERT INTO `consumed` VALUES (1245, '2023-11-01', 266, 130);
INSERT INTO `consumed` VALUES (1247, '2023-11-01', 5, 200);
INSERT INTO `consumed` VALUES (1248, '2023-11-01', 52, 300);
INSERT INTO `consumed` VALUES (1249, '2023-11-01', 8, 180);
INSERT INTO `consumed` VALUES (1250, '2023-11-02', 12, 290);
INSERT INTO `consumed` VALUES (1251, '2023-11-02', 27, 270);
INSERT INTO `consumed` VALUES (1252, '2023-11-02', 274, 200);
INSERT INTO `consumed` VALUES (1253, '2023-11-02', 280, 130);
INSERT INTO `consumed` VALUES (1254, '2023-11-02', 10, 130);
INSERT INTO `consumed` VALUES (1255, '2023-11-02', 52, 300);
INSERT INTO `consumed` VALUES (1256, '2023-11-03', 12, 290);
INSERT INTO `consumed` VALUES (1257, '2023-11-03', 27, 270);
INSERT INTO `consumed` VALUES (1258, '2023-11-03', 274, 200);
INSERT INTO `consumed` VALUES (1259, '2023-11-03', 280, 130);
INSERT INTO `consumed` VALUES (1260, '2023-11-03', 5, 200);
INSERT INTO `consumed` VALUES (1261, '2023-11-03', 10, 130);
INSERT INTO `consumed` VALUES (1262, '2023-11-03', 52, 300);
INSERT INTO `consumed` VALUES (1263, '2023-11-02', 5, 200);
INSERT INTO `consumed` VALUES (1264, '2023-11-04', 12, 290);
INSERT INTO `consumed` VALUES (1265, '2023-11-04', 274, 200);
INSERT INTO `consumed` VALUES (1266, '2023-11-04', 27, 270);
INSERT INTO `consumed` VALUES (1267, '2023-11-04', 280, 130);
INSERT INTO `consumed` VALUES (1268, '2023-11-04', 5, 200);
INSERT INTO `consumed` VALUES (1269, '2023-11-04', 10, 130);
INSERT INTO `consumed` VALUES (1270, '2023-11-04', 52, 300);
INSERT INTO `consumed` VALUES (1272, '2023-11-05', 271, 305);
INSERT INTO `consumed` VALUES (1273, '2023-11-05', 281, 300);
INSERT INTO `consumed` VALUES (1274, '2023-11-05', 274, 200);
INSERT INTO `consumed` VALUES (1275, '2023-11-05', 280, 130);
INSERT INTO `consumed` VALUES (1276, '2023-11-06', 279, 300);
INSERT INTO `consumed` VALUES (1277, '2023-11-06', 274, 200);
INSERT INTO `consumed` VALUES (1278, '2023-11-06', 280, 130);
INSERT INTO `consumed` VALUES (1279, '2023-11-06', 281, 300);
INSERT INTO `consumed` VALUES (1280, '2023-11-06', 10, 130);
INSERT INTO `consumed` VALUES (1281, '2023-11-06', 52, 300);
INSERT INTO `consumed` VALUES (1282, '2023-11-07', 279, 300);
INSERT INTO `consumed` VALUES (1283, '2023-11-07', 274, 200);
INSERT INTO `consumed` VALUES (1284, '2023-11-07', 280, 130);
INSERT INTO `consumed` VALUES (1286, '2023-11-07', 10, 130);
INSERT INTO `consumed` VALUES (1287, '2023-11-07', 52, 150);
INSERT INTO `consumed` VALUES (1288, '2023-11-07', 49, 390);
INSERT INTO `consumed` VALUES (1289, '2023-11-08', 279, 300);
INSERT INTO `consumed` VALUES (1290, '2023-11-08', 27, 270);
INSERT INTO `consumed` VALUES (1291, '2023-11-08', 274, 200);
INSERT INTO `consumed` VALUES (1293, '2023-11-08', 266, 130);
INSERT INTO `consumed` VALUES (1294, '2023-11-08', 5, 200);
INSERT INTO `consumed` VALUES (1295, '2023-11-08', 52, 300);
INSERT INTO `consumed` VALUES (1296, '2023-11-09', 271, 305);
INSERT INTO `consumed` VALUES (1297, '2023-11-09', 274, 200);
INSERT INTO `consumed` VALUES (1298, '2023-11-09', 27, 270);
INSERT INTO `consumed` VALUES (1299, '2023-11-09', 266, 130);
INSERT INTO `consumed` VALUES (1300, '2023-11-09', 5, 200);
INSERT INTO `consumed` VALUES (1302, '2023-11-09', 52, 300);
INSERT INTO `consumed` VALUES (1303, '2023-11-09', 265, 930);
INSERT INTO `consumed` VALUES (1304, '2023-11-10', 12, 290);
INSERT INTO `consumed` VALUES (1305, '2023-11-10', 27, 270);
INSERT INTO `consumed` VALUES (1306, '2023-11-10', 274, 200);
INSERT INTO `consumed` VALUES (1307, '2023-11-10', 5, 200);
INSERT INTO `consumed` VALUES (1308, '2023-11-10', 280, 130);
INSERT INTO `consumed` VALUES (1310, '2023-11-10', 52, 300);
INSERT INTO `consumed` VALUES (1311, '2023-11-11', 12, 290);
INSERT INTO `consumed` VALUES (1312, '2023-11-11', 27, 270);
INSERT INTO `consumed` VALUES (1313, '2023-11-11', 274, 200);
INSERT INTO `consumed` VALUES (1314, '2023-11-11', 280, 130);
INSERT INTO `consumed` VALUES (1316, '2023-11-11', 52, 300);
INSERT INTO `consumed` VALUES (1317, '2023-11-12', 12, 290);
INSERT INTO `consumed` VALUES (1318, '2023-11-12', 274, 200);
INSERT INTO `consumed` VALUES (1319, '2023-11-12', 27, 270);
INSERT INTO `consumed` VALUES (1320, '2023-11-12', 280, 130);
INSERT INTO `consumed` VALUES (1322, '2023-11-12', 52, 450);
INSERT INTO `consumed` VALUES (1323, '2023-11-13', 12, 290);
INSERT INTO `consumed` VALUES (1324, '2023-11-13', 274, 200);
INSERT INTO `consumed` VALUES (1325, '2023-11-13', 280, 130);
INSERT INTO `consumed` VALUES (1326, '2023-11-13', 27, 270);
INSERT INTO `consumed` VALUES (1328, '2023-11-13', 52, 300);
INSERT INTO `consumed` VALUES (1329, '2023-11-14', 12, 290);
INSERT INTO `consumed` VALUES (1330, '2023-11-14', 27, 270);
INSERT INTO `consumed` VALUES (1331, '2023-11-14', 280, 130);
INSERT INTO `consumed` VALUES (1332, '2023-11-14', 274, 200);
INSERT INTO `consumed` VALUES (1334, '2023-11-14', 5, 200);
INSERT INTO `consumed` VALUES (1335, '2023-11-13', 5, 200);
INSERT INTO `consumed` VALUES (1336, '2023-11-14', 52, 300);
INSERT INTO `consumed` VALUES (1337, '2023-11-15', 12, 290);
INSERT INTO `consumed` VALUES (1338, '2023-11-15', 27, 270);
INSERT INTO `consumed` VALUES (1339, '2023-11-15', 274, 200);
INSERT INTO `consumed` VALUES (1340, '2023-11-15', 280, 130);
INSERT INTO `consumed` VALUES (1343, '2023-11-15', 52, 300);
INSERT INTO `consumed` VALUES (1344, '2023-11-16', 12, 290);
INSERT INTO `consumed` VALUES (1345, '2023-11-16', 274, 200);
INSERT INTO `consumed` VALUES (1346, '2023-11-16', 27, 270);
INSERT INTO `consumed` VALUES (1347, '2023-11-16', 280, 130);
INSERT INTO `consumed` VALUES (1349, '2023-11-16', 52, 450);
INSERT INTO `consumed` VALUES (1350, '2023-11-17', 12, 290);
INSERT INTO `consumed` VALUES (1351, '2023-11-17', 274, 200);
INSERT INTO `consumed` VALUES (1352, '2023-11-17', 27, 270);
INSERT INTO `consumed` VALUES (1353, '2023-11-17', 280, 130);
INSERT INTO `consumed` VALUES (1355, '2023-11-17', 52, 600);
INSERT INTO `consumed` VALUES (1356, '2023-11-18', 12, 290);
INSERT INTO `consumed` VALUES (1357, '2023-11-18', 27, 270);
INSERT INTO `consumed` VALUES (1358, '2023-11-18', 274, 200);
INSERT INTO `consumed` VALUES (1359, '2023-11-18', 280, 130);
INSERT INTO `consumed` VALUES (1361, '2023-11-18', 52, 300);
INSERT INTO `consumed` VALUES (1362, '2023-11-18', 5, 200);
INSERT INTO `consumed` VALUES (1363, '2023-11-19', 12, 290);
INSERT INTO `consumed` VALUES (1364, '2023-11-19', 274, 200);
INSERT INTO `consumed` VALUES (1365, '2023-11-19', 27, 270);
INSERT INTO `consumed` VALUES (1366, '2023-11-19', 280, 130);
INSERT INTO `consumed` VALUES (1368, '2023-11-19', 52, 300);
INSERT INTO `consumed` VALUES (1369, '2023-11-19', 5, 200);
INSERT INTO `consumed` VALUES (1370, '2023-11-19', 282, 150);
INSERT INTO `consumed` VALUES (1371, '2023-11-18', 282, 150);
INSERT INTO `consumed` VALUES (1372, '2023-11-17', 282, 150);
INSERT INTO `consumed` VALUES (1373, '2023-11-16', 282, 150);
INSERT INTO `consumed` VALUES (1374, '2023-11-15', 282, 150);
INSERT INTO `consumed` VALUES (1375, '2023-11-14', 282, 150);
INSERT INTO `consumed` VALUES (1376, '2023-11-13', 282, 150);
INSERT INTO `consumed` VALUES (1377, '2023-11-12', 282, 150);
INSERT INTO `consumed` VALUES (1378, '2023-11-11', 282, 150);
INSERT INTO `consumed` VALUES (1379, '2023-11-10', 282, 150);
INSERT INTO `consumed` VALUES (1380, '2023-11-09', 282, 150);
INSERT INTO `consumed` VALUES (1381, '2023-11-08', 282, 150);
INSERT INTO `consumed` VALUES (1382, '2023-11-20', 12, 290);
INSERT INTO `consumed` VALUES (1383, '2023-11-20', 27, 270);
INSERT INTO `consumed` VALUES (1384, '2023-11-20', 274, 200);
INSERT INTO `consumed` VALUES (1385, '2023-11-20', 280, 130);
INSERT INTO `consumed` VALUES (1386, '2023-11-20', 282, 150);
INSERT INTO `consumed` VALUES (1387, '2023-11-20', 5, 200);
INSERT INTO `consumed` VALUES (1388, '2023-11-20', 52, 300);
INSERT INTO `consumed` VALUES (1389, '2023-11-21', 12, 290);
INSERT INTO `consumed` VALUES (1390, '2023-11-21', 27, 270);
INSERT INTO `consumed` VALUES (1391, '2023-11-21', 274, 200);
INSERT INTO `consumed` VALUES (1392, '2023-11-21', 280, 130);
INSERT INTO `consumed` VALUES (1393, '2023-11-21', 282, 150);
INSERT INTO `consumed` VALUES (1394, '2023-11-21', 52, 300);
INSERT INTO `consumed` VALUES (1395, '2023-11-22', 12, 290);
INSERT INTO `consumed` VALUES (1396, '2023-11-22', 27, 270);
INSERT INTO `consumed` VALUES (1397, '2023-11-22', 274, 200);
INSERT INTO `consumed` VALUES (1398, '2023-11-22', 5, 200);
INSERT INTO `consumed` VALUES (1399, '2023-11-22', 282, 150);
INSERT INTO `consumed` VALUES (1400, '2023-11-22', 52, 300);
INSERT INTO `consumed` VALUES (1401, '2023-11-22', 280, 130);
INSERT INTO `consumed` VALUES (1403, '2023-11-23', 274, 200);
INSERT INTO `consumed` VALUES (1404, '2023-11-23', 27, 270);
INSERT INTO `consumed` VALUES (1405, '2023-11-23', 280, 130);
INSERT INTO `consumed` VALUES (1406, '2023-11-23', 5, 200);
INSERT INTO `consumed` VALUES (1407, '2023-11-23', 282, 150);
INSERT INTO `consumed` VALUES (1408, '2023-11-23', 52, 600);
INSERT INTO `consumed` VALUES (1409, '2023-11-23', 271, 305);
INSERT INTO `consumed` VALUES (1410, '2023-11-24', 12, 290);
INSERT INTO `consumed` VALUES (1411, '2023-11-24', 27, 270);
INSERT INTO `consumed` VALUES (1412, '2023-11-24', 280, 130);
INSERT INTO `consumed` VALUES (1413, '2023-11-24', 274, 200);
INSERT INTO `consumed` VALUES (1414, '2023-11-24', 282, 150);
INSERT INTO `consumed` VALUES (1415, '2023-11-24', 52, 300);
INSERT INTO `consumed` VALUES (1416, '2023-11-25', 12, 290);
INSERT INTO `consumed` VALUES (1417, '2023-11-25', 27, 270);
INSERT INTO `consumed` VALUES (1418, '2023-11-25', 280, 130);
INSERT INTO `consumed` VALUES (1419, '2023-11-25', 282, 150);
INSERT INTO `consumed` VALUES (1420, '2023-11-25', 274, 200);
INSERT INTO `consumed` VALUES (1421, '2023-11-25', 52, 600);
INSERT INTO `consumed` VALUES (1422, '2023-11-26', 12, 290);
INSERT INTO `consumed` VALUES (1423, '2023-11-26', 27, 270);
INSERT INTO `consumed` VALUES (1424, '2023-11-26', 280, 130);
INSERT INTO `consumed` VALUES (1425, '2023-11-26', 274, 200);
INSERT INTO `consumed` VALUES (1426, '2023-11-26', 5, 200);
INSERT INTO `consumed` VALUES (1427, '2023-11-26', 52, 300);
INSERT INTO `consumed` VALUES (1428, '2023-11-26', 265, 930);
INSERT INTO `consumed` VALUES (1429, '2023-11-26', 283, 150);
INSERT INTO `consumed` VALUES (1430, '2023-11-26', 284, 150);
INSERT INTO `consumed` VALUES (1431, '2023-11-26', 285, 140);
INSERT INTO `consumed` VALUES (1432, '2023-11-27', 12, 290);
INSERT INTO `consumed` VALUES (1433, '2023-11-27', 27, 270);
INSERT INTO `consumed` VALUES (1434, '2023-11-27', 280, 130);
INSERT INTO `consumed` VALUES (1435, '2023-11-27', 274, 200);
INSERT INTO `consumed` VALUES (1436, '2023-11-27', 283, 75);
INSERT INTO `consumed` VALUES (1437, '2023-11-27', 284, 75);
INSERT INTO `consumed` VALUES (1438, '2023-11-27', 282, 150);
INSERT INTO `consumed` VALUES (1439, '2023-11-27', 52, 600);
INSERT INTO `consumed` VALUES (1440, '2023-11-28', 12, 290);
INSERT INTO `consumed` VALUES (1441, '2023-11-28', 26, 200);
INSERT INTO `consumed` VALUES (1442, '2023-11-28', 27, 270);
INSERT INTO `consumed` VALUES (1443, '2023-11-28', 274, 200);
INSERT INTO `consumed` VALUES (1444, '2023-11-28', 52, 600);
INSERT INTO `consumed` VALUES (1445, '2023-11-28', 280, 130);
INSERT INTO `consumed` VALUES (1446, '2023-11-29', 12, 290);
INSERT INTO `consumed` VALUES (1448, '2023-11-29', 274, 200);
INSERT INTO `consumed` VALUES (1449, '2023-11-29', 27, 270);
INSERT INTO `consumed` VALUES (1450, '2023-11-29', 266, 130);
INSERT INTO `consumed` VALUES (1451, '2023-11-29', 282, 150);
INSERT INTO `consumed` VALUES (1452, '2023-11-29', 52, 300);
INSERT INTO `consumed` VALUES (1453, '2023-11-29', 5, 200);
INSERT INTO `consumed` VALUES (1454, '2023-11-30', 12, 290);
INSERT INTO `consumed` VALUES (1455, '2023-11-30', 274, 200);
INSERT INTO `consumed` VALUES (1456, '2023-11-30', 27, 270);
INSERT INTO `consumed` VALUES (1457, '2023-11-30', 280, 130);
INSERT INTO `consumed` VALUES (1458, '2023-11-30', 282, 150);
INSERT INTO `consumed` VALUES (1459, '2023-11-30', 52, 600);
INSERT INTO `consumed` VALUES (1460, '2023-11-30', 5, 200);
INSERT INTO `consumed` VALUES (1461, '2023-12-01', 271, 305);
INSERT INTO `consumed` VALUES (1462, '2023-12-01', 27, 270);
INSERT INTO `consumed` VALUES (1463, '2023-12-01', 274, 200);
INSERT INTO `consumed` VALUES (1464, '2023-12-01', 280, 130);
INSERT INTO `consumed` VALUES (1465, '2023-12-01', 52, 300);
INSERT INTO `consumed` VALUES (1466, '2023-12-01', 15, 220);
INSERT INTO `consumed` VALUES (1467, '2023-12-02', 12, 290);
INSERT INTO `consumed` VALUES (1468, '2023-12-02', 27, 270);
INSERT INTO `consumed` VALUES (1469, '2023-12-02', 280, 130);
INSERT INTO `consumed` VALUES (1470, '2023-12-02', 274, 200);
INSERT INTO `consumed` VALUES (1471, '2023-12-02', 282, 150);
INSERT INTO `consumed` VALUES (1472, '2023-12-02', 52, 300);
INSERT INTO `consumed` VALUES (1473, '2023-12-03', 12, 290);
INSERT INTO `consumed` VALUES (1474, '2023-12-03', 27, 270);
INSERT INTO `consumed` VALUES (1475, '2023-12-03', 280, 130);
INSERT INTO `consumed` VALUES (1476, '2023-12-03', 274, 200);
INSERT INTO `consumed` VALUES (1477, '2023-12-03', 282, 150);
INSERT INTO `consumed` VALUES (1478, '2023-12-03', 52, 600);
INSERT INTO `consumed` VALUES (1479, '2023-12-04', 12, 290);
INSERT INTO `consumed` VALUES (1480, '2023-12-04', 27, 270);
INSERT INTO `consumed` VALUES (1481, '2023-12-04', 274, 200);
INSERT INTO `consumed` VALUES (1482, '2023-12-04', 280, 130);
INSERT INTO `consumed` VALUES (1483, '2023-12-04', 282, 150);
INSERT INTO `consumed` VALUES (1484, '2023-12-04', 52, 300);
INSERT INTO `consumed` VALUES (1485, '2023-12-05', 12, 290);
INSERT INTO `consumed` VALUES (1486, '2023-12-05', 274, 200);
INSERT INTO `consumed` VALUES (1487, '2023-12-05', 27, 270);
INSERT INTO `consumed` VALUES (1488, '2023-12-05', 280, 130);
INSERT INTO `consumed` VALUES (1489, '2023-12-05', 52, 300);
INSERT INTO `consumed` VALUES (1490, '2023-12-05', 282, 150);
INSERT INTO `consumed` VALUES (1491, '2023-12-06', 12, 290);
INSERT INTO `consumed` VALUES (1492, '2023-12-06', 27, 270);
INSERT INTO `consumed` VALUES (1493, '2023-12-06', 274, 200);
INSERT INTO `consumed` VALUES (1494, '2023-12-06', 280, 130);
INSERT INTO `consumed` VALUES (1495, '2023-12-06', 282, 150);
INSERT INTO `consumed` VALUES (1496, '2023-12-06', 52, 600);
INSERT INTO `consumed` VALUES (1497, '2023-12-07', 12, 290);
INSERT INTO `consumed` VALUES (1498, '2023-12-07', 274, 200);
INSERT INTO `consumed` VALUES (1499, '2023-12-07', 27, 270);
INSERT INTO `consumed` VALUES (1500, '2023-12-07', 52, 300);
INSERT INTO `consumed` VALUES (1501, '2023-12-07', 280, 130);
INSERT INTO `consumed` VALUES (1502, '2023-12-07', 282, 150);
INSERT INTO `consumed` VALUES (1503, '2023-12-08', 12, 290);
INSERT INTO `consumed` VALUES (1504, '2023-12-08', 27, 270);
INSERT INTO `consumed` VALUES (1505, '2023-12-08', 274, 200);
INSERT INTO `consumed` VALUES (1506, '2023-12-08', 280, 130);
INSERT INTO `consumed` VALUES (1507, '2023-12-08', 282, 150);
INSERT INTO `consumed` VALUES (1508, '2023-12-08', 52, 300);
INSERT INTO `consumed` VALUES (1509, '2023-12-09', 12, 290);
INSERT INTO `consumed` VALUES (1510, '2023-12-09', 274, 200);
INSERT INTO `consumed` VALUES (1511, '2023-12-09', 27, 270);
INSERT INTO `consumed` VALUES (1512, '2023-12-09', 52, 100);
INSERT INTO `consumed` VALUES (1513, '2023-12-09', 266, 130);
INSERT INTO `consumed` VALUES (1514, '2023-12-09', 282, 150);
INSERT INTO `consumed` VALUES (1515, '2023-12-10', 12, 290);
INSERT INTO `consumed` VALUES (1516, '2023-12-10', 285, 140);
INSERT INTO `consumed` VALUES (1517, '2023-12-10', 265, 930);
INSERT INTO `consumed` VALUES (1518, '2023-12-10', 283, 300);
INSERT INTO `consumed` VALUES (1519, '2023-12-10', 284, 375);
INSERT INTO `consumed` VALUES (1520, '2023-12-10', 27, 270);
INSERT INTO `consumed` VALUES (1521, '2023-12-10', 274, 200);
INSERT INTO `consumed` VALUES (1522, '2023-12-10', 280, 130);
INSERT INTO `consumed` VALUES (1523, '2023-12-10', 5, 200);
INSERT INTO `consumed` VALUES (1524, '2023-12-10', 282, 150);
INSERT INTO `consumed` VALUES (1526, '2023-12-10', 288, 125);
INSERT INTO `consumed` VALUES (1527, '2023-12-10', 287, 140);
INSERT INTO `consumed` VALUES (1528, '2023-12-10', 286, 150);
INSERT INTO `consumed` VALUES (1529, '2023-12-11', 12, 290);
INSERT INTO `consumed` VALUES (1530, '2023-12-11', 27, 270);
INSERT INTO `consumed` VALUES (1531, '2023-12-11', 274, 200);
INSERT INTO `consumed` VALUES (1532, '2023-12-11', 280, 130);
INSERT INTO `consumed` VALUES (1533, '2023-12-11', 52, 600);
INSERT INTO `consumed` VALUES (1534, '2023-12-11', 5, 200);
INSERT INTO `consumed` VALUES (1535, '2023-12-11', 282, 150);
INSERT INTO `consumed` VALUES (1536, '2023-12-12', 12, 290);
INSERT INTO `consumed` VALUES (1537, '2023-12-12', 27, 270);
INSERT INTO `consumed` VALUES (1538, '2023-12-12', 274, 200);
INSERT INTO `consumed` VALUES (1539, '2023-12-12', 266, 130);
INSERT INTO `consumed` VALUES (1540, '2023-12-12', 52, 450);
INSERT INTO `consumed` VALUES (1541, '2023-12-12', 282, 150);
INSERT INTO `consumed` VALUES (1542, '2023-12-13', 12, 290);
INSERT INTO `consumed` VALUES (1543, '2023-12-13', 27, 270);
INSERT INTO `consumed` VALUES (1544, '2023-12-13', 274, 200);
INSERT INTO `consumed` VALUES (1545, '2023-12-13', 266, 130);
INSERT INTO `consumed` VALUES (1546, '2023-12-13', 282, 150);
INSERT INTO `consumed` VALUES (1547, '2023-12-13', 52, 300);
INSERT INTO `consumed` VALUES (1548, '2023-12-13', 283, 150);
INSERT INTO `consumed` VALUES (1549, '2023-12-13', 284, 150);
INSERT INTO `consumed` VALUES (1550, '2023-12-13', 265, 930);
INSERT INTO `consumed` VALUES (1551, '2023-12-13', 286, 150);
INSERT INTO `consumed` VALUES (1552, '2023-12-13', 289, 115);
INSERT INTO `consumed` VALUES (1553, '2023-12-13', 290, 150);
INSERT INTO `consumed` VALUES (1554, '2023-12-14', 279, 300);
INSERT INTO `consumed` VALUES (1555, '2023-12-14', 291, 390);
INSERT INTO `consumed` VALUES (1556, '2023-12-14', 266, 130);
INSERT INTO `consumed` VALUES (1557, '2023-12-14', 274, 200);
INSERT INTO `consumed` VALUES (1558, '2023-12-14', 282, 150);
INSERT INTO `consumed` VALUES (1559, '2023-12-14', 52, 300);
INSERT INTO `consumed` VALUES (1560, '2023-12-15', 279, 300);
INSERT INTO `consumed` VALUES (1561, '2023-12-15', 281, 300);
INSERT INTO `consumed` VALUES (1562, '2023-12-15', 274, 200);
INSERT INTO `consumed` VALUES (1563, '2023-12-15', 280, 130);
INSERT INTO `consumed` VALUES (1564, '2023-12-15', 282, 150);
INSERT INTO `consumed` VALUES (1565, '2023-12-15', 52, 300);
INSERT INTO `consumed` VALUES (1566, '2023-12-15', 289, 115);
INSERT INTO `consumed` VALUES (1567, '2023-12-15', 285, 140);
INSERT INTO `consumed` VALUES (1568, '2023-12-15', 286, 150);
INSERT INTO `consumed` VALUES (1569, '2023-12-15', 290, 150);
INSERT INTO `consumed` VALUES (1570, '2023-12-16', 279, 300);
INSERT INTO `consumed` VALUES (1572, '2023-12-16', 49, 390);
INSERT INTO `consumed` VALUES (1573, '2023-12-16', 274, 200);
INSERT INTO `consumed` VALUES (1574, '2023-12-16', 280, 130);
INSERT INTO `consumed` VALUES (1576, '2023-12-16', 52, 300);
INSERT INTO `consumed` VALUES (1577, '2023-12-16', 275, 170);
INSERT INTO `consumed` VALUES (1578, '2023-12-16', 290, 300);
INSERT INTO `consumed` VALUES (1579, '2023-12-16', 288, 125);
INSERT INTO `consumed` VALUES (1580, '2023-12-16', 282, 150);
INSERT INTO `consumed` VALUES (1581, '2023-12-16', 286, 300);
INSERT INTO `consumed` VALUES (1582, '2023-12-17', 12, 290);
INSERT INTO `consumed` VALUES (1583, '2023-12-17', 286, 300);
INSERT INTO `consumed` VALUES (1584, '2023-12-17', 292, 250);
INSERT INTO `consumed` VALUES (1585, '2023-12-17', 281, 300);
INSERT INTO `consumed` VALUES (1586, '2023-12-17', 274, 200);
INSERT INTO `consumed` VALUES (1587, '2023-12-17', 280, 130);
INSERT INTO `consumed` VALUES (1588, '2023-12-17', 282, 150);
INSERT INTO `consumed` VALUES (1589, '2023-12-17', 52, 300);
INSERT INTO `consumed` VALUES (1590, '2023-12-17', 285, 140);
INSERT INTO `consumed` VALUES (1591, '2023-12-17', 289, 115);
INSERT INTO `consumed` VALUES (1592, '2023-12-17', 290, 150);
INSERT INTO `consumed` VALUES (1594, '2023-12-18', 291, 390);
INSERT INTO `consumed` VALUES (1595, '2023-12-18', 274, 200);
INSERT INTO `consumed` VALUES (1596, '2023-12-18', 280, 130);
INSERT INTO `consumed` VALUES (1597, '2023-12-18', 282, 150);
INSERT INTO `consumed` VALUES (1598, '2023-12-18', 52, 300);
INSERT INTO `consumed` VALUES (1599, '2023-12-18', 271, 305);
INSERT INTO `consumed` VALUES (1600, '2023-12-18', 290, 150);
INSERT INTO `consumed` VALUES (1601, '2023-12-18', 286, 150);
INSERT INTO `consumed` VALUES (1602, '2023-12-19', 279, 300);
INSERT INTO `consumed` VALUES (1603, '2023-12-19', 281, 300);
INSERT INTO `consumed` VALUES (1604, '2023-12-19', 274, 200);
INSERT INTO `consumed` VALUES (1605, '2023-12-19', 280, 130);
INSERT INTO `consumed` VALUES (1606, '2023-12-19', 5, 400);
INSERT INTO `consumed` VALUES (1607, '2023-12-18', 5, 200);
INSERT INTO `consumed` VALUES (1608, '2023-12-17', 5, 200);
INSERT INTO `consumed` VALUES (1609, '2023-12-19', 52, 300);
INSERT INTO `consumed` VALUES (1610, '2023-12-19', 12, 290);
INSERT INTO `consumed` VALUES (1611, '2023-12-19', 286, 150);
INSERT INTO `consumed` VALUES (1612, '2023-12-19', 290, 150);
INSERT INTO `consumed` VALUES (1613, '2023-12-19', 292, 125);
INSERT INTO `consumed` VALUES (1614, '2023-12-19', 282, 150);
INSERT INTO `consumed` VALUES (1615, '2023-12-19', 293, 90);
INSERT INTO `consumed` VALUES (1616, '2023-12-19', 284, 150);
INSERT INTO `consumed` VALUES (1617, '2023-12-20', 279, 600);
INSERT INTO `consumed` VALUES (1618, '2023-12-20', 281, 300);
INSERT INTO `consumed` VALUES (1619, '2023-12-20', 274, 200);
INSERT INTO `consumed` VALUES (1620, '2023-12-20', 280, 130);
INSERT INTO `consumed` VALUES (1621, '2023-12-20', 5, 200);
INSERT INTO `consumed` VALUES (1622, '2023-12-20', 282, 150);
INSERT INTO `consumed` VALUES (1623, '2023-12-20', 52, 300);
INSERT INTO `consumed` VALUES (1624, '2023-12-21', 12, 290);
INSERT INTO `consumed` VALUES (1625, '2023-12-21', 274, 200);
INSERT INTO `consumed` VALUES (1626, '2023-12-21', 27, 270);
INSERT INTO `consumed` VALUES (1627, '2023-12-21', 280, 130);
INSERT INTO `consumed` VALUES (1628, '2023-12-21', 5, 200);
INSERT INTO `consumed` VALUES (1629, '2023-12-21', 282, 150);
INSERT INTO `consumed` VALUES (1630, '2023-12-21', 52, 300);
INSERT INTO `consumed` VALUES (1631, '2023-12-22', 12, 290);
INSERT INTO `consumed` VALUES (1632, '2023-12-22', 274, 200);
INSERT INTO `consumed` VALUES (1633, '2023-12-22', 27, 270);
INSERT INTO `consumed` VALUES (1634, '2023-12-22', 280, 130);
INSERT INTO `consumed` VALUES (1635, '2023-12-22', 5, 200);
INSERT INTO `consumed` VALUES (1636, '2023-12-22', 282, 150);
INSERT INTO `consumed` VALUES (1637, '2023-12-22', 52, 600);
INSERT INTO `consumed` VALUES (1638, '2023-12-23', 12, 290);
INSERT INTO `consumed` VALUES (1639, '2023-12-23', 286, 150);
INSERT INTO `consumed` VALUES (1640, '2023-12-23', 293, 90);
INSERT INTO `consumed` VALUES (1641, '2023-12-23', 290, 150);
INSERT INTO `consumed` VALUES (1642, '2023-12-23', 274, 200);
INSERT INTO `consumed` VALUES (1643, '2023-12-23', 280, 130);
INSERT INTO `consumed` VALUES (1644, '2023-12-23', 52, 300);
INSERT INTO `consumed` VALUES (1645, '2023-12-24', 12, 290);
INSERT INTO `consumed` VALUES (1646, '2023-12-24', 280, 130);
INSERT INTO `consumed` VALUES (1647, '2023-12-24', 274, 200);
INSERT INTO `consumed` VALUES (1648, '2023-12-24', 5, 200);
INSERT INTO `consumed` VALUES (1649, '2023-12-24', 282, 150);
INSERT INTO `consumed` VALUES (1650, '2023-12-24', 52, 300);
INSERT INTO `consumed` VALUES (1651, '2023-12-24', 286, 300);
INSERT INTO `consumed` VALUES (1652, '2023-12-24', 290, 150);
INSERT INTO `consumed` VALUES (1653, '2023-12-24', 293, 90);
INSERT INTO `consumed` VALUES (1654, '2023-12-25', 12, 290);
INSERT INTO `consumed` VALUES (1655, '2023-12-25', 52, 450);
INSERT INTO `consumed` VALUES (1656, '2023-12-25', 27, 270);
INSERT INTO `consumed` VALUES (1657, '2023-12-25', 274, 200);
INSERT INTO `consumed` VALUES (1659, '2023-12-25', 282, 150);
INSERT INTO `consumed` VALUES (1660, '2023-12-25', 280, 130);
INSERT INTO `consumed` VALUES (1661, '2023-12-26', 12, 290);
INSERT INTO `consumed` VALUES (1662, '2023-12-26', 27, 270);
INSERT INTO `consumed` VALUES (1663, '2023-12-26', 274, 200);
INSERT INTO `consumed` VALUES (1664, '2023-12-26', 266, 130);
INSERT INTO `consumed` VALUES (1665, '2023-12-26', 8, 180);
INSERT INTO `consumed` VALUES (1666, '2023-12-26', 52, 300);
INSERT INTO `consumed` VALUES (1667, '2023-12-26', 294, 150);
INSERT INTO `consumed` VALUES (1668, '2023-12-26', 290, 150);
INSERT INTO `consumed` VALUES (1669, '2023-12-26', 283, 75);
INSERT INTO `consumed` VALUES (1670, '2023-12-26', 292, 125);
INSERT INTO `consumed` VALUES (1672, '2023-12-11', 289, 115);
INSERT INTO `consumed` VALUES (1673, '2023-12-11', 294, 150);
INSERT INTO `consumed` VALUES (1674, '2023-12-11', 290, 150);
INSERT INTO `consumed` VALUES (1675, '2023-12-27', 294, 150);
INSERT INTO `consumed` VALUES (1676, '2023-12-27', 290, 150);
INSERT INTO `consumed` VALUES (1677, '2023-12-27', 292, 125);
INSERT INTO `consumed` VALUES (1678, '2023-12-27', 289, 115);
INSERT INTO `consumed` VALUES (1679, '2023-12-27', 272, 305);
INSERT INTO `consumed` VALUES (1680, '2023-12-27', 27, 270);
INSERT INTO `consumed` VALUES (1681, '2023-12-27', 274, 200);
INSERT INTO `consumed` VALUES (1682, '2023-12-27', 8, 180);
INSERT INTO `consumed` VALUES (1683, '2023-12-27', 52, 450);
INSERT INTO `consumed` VALUES (1684, '2023-12-28', 12, 290);
INSERT INTO `consumed` VALUES (1685, '2023-12-28', 272, 305);
INSERT INTO `consumed` VALUES (1686, '2023-12-28', 27, 270);
INSERT INTO `consumed` VALUES (1687, '2023-12-28', 274, 200);
INSERT INTO `consumed` VALUES (1688, '2023-12-28', 266, 130);
INSERT INTO `consumed` VALUES (1689, '2023-12-28', 294, 150);
INSERT INTO `consumed` VALUES (1690, '2023-12-28', 293, 90);
INSERT INTO `consumed` VALUES (1691, '2023-12-28', 292, 125);
INSERT INTO `consumed` VALUES (1692, '2023-12-28', 287, 210);
INSERT INTO `consumed` VALUES (1693, '2023-12-28', 52, 300);
INSERT INTO `consumed` VALUES (1694, '2023-12-28', 282, 150);
INSERT INTO `consumed` VALUES (1695, '2023-12-29', 12, 580);
INSERT INTO `consumed` VALUES (1696, '2023-12-29', 27, 270);
INSERT INTO `consumed` VALUES (1697, '2023-12-29', 274, 200);
INSERT INTO `consumed` VALUES (1698, '2023-12-29', 280, 130);
INSERT INTO `consumed` VALUES (1699, '2023-12-29', 282, 300);
INSERT INTO `consumed` VALUES (1700, '2023-12-29', 52, 600);
INSERT INTO `consumed` VALUES (1701, '2023-12-29', 295, 190);
INSERT INTO `consumed` VALUES (1702, '2023-12-29', 289, 115);
INSERT INTO `consumed` VALUES (1703, '2023-12-29', 294, 150);
INSERT INTO `consumed` VALUES (1704, '2023-12-29', 292, 250);
INSERT INTO `consumed` VALUES (1705, '2023-12-30', 12, 290);
INSERT INTO `consumed` VALUES (1706, '2023-12-30', 294, 150);
INSERT INTO `consumed` VALUES (1707, '2023-12-30', 289, 115);
INSERT INTO `consumed` VALUES (1708, '2023-12-30', 292, 125);
INSERT INTO `consumed` VALUES (1709, '2023-12-30', 286, 300);
INSERT INTO `consumed` VALUES (1710, '2023-12-30', 27, 270);
INSERT INTO `consumed` VALUES (1711, '2023-12-30', 274, 200);
INSERT INTO `consumed` VALUES (1712, '2023-12-30', 282, 150);
INSERT INTO `consumed` VALUES (1713, '2023-12-30', 52, 300);
INSERT INTO `consumed` VALUES (1714, '2023-12-30', 265, 930);
INSERT INTO `consumed` VALUES (1715, '2023-12-31', 12, 580);
INSERT INTO `consumed` VALUES (1716, '2023-12-31', 27, 270);
INSERT INTO `consumed` VALUES (1717, '2023-12-31', 274, 200);
INSERT INTO `consumed` VALUES (1718, '2023-12-31', 280, 130);
INSERT INTO `consumed` VALUES (1719, '2023-12-31', 282, 150);
INSERT INTO `consumed` VALUES (1720, '2023-12-31', 52, 300);
INSERT INTO `consumed` VALUES (1721, '2024-01-01', 12, 290);
INSERT INTO `consumed` VALUES (1722, '2024-01-01', 27, 270);
INSERT INTO `consumed` VALUES (1723, '2024-01-01', 274, 200);
INSERT INTO `consumed` VALUES (1724, '2024-01-01', 282, 150);
INSERT INTO `consumed` VALUES (1725, '2024-01-01', 280, 130);
INSERT INTO `consumed` VALUES (1726, '2024-01-01', 52, 300);
INSERT INTO `consumed` VALUES (1727, '2024-01-01', 286, 150);
INSERT INTO `consumed` VALUES (1728, '2024-01-01', 294, 300);
INSERT INTO `consumed` VALUES (1729, '2024-01-02', 12, 290);
INSERT INTO `consumed` VALUES (1730, '2024-01-02', 27, 270);
INSERT INTO `consumed` VALUES (1731, '2024-01-02', 274, 200);
INSERT INTO `consumed` VALUES (1732, '2024-01-02', 266, 130);
INSERT INTO `consumed` VALUES (1733, '2024-01-02', 282, 150);
INSERT INTO `consumed` VALUES (1734, '2024-01-02', 52, 300);
INSERT INTO `consumed` VALUES (1735, '2024-01-03', 275, 340);
INSERT INTO `consumed` VALUES (1736, '2024-01-03', 296, 520);
INSERT INTO `consumed` VALUES (1737, '2024-01-03', 297, 140);
INSERT INTO `consumed` VALUES (1738, '2024-01-03', 298, 330);
INSERT INTO `consumed` VALUES (1739, '2024-01-02', 298, 330);
INSERT INTO `consumed` VALUES (1740, '2024-01-02', 297, 70);
INSERT INTO `consumed` VALUES (1741, '2024-01-03', 27, 270);
INSERT INTO `consumed` VALUES (1742, '2024-01-03', 274, 200);
INSERT INTO `consumed` VALUES (1743, '2024-01-03', 266, 130);
INSERT INTO `consumed` VALUES (1744, '2024-01-03', 282, 150);
INSERT INTO `consumed` VALUES (1745, '2024-01-03', 52, 300);
INSERT INTO `consumed` VALUES (1746, '2024-01-03', 276, 950);
INSERT INTO `consumed` VALUES (1747, '2024-01-03', 294, 150);
INSERT INTO `consumed` VALUES (1748, '2024-01-03', 299, 500);
INSERT INTO `consumed` VALUES (1750, '2024-01-04', 290, 150);
INSERT INTO `consumed` VALUES (1751, '2024-01-04', 279, 300);
INSERT INTO `consumed` VALUES (1752, '2024-01-04', 27, 270);
INSERT INTO `consumed` VALUES (1753, '2024-01-04', 274, 200);
INSERT INTO `consumed` VALUES (1754, '2024-01-04', 266, 130);
INSERT INTO `consumed` VALUES (1755, '2024-01-04', 277, 140);
INSERT INTO `consumed` VALUES (1756, '2024-01-04', 52, 300);
INSERT INTO `consumed` VALUES (1757, '2024-01-04', 271, 305);
INSERT INTO `consumed` VALUES (1758, '2024-02-03', 12, 290);
INSERT INTO `consumed` VALUES (1760, '2024-02-03', 27, 270);
INSERT INTO `consumed` VALUES (1761, '2024-02-03', 274, 200);
INSERT INTO `consumed` VALUES (1762, '2024-02-03', 300, 500);
INSERT INTO `consumed` VALUES (1763, '2024-02-03', 282, 150);
INSERT INTO `consumed` VALUES (1764, '2024-02-03', 52, 300);
INSERT INTO `consumed` VALUES (1765, '2024-02-03', 275, 170);
INSERT INTO `consumed` VALUES (1766, '2024-02-04', 12, 290);
INSERT INTO `consumed` VALUES (1767, '2024-02-04', 269, 100);
INSERT INTO `consumed` VALUES (1768, '2024-02-04', 27, 270);
INSERT INTO `consumed` VALUES (1769, '2024-02-04', 274, 200);
INSERT INTO `consumed` VALUES (1770, '2024-02-04', 5, 200);
INSERT INTO `consumed` VALUES (1771, '2024-02-04', 52, 600);
INSERT INTO `consumed` VALUES (1772, '2024-02-04', 8, 180);
INSERT INTO `consumed` VALUES (1773, '2024-02-05', 12, 290);
INSERT INTO `consumed` VALUES (1774, '2024-02-05', 4, 400);
INSERT INTO `consumed` VALUES (1775, '2024-02-05', 27, 270);
INSERT INTO `consumed` VALUES (1776, '2024-02-05', 269, 100);
INSERT INTO `consumed` VALUES (1777, '2024-02-05', 52, 300);
INSERT INTO `consumed` VALUES (1779, '2024-02-05', 8, 180);
INSERT INTO `consumed` VALUES (1780, '2024-02-06', 12, 290);
INSERT INTO `consumed` VALUES (1781, '2024-02-06', 47, 200);
INSERT INTO `consumed` VALUES (1782, '2024-02-06', 266, 130);
INSERT INTO `consumed` VALUES (1783, '2024-02-06', 27, 270);
INSERT INTO `consumed` VALUES (1785, '2024-02-06', 52, 600);
INSERT INTO `consumed` VALUES (1786, '2024-02-06', 8, 180);
INSERT INTO `consumed` VALUES (1787, '2024-02-07', 12, 290);
INSERT INTO `consumed` VALUES (1788, '2024-02-07', 27, 270);
INSERT INTO `consumed` VALUES (1789, '2024-02-07', 47, 200);
INSERT INTO `consumed` VALUES (1790, '2024-02-07', 280, 130);
INSERT INTO `consumed` VALUES (1791, '2024-02-07', 277, 140);
INSERT INTO `consumed` VALUES (1792, '2024-02-07', 52, 300);
INSERT INTO `consumed` VALUES (1793, '2024-02-08', 302, 270);
INSERT INTO `consumed` VALUES (1794, '2024-02-08', 27, 270);
INSERT INTO `consumed` VALUES (1795, '2024-02-08', 266, 130);
INSERT INTO `consumed` VALUES (1796, '2024-02-08', 47, 200);
INSERT INTO `consumed` VALUES (1797, '2024-02-08', 277, 140);
INSERT INTO `consumed` VALUES (1798, '2024-02-08', 52, 300);
INSERT INTO `consumed` VALUES (1799, '2024-02-08', 304, 150);
INSERT INTO `consumed` VALUES (1800, '2024-02-08', 303, 60);
INSERT INTO `consumed` VALUES (1801, '2024-02-08', 290, 150);
INSERT INTO `consumed` VALUES (1802, '2024-02-08', 294, 150);
INSERT INTO `consumed` VALUES (1803, '2024-02-08', 300, 500);
INSERT INTO `consumed` VALUES (1804, '2024-02-09', 12, 290);
INSERT INTO `consumed` VALUES (1805, '2024-02-09', 304, 150);
INSERT INTO `consumed` VALUES (1806, '2024-02-09', 294, 150);
INSERT INTO `consumed` VALUES (1807, '2024-02-09', 290, 150);
INSERT INTO `consumed` VALUES (1808, '2024-02-09', 303, 60);
INSERT INTO `consumed` VALUES (1809, '2024-02-09', 27, 270);
INSERT INTO `consumed` VALUES (1810, '2024-02-09', 266, 130);
INSERT INTO `consumed` VALUES (1811, '2024-02-09', 47, 200);
INSERT INTO `consumed` VALUES (1812, '2024-02-09', 8, 180);
INSERT INTO `consumed` VALUES (1813, '2024-02-09', 52, 600);
INSERT INTO `consumed` VALUES (1814, '2024-02-09', 5, 200);
INSERT INTO `consumed` VALUES (1815, '2024-02-10', 12, 290);
INSERT INTO `consumed` VALUES (1816, '2024-02-10', 27, 270);
INSERT INTO `consumed` VALUES (1817, '2024-02-10', 8, 180);
INSERT INTO `consumed` VALUES (1818, '2024-02-10', 5, 200);
INSERT INTO `consumed` VALUES (1819, '2024-02-10', 52, 300);
INSERT INTO `consumed` VALUES (1820, '2024-02-10', 47, 200);
INSERT INTO `consumed` VALUES (1821, '2024-02-10', 266, 130);
INSERT INTO `consumed` VALUES (1823, '2024-02-18', 12, 290);
INSERT INTO `consumed` VALUES (1824, '2024-02-18', 27, 270);
INSERT INTO `consumed` VALUES (1825, '2024-02-18', 274, 200);
INSERT INTO `consumed` VALUES (1826, '2024-02-18', 266, 130);
INSERT INTO `consumed` VALUES (1827, '2024-02-18', 8, 180);
INSERT INTO `consumed` VALUES (1828, '2024-02-18', 52, 300);
INSERT INTO `consumed` VALUES (1829, '2024-03-29', 12, 290);
INSERT INTO `consumed` VALUES (1830, '2024-03-29', 305, 140);
INSERT INTO `consumed` VALUES (1831, '2024-03-29', 49, 390);
INSERT INTO `consumed` VALUES (1832, '2024-03-29', 274, 200);
INSERT INTO `consumed` VALUES (1833, '2024-03-29', 282, 150);
INSERT INTO `consumed` VALUES (1834, '2024-03-29', 278, 200);
INSERT INTO `consumed` VALUES (1835, '2024-03-30', 12, 290);
INSERT INTO `consumed` VALUES (1836, '2024-03-30', 305, 140);
INSERT INTO `consumed` VALUES (1837, '2024-03-30', 274, 200);
INSERT INTO `consumed` VALUES (1838, '2024-03-30', 291, 390);
INSERT INTO `consumed` VALUES (1839, '2024-03-30', 278, 100);
INSERT INTO `consumed` VALUES (1841, '2024-03-30', 282, 150);
INSERT INTO `consumed` VALUES (1842, '2024-03-31', 12, 290);
INSERT INTO `consumed` VALUES (1843, '2024-03-31', 274, 200);
INSERT INTO `consumed` VALUES (1844, '2024-03-31', 266, 130);
INSERT INTO `consumed` VALUES (1845, '2024-03-31', 27, 270);
INSERT INTO `consumed` VALUES (1846, '2024-03-31', 5, 200);
INSERT INTO `consumed` VALUES (1847, '2024-03-31', 26, 200);
INSERT INTO `consumed` VALUES (1848, '2024-03-31', 52, 300);
INSERT INTO `consumed` VALUES (1849, '2024-04-01', 12, 290);
INSERT INTO `consumed` VALUES (1850, '2024-04-01', 27, 270);
INSERT INTO `consumed` VALUES (1851, '2024-04-01', 274, 200);
INSERT INTO `consumed` VALUES (1853, '2024-04-01', 280, 130);
INSERT INTO `consumed` VALUES (1854, '2024-04-01', 5, 200);
INSERT INTO `consumed` VALUES (1855, '2024-04-01', 8, 180);
INSERT INTO `consumed` VALUES (1856, '2024-04-01', 52, 400);
INSERT INTO `consumed` VALUES (1857, '2024-04-02', 306, 210);
INSERT INTO `consumed` VALUES (1858, '2024-04-02', 27, 270);
INSERT INTO `consumed` VALUES (1859, '2024-04-02', 266, 130);
INSERT INTO `consumed` VALUES (1860, '2024-04-02', 274, 200);
INSERT INTO `consumed` VALUES (1861, '2024-04-02', 282, 150);
INSERT INTO `consumed` VALUES (1862, '2024-04-02', 52, 300);
INSERT INTO `consumed` VALUES (1863, '2024-04-03', 15, 230);
INSERT INTO `consumed` VALUES (1864, '2024-04-03', 27, 270);
INSERT INTO `consumed` VALUES (1865, '2024-04-03', 274, 200);
INSERT INTO `consumed` VALUES (1867, '2024-04-03', 280, 130);
INSERT INTO `consumed` VALUES (1868, '2024-04-03', 8, 180);
INSERT INTO `consumed` VALUES (1869, '2024-04-03', 52, 400);
INSERT INTO `consumed` VALUES (1870, '2024-04-03', 5, 200);
INSERT INTO `consumed` VALUES (1871, '2024-04-03', 307, 320);
INSERT INTO `consumed` VALUES (1872, '2024-04-03', 294, 150);
INSERT INTO `consumed` VALUES (1873, '2024-04-03', 290, 150);
INSERT INTO `consumed` VALUES (1874, '2024-04-03', 303, 60);
INSERT INTO `consumed` VALUES (1876, '2024-06-06', 12, 290);
INSERT INTO `consumed` VALUES (1877, '2024-06-06', 25, 150);
INSERT INTO `consumed` VALUES (1878, '2024-06-15', 25, 300);
INSERT INTO `consumed` VALUES (1879, '2024-06-15', 282, 900);
INSERT INTO `consumed` VALUES (1880, '2024-06-15', 266, 130);

-- ----------------------------
-- Table structure for limitation
-- ----------------------------
DROP TABLE IF EXISTS `limitation`;
CREATE TABLE `limitation`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `account_id` int UNSIGNED NOT NULL,
  `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `b` decimal(5, 2) UNSIGNED NULL DEFAULT NULL,
  `j` decimal(5, 2) UNSIGNED NULL DEFAULT NULL,
  `u` decimal(5, 2) UNSIGNED NULL DEFAULT NULL,
  `b_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`b` * 4)) VIRTUAL NULL,
  `j_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`j` * 9)) VIRTUAL NULL,
  `u_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`u` * 4)) VIRTUAL NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `limitation_account_account_id_fk`(`account_id` ASC) USING BTREE,
  CONSTRAINT `limitation_account_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of limitation
-- ----------------------------
INSERT INTO `limitation` VALUES (1, 1, 'Похудение', 1.50, 0.50, NULL, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `limitation` VALUES (50, 14, 'Похудение', 1.50, 0.50, NULL, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `limitation` VALUES (51, 15, 'Похудение', 1.50, 0.50, NULL, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `limitation` VALUES (52, 16, 'Похудение', 1.50, 0.50, NULL, DEFAULT, DEFAULT, DEFAULT);

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `store_id` int UNSIGNED NOT NULL,
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `portion_gram` decimal(4, 0) UNSIGNED NOT NULL,
  `b` decimal(5, 2) UNSIGNED NOT NULL,
  `j` decimal(5, 2) UNSIGNED NOT NULL,
  `u` decimal(5, 2) UNSIGNED NOT NULL,
  `b_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`b` * 4)) VIRTUAL NOT NULL,
  `j_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`j` * 9)) VIRTUAL NOT NULL,
  `u_to_kkal` decimal(6, 2) UNSIGNED GENERATED ALWAYS AS ((`u` * 4)) VIRTUAL NOT NULL,
  `kkal` decimal(7, 2) UNSIGNED GENERATED ALWAYS AS (((`b_to_kkal` + `j_to_kkal`) + `u_to_kkal`)) VIRTUAL NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `product_store_store_id_fk`(`store_id` ASC) USING BTREE,
  CONSTRAINT `product_store_store_id_fk` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 308 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'bju and kkal values: per 100 gram' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES (1, 1, 'ветчина империя вкуса', 400, 9.00, 3.00, 5.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (2, 1, 'греческий салат', 245, 8.00, 19.00, 10.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (3, 1, 'кето-омлет с лососем и луком порей (без соуса)', 200, 22.00, 26.00, 3.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (4, 1, 'макароны в сливочном соусе', 200, 5.12, 6.51, 16.44, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (5, 1, 'овощи на пару', 200, 2.50, 2.00, 13.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (6, 1, 'омлет с овощами и моцароллой', 155, 15.00, 19.00, 7.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (7, 1, 'рис басмати', 150, 2.90, 5.50, 25.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (8, 1, 'салат айсберг', 180, 1.50, 0.20, 2.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (9, 1, 'салат винегрет', 200, 4.00, 9.00, 21.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (10, 1, 'салат неаполь (айсберг+радиччо+романо)', 130, 1.50, 0.20, 2.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (11, 1, 'салат цезарь (без соуса)', 195, 18.00, 6.00, 14.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (12, 1, 'скрэмбл с куриными кебабами, овощами (без соуса)', 290, 33.00, 18.00, 11.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (13, 1, 'стаканчик яблочек (нарезанное зеленое яблоко)', 150, 0.40, 0.40, 9.80, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (14, 1, 'фриттата с креветками и овощами', 265, 28.00, 22.00, 9.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (15, 1, 'скрэмбл с ветчиной из индейки и сыром чеддер', 220, 18.00, 28.00, 6.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (16, 1, 'капуста тушёная с кабачками', 200, 1.60, 2.40, 5.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (17, 1, 'салат с жареными шампиньонами', 220, 5.00, 19.00, 18.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (24, 1, 'кето-омлет с лососем и луком порей (без соуса)', 200, 26.00, 28.00, 3.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (25, 1, 'гречка отварная с маслом', 150, 4.30, 5.40, 23.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (26, 1, 'греческий салат (без сыра)', 200, 2.00, 0.20, 10.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (27, 1, 'суп борщ вегетарианский', 270, 1.30, 3.30, 9.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (28, 1, 'капуста тушеная с сосисками', 220, 3.40, 14.30, 4.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (29, 1, 'каша гречневая с овощами', 200, 2.30, 2.10, 12.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (30, 1, 'салат оливье с растительным филе со вкусом курицы', 200, 4.40, 9.00, 11.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (45, 1, 'тефтели из куриного филе с гречкой (без соуса)', 330, 7.60, 3.60, 28.25, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (46, 2, 'омлет с ветчиной и томатами', 327, 15.30, 11.80, 3.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (47, 2, 'гречка отварная с овощами', 200, 4.10, 4.70, 23.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (48, 2, 'солянка из сёмги и форели', 300, 3.50, 3.10, 5.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (49, 2, 'борщ вегетарианский', 390, 1.00, 3.20, 8.30, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (50, 2, 'салат с северной креветкой', 236, 6.20, 13.30, 3.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (51, 1, 'яблочные чипсы', 25, 1.13, 0.40, 73.20, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (52, 1, 'яблоки зеленые', 600, 0.40, 0.40, 9.80, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (260, 51, 'Салат «Цезарь»', 180, 12.20, 14.30, 7.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (261, 1, 'запечённая треска с овощами в сливочном соусе', 290, 21.00, 34.00, 20.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (262, 1, 'филе трески с брокколи (без соуса)', 190, 11.00, 1.20, 4.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (263, 52, 'Фруктовый микс манго, клубника', 220, 0.80, 0.40, 11.10, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (264, 52, 'Кефир 1%', 930, 3.30, 1.00, 4.50, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (265, 1, 'кефир Bio Баланс turbo fit', 930, 3.00, 1.00, 4.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (266, 1, 'филе тунца fortuna', 130, 24.60, 0.45, 0.20, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (267, 1, 'горбуша Беринг', 245, 21.00, 6.00, 0.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (269, 1, 'филе тунца маруго', 100, 16.00, 0.20, 0.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (270, 1, 'арбуз нарезанный', 500, 0.70, 0.10, 5.80, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (271, 1, 'омлет три сыра с овощами', 305, 28.00, 22.00, 4.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (272, 1, 'омлет три сыра с овощами (без йогурта)', 305, 28.00, 22.00, 4.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (273, 1, 'финский сливочный суп', 320, 7.00, 18.00, 8.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (274, 1, 'каша гречневая с овощами (из казана)', 200, 2.40, 4.00, 23.70, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (275, 1, 'лосось на пару с брокколи (без йогурта)', 170, 20.00, 7.00, 4.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (276, 1, 'кефир из лавки', 950, 3.00, 1.00, 4.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (277, 2, 'салатный микс цезарь (айсберг+романо)', 140, 0.00, 0.00, 3.50, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (278, 2, 'яблоки зеленые', 100, 0.00, 0.00, 9.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (279, 2, 'омлет с брокколи', 300, 10.20, 7.30, 4.20, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (280, 1, 'филе тунца fortuna рубленный', 130, 20.80, 0.93, 0.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (281, 2, 'борщ вегетарианский без картофеля с красной фасолью', 300, 0.80, 1.00, 5.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (282, 1, 'салат Белая Дача (айсберг+романо)', 150, 1.50, 0.20, 2.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (283, 1, 'мороженое с протеином \"банан\" без сахара', 75, 16.00, 2.00, 7.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (284, 1, 'мороженое с протеином \"карамель\" без сахара', 75, 16.00, 7.00, 12.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (285, 1, 'фруктовый микс яблоко, виноград, клубника, грецкий орех', 140, 3.00, 12.00, 12.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (286, 1, 'ягодный микс голубика малина клубника', 150, 1.00, 0.50, 12.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (287, 1, 'фруктовый микс манго голубика', 140, 0.80, 0.40, 12.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (288, 1, 'фруктовый микс голубика клубника ананас кокос', 125, 1.00, 10.00, 11.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (289, 1, 'фруктовый микс манго клубника голубика миндаль', 115, 3.00, 7.00, 12.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (290, 1, 'мороженое протеиновое соленая карамель со сливками без сахара', 150, 15.00, 6.00, 14.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (291, 2, 'борщ вегетарианский', 390, 1.30, 3.30, 9.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (292, 1, 'голубика', 125, 1.00, 0.50, 6.60, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (293, 1, 'мороженое протеиновое без сахара бельгийский шоколад', 90, 15.00, 6.00, 19.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (294, 1, 'мороженое протеиновое с фундуком пастой арахисом', 150, 15.00, 6.00, 14.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (295, 1, 'паровая котлета из индейки с овощным миксом', 190, 15.00, 23.00, 13.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (296, 1, 'икра кабачковая из лавки', 520, 0.00, 7.00, 7.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (297, 1, 'мороженое протеиновое bombbar пломбир', 70, 15.00, 14.00, 12.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (298, 1, 'лимонад bombbar вкус арбуза без сахара', 330, 0.00, 0.00, 0.50, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (299, 1, 'виноград', 500, 0.60, 0.20, 16.80, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (300, 1, 'напиток exponenta дыня', 500, 6.00, 0.00, 3.00, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (302, 1, 'кето тефтели из индейки и шпината', 180, 13.00, 10.20, 2.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (303, 1, 'наполеон без сахара', 60, 5.90, 16.70, 20.40, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (304, 1, 'фисташки с солью', 150, 21.20, 52.60, 16.70, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (305, 2, 'блин-омлет с куриным филе', 140, 16.70, 19.90, 1.70, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (306, 1, 'жареный омлет с форелью, сыром, шпинатом', 210, 12.40, 11.00, 1.70, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `product` VALUES (307, 2, 'омлет с беконом и ветчиной', 320, 13.53, 19.14, 0.81, DEFAULT, DEFAULT, DEFAULT, DEFAULT);

-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'string or json',
  `roles` json NULL COMMENT 'json array with roles names, example: [\"owner\",\"admin\"]',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `key`(`key` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'Create OAuth 2.0 client id: https://console.cloud.google.com/apis/credentials' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of setting
-- ----------------------------
INSERT INTO `setting` VALUES (1, 'owner_contacts', '(owner contacts undefined, update in setting table, example: <a href=\'https://yours.site\' target=\'_blank\'>yours.site</a>)', NULL);
INSERT INTO `setting` VALUES (2, 'recommendations_json', '{\"ru\":\"Белки:\nЯичный белок\nКуриные грудки\nПостная говядина\nМорская говядина - тунец\nКонсервированный в собственном соку\nКусковой, не рубленный. Не салатный\nОбезжиренный творог. Без крахмала\nПостепенно менять на казеин\nРыба\nИндейка\n\nЖиры:\nОливковое масло\nЛьняное масло\nКунжутное масло\nЖидкие ненасыщенные жиры\nПодсолнечное масло\n\nУглеводы:\nОвсянка\nГречка\nПерловка\nРис красный,Неочищенный (белый рис нельзя!)\nМакароны из твёрдых сортов пшеницы\n\nКлетчатка:\nБрокколи\nЦветная капуста\nЛюбая зелень\nОгурцы\n\nСпециальные добавки:\nТвёрдые сыры\nАрахисовая паста\nОрехи (жиры):\nГрецкие, Кунжут, Кешью\nМаксимум 25-30 грамм в день\nЛюбые орехи\n\nФрукты:\nЗеленые яблоки\n\nне забывайте получать полезные жиры [орехи например грецкие] и пить витамины / клетчатку\n\nБелки с утра до 12:00 и вечером после 18:00\nКлетчатка в любое время\nЖиры и все углеводы до 18:00\nПитание каждые 3 часа\nРазмер порции примерно как 2 пачки сигарет\nЗа 2 часа до сна не есть\",\n\"en\":\"Proteins:\nEgg white\nChicken breasts\nlean beef\nSea beef - tuna\nCanned in own juice\nLumpy, not chopped. Not salad\nSkim cheese. starch free\nGradually change to casein\nFish\nTurkey\n\nFats:\nOlive oil\nLinseed oil\nSesame oil\nLiquid unsaturated fats\nSunflower oil\n\nCarbohydrates:\nOatmeal\nBuckwheat\nPearl barley\nRice red, Unpeeled (white rice is not allowed!)\nDurum wheat pasta\n\nCellulose:\nBroccoli\nCauliflower\nAny greens\ncucumbers\n\nSpecial Additives:\nhard cheeses\nPeanut paste\nNuts (fats):\nWalnuts, Sesame, Cashew\nMaximum 25-30 grams per day\nAny nuts\n\nFruits:\ngreen apples\n\nremember to get healthy fats [eg walnuts] and vitamins/fiber\n\nProteins in the morning before 12:00 and in the evening after 18:00\nFiber at any time\nFats and all carbohydrates until 18:00\nMeals every 3 hours\nThe serving size is about the same as 2 packs of cigarettes\nDo not eat 2 hours before bedtime\"\n}', '[\"redactor\"]');
INSERT INTO `setting` VALUES (3, 'description_json', '{\"ru\":\"Сайт поможет вам в похудении! У нас вы сможете вести учет потребления калорий, вести журнал продуктов, которые вы употребляете, вести журнал своего веса, отслеживать вес и потреблённые продукты остальных пользователей. Получите все необходимые инструменты для достижения своей цели по снижению веса.\",\r\n\"en\":\"The site will help you in losing weight! With us you can keep track of your calorie intake, keep a log of the foods you eat, keep a log of your weight, track the weight and foods consumed by other users. Get all the tools you need to reach your weight loss goal.\"}', NULL);
INSERT INTO `setting` VALUES (4, 'donate_links_json', '{\n	\"htmls\": [\n		\"<iframe src=\\\"https://yoomoney.ru/quickpay/fundraise/button?billNumber=35jwKATNGtI.230604&\\\" width=\\\"330\\\" height=\\\"50\\\" frameborder=\\\"0\\\" allowtransparency=\\\"true\\\" scrolling=\\\"no\\\"></iframe>\",\n		\"<iframe src=\\\"https://yoomoney.ru/quickpay/fundraise/button?billNumber=BNhJyQLg3Ds.230604&\\\" width=\\\"330\\\" height=\\\"50\\\" frameborder=\\\"0\\\" allowtransparency=\\\"true\\\" scrolling=\\\"no\\\"></iframe>\",\n		\"<iframe src=\\\"https://yoomoney.ru/quickpay/fundraise/button?billNumber=p3jKxwLiLBE.230604&\\\" width=\\\"330\\\" height=\\\"50\\\" frameborder=\\\"0\\\" allowtransparency=\\\"true\\\" scrolling=\\\"no\\\"></iframe>\",\n\"<iframe src=\\\"https://yoomoney.ru/quickpay/fundraise/button?billNumber=ggQplQPZIag.230604&\\\" width=\\\"330\\\" height=\\\"50\\\" frameborder=\\\"0\\\" allowtransparency=\\\"true\\\" scrolling=\\\"no\\\"></iframe>\"\n    ],\n	\"directUrl\": \"https://yoomoney.ru/to/4100118034317855\",\n	\"en\": {\n		\"pay\": \"Did the site help you lose weight?\"\n	}\n	\"ru\": {\n		\"pay\": \"Сайт помог похудеть?\"\n	}\n}', NULL);
INSERT INTO `setting` VALUES (5, 'metric_scripts', '(html metric scripts undefined, update in setting table (yandex.metrika, rambler.top100, rating.mail.ru, google.analytics, etc...))', NULL);
INSERT INTO `setting` VALUES (6, 'google_client_id', '38306472989-5ug4499s4p14lp0hcrqtilikqttrt9vg.apps.googleusercontent.com', NULL);
INSERT INTO `setting` VALUES (7, 'google_client_secret', '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', NULL);
INSERT INTO `setting` VALUES (8, 'google_callback', 'http://localhost:8080/account', NULL);
INSERT INTO `setting` VALUES (9, 'google_userinfo_url', 'https://www.googleapis.com/oauth2/v3/userinfo', NULL);

-- ----------------------------
-- Table structure for store
-- ----------------------------
DROP TABLE IF EXISTS `store`;
CREATE TABLE `store`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `account_id` int UNSIGNED NOT NULL,
  `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `store_account_account_id_fk`(`account_id` ASC) USING BTREE,
  INDEX `updated_at`(`updated_at` ASC) USING BTREE,
  CONSTRAINT `store_account_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of store
-- ----------------------------
INSERT INTO `store` VALUES (1, '2024-04-02 12:28:07', 1, 'Яндекс.Лавка');
INSERT INTO `store` VALUES (2, '2024-04-04 02:50:35', 1, 'Вкусвилл');
INSERT INTO `store` VALUES (51, '2023-06-23 12:09:19', 14, 'ВкусВилл');
INSERT INTO `store` VALUES (52, '2023-07-20 01:47:09', 1, 'Азбука вкуса');

-- ----------------------------
-- Table structure for weight
-- ----------------------------
DROP TABLE IF EXISTS `weight`;
CREATE TABLE `weight`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `account_id` int UNSIGNED NOT NULL,
  `kilogram` decimal(4, 1) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `date`(`date` ASC) USING BTREE,
  INDEX `weight_account_account_id_fk`(`account_id` ASC) USING BTREE,
  CONSTRAINT `weight_account_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 342 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of weight
-- ----------------------------
INSERT INTO `weight` VALUES (1, '2023-04-04', 1, 156.0);
INSERT INTO `weight` VALUES (2, '2023-04-05', 1, 155.0);
INSERT INTO `weight` VALUES (3, '2023-04-06', 1, 154.0);
INSERT INTO `weight` VALUES (4, '2023-04-07', 1, 153.2);
INSERT INTO `weight` VALUES (5, '2023-04-08', 1, 152.5);
INSERT INTO `weight` VALUES (6, '2023-04-09', 1, 152.0);
INSERT INTO `weight` VALUES (7, '2023-04-10', 1, 151.8);
INSERT INTO `weight` VALUES (8, '2023-04-11', 1, 152.2);
INSERT INTO `weight` VALUES (9, '2023-04-12', 1, 152.4);
INSERT INTO `weight` VALUES (10, '2023-04-13', 1, 151.5);
INSERT INTO `weight` VALUES (16, '2023-04-14', 1, 151.0);
INSERT INTO `weight` VALUES (27, '2023-04-15', 1, 150.8);
INSERT INTO `weight` VALUES (31, '2023-04-16', 1, 150.2);
INSERT INTO `weight` VALUES (37, '2023-04-17', 1, 150.0);
INSERT INTO `weight` VALUES (38, '2023-04-18', 1, 150.0);
INSERT INTO `weight` VALUES (39, '2023-04-19', 1, 149.0);
INSERT INTO `weight` VALUES (40, '2023-04-20', 1, 148.0);
INSERT INTO `weight` VALUES (41, '2023-04-21', 1, 148.0);
INSERT INTO `weight` VALUES (42, '2023-04-22', 1, 148.5);
INSERT INTO `weight` VALUES (43, '2023-04-23', 1, 148.7);
INSERT INTO `weight` VALUES (44, '2023-04-24', 1, 147.5);
INSERT INTO `weight` VALUES (45, '2023-04-25', 1, 147.2);
INSERT INTO `weight` VALUES (46, '2023-04-26', 1, 147.0);
INSERT INTO `weight` VALUES (47, '2023-04-03', 1, 157.0);
INSERT INTO `weight` VALUES (48, '2023-04-02', 1, 158.0);
INSERT INTO `weight` VALUES (49, '2023-04-01', 1, 160.0);
INSERT INTO `weight` VALUES (50, '2023-04-27', 1, 146.5);
INSERT INTO `weight` VALUES (51, '2023-04-28', 1, 147.3);
INSERT INTO `weight` VALUES (52, '2023-04-29', 1, 147.5);
INSERT INTO `weight` VALUES (53, '2023-04-30', 1, 146.5);
INSERT INTO `weight` VALUES (54, '2023-05-01', 1, 145.5);
INSERT INTO `weight` VALUES (55, '2023-05-02', 1, 145.1);
INSERT INTO `weight` VALUES (56, '2023-05-03', 1, 145.5);
INSERT INTO `weight` VALUES (57, '2023-05-04', 1, 145.2);
INSERT INTO `weight` VALUES (58, '2023-05-05', 1, 146.3);
INSERT INTO `weight` VALUES (59, '2023-06-15', 1, 137.8);
INSERT INTO `weight` VALUES (121, '2023-06-13', 1, 137.1);
INSERT INTO `weight` VALUES (133, '2023-06-14', 1, 137.5);
INSERT INTO `weight` VALUES (134, '2023-06-16', 1, 137.4);
INSERT INTO `weight` VALUES (135, '2023-06-17', 1, 137.0);
INSERT INTO `weight` VALUES (136, '2023-06-21', 1, 136.5);
INSERT INTO `weight` VALUES (141, '2023-06-23', 14, 90.0);
INSERT INTO `weight` VALUES (142, '2023-06-25', 1, 136.5);
INSERT INTO `weight` VALUES (143, '2023-06-26', 1, 136.5);
INSERT INTO `weight` VALUES (144, '2023-06-27', 1, 135.5);
INSERT INTO `weight` VALUES (145, '2023-06-28', 1, 135.5);
INSERT INTO `weight` VALUES (146, '2023-06-29', 1, 136.5);
INSERT INTO `weight` VALUES (147, '2023-06-30', 1, 135.9);
INSERT INTO `weight` VALUES (148, '2023-07-01', 1, 136.2);
INSERT INTO `weight` VALUES (149, '2023-07-02', 1, 135.1);
INSERT INTO `weight` VALUES (150, '2023-07-03', 1, 135.3);
INSERT INTO `weight` VALUES (151, '2023-07-04', 1, 134.5);
INSERT INTO `weight` VALUES (152, '2023-07-05', 1, 134.4);
INSERT INTO `weight` VALUES (153, '2023-07-06', 1, 134.1);
INSERT INTO `weight` VALUES (154, '2023-07-07', 1, 134.4);
INSERT INTO `weight` VALUES (155, '2023-07-08', 1, 133.3);
INSERT INTO `weight` VALUES (156, '2023-07-09', 1, 132.2);
INSERT INTO `weight` VALUES (157, '2023-07-10', 1, 132.2);
INSERT INTO `weight` VALUES (158, '2023-07-11', 1, 132.8);
INSERT INTO `weight` VALUES (159, '2023-07-12', 1, 133.5);
INSERT INTO `weight` VALUES (160, '2023-07-13', 1, 132.7);
INSERT INTO `weight` VALUES (161, '2023-07-14', 1, 132.3);
INSERT INTO `weight` VALUES (162, '2023-07-15', 1, 132.7);
INSERT INTO `weight` VALUES (163, '2023-07-16', 1, 133.2);
INSERT INTO `weight` VALUES (164, '2023-07-17', 1, 132.0);
INSERT INTO `weight` VALUES (165, '2023-07-18', 1, 132.2);
INSERT INTO `weight` VALUES (166, '2023-07-19', 1, 132.2);
INSERT INTO `weight` VALUES (167, '2023-07-20', 1, 132.1);
INSERT INTO `weight` VALUES (168, '2023-07-21', 1, 131.9);
INSERT INTO `weight` VALUES (169, '2023-07-22', 1, 132.0);
INSERT INTO `weight` VALUES (170, '2023-07-23', 1, 131.8);
INSERT INTO `weight` VALUES (171, '2023-07-24', 1, 131.4);
INSERT INTO `weight` VALUES (172, '2023-07-25', 1, 130.8);
INSERT INTO `weight` VALUES (173, '2023-07-26', 1, 131.1);
INSERT INTO `weight` VALUES (174, '2023-07-27', 1, 130.5);
INSERT INTO `weight` VALUES (175, '2023-07-28', 1, 129.9);
INSERT INTO `weight` VALUES (176, '2023-07-29', 1, 129.2);
INSERT INTO `weight` VALUES (177, '2023-07-30', 1, 129.5);
INSERT INTO `weight` VALUES (178, '2023-07-31', 1, 130.0);
INSERT INTO `weight` VALUES (179, '2023-08-01', 1, 129.5);
INSERT INTO `weight` VALUES (180, '2023-08-02', 1, 129.7);
INSERT INTO `weight` VALUES (181, '2023-08-03', 1, 129.0);
INSERT INTO `weight` VALUES (182, '2023-08-04', 1, 128.8);
INSERT INTO `weight` VALUES (183, '2023-08-05', 1, 128.4);
INSERT INTO `weight` VALUES (184, '2023-08-06', 1, 128.4);
INSERT INTO `weight` VALUES (185, '2023-08-07', 1, 128.4);
INSERT INTO `weight` VALUES (186, '2023-08-08', 1, 128.2);
INSERT INTO `weight` VALUES (187, '2023-08-09', 1, 127.7);
INSERT INTO `weight` VALUES (188, '2023-08-10', 1, 127.7);
INSERT INTO `weight` VALUES (189, '2023-08-11', 1, 127.8);
INSERT INTO `weight` VALUES (190, '2023-08-12', 1, 127.6);
INSERT INTO `weight` VALUES (191, '2023-08-13', 1, 127.1);
INSERT INTO `weight` VALUES (192, '2023-08-14', 1, 127.7);
INSERT INTO `weight` VALUES (193, '2023-08-15', 1, 127.1);
INSERT INTO `weight` VALUES (194, '2023-08-16', 1, 125.8);
INSERT INTO `weight` VALUES (195, '2023-08-17', 1, 126.5);
INSERT INTO `weight` VALUES (196, '2023-08-18', 1, 126.0);
INSERT INTO `weight` VALUES (197, '2023-08-19', 1, 125.5);
INSERT INTO `weight` VALUES (198, '2023-08-20', 1, 126.5);
INSERT INTO `weight` VALUES (199, '2023-08-21', 1, 126.5);
INSERT INTO `weight` VALUES (200, '2023-08-22', 1, 126.6);
INSERT INTO `weight` VALUES (201, '2023-08-23', 1, 126.4);
INSERT INTO `weight` VALUES (202, '2023-08-24', 1, 126.4);
INSERT INTO `weight` VALUES (203, '2023-08-25', 1, 126.1);
INSERT INTO `weight` VALUES (204, '2023-08-26', 1, 126.6);
INSERT INTO `weight` VALUES (205, '2023-08-27', 1, 126.3);
INSERT INTO `weight` VALUES (206, '2023-08-28', 1, 126.6);
INSERT INTO `weight` VALUES (207, '2023-08-29', 1, 125.8);
INSERT INTO `weight` VALUES (208, '2023-08-30', 1, 125.8);
INSERT INTO `weight` VALUES (209, '2023-08-31', 1, 125.2);
INSERT INTO `weight` VALUES (210, '2023-09-01', 1, 124.6);
INSERT INTO `weight` VALUES (211, '2023-09-02', 1, 124.5);
INSERT INTO `weight` VALUES (212, '2023-09-03', 1, 124.6);
INSERT INTO `weight` VALUES (213, '2023-09-04', 1, 124.6);
INSERT INTO `weight` VALUES (214, '2023-09-05', 1, 124.7);
INSERT INTO `weight` VALUES (215, '2023-09-06', 1, 125.0);
INSERT INTO `weight` VALUES (216, '2023-09-07', 1, 124.6);
INSERT INTO `weight` VALUES (217, '2023-09-08', 1, 124.5);
INSERT INTO `weight` VALUES (218, '2023-09-09', 1, 124.2);
INSERT INTO `weight` VALUES (219, '2023-09-10', 1, 123.7);
INSERT INTO `weight` VALUES (220, '2023-09-11', 1, 123.5);
INSERT INTO `weight` VALUES (221, '2023-09-12', 1, 123.6);
INSERT INTO `weight` VALUES (222, '2023-09-13', 1, 123.4);
INSERT INTO `weight` VALUES (223, '2023-09-14', 1, 123.5);
INSERT INTO `weight` VALUES (224, '2023-09-15', 1, 123.1);
INSERT INTO `weight` VALUES (225, '2023-09-16', 1, 122.9);
INSERT INTO `weight` VALUES (226, '2023-09-17', 1, 122.6);
INSERT INTO `weight` VALUES (227, '2023-09-18', 1, 123.0);
INSERT INTO `weight` VALUES (228, '2023-09-19', 1, 122.7);
INSERT INTO `weight` VALUES (229, '2023-09-20', 1, 122.3);
INSERT INTO `weight` VALUES (230, '2023-09-21', 1, 122.2);
INSERT INTO `weight` VALUES (231, '2023-09-22', 1, 123.0);
INSERT INTO `weight` VALUES (232, '2023-09-23', 1, 122.2);
INSERT INTO `weight` VALUES (233, '2023-09-24', 1, 122.5);
INSERT INTO `weight` VALUES (234, '2023-09-25', 1, 122.4);
INSERT INTO `weight` VALUES (235, '2023-09-26', 1, 122.0);
INSERT INTO `weight` VALUES (236, '2023-09-27', 1, 122.2);
INSERT INTO `weight` VALUES (237, '2023-09-28', 1, 122.2);
INSERT INTO `weight` VALUES (238, '2023-09-29', 1, 121.4);
INSERT INTO `weight` VALUES (239, '2023-09-30', 1, 121.1);
INSERT INTO `weight` VALUES (240, '2023-10-01', 1, 121.0);
INSERT INTO `weight` VALUES (241, '2023-10-02', 1, 120.7);
INSERT INTO `weight` VALUES (242, '2023-10-03', 1, 120.2);
INSERT INTO `weight` VALUES (243, '2023-10-04', 1, 119.8);
INSERT INTO `weight` VALUES (244, '2023-10-05', 1, 120.1);
INSERT INTO `weight` VALUES (245, '2023-10-06', 1, 119.9);
INSERT INTO `weight` VALUES (246, '2023-10-07', 1, 120.2);
INSERT INTO `weight` VALUES (247, '2023-10-08', 1, 119.7);
INSERT INTO `weight` VALUES (248, '2023-10-09', 1, 119.6);
INSERT INTO `weight` VALUES (249, '2023-10-10', 1, 119.6);
INSERT INTO `weight` VALUES (250, '2023-10-23', 1, 116.8);
INSERT INTO `weight` VALUES (251, '2023-10-25', 1, 116.0);
INSERT INTO `weight` VALUES (252, '2023-10-24', 1, 116.4);
INSERT INTO `weight` VALUES (253, '2023-10-26', 1, 116.6);
INSERT INTO `weight` VALUES (254, '2023-10-27', 1, 115.8);
INSERT INTO `weight` VALUES (255, '2023-10-28', 1, 116.0);
INSERT INTO `weight` VALUES (256, '2023-10-29', 1, 115.0);
INSERT INTO `weight` VALUES (257, '2023-10-30', 1, 114.5);
INSERT INTO `weight` VALUES (258, '2023-10-31', 1, 114.8);
INSERT INTO `weight` VALUES (259, '2023-11-01', 1, 114.5);
INSERT INTO `weight` VALUES (260, '2023-11-02', 1, 114.3);
INSERT INTO `weight` VALUES (261, '2023-11-03', 1, 114.5);
INSERT INTO `weight` VALUES (262, '2023-11-04', 1, 114.5);
INSERT INTO `weight` VALUES (263, '2023-11-05', 1, 113.7);
INSERT INTO `weight` VALUES (264, '2023-11-06', 1, 113.4);
INSERT INTO `weight` VALUES (265, '2023-11-07', 1, 113.4);
INSERT INTO `weight` VALUES (266, '2023-11-08', 1, 113.2);
INSERT INTO `weight` VALUES (267, '2023-11-09', 1, 112.8);
INSERT INTO `weight` VALUES (268, '2023-11-10', 1, 113.2);
INSERT INTO `weight` VALUES (269, '2023-11-11', 1, 113.5);
INSERT INTO `weight` VALUES (270, '2023-11-12', 1, 113.0);
INSERT INTO `weight` VALUES (271, '2023-11-13', 1, 112.6);
INSERT INTO `weight` VALUES (272, '2023-11-14', 1, 113.2);
INSERT INTO `weight` VALUES (273, '2023-11-15', 1, 112.6);
INSERT INTO `weight` VALUES (274, '2023-11-16', 1, 112.5);
INSERT INTO `weight` VALUES (275, '2023-11-17', 1, 112.0);
INSERT INTO `weight` VALUES (276, '2023-11-18', 1, 111.8);
INSERT INTO `weight` VALUES (277, '2023-11-20', 1, 112.2);
INSERT INTO `weight` VALUES (278, '2023-11-19', 1, 112.0);
INSERT INTO `weight` VALUES (279, '2023-11-21', 1, 111.8);
INSERT INTO `weight` VALUES (280, '2023-11-22', 1, 112.4);
INSERT INTO `weight` VALUES (281, '2023-11-23', 1, 111.6);
INSERT INTO `weight` VALUES (282, '2023-11-24', 1, 111.4);
INSERT INTO `weight` VALUES (283, '2023-11-25', 1, 111.5);
INSERT INTO `weight` VALUES (284, '2023-11-26', 1, 111.3);
INSERT INTO `weight` VALUES (285, '2023-11-27', 1, 111.7);
INSERT INTO `weight` VALUES (286, '2023-11-28', 1, 111.7);
INSERT INTO `weight` VALUES (287, '2023-11-29', 1, 111.4);
INSERT INTO `weight` VALUES (288, '2023-11-30', 1, 111.3);
INSERT INTO `weight` VALUES (289, '2023-12-01', 1, 111.5);
INSERT INTO `weight` VALUES (290, '2023-12-02', 1, 111.6);
INSERT INTO `weight` VALUES (291, '2023-12-03', 1, 111.0);
INSERT INTO `weight` VALUES (292, '2023-12-04', 1, 110.9);
INSERT INTO `weight` VALUES (293, '2023-12-05', 1, 110.4);
INSERT INTO `weight` VALUES (294, '2023-12-06', 1, 109.9);
INSERT INTO `weight` VALUES (295, '2023-12-07', 1, 109.8);
INSERT INTO `weight` VALUES (296, '2023-12-08', 1, 110.0);
INSERT INTO `weight` VALUES (297, '2023-12-09', 1, 109.8);
INSERT INTO `weight` VALUES (298, '2023-12-10', 1, 109.8);
INSERT INTO `weight` VALUES (299, '2023-12-11', 1, 110.0);
INSERT INTO `weight` VALUES (300, '2023-12-12', 1, 109.9);
INSERT INTO `weight` VALUES (301, '2023-12-13', 1, 109.7);
INSERT INTO `weight` VALUES (302, '2023-12-14', 1, 110.4);
INSERT INTO `weight` VALUES (303, '2023-12-16', 1, 109.5);
INSERT INTO `weight` VALUES (304, '2023-12-15', 1, 110.0);
INSERT INTO `weight` VALUES (305, '2023-12-17', 1, 109.8);
INSERT INTO `weight` VALUES (306, '2023-12-18', 1, 109.8);
INSERT INTO `weight` VALUES (307, '2023-12-19', 1, 109.9);
INSERT INTO `weight` VALUES (308, '2023-12-20', 1, 110.9);
INSERT INTO `weight` VALUES (309, '2023-12-21', 1, 110.1);
INSERT INTO `weight` VALUES (310, '2023-12-22', 1, 109.3);
INSERT INTO `weight` VALUES (311, '2023-12-23', 1, 108.6);
INSERT INTO `weight` VALUES (312, '2023-12-24', 1, 108.6);
INSERT INTO `weight` VALUES (313, '2023-12-25', 1, 109.2);
INSERT INTO `weight` VALUES (314, '2023-12-26', 1, 109.8);
INSERT INTO `weight` VALUES (315, '2023-12-27', 1, 109.8);
INSERT INTO `weight` VALUES (316, '2023-12-28', 1, 108.9);
INSERT INTO `weight` VALUES (317, '2023-12-29', 1, 109.3);
INSERT INTO `weight` VALUES (318, '2023-12-30', 1, 109.5);
INSERT INTO `weight` VALUES (319, '2024-01-03', 1, 109.0);
INSERT INTO `weight` VALUES (320, '2024-01-04', 1, 109.8);
INSERT INTO `weight` VALUES (321, '2024-01-12', 1, 109.3);
INSERT INTO `weight` VALUES (322, '2024-02-03', 1, 112.8);
INSERT INTO `weight` VALUES (323, '2024-02-04', 1, 112.1);
INSERT INTO `weight` VALUES (324, '2024-02-05', 1, 111.4);
INSERT INTO `weight` VALUES (325, '2024-02-06', 1, 110.7);
INSERT INTO `weight` VALUES (326, '2024-02-07', 1, 110.7);
INSERT INTO `weight` VALUES (327, '2024-02-08', 1, 109.8);
INSERT INTO `weight` VALUES (328, '2024-02-09', 1, 111.2);
INSERT INTO `weight` VALUES (329, '2024-02-10', 1, 111.0);
INSERT INTO `weight` VALUES (330, '2024-02-12', 1, 110.2);
INSERT INTO `weight` VALUES (331, '2024-02-18', 1, 113.0);
INSERT INTO `weight` VALUES (332, '2024-03-29', 1, 123.4);
INSERT INTO `weight` VALUES (333, '2024-03-30', 1, 122.0);
INSERT INTO `weight` VALUES (334, '2024-03-31', 1, 120.5);
INSERT INTO `weight` VALUES (335, '2024-04-01', 1, 119.3);
INSERT INTO `weight` VALUES (336, '2024-04-02', 1, 118.4);
INSERT INTO `weight` VALUES (337, '2024-04-03', 1, 118.3);
INSERT INTO `weight` VALUES (338, '2024-04-13', 1, 120.6);
INSERT INTO `weight` VALUES (339, '2024-05-10', 1, 128.5);
INSERT INTO `weight` VALUES (340, '2024-06-04', 1, 135.0);
INSERT INTO `weight` VALUES (341, '2024-06-15', 1, 137.9);

-- ----------------------------
-- Triggers structure for table account
-- ----------------------------
DROP TRIGGER IF EXISTS `account_BEFORE_INSERT`;
delimiter ;;
CREATE TRIGGER `account_BEFORE_INSERT` BEFORE INSERT ON `account` FOR EACH ROW BEGIN
if(NEW.roles = cast('[]' as json)) then
 set NEW.roles = null;
end if;
if(NEW.is_banned = 0) then
 set NEW.is_banned = null;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table account
-- ----------------------------
DROP TRIGGER IF EXISTS `account_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `account_BEFORE_UPDATE` BEFORE UPDATE ON `account` FOR EACH ROW BEGIN
if(NEW.roles = cast('[]' as json)) then
 set NEW.roles = null;
end if;
if(NEW.is_banned = 0) then
 set NEW.is_banned = null;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table consumed
-- ----------------------------
DROP TRIGGER IF EXISTS `consumed_BEFORE_INSERT`;
delimiter ;;
CREATE TRIGGER `consumed_BEFORE_INSERT` BEFORE INSERT ON `consumed` FOR EACH ROW BEGIN
declare error_msg text;
declare existed_id int unsigned;
select id from consumed where
		date = NEW.date
    and product_id = NEW.product_id
    limit 1 into existed_id;
    
if (existed_id is not null) then
	set error_msg = concat('Unable to insert, due date=', NEW.date, ' and product_id=', NEW.product_id, ' already existed in id=', existed_id);
	SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_msg;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table consumed
-- ----------------------------
DROP TRIGGER IF EXISTS `consumed_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `consumed_BEFORE_UPDATE` BEFORE UPDATE ON `consumed` FOR EACH ROW BEGIN
declare error_msg text;
declare existed_id int unsigned;
if(!(OLD.date <=> NEW.date) or !(OLD.product_id <=> NEW.product_id)) then
	select id from consumed where
			date = NEW.date
			and product_id = NEW.product_id
			limit 1 into existed_id;

	if (existed_id is not null) then
		set error_msg = concat('Unable to update, due date=', NEW.date, ' and product_id=', NEW.product_id, ' already existed in id=', existed_id);
		SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_msg;
	end if;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table product
-- ----------------------------
DROP TRIGGER IF EXISTS `product_BEFORE_INSERT`;
delimiter ;;
CREATE TRIGGER `product_BEFORE_INSERT` BEFORE INSERT ON `product` FOR EACH ROW BEGIN
update store set updated_at=current_timestamp() where id=NEW.store_id;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table product
-- ----------------------------
DROP TRIGGER IF EXISTS `product_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `product_BEFORE_UPDATE` BEFORE UPDATE ON `product` FOR EACH ROW BEGIN
if(!(OLD.id <=> NEW.id)
 or !(OLD.store_id <=> NEW.store_id)
 or !(OLD.title <=> NEW.title)
 or !(OLD.portion_gram <=> NEW.portion_gram)
 or !(OLD.b <=> NEW.b)
 or !(OLD.j <=> NEW.j)
 or !(OLD.u <=> NEW.u)
 ) then
 update store set updated_at=current_timestamp() where id in (OLD.store_id, NEW.store_id);
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table product
-- ----------------------------
DROP TRIGGER IF EXISTS `product_BEFORE_DELETE`;
delimiter ;;
CREATE TRIGGER `product_BEFORE_DELETE` BEFORE DELETE ON `product` FOR EACH ROW BEGIN
update store set updated_at=current_timestamp() where id=OLD.store_id;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table setting
-- ----------------------------
DROP TRIGGER IF EXISTS `setting_BEFORE_INSERT`;
delimiter ;;
CREATE TRIGGER `setting_BEFORE_INSERT` BEFORE INSERT ON `setting` FOR EACH ROW BEGIN
if(NEW.roles = cast('[]' as json)) then
 set NEW.roles = null;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table setting
-- ----------------------------
DROP TRIGGER IF EXISTS `setting_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `setting_BEFORE_UPDATE` BEFORE UPDATE ON `setting` FOR EACH ROW BEGIN
if(NEW.roles = cast('[]' as json)) then
 set NEW.roles = null;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table store
-- ----------------------------
DROP TRIGGER IF EXISTS `store_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `store_BEFORE_UPDATE` BEFORE UPDATE ON `store` FOR EACH ROW BEGIN
if(!(OLD.title <=> NEW.title)) then
 set NEW.updated_at=current_timestamp();
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table weight
-- ----------------------------
DROP TRIGGER IF EXISTS `weight_BEFORE_INSERT`;
delimiter ;;
CREATE TRIGGER `weight_BEFORE_INSERT` BEFORE INSERT ON `weight` FOR EACH ROW BEGIN
declare error_msg text;
declare existed_id int unsigned;
select id from weight where
		date = NEW.date
    and account_id = NEW.account_id
    limit 1 into existed_id;
    
if (existed_id is not null) then
	set error_msg = concat('Unable to insert, due date=', NEW.date, ' and account_id=', NEW.account_id, ' already existed in id=', existed_id);
	SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_msg;
end if;
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table weight
-- ----------------------------
DROP TRIGGER IF EXISTS `weight_BEFORE_UPDATE`;
delimiter ;;
CREATE TRIGGER `weight_BEFORE_UPDATE` BEFORE UPDATE ON `weight` FOR EACH ROW BEGIN
declare error_msg text;
declare existed_id int unsigned;
if(!(OLD.date <=> NEW.date) or !(OLD.account_id <=> NEW.account_id)) then
	select id from weight where
			date = NEW.date
			and account_id = NEW.account_id
			limit 1 into existed_id;

	if (existed_id is not null) then
		set error_msg = concat('Unable to update, due date=', NEW.date, ' and account_id=', NEW.account_id, ' already existed in id=', existed_id);
		SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = error_msg;
	end if;
end if;
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;