--
-- Host: localhost    Database: happy_paradise
-- ------------------------------------------------------


--
-- Table structure for table `base_configs`
--

CREATE TABLE `base_configs` (
  `uid` int unsigned NOT NULL AUTO_INCREMENT,
  `zero_child_modify_configs` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许0级子账号修改base_configs（1: 开启, 0: 关闭）。',
  `open_registration` tinyint(1) NOT NULL DEFAULT '0' COMMENT '注册开关 1:开启 0:关闭',
  `open_store` tinyint(1) DEFAULT '0' COMMENT '是否開啟市集,1:是,0:否',
  `is_under_maintenance` tinyint(1) DEFAULT '0' COMMENT '是否正在維護,1:是,0:否',
  `open_pop_up` tinyint(1) DEFAULT '0' COMMENT '是否開啟彈跳功能',
  `roulettes_activity` tinyint(1) NOT NULL DEFAULT '0' COMMENT '轮盘活动状态1:启用0:关闭',
  `email_verification` tinyint(1) NOT NULL DEFAULT '0' COMMENT '简讯验证注册状态1:启用0:关闭',
  `bing_id_card` tinyint(1) DEFAULT '0' COMMENT '綁定身分ID,1:是,0:否',
  `check_in_activity` tinyint(1) NOT NULL DEFAULT '0' COMMENT '簽到活動1:启用0:关闭',
  `profit_ranking_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '前台排行榜狀態1:启用0:关闭',
  `app_download_open` tinyint(1) NOT NULL DEFAULT '0' COMMENT '使否開啟下載按鈕',
  `vip_open` tinyint(1) DEFAULT '0' COMMENT 'VIP的顯示開關',
  `level_limit` int NOT NULL DEFAULT '7' COMMENT '代理最低能创到几级(不能修改)',
  `web_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '网站名称',
  `default_passwd` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '玩家/代理默认密码',
  `default_currency_code` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDR' COMMENT '網站默认幣別',
  `player_prefix` char(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '转账钱包玩家名称前缀(不能修改,一开始就决定了)',
  `special_setting` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '站台名称，有特殊设置在代码写死用的(不能修改,一开始就决定了)',
  `base_cagent_level1` int DEFAULT NULL COMMENT '创玩家的默认代理(不能修改,一开始就决定了)',
  `base_cagent_level2` int DEFAULT NULL COMMENT '创玩家的默认代理(注意:如果需把总代理玩家，指定在level2分代理，把"-"改为代理名称(默认值"-"))(不能修改,一开始就决定了)',
  `base_cagent_level` int NOT NULL DEFAULT '0' COMMENT '创玩家的默认代理的最低等级(注意:如果base_cagent_level2该栏位有设定代理，就需要改为该代理的等级 2 (默认值1(总代理)))不能修改,一开始就决定了',
  `base_cagent_uid` int NOT NULL DEFAULT '1' COMMENT '创玩家的默认代理的uid(注意:如果base_cagent_level2该栏位有设定代理，就需要改为该代理的UID(默认值2(总代理UID)))不能修改,一开始就决定了',
  `allow_domain_url` json NOT NULL COMMENT '允许网域',
  `app_download_url` json NOT NULL COMMENT 'app下载网域',
  `communication_url` json NOT NULL COMMENT '通信软体的URL(比如FB，youtube等)',
  `web_language` json NOT NULL COMMENT '支援的語言',
  `web_style` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '預設網站顏色',
  `web_style_config` json NOT NULL COMMENT '設定的顏色樣式',
  `expected_web_name` json NOT NULL COMMENT '要排除的網域名稱',
  `customer_service_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '前台客服網址',
  PRIMARY KEY (`uid`),
  KEY `zero_child_modify_configs_idx` (`zero_child_modify_configs`),
  KEY `open_registration_idx` (`open_registration`),
  KEY `web_name_idx` (`web_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `base_configs`
--

REPLACE INTO `base_configs` VALUES (1,0,1,1,0,0,1,0,1,0,1,0,1,7,'happyparadise','123','TWD','xxx','特殊设置',1,NULL,1,1,'[\"example.com\", \"example2.com\"]','{\"Ios\": \"https://www.google.com/\", \"Android\": \"https://www.google.com/\"}','{\"Tiktok\": \"https://www.tiktok.com/\", \"Youtube\": \"https://www.Youtube.com/\", \"Facebook\": \"https://www.facebook.com/\", \"Telegram\": \"https://web.telegram.org/\"}','[\"tw\", \"en\"]','happy_paradise_main','{\"happy_paradise_main\": {\"dark\": {\"100\": \"#532104\", \"150\": \"#1e1400\", \"200\": \"#8C3605\", \"250\": \"#eda200\", \"300\": \"#ffb20b\", \"400\": \"#ffc447\", \"500\": \"#ffbb29\", \"600\": \"#ffce64\", \"700\": \"#ffe19f\"}, \"brand\": {\"100\": \"#ffeabd\", \"200\": \"#ffe19f\", \"300\": \"#ffd782\", \"400\": \"#ffce64\", \"500\": \"#ffbb29\", \"600\": \"#ffb20b\", \"700\": \"#eda200\", \"800\": \"#de9700\", \"900\": \"#cf8d00\", \"950\": \"#c08300\", \"1000\": \"#b27900\"}, \"light\": {\"100\": \"#f1f2f4\", \"200\": \"#ffffff\", \"300\": \"#DDE0E3\", \"350\": \"rgb(170,170,170)\", \"400\": \"#535353\", \"500\": \"#15191C\", \"600\": \"#5f5f5f\"}, \"special\": {\"1\": \"#ffa46f\", \"gold\": \"#f8e709\", \"jackpot-to\": \"#F6EB20\", \"jackpot-from\": \"#FEF87D\"}, \"game-item\": {\"mask\": \"rgba(255, 187, 41, 0.4)\", \"text-mask-from\": \"#ffce64\"}, \"v3-profile\": {\"banner-to\": \"#ffe19f\", \"banner-from\": \"#fff3db\", \"banner-title\": \"#ffd782\", \"banner-border\": \"#eda200\"}, \"leaderBoard\": {\"left\": \"#cf8d00\", \"right\": \"#eda200\", \"avatar\": \"#ffbb29\", \"border\": \"#b27900\", \"v3-border\": \"#C9D0E9\"}, \"second-brand\": {\"500\": \"#000000\", \"700\": \"#000000\"}, \"v3-second-brand\": {\"100\": \"#aa2424\", \"200\": \"#9e2222\", \"300\": \"#931f1f\", \"400\": \"#881d1d\", \"500\": \"#711818\", \"600\": \"#661616\", \"700\": \"#5a1313\", \"800\": \"#551212\", \"900\": \"#4f1111\", \"950\": \"#491010\", \"1000\": \"#440e0e\", \"500-opacity\": \"#440e0e\", \"700-opacity\": \"#390c0c\"}, \"right-promotion-box\": {\"to\": \"#ffc447\", \"from\": \"#ffce64\", \"border\": \"#ffb20b\", \"hover_to\": \"#ffbb29\", \"background\": {\"platformBg\": \"#e3e3e3\", \"transactionCard\": \"#fff\"}, \"hover_from\": \"#ffc447\"}}}','[\"127\", \"localhost\", \"boom69\", \"creditwww\"]','https://www.facebook.com/');


