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

DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `currencies` (
  `currency_code` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '貨幣字母代碼, 符合ISO 4217標準',
  `currency_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '貨幣名稱',
  `exchange_rate` json NOT NULL COMMENT '相對於基準貨幣的匯率',
  `prefix` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '貨幣前綴',
  `symbol` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '貨幣符號',
  `decimal` tinyint(1) DEFAULT NULL COMMENT '小數到第幾位',
  `is_crypto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '虛擬貨幣1是0否',
  `auto_withdrawal_limit` double(35,8) NOT NULL DEFAULT '0.00000000' COMMENT '自動出款閾值，當用戶申請提款低於此值時可自動進行出款處理',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '貨幣狀態, 1表示啟用, 0表示關閉',
  `status_front` tinyint(1) NOT NULL DEFAULT '0' COMMENT '前台貨幣狀態,是否可存提款或遊玩遊戲, 1表示啟用, 0表示關閉',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '最後更新時間',
  `bank` json DEFAULT NULL COMMENT '銀行名稱',
  PRIMARY KEY (`currency_code`),
  KEY `status_idx` (`status`),
  KEY `status_front_idx` (`status_front`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currencies`
--

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
REPLACE INTO `currencies` VALUES ('IDR','Indonesian Rupiah','{\"IDR\": 1, \"JPY\": \"0.0096638501\", \"PHP\": \"0.0036165855\", \"TWD\": \"0.0020290406\", \"VND\": \"1.5548619713\", \"USDT\": \"0.0000613188\"}','idr_','Rp',8,0,150000000.00000000,0,0,'2025-01-11 19:40:02',NULL),('JPY','Japanese Yen','{\"IDR\": \"103.4784263959\", \"JPY\": 1, \"PHP\": \"0.3742385787\", \"TWD\": \"0.2099619289\", \"VND\": \"160.8946700508\", \"USDT\": \"0.0063451777\"}','jpy_','¥',8,0,10000.00000000,0,0,'2025-01-11 19:40:02',NULL),('PHP','Philippine Peso','{\"IDR\": \"276.503899627\", \"JPY\": \"2.6720922347\", \"PHP\": 1, \"TWD\": \"0.5610376399\", \"VND\": \"429.9253984401\", \"USDT\": \"0.0169549\"}','php_','₱',8,0,30000.00000000,0,0,'2025-01-11 19:40:02','[\"Gcash\", \"PayMaya\", \"BPI Bank\", \"BDO Unibank\", \"Metropolitan Bank and Trust Co\", \"LANDBANK / OFBank\", \"Security Bank Corporation\", \"Union Bank of the Philippines\", \"Philippine National Bank\", \"China Banking Corporation\", \"East West Banking Corporation\", \"RCBC/DiskarTech\", \"United Coconut Planters Bank (UCPB)\", \"Philippine Savings Bank\", \"Asia United Bank Corporation\", \"Philippine Bank of Communications\", \"Development Bank of the Philippines\", \"ALLBANK(A Thirft Bank)\", \"Asenso\", \"Bangko Mabuhay\", \"Bank of Commerce\", \"BanKo,A Subsidiary of BPI\", \"Bayad\", \"BDO NeTwork Bank\", \"Camalig Bank\", \"CARD Bank\", \"Cebuana Lhuillier Bank / Cebuana Xpress\", \"China Bank Savings\", \"Coins.ph (DCPay)\", \"CTBC Bank (Philippines) Corporation\", \"Dumaguete City Development Bank\", \"Dungganon Bank\", \"Equicom Savings Bank\", \"GrabPay\", \"ING Bank N.V.\", \"ISLA Bank\", \"JuanCash\", \"Zybi Tech Inc. / JuanCash\", \"Komo / EastWest Rural Bank\", \"East West Rural Bank / Komo\", \"Legazpi Saving Bank\", \"Malayan Bank Saving and Mortage Bank\", \"Malayan Bank Savings and Mortgage Bank Inc.\", \"Maybank Philippnies\", \"Mindanao Consolidated CoopBank\", \"Netbank\", \"OmniPay\", \"OmniPay, Inc.\", \"Partner Rural Bank\", \"Partner Rural Bank (Cotabato), Inc.\", \"Philippine Business Bank\", \"Philippine Trust Company\", \"Producers Bank\", \"Queenbank\", \"Quezon Capital Rural Bank\", \"RCBC Saving Bank\", \"Robinsons Bank Corporation\", \"Seabank\", \"ShopeePay\", \"Standard Chartered Bank\", \"Starpay\", \"Sterling Bank of Asia\", \"Sun Savings Bank\", \"TayoCash\", \"UCPB Savings Bank\", \"USSC Monet Services\", \"Veterans Bank\", \"Wealth Development Bank\"]'),('TWD','New Taiwan dollar','{\"IDR\": \"492.8437594439\", \"JPY\": \"4.7627682079\", \"PHP\": \"1.7824116047\", \"TWD\": 1, \"VND\": \"766.3040193412\", \"USDT\": \"0.0302206105\"}','twd_','$',8,0,10000.00000000,1,1,'2025-01-11 19:40:02','[\"004 臺灣銀行\", \"005 台灣土地銀行\", \"006 合作金庫銀行\", \"007 第一商業銀行\", \"008 華南商業銀行\", \"009 彰化商業銀行\", \"010 花旗(台灣)(原華僑銀行)\", \"011 上海商業銀行\", \"012 台北富邦銀行\", \"013 國泰世華商業銀行\", \"016 高雄銀行\", \"017 兆豐國際商業銀行\", \"021 花旗銀行\", \"024 美國運通銀行\", \"025 首都銀行\", \"039 荷蘭銀行\", \"040 中華開發\", \"050 台灣中小企業銀行\", \"052 渣打國際商銀(原新竹商銀)\", \"053 台中商業銀行\", \"054 京城商銀\", \"057 台東區中小企業銀行\", \"072 德意志銀行\", \"073 東亞銀行\", \"081 匯豐銀行\", \"101 稻江商銀\", \"102 華泰商業銀行\", \"103 新光商業銀行\", \"104 台北市第五信用合作社\", \"106 台北市第九信用合作社\", \"108 陽信商業銀行\", \"114 基隆第一信用合作社\", \"115 基隆第二信用合作社\", \"118 板信商業銀行\", \"119 台北縣淡水第一信用合作社\", \"120 台北縣淡水信用合作社\", \"124 宜蘭信用合作社\", \"127 桃園信用合作社\", \"130 新竹第一信用合作社\", \"132 新竹第三信用合作社\", \"139 苗栗縣竹南信用合作社\", \"146 台中市第二信用合作社\", \"147 三信商業銀行\", \"158 彰化第一信用合作社\", \"161 彰化第五信用合作社\", \"162 彰化第六信用合作社\", \"163 彰化第十信用合作社\", \"165 彰化縣鹿港信用合作社\", \"178 嘉義市第三信用合作社\", \"179 嘉義市第四信用合作社\", \"188 台南第三信用合作社\", \"203 高雄第二信用合作社\", \"204 高雄第三信用合作社\", \"215 花蓮第一信用合作社\", \"216 花蓮第二信用合作社\", \"222 澎湖縣第一信用合作社\", \"223 澎湖縣第二信用合作社\", \"224 金門縣信用合作社\", \"700 中華郵政\", \"803 聯邦商業銀行\", \"804 滙豐銀行(原中華銀行)\", \"805 遠東商業銀行\", \"806 元大銀行\", \"807 永豐銀行\", \"808 玉山商業銀行\", \"809 萬泰商業銀行\", \"810 星辰銀行(原寶華銀行)\", \"812 台新國際商業銀行\", \"814 大眾商業銀行\", \"815 日盛國際商業銀行\", \"816 安泰商業銀行\", \"822 中國信託商業銀行\", \"825 慶豐商業銀行\"]'),('USDT','Tether','{\"IDR\": \"16,308.2\", \"JPY\": \"157.6\", \"PHP\": \"58.98\", \"TWD\": \"33.09\", \"VND\": \"25,357.\", \"USDT\": 1}','usdt_','₮',8,1,1000.00000000,1,1,'2025-01-11 19:40:02',NULL),('VND','Vietnamese Dong','{\"IDR\": \"0.643143905\", \"JPY\": \"0.0062152463\", \"PHP\": \"0.0023259849\", \"TWD\": \"0.0013049651\", \"VND\": 1, \"USDT\": \"0.0000394368\"}','vnd_','₫',8,0,5000000.00000000,0,0,'2025-01-11 19:40:02','[\"ACB\", \"AB\", \"AGRIBANK\", \"BIDV\", \"BVB\", \"BACABANK\", \"CB\", \"CIMB\", \"DBS\", \"DONGA\", \"EXIMBANK\", \"GPB\", \"HDB\", \"IBK\", \"IVB\", \"KIENLONGBANK\", \"LPB\", \"MBBANK\", \"MHB\", \"MSB\", \"NAMA\", \"NCB\", \"NHB\", \"OCB\", \"OCEAN\", \"PBVN\", \"PG\", \"PVCOM\", \"SACOMBANK\", \"SCB\", \"SCB_VN\", \"SEA\", \"SHB\", \"SHINHANBANK\", \"TECHCOM\", \"TPB\", \"UOB\", \"VAB\", \"VIETABANK\", \"VIB\", \"VIETCAPITAL\", \"VIETCOMBANK\", \"VIETINBANK\", \"VPBANK\", \"VRB\"]');
/*!40000 ALTER TABLE `currencies` 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:24
