New product creation

create_product.sql

INSERT INTO `product` (`id`, `name`, `sku`, `description`, `category_id`, `price_amount`, `price_currency`, `unit_per_product`, `unit_measure`, `cogs_amount`, `base64encoded_image`) VALUES (2, 'Porridge', 'PO1', '1 bag of Porridge', 2, 24000.00, 'UGX', 1, 'bags', 12000.00, 'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/4RDyRXhpZgAATU0AKgAAAAgABAE7AAIAAAANAAAISodpAAQAAAABAAAIWJydAAEAAAAaAAAQ0OocAAcAAAgMAAAAPgAAAAAc6gAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAERhbmllbCBOb2xhbgAAAAWQAwACAAAAFAAAEKaQBAACAAAAFAAAELqSkQACAAAAAzY5AACSkgACAAAAAzY5AADqHAAHAAAIDAAACJoAAAAAHOoAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAyMDE4OjEwOjEwIDExOjIyOjQyADIwMTg6MTA6MTAgMTE6MjI6NDIAAABEAGEAbgBpAGUAbAAgAE4AbwBsAGEAbgAAAP/hCx9odHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvADw/eHBhY2tldCBiZWdpbj0n77u/JyBpZD0nVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkJz8+DQo8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5zOm1ldGEvIj48cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPjxyZGY6RGVzY3JpcHRpb24gcmRmOmFib3V0PSJ1dWlkOmZhZjViZGQ1LWJhM2QtMTFkYS1hZDMxLWQzM2Q3NTE4MmYxYiIgeG1sbnM6ZGM9Imh0dHA6Ly9wdXJsLm9yZy9kYy9lbGVtZW50cy8xLjEvIi8+PHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9InV1aWQ6ZmFmNWJkZDUtYmEzZC0xMWRhLWFkMzEtZDMzZDc1MTgyZjFiIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iPjx4bXA6Q3JlYXRlRGF0ZT4yMDE4LTEwLTEwVDExOjIyOjQyLjY5MzwveG1wOkNyZWF0ZURhdGU+PC9yZGY6RGVzY3JpcHRpb24+PHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9InV1aWQ6ZmFmNWJkZDUtYmEzZC0xMWRhLWFkMzEtZDMzZDc1MTgyZjFiIiB4bWxuczpkYz0iaHR0cDovL3B1cmwub3JnL2RjL2VsZW1lbnRzLzEuMS8iPjxkYzpjcmVhdG9yPjxyZGY6U2VxIHhtbG5zOnJkZj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+PHJkZjpsaT5EYW5pZWwgTm9sYW48L3JkZjpsaT48L3JkZjpTZXE+DQoJCQk8L2RjOmNyZWF0b3I+PC9yZGY6RGVzY3JpcHRpb24+PC9yZGY6UkRGPjwveDp4bXBtZXRhPg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8P3hwYWNrZXQgZW5kPSd3Jz8+/9sAQwAHBQUGBQQHBgUGCAcHCAoRCwoJCQoVDxAMERgVGhkYFRgXGx4nIRsdJR0XGCIuIiUoKSssKxogLzMvKjInKisq/9sAQwEHCAgKCQoUCwsUKhwYHCoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq/8AAEQgA5wCOAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A9tvdZt9OmEU4csV3fKO1VT4qtc/LFIfyrM8T/wDISH/XIfzNYWSDVJGUpNM7EeKbU9YZB+IpT4mtQMiNz+Irjc9zQGp8pPOzsP8AhKLY/eif8DUEviG34MULn/eauYBytPH+rFFg52bzeKJB92BMe5NRt4mn6iGP8j/jWIenrTWPFUkhc7N0eKLgDiKL9f8AGnDxNcN/yyhx9D/jWAvWlckYxSsh87OjTxGw4khQj2JFWI/EsXQQjPoTiuT83nmpA4I5osHMzrl8RqeGt2B9mpJNbtn/ANaHHsGrl1n4wuce56UmSaLBzs6Q6tp3pIT9aifWbMfdikP1YVgbaXjbnOPWmLmZrz6pDc28sMcbozoV3bumR1ry/wARC+8KRx2+lXU9ul5K8vmBwHcKFAyQOmXb8q7qLaZBjnryPpXI/EDRtQ1eexbT1EwgjMbIpwVJOc8+uf0r0MBP97yS2e5yYr4ObqegeJuNQU9f3Y/mawG610viSDfdqVJ+4P61gGEjqK81HXLcgB5IpSCak8kg9KUR571RJHFndt61MOFxSeWYyMc0uM9qAG44NRE4OKmxQY89ulA7EatSuc4pduKQ9qAGHrShsUMpBo29xQJgH2tViObcMcGqxU0gYpIG7UwLZZuf6VC8mFIOan6KCOVPQ1EybqAHQEGZNrdT1FdTbWNtNZxNPAkjberKDXL20ZW4TPTcO1djbcW0Y/2RSTaLST3I9UgjmudxY528CsmSxJJwMVsl82SyHkkdfxqkbgBcEZqNS5JGYbI9xxVeS0dW+XkVqPLu6cVC8mOtMixSWBhnPcUwxYPSrbP36Uxvm6dKYiBYeTTxFkU8LThQBAYB6VE0YUg8VdwKiljyKYETwq65AqExbc+tWkztIprrTEUuRwRTWU/WrDpjrTQtMRJZxiWERsdpB4yOtWRYsvvVdRtwRVyC4JGD1pFJBCmyQZHet+Ntsaj0FY4fLLj1rSzx1oKWhDdXPl2MES9duTWcZSTUeoMYrmNhyGiXI/Cot2RkGoQpPUsFyaYxpisaGPNUTcU9KeozyaYoB4NTdqQIaRTeaceaaaYxRTW+6aUGlNMREtKwGKBwTQTQBE4yOlIi5pzAtwO9ToEhUFutAIj8k4pNpj5p73QxhME1VknIPzmgZcjk6HNbIORXMpcAkV0aN8tA0Yt27TSZK/KiKoP4VXRsH2qbUb7ANrGoABBY+pxVJXz1qUTLcuKakHNVEk4qaKX5ue1MRYQUrMB0qFrkfw0wyZoHclLk0m6o91JuoETBqeGFVw1Kr80xkhOJDQRmopn2lW/A1KjBlyKAAD5s1FNE8vKt+GKlJxTS+KAKbWzLyGwexFVyCxZXf5ge9Xy+5qp3MeZiRwaYiSGKJepLGulztYiuQXcrcmutlOH/AAH8qTLicxeEm8lz/fP86jBxU+ors1G4HpI386qihbEPcnRqeGyv41AOKUNz1oAnzzTg1Qg/MM05T60gJt3FKGqLdQD60AS7qN1RbqC2KYE7kPCV79RRbS8bTUSv6GowxBOOtAGg5wuTVcvn3qJpWY7XbIphO09aLBcsoRmo5l+aow+OlOLlxgjmmIYI8kAc5rpJeWX3VT+lYcS7SD3raY5ihb1jFJlwepgahIlxdPNHyJMP+YzVQjCnHWhP9RFg5/dr/wCginYoiTLc8k03xJ4z1iaddJla5MJ+cBIhtznHUe1aP2n4jj/lg3/fMNJ8K/3es6xF/un8mNemsBXXUqcrskjJRv1PNBc/EjB/cPn1AhoM3xJPSKT8oa9LHWq95f2enxCS9uYoF7GRwM/T1qFVb2ivuHyrueeeZ8SSP9VLn1/c0Z+JJx+7l/77iH9a73Tdd03WJJY9NulnaIAvtVhjPTqPatGm6rT1ivuBRT6nmJj+JDfwSj/trH/jSfZPiM3V5R/28J/jXpb3UEUgSWeNHPRWYAmpuKXtpdl9wcq7nmA0/wCIrcee4/7eR/jTxofxBcYOoMn/AG9kfyr00DnNDH0o9vLsvuDkR5ofCvjuXltZAz/0+ycfpTJPBXjJseZrUZPfN1If/Za9PFNcZp/WJ+X3C5EeYr4C8Ut9/WYuf+mrn+lR+H7fUNF+JllpV/dfaGCsxZScHMTHvXqaLXnt0hX43Wz4/gx/5BNaU6kp3T7EyilZo9I521sj5tOtW/2SP1rHXlK1oedJg/2WYVxM6IbnMwaSND0+000S+cLWBIvMxjfhQM47Up61Zu7hbm1srmM5E1ujZ/CqtTB3imFRWk0ee+AFgh8X61EGZZ1LqUI4IEnXP4gYr0XOa818Igx/FbXFP8Ql/wDRimvS85reruZxG968U8bXRfxrfreGWVEYKgV8bRxwOD717X3rwbxnJ5vjLU2B6TsvHtx/StcL8bJqbHY/C6SG3tdZvZMxW6CPLuc4ADE/zFXJ/i1YR3hSDT5pYQceYZAp+u3B/nR8ONLiuvAl1DeKWivJnDc4JXAHX6g0ad4a8FaRq8atqH2y5LhY4pZhIFbPHCj19aqTg5yclcSuoqxzHj9Ut/FTSweYq3cEdxg8EEgj+ma7v4bXk954U/0h2fy5mRCxzhRjiuC+JVx5/jSZBnEESR/pu/8AZqp2XjDUtN0OHTdNk+yohZnkUfM5JJ6np6Vv7N1KKiiOZRk2e7g80ueteP8Ag7xtqcfiCC1v7mS6t7lxGfNOSpPAIP1rQ8TfEDWdM8RXNlbJbpHBJtXKbiw9TzXM8NNS5S/aRtc9QBqFru2W6W3aeMTv92MuNx79K5/XtZnX4dPq1s3kTzW0cilT9zftzj8DXC/DWCXUPGn2q4kaRreF5CzHOSfl/wDZjUxo3g5N7Dc7NI9kRcda4O7upV+McFqvl+XIoZiUBbiFv4sZArvQa89vOfjfZ9P9Vz/36anh9W/RinseiZwlXopWj0ZAFLfvcjH41QYccVneKdQksNCsRExVpJWyR7f/AK65Zu0bnTRjzzURLK8F/oVhMBgeWy49MOwqTFZPhKTzvDUSf88ppE+nQ/1rXxUUf4aKxFvayseceH/3fxf1VCfviX+YNelY+WvNbZTbfG516ebuP5xZ/pXod3dpZ2U1zLny4UMjYHYDNddVXa9Dlj1JCQoJbAUDJJ7V88atcLe6zeXOciaZ36+pJrsdd+J8uoabPaWFkbfzgUMzSZIU9cDHBrkNG0q41vVYbK0jZ2kYbyBwi55Y+1dVCDppykROXNojutYeXR/hDpkELmJ7h1D4OCVYO5H8q5/4e2H2/wAY2zHlbYGZs+3A/Uiui+KpW3sNIs4+EG8gem0KB/M1T+GsqWVnrt+4x5ECkHHoGP8AQURdqLkuoP4jmPEVydQ8VahKCWMlwwXB6gHA/kK9Lv8Awloel+A7j7RZQtPFbFjcEfOZMdd3Xr26V5EsrJdLOOXVw4JHfOa6bVvFmueL40sIbbMecmG1iY7j6nr/AIVtUg7RSdkiIvcz/CdobrxbpsUQJIuFc/RfmP6CneLLhLzxbqMqEFTOyqc9gcZ/SvQ/Afg2XQ4pNQ1EKL+ZNqRg58pfc+p4/KvMZ9Nvxqj2ctlcG7ZyPK8slif6/WnCpGdR+QpRaid7488RaaPDtroul3CTD5N5jbKqijgZ/L8qd8I7dfM1O474jQH8zWNrfgS40Xwrb30sTTXZkzcCPkQqRwPfHc1d+Fepm11i4sWhlZbpQVdEJCsueuOgwetZyUPYSUGHvc6bPWgMV55qGB8bLH18sf8Aotq9Erz3UAT8abLHQR/+0mrlw/xP0ZrPY9F6jFcv8Q5xBY6ShPXzT+q11IOK4P4ozr5mlQk8rE7fm3/1q4avwM7sL/FRa8ASh9CuUJyUuScfVR/ga6QjHSuC+HE7vd38Knjajke4JH9a9A60qXwk4j+IzzHX2+xfGDTJv+e3lL/31lK9Du4IryzmtpgTHKhRgD2Iwa888fL5XxC0KbjG6H9Ja9DGSua7KnwxZzR3ZxcHwr0hZN0t1dyKDnbuUA/kM11mj6JpuiWpj023SBSfmI5Zj7k8mreOK5jXpbq21CaS4ST7I9uBbXKRmVLaXnLOg59MNg4/Op55S0bHZI5L4sTMfENnCOiW278Sx/wFXPhMUlXVreYK4ZYyVYZBB3AijUU0rXbK2j1FWe4tk2C6stQhcuO+RKytyeeRxUekDS/D32n7CJHe5URlr3UIYwvfIETFs/QV08y9lyGfK+a51dp8PdAt9UW9gjkOwkiFn3R5xjof8a6QRRwxhIkVFHQKMCuT8OWt6dVs5rTzFto4WF9cyRmJbxz90qhwcj++QM+9djKP3Zrlm3fVmisRgVJCckj+lQKeKejbXyKgZZHOfSlCgdBUcTdR6mph0oAXFedXf/JbrXP/ADz4H/bFq9F5xXnOoZ/4XbZFcZ8sf+i2row/xP0ZnU2PRxkjiue8VeHrfXWt/NYwywrtDqM5UknH610AOKr6mVNyGXgFB/KudpPRm8JOLujgfh1bSafr+sWV3HsmjjB+mGx+XzV3LPzxRYwQTR3t8bPybp1VfNZcMyg9OfpTM81hh5c0EzfFR5KrR5x8TDjxBojDhsnn/gS16MDhRxXm/wAUG2a5ornoC36Mtek4yK7Z/BE41uzjLrxvewalqcMOki4t9Nf99Is2GC+uCOehrSn8Z2kNnZNZ28t7c6goe3tk4Yjvn0x/Q1gWfhc6p4y15dTjvoLSRwyMhaNJh3GcYarmtaJPoviHR9X0qwlubOxi8h7e3G51XDAEDqfvfpz1qrQvYWpfg8RadqlrqTXulBL7TYmkltbhQWwBng46cfqKoaZ4zt4jYyyaEllaX8hjhmidTkg4OQBkc1BZ6df6trfiDXDYXFnBcWD28EM6bZJGKgZ29vu/qKytM8PahplnoerDT7meWG4cXNpIpbYu44dVPTjnPrirSp9RanS3nja/h1PVLa00qKWLTPmmZp9p2+oGP0qW48al10GS2tR5WqybG8wkNHggH69aw9R8HXGs+J/ELvayKHhD2cxbarSYBx179OelXL3Rdd1Cz8LySaeIp9PnH2pA6AIoKjcMHHIXOBStT0DUnfxpdrqupW0OjtPFpzfvnjmG4Lzg7SOeAelak/i/S4PD8WrmVjBLwiAfOzf3ceoxWC2n63pfijXru10dryG/VRCwnRRnb3BOcZNUJfCGp2PhbS3WIXN1Y3RupbZWzuBIJUepGB+uKnlgPU7PQ/EyahO8U2n31nL5ZkRbmHaHA9D+NR6V4tvNcZX03RZHtfNEbzyTqu3nk46nArF0vW9Zu/GSRRpfjSpEZpFubIR+U2D8u7GT271jeDGt7a33X666Zkut6W9sj+UQCCCQBg8jnmmoRs7hd3PXB09K87vNq/Gy1J7x8f8Afpq9EzkV5xq5K/GjTWGMFF7f7LCjD/E/RinsekKuRVW4glkuCkaNIVA4VSeKvRLlq6LSzAtudoXeT85HU1xVJ8iudVKnzs4e111bgm2wAWQ546cU0muX0HUYJJ445zhlkG1s9s9K6jp1rlwcuaLO7MoqM1Y83+LPEmlSdx5n/stemRfMintivOfixHu0/Tn9JHXP1A/wruLDVLNrGBjdwAtGpIMoyOPrXqyV6cbHkLdmRf6frc+ualNa3dxDbpbfuEVjiRzE4wvOBhtpz6gVmpaeKFs9s7X0jBZPL8qbBEhVDGSSclQdwIOec9sV2X9pWQ63lv8A9/V/xpp1fTVzu1C1X1zOo/rUJytsVocrLp/id5bxYpLhXYTHeZ/kbKLsCDPynfu5wOKsR22syXy3F3BeG0a4kbyEuArqCE2E4boCH4z36Vv/ANu6V/0FLL/wIT/GkOuaSc/8TSy/8CE/xp3k+gaFfRLZ7S41MzSuA9ziBpJi+E8tSByTjndx1rnk8N6leWqK2xEJg81jKJFuGVyXlHUcg9+vcUX2nadd291b2+uWFvHPfi5V1ulLKvk+W3XuTk/1ottZjtvEFu17qNqbaGMIfs94PLB2YyEHbPbrkntVqMugro1te0fULpdPGmSRoLI+Zhzt3su3aMDoMbh6c1kTaL4hSKYw3EhLLLsRJdu3MwZecjque4x0rck8aeHU4OqRfgrH+QqA+OPDZJC6pHn/AK5v/hUqM10C8SrI2p2twJhDelY7NsR7i4lm5wCNzYwB687vatzwzcXr6aU1SORLmKRlYyKAXGeDxweCOnfNV4fEWkXG0w6lbEHpmQKfyNaVvcRS8xSo49VYGpd7WsPQ0Qa868QHb8XtIP8AeVB+ZYV332iJFy8ir9SBXAeICtz8VtEe3ZZFHl5KnI++a1w6fO/Rmc9j1G3TCc1Qu9UnivG+wExzRjy3Dcq46g/Uf1NaQyBwK87vQU8QahNNczAPKQqKdoUV5WLV4WPXwFlUfocHrEl3Yai9nao7SJgq2ccdua9i3CX5wu3dztPavP8AxHcWltq8Ekm3cw4+o6V3NtN5+n28oP8ArIkb8wDWOBldG+Zq1mZviPw5B4ls4ra6lkiWKTzA0eM9CO/1rBX4U2J/5iV3j6LXbA5qdT8terGpOKsmeLyp7nCj4U6dn5tQvD/3z/hUqfCrR+N91ekf76j+ldvgUVXt6ncXJHscV/wq3QgeZLw/9tR/8TS/8Kt0EH795/3+H+FdpwetGKPbVO4+VHGD4X6Ap+9eY/66j/Cp0+GPh1RzFcN/vTH+ldaFzTwKPbVO4cq7HLL8O/DcZ/48Cx/2pnP9ae3gbw4ox/Zkf/fTf410kjAVVkkwQAM5qfaTfUdkcndfDvQJj8kEsH/XKU/1zVUfDCyBP2bUryIEY5Kt/QV2Z5Oali/KqVSa6k8qOMT4YWr/AOu1S7bHHGBW74b8AaTpOpJeLLczzRHdH5jjAPrgCtxDVqz/ANZx1odaptcFCNzQYkLxwK8i1+Zj4gvvm489sfnXrsp2xH6V4h4luFi8S6jGx5W4YVw4jWJ6WClabLX9iWWvQNPctIZdvysG5Wu30qD7No9lb7t/lW8abj3woFeX+D/EkcUgtrkja5+Vj2r1u3jU2cBDLtaMEYOeK5MJzRquD2OvMHGdKM13FReSamApcqBhaA1eoeILkd6XtTdwoDUhjqXimZpQaAHA/NTyeDUX480pbg0AQs241HjNPK4PWkX72KoBAtSKuKeExS44pANHBq5Z4+0L6GqmKWORoXDKehoA2pwdnA4r5/8AGI8nxrqxdsBp8gfUA19BW8yXUWAcHvXz38T1e28fX8eeMo3HugrGorxOijLllc5rVtJvvDerPZ3gVJo+fkYMCOxBrtvDPxQtrLTEtNat7h2hGElhw24Z6EEjGKKKjaV0VdyjZm2PixoB5+z6h/36T/4qpk+KWhN/yxvR9Yl/+KooqudijTi0Pj+Jmgt2ugPUxD/GulstRt9Qs4rq2LGKVQykjBxRRVwk27MipBRWhZLAng0pdRyaKK0MSNblGnWIZ3McDirRt3z0/WiigBrWrsAVHHfmochGz3FFFCAcZgfu5pyvmiinYCZLWWTkbfzrF1vWRoELS6jZ3Cwrz5ilGB/Ddn9KKKGNGJafFzw/C2R9rPsIf/r1bh8IWni/V7nxHrkDCG8VRa2+/BCAAB22nqcdM8fyKKmOu5T02P/Z');

create_product_category.sql

INSERT INTO `product_category` (`id`, `description`, `name`) VALUES (2, 'Food products', 'food_products');

map_product_to_sales_channels.sql

INSERT INTO `product_mrp` (`id`, `kiosk_id`, `product_id`, `sales_channel_id`, `price_amount`, `price_currency`, `cogs_amount`) VALUES (3, 1, 2, 1, '24000.00', 'UGX', '12000.00');
INSERT INTO `product_mrp` (`id`, `kiosk_id`, `product_id`, `sales_channel_id`, `price_amount`, `price_currency`, `cogs_amount`) VALUES (4, 1, 2, 2, '26000.00', 'UGX', '13000.00');