-- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
--
-- Host: localhost    Database: happy_paradise
-- ------------------------------------------------------
-- Server version	8.0.40-0ubuntu0.22.04.1

/*!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 */;
/*!50503 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 `product_image`
--

DROP TABLE IF EXISTS `product_image`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_image` (
  `uid` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_uid` bigint unsigned NOT NULL,
  `image_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`uid`),
  KEY `product_image_product_uid_foreign` (`product_uid`),
  CONSTRAINT `product_image_product_uid_foreign` FOREIGN KEY (`product_uid`) REFERENCES `product` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='市集商品圖片';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_image`
--

LOCK TABLES `product_image` WRITE;
/*!40000 ALTER TABLE `product_image` DISABLE KEYS */;
REPLACE INTO `product_image` VALUES (1,1,'product_1_1.png','product/product_1_1.png'),(2,2,'product_2_1.png','product/product_2_1.png'),(3,3,'product_3_1.png','product/product_3_1.png'),(4,4,'product_4_1.png','product/product_4_1.png'),(5,5,'product_5_1.png','product/product_5_1.png'),(6,6,'product_6_1.jpg','product/product_6_1.jpg'),(7,7,'product_7_1.png','product/product_7_1.png'),(8,8,'product_8_1.png','product/product_8_1.png'),(9,9,'product_9_1.png','product/product_9_1.png'),(10,10,'product_10_1.png','product/product_10_1.png'),(11,11,'product_11_1.png','product/product_11_1.png'),(12,12,'product_12_1.png','product/product_12_1.png'),(13,13,'product_13_1.png','product/product_13_1.png'),(14,14,'product_14_1.png','product/product_14_1.png'),(15,15,'product_15_1.png','product/product_15_1.png'),(16,16,'product_16_1.png','product/product_16_1.png'),(17,17,'product_17_1.png','product/product_17_1.png'),(18,18,'product_18_1.png','product/product_18_1.png'),(19,19,'product_19_1.png','product/product_19_1.png'),(20,20,'product_20_1.png','product/product_20_1.png'),(21,21,'product_21_1.png','product/product_21_1.png'),(22,22,'product_22_1.png','product/product_22_1.png'),(23,23,'product_23_1.png','product/product_23_1.png'),(24,24,'product_24_1.png','product/product_24_1.png'),(25,25,'product_25_1.png','product/product_25_1.png'),(26,26,'product_26_1.png','product/product_26_1.png'),(27,27,'product_27_1.png','product/product_27_1.png'),(28,28,'product_28_1.png','product/product_28_1.png'),(29,29,'product_29_1.png','product/product_29_1.png'),(30,30,'product_30_1.png','product/product_30_1.png'),(31,31,'product_31_1.png','product/product_31_1.png'),(32,32,'product_32_1.png','product/product_32_1.png'),(33,33,'product_33_1.png','product/product_33_1.png'),(34,34,'product_34_1.png','product/product_34_1.png'),(35,35,'product_35_1.png','product/product_35_1.png'),(36,36,'product_36_1.png','product/product_36_1.png'),(37,37,'product_37_1.png','product/product_37_1.png'),(38,38,'product_38_1.png','product/product_38_1.png'),(39,39,'product_39_1.png','product/product_39_1.png'),(40,40,'product_40_1.png','product/product_40_1.png'),(41,41,'product_41_1.png','product/product_41_1.png'),(42,42,'product_42_1.png','product/product_42_1.png'),(43,43,'product_43_1.png','product/product_43_1.png'),(44,44,'product_44_1.png','product/product_44_1.png'),(45,45,'product_45_1.png','product/product_45_1.png'),(46,46,'product_46_1.png','product/product_46_1.png'),(47,47,'product_47_1.png','product/product_47_1.png'),(48,48,'product_48_1.png','product/product_48_1.png'),(49,49,'product_49_1.png','product/product_49_1.png'),(50,50,'product_50_1.png','product/product_50_1.png'),(51,51,'product_51_1.png','product/product_51_1.png'),(52,52,'product_52_1.png','product/product_52_1.png'),(53,53,'product_53_1.png','product/product_53_1.png'),(54,54,'product_54_1.png','product/product_54_1.png'),(55,55,'product_55_1.png','product/product_55_1.png'),(56,56,'product_56_1.png','product/product_56_1.png'),(57,57,'product_57_1.png','product/product_57_1.png'),(58,58,'product_58_1.png','product/product_58_1.png'),(59,59,'product_59_1.png','product/product_59_1.png'),(60,60,'product_60_1.png','product/product_60_1.png'),(61,61,'product_61_1.png','product/product_61_1.png'),(62,62,'product_62_1.png','product/product_62_1.png'),(63,63,'product_63_1.png','product/product_63_1.png'),(64,64,'product_64_1.png','product/product_64_1.png'),(65,65,'product_65_1.png','product/product_65_1.png');
/*!40000 ALTER TABLE `product_image` 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 2025-01-20 19:22:26
