52 lines
2.3 KiB
SQL
52 lines
2.3 KiB
SQL
-- 游戏管理表
|
||
CREATE TABLE IF NOT EXISTS `dice_game` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`provider` varchar(64) NOT NULL DEFAULT 'Dicey Fun' COMMENT '供应商名称',
|
||
`provider_code` varchar(32) NOT NULL DEFAULT 'DF' COMMENT '供应商编码',
|
||
`game_code` varchar(64) NOT NULL COMMENT '游戏编号',
|
||
`game_key` varchar(64) NOT NULL COMMENT '游戏唯一值',
|
||
`game_name` varchar(128) NOT NULL COMMENT '游戏名称（中文）',
|
||
`game_name_en` varchar(128) NOT NULL DEFAULT '' COMMENT '游戏名称（英文）',
|
||
`game_type` varchar(32) NOT NULL DEFAULT 'slot' COMMENT '游戏类型',
|
||
`logo` varchar(255) NOT NULL DEFAULT '' COMMENT '游戏LOGO地址',
|
||
`game_url` varchar(255) NOT NULL DEFAULT '' COMMENT '游戏地址',
|
||
`hall_url` varchar(255) NOT NULL DEFAULT '' COMMENT '大厅地址',
|
||
`status` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用',
|
||
`sort` int NOT NULL DEFAULT 100 COMMENT '排序值，越小越靠前',
|
||
`is_hot` tinyint NOT NULL DEFAULT 0 COMMENT '是否热门：1是 0否',
|
||
`merchant_config_json` text COMMENT '商户可见扩展配置',
|
||
`sensitive_config_json` text COMMENT '敏感配置（不对大厅接口返回）',
|
||
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
|
||
`delete_time` datetime DEFAULT NULL COMMENT '删除时间',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_dice_game_code` (`game_code`),
|
||
UNIQUE KEY `uk_dice_game_key` (`game_key`),
|
||
KEY `idx_provider_status_sort` (`provider_code`,`status`,`sort`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='游戏管理表';
|
||
|
||
-- 初始化默认游戏（大富翁）
|
||
INSERT INTO `dice_game`
|
||
(`provider`,`provider_code`,`game_code`,`game_key`,`game_name`,`game_name_en`,`game_type`,`logo`,`game_url`,`hall_url`,`status`,`sort`,`is_hot`,`merchant_config_json`,`sensitive_config_json`,`remark`)
|
||
SELECT
|
||
'Dicey Fun',
|
||
'DF',
|
||
'dafuwen',
|
||
'dafuwen',
|
||
'大富翁',
|
||
'Dafuweng',
|
||
'slot',
|
||
'',
|
||
'https://dice-v3-game.h55555game.top/',
|
||
'https://dice-v3-game.h55555game.top/',
|
||
1,
|
||
1,
|
||
1,
|
||
NULL,
|
||
NULL,
|
||
'初始化默认游戏'
|
||
WHERE NOT EXISTS (
|
||
SELECT 1 FROM `dice_game` WHERE `game_code` = 'dafuwen'
|
||
);
|