-- MariaDB dump 10.19  Distrib 10.4.24-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: ice
-- ------------------------------------------------------
-- Server version	10.4.24-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `category`
--
CREATE DATABASE `ice`;
USE `ice`;

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (2,'Lielie iepakojumi'),(3,'Mazie iepakojumi');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messenger_messages`
--

DROP TABLE IF EXISTS `messenger_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messenger_messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `headers` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue_name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `available_at` datetime NOT NULL,
  `delivered_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_75EA56E0FB7336F0` (`queue_name`),
  KEY `IDX_75EA56E0E3BD61CE` (`available_at`),
  KEY `IDX_75EA56E016BA31DB` (`delivered_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messenger_messages`
--

LOCK TABLES `messenger_messages` WRITE;
/*!40000 ALTER TABLE `messenger_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messenger_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double NOT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D34A04AD12469DE2` (`category_id`),
  CONSTRAINT `FK_D34A04AD12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (2,2,'Saldējums \"Pistācijas\"','Itāļu saldējums ar pistāciju garšu un janjuya piedevu',10,'https://cheese-cake.ru/DesertImg/morozhenoe-fistashka-i-dzhandzhuya-0.jpg',500),(3,2,'Saldējums \"Kafijas kakao\"','Itāļu saldējums \"Coffee Cocoa\" ar kafijas un kakao garšu',12,'https://cheese-cake.ru/DesertImg/dzhelato-vanna-kofe-kakao-0.jpg',500),(4,2,'Saldējums \"Affogato Cafe\"','Itāļu saldējums ar piena garšu un kafijas pildījumu',13,'https://cheese-cake.ru/DesertImg/morozhenoe-affogato-kafe-0.jpg',500),(5,2,'Saldējums \"Coffee-Nochiolla\"','Itāļu saldējums \"Coffee Nochiolla\" ar kafijas un lazdu riekstu garšu',9,'https://cheese-cake.ru/DesertImg/dzhelato-vanna-kofe-nochiolla-0.jpg',500),(6,2,'Saldējums \"Kafija no Salento\"','Itāļu saldējums \"Kafija no Salento\" ar kafijas mērci un mandeļu pildījumu',11,'https://cheese-cake.ru/DesertImg/dzhelato-vanna-kofe-iz-salento-0.jpg',500),(7,2,'Saldējums \" Ananāsu\"','Ananāsu saldējums ar ananāsu gabaliņiem',7,'https://cheese-cake.ru/DesertImg/chudesa-sveta-morozhenoe-ananas-0.jpg',450),(8,3,'Saldējums \"sarkanais vīns\"','Krēmīgs sarkanvīna karstvīna saldējums ar ābolu ievārījumu un apelsīnu sukādes.',5,'https://cheese-cake.ru/DesertImg/morozhenoe-v-vedre-salwadore-krasnyj-glintvejn-0.jpg',260),(9,3,'Saldējums \"Ķirbju\"','Ķirbju saldējums ar ķirbju sēklām un ābolu ievārījumu',4,'https://cheese-cake.ru/DesertImg/morozhenoe-v-vedre-delo-v-slivkah-tykva-0.jpg',260),(10,3,'Saldējums \"Stout\"','Krēmveida saldējuma stout ar šokolādes pildījumu un karameļu kraukšķīgumu',7,'https://cheese-cake.ru/DesertImg/morozhenoe-v-vedre-salwadore-staut-0.jpg',260),(11,3,'Saldējums \"Vīģu\"','Vīģu saldējums ar vīģes gabaliņiem',5,'https://cheese-cake.ru/DesertImg/morozhenoe-v-vedre-delo-v-slivkah-inzhir-0.jpg',260),(12,3,'Saldējums \"Karamele\"','Krēmveida saldējums ar karameļu garšu un nugas gabaliņiem (10%)',4,'https://cheese-cake.ru/DesertImg/morozhenoe-turron-bits-s-kusochkami-nugi-superpremium-1.jpg',260),(13,3,'Saldējums \"Meduskuka\"','Saldējuma asorti bļodā: medus kūka (3 porcijas), Prāga (2 porcijas), tiramisu (1 porcija)',8,'https://cheese-cake.ru/DesertImg/assorti-eklerto-medovik-praga-tiramisu-2.jpg',600);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-12-14 19:47:53