-- MariaDB dump 10.19  Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: commerce
-- ------------------------------------------------------
-- Server version	10.5.19-MariaDB-0+deb11u2

/*!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 `hanna`
--

DROP TABLE IF EXISTS `hanna`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hanna` (
  `id` int(11) NOT NULL DEFAULT 0,
  `brand_id` varchar(100) NOT NULL,
  `image` varchar(255) NOT NULL,
  `price` float(5,2) unsigned NOT NULL,
  `product_brand` varchar(100) DEFAULT NULL,
  `product_status` enum('0','1') DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hanna`
--

LOCK TABLES `hanna` WRITE;
/*!40000 ALTER TABLE `hanna` DISABLE KEYS */;
INSERT INTO `hanna` VALUES
(1,'1','1.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),
(2,'1','2.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(3,'1','3.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(4,'1','4.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(5,'1','5.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(6,'1','6.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(7,'1','7.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(8,'1','8.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(9,'1','9.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(10,'1','10.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(11,'1','11.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(12,'1','12.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(13,'1','13.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(14,'1','14.jpg',1.95,'Viennoiseries','1','2022-08-02 20:21:30'),(15,'2','15.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(16,'2','16.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(17,'2','17.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(18,'2','18.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(19,'2','19.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(20,'2','20.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(21,'2','21.jpg',0.00,'Sandwichs','1','2022-08-02 20:21:30'),(22,'2','22.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(23,'2','23.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(24,'2','24.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(25,'2','25.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(26,'2','26.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(27,'2','27.jpg',4.25,'Sandwichs','1','2022-08-02 20:21:30'),(28,'3','28.jpg',5.50,'Salades','1','2022-08-02 20:21:30'),(29,'3','29.jpg',5.50,'Salades','1','2022-08-02 20:21:30'),(30,'3','30.jpg',5.50,'Salades','1','2022-08-02 20:21:30'),(31,'3','31.jpg',5.50,'Salades','1','2022-08-02 20:21:30'),(32,'4','32.jpg',3.25,'Boissons','1','2022-08-02 20:21:30'),(33,'4','33.jpg',3.25,'Boissons','1','2022-08-02 20:21:30'),(34,'4','34.jpg',3.25,'Boissons','1','2022-08-02 20:21:30'),(35,'4','35.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(36,'4','36.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(37,'4','37.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(38,'4','38.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(39,'4','39.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(40,'4','40.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(41,'4','41.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(42,'4','42.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(43,'4','43.jpg',2.85,'Boissons','1','2022-08-02 20:21:30'),(44,'5','44.jpg',6.25,'Plats chauds','1','2022-08-02 20:21:30'),(45,'5','45.jpg',6.25,'Plats chauds','1','2022-08-02 20:21:30'),(46,'5','46.jpg',6.25,'Plats chauds','1','2022-08-02 20:21:30'),(47,'5','47.jpg',6.25,'Plats chauds','1','2022-08-02 20:21:30'),(48,'5','48.jpg',6.25,'Plats chauds','1','2022-08-02 20:21:30'),(49,'6','49.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(50,'6','50.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(51,'6','51.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(52,'6','52.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(53,'6','53.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(54,'6','54.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(55,'6','55.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(56,'6','56.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(57,'6','57.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(58,'6','58.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(59,'6','59.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(60,'6','60.jpg',3.25,'Desserts','1','2022-08-02 20:21:30'),(61,'7','61.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(62,'7','62.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(63,'7','63.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(64,'7','64.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(65,'7','65.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(66,'7','66.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(67,'7','67.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(68,'7','68.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(69,'7','69.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(70,'7','70.jpg',3.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(71,'7','71.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(72,'7','72.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(73,'7','73.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(74,'7','74.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(75,'7','75.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(76,'7','76.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(77,'7','77.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(78,'7','78.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(79,'7','79.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(80,'7','80.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(81,'7','81.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(82,'7','82.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(83,'7','83.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(84,'7','84.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(85,'7','85.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(86,'7','86.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(87,'7','87.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(88,'7','88.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30'),(89,'7','89.jpg',2.50,'Délices Méditerranéens','1','2022-08-02 20:21:30');
/*!40000 ALTER TABLE `hanna` 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 2023-09-18 11:04:15
