--
-- Host: localhost    Database: ice
-- ------------------------------------------------------


--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` VALUES (2,'Test','Kekv'),(3,'Test','Kekv'),(4,'Test','Kekv'),(5,'Test','Kekv'),(6,'Test','Kekv');

--
-- Table structure for table `cart_product`
--

CREATE TABLE `cart_product` (
  `cart_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`cart_id`,`product_id`),
  KEY `IDX_2890CCAA1AD5CDBF` (`cart_id`),
  KEY `IDX_2890CCAA4584665A` (`product_id`),
  CONSTRAINT `FK_2890CCAA1AD5CDBF` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2890CCAA4584665A` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart_product`
--

INSERT INTO `cart_product` VALUES (2,2),(2,8),(5,2);

--
-- Table structure for table `category`
--

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;

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

INSERT INTO `category` VALUES (2,'Lielie iepakojumi'),(3,'Mazie iepakojumi');

--
-- Table structure for table `doctrine_migration_versions`
--

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20230419210251','2023-04-19 23:03:01',307),('DoctrineMigrations\\Version20230520090755','2023-05-20 11:08:35',104);

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` VALUES (1,'gangunitЙ','+371 22-052-238','abob');

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

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;

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


--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_line1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_line2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` int(11) NOT NULL,
  `postcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order`
--

INSERT INTO `order` VALUES (1,'Gangsta Burito','Pernavas Iela 15 8','Pernavas iela 21-7','Jelgava','Jelgavas pilsēta','22052238','denielsmeinards@gmail.com',86320459,'LV-3004','ORDER_CANCELED','10');

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

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;

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

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);

--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review`
--

INSERT INTO `review` VALUES (2,'Uldis','uldis@gmail.com','asdasdasdasdasda',5),(3,'Valdis','test@gmail.com','RJ-45',1),(4,'Valija','abobus@info.com','Strava',4),(5,'Džesija','logoritmi@inbox.lv','Uzrakstīts ar photomath, 2!',5),(6,'Inga','vēsture@inbox.lv','Hamurapi likums nav top',3),(7,'Daiga','nav','MacOS the best',5),(8,'Armands','phpSTORM@inbox.lv','8. praktiskais darbs - datu pārveide JSON formātā (no CSV/HVI) un izvade, noformējot tabulas izskatā.\npapildus - AJAX datu pierasījums un apstrāde, atgriežot JSON',1),(9,'Kirils','sport@box.lv','Sprints 100km',5);

--
-- Dumping routines for database 'ice'
--


