-- 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 `roulettes_attribute`
--

DROP TABLE IF EXISTS `roulettes_attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roulettes_attribute` (
  `uid` int unsigned NOT NULL AUTO_INCREMENT,
  `roulettes_uid` int unsigned NOT NULL COMMENT '輪盤uid',
  `currency` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '輪盤幣別',
  `award_detail` text COLLATE utf8mb4_unicode_ci COMMENT '獎勵內容加密',
  `complete_times` int unsigned NOT NULL COMMENT '總遊玩次數',
  `complete_bonus` double(30,8) NOT NULL DEFAULT '0.00000000' COMMENT '總送出獎勵',
  `memo` text COLLATE utf8mb4_unicode_ci COMMENT '備註',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '記錄創建的時間戳',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '記錄最後更新的時間戳',
  PRIMARY KEY (`uid`),
  KEY `roulettes_attribute_roulettes_uid_index` (`roulettes_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roulettes_attribute`
--

LOCK TABLES `roulettes_attribute` WRITE;
/*!40000 ALTER TABLE `roulettes_attribute` DISABLE KEYS */;
REPLACE INTO `roulettes_attribute` VALUES (1,1,'TWD','W3sicm91bGV0dGVUaXRsZSI6ImlQaG9uZSAxNiBQcm8gTWF4IiwiYXdhcmRCb251cyI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyZXdhcmRfdHlwZSI6InByaXplIiwicmV3YXJkVGltZXNMaW1pdCI6MH0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjk5OSwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyZXdhcmRfdHlwZSI6ImFtb3VudCIsInJld2FyZFRpbWVzTGltaXQiOjk5OX0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjExMSwicm91bGV0dGVQcm9iYWJpbGl0eSI6MTAsImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicmV3YXJkVGltZXNMaW1pdCI6OTk5LCJyZXdhcmRfdHlwZSI6ImFtb3VudCJ9LHsicm91bGV0dGVUaXRsZSI6Ilx1NGUwYlx1NGUwMFx1NmIyMVx1NTE4ZFx1NGY4Nn4hIiwiYXdhcmRCb251cyI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MzAsImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicmV3YXJkVGltZXNMaW1pdCI6OTk5LCJyZXdhcmRfdHlwZSI6InByaXplIn0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjY2Niwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTksInJld2FyZF90eXBlIjoiYW1vdW50In0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjg4OCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTksInJld2FyZF90eXBlIjoiYW1vdW50In0seyJyb3VsZXR0ZVRpdGxlIjoiXHU5Mjk4XHU4YjFkXHU2MGUwXHU5ODY3IiwiYXdhcmRCb251cyI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MTAsImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicmV3YXJkX3R5cGUiOiJwcml6ZSIsInJld2FyZFRpbWVzTGltaXQiOjk5OX0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjc3Nywicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyZXdhcmRfdHlwZSI6ImFtb3VudCIsInJld2FyZFRpbWVzTGltaXQiOjk5OX0seyJyb3VsZXR0ZVRpdGxlIjoiXHU5ODU4XHU2NzFiXHU1YzMxXHU4OTgxXHU1YmU2XHU3M2ZlXHU0ZTg2ISIsImF3YXJkQm9udXMiOjAsInJvdWxldHRlUHJvYmFiaWxpdHkiOjIwLCJhd2FyZE11bHRpcGxlIjowLCJ0dXJub3Zlck1pbiI6MCwidHVybm92ZXJNYXgiOjAsInJld2FyZF90eXBlIjoicHJpemUiLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTl9LHsicm91bGV0dGVUaXRsZSI6Ilx1NGUwYlx1NGUwMFx1NmIyMVx1NTE4ZFx1NGY4Nn4hIiwiYXdhcmRCb251cyI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MjAsImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicmV3YXJkX3R5cGUiOiJwcml6ZSIsInJld2FyZFRpbWVzTGltaXQiOjk5OX0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjMzMywiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyb3VsZXR0ZVByb2JhYmlsaXR5IjowLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTksInJld2FyZF90eXBlIjoiYW1vdW50In0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjc3NywiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyb3VsZXR0ZVByb2JhYmlsaXR5IjowLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTksInJld2FyZF90eXBlIjoiYW1vdW50In0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjU1NSwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyb3VsZXR0ZVByb2JhYmlsaXR5IjowLCJyZXdhcmRUaW1lc0xpbWl0Ijo5OTksInJld2FyZF90eXBlIjoiYW1vdW50In0seyJyb3VsZXR0ZVRpdGxlIjoiLSIsImF3YXJkQm9udXMiOjIyMiwiYXdhcmRNdWx0aXBsZSI6MCwidHVybm92ZXJNaW4iOjAsInR1cm5vdmVyTWF4IjowLCJyb3VsZXR0ZVByb2JhYmlsaXR5IjoxMCwicmV3YXJkVGltZXNMaW1pdCI6OTk5LCJyZXdhcmRfdHlwZSI6ImFtb3VudCJ9LHsicm91bGV0dGVUaXRsZSI6Ii0iLCJhd2FyZEJvbnVzIjo5OTksImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwicmV3YXJkVGltZXNMaW1pdCI6OTk5LCJyZXdhcmRfdHlwZSI6ImFtb3VudCJ9LHsicm91bGV0dGVUaXRsZSI6Ii0iLCJhd2FyZEJvbnVzIjo0NDQsImF3YXJkTXVsdGlwbGUiOjAsInR1cm5vdmVyTWluIjowLCJ0dXJub3Zlck1heCI6MCwicm91bGV0dGVQcm9iYWJpbGl0eSI6MCwicmV3YXJkVGltZXNMaW1pdCI6OTk5LCJyZXdhcmRfdHlwZSI6ImFtb3VudCJ9XQ==',9,141.00000000,'TWD_memo','2024-11-12 05:58:39','2025-01-10 10:05:30');
/*!40000 ALTER TABLE `roulettes_attribute` 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:24:30
