skills.rest
yuezhen-huang
yuezhen-huangCOMMUNITY
Explore all skills by this author →
GitHub

create-role-info-ddl

Creates role_info table DDL work orders in cn or i18n-bd regions via bytedcli.

Updated Apr 30, 2026
Search Tags:#database#mysql#rds#ddl#work order#bytedcli#role table
One-click install
npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill create-role-info-ddl-yuezhen-huang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: create-role-info-ddl
Source: https://github.com/yuezhen-huang/my-bytedance-skillhub/tree/main/create-role-info-ddl
Command: npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill create-role-info-ddl-yuezhen-huang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually creating role tables for game appids across regions involves writing a long, error-prone SQL DDL and submitting separate BPM work orders for two databases, where a single missing field or wrong region flag causes rejection. ## Core Features & Use Cases - Fixed SQL Template: Generates the complete role_info_<appid> CREATE TABLE statement with all required fields, indexes, charset, and collation preserved exactly. - Region-Aware Work Orders: Submits BPM create tickets to ttgame_platform_sdk_api_sandbox and ttgame_platform_role_manager in either cn or i18n-bd (sinf-my, workflow-config-id 396) via bytedcli. - Use Case: A user says "给我在 cn 地区创建 appid 1789 的角色表" and receives two BPM work order links, one per database, with the correct cloud.bytedance.net URL format. ## Quick Start Ask the assistant to create the role table for appid 1789 in the cn region and return the two work order links.

Frequently Asked Questions about create-role-info-ddl

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a role_info table for an appid in the cn region?▼

Provide the region cn and a numeric appid, and the skill generates the fixed role_info_<appid> DDL and submits BPM create tickets to ttgame_platform_sdk_api_sandbox and ttgame_platform_role_manager via bytedcli. It returns two cloud.bytedance.net work order links.

How to create a role table work order in the i18n-bd region?▼

Specify i18n-bd as the region with a numeric appid. The skill runs bytedcli with --site i18n-bd, --vregion sinf-my, and --workflow-config-id 396, then returns two cloud.byteintl.net BPM record links.

Which regions and databases does the role table creation support?▼

Only cn and i18n-bd regions are supported, and the target databases are fixed to ttgame_platform_sdk_api_sandbox and ttgame_platform_role_manager. Any other region returns a failure message directly.

What happens if the appid is missing or not a number?▼

The skill does not guess the appid. If the appid is missing, non-numeric, or ambiguous, it asks the user to confirm before generating any SQL or submitting work orders.

Why does the role table DDL fail or get rejected?▼

Common causes include dropping fields like server_list, origin_server_id, game_stage_level, or aid, altering the uniq_account_id unique index, or omitting utf8mb4 charset and ROW_FORMAT=DYNAMIC. The SQL template must be preserved exactly except for the appid in the table name.

Related Skills

Explore More Software Engineering Skills→
itsuki0927itsuki0927

bytedance-jwt

Retrieve ByteDance JWT tokens via byte-cli with cookie or SSO fallback.

Community
Advanced
PremModhaOfficialPremModhaOfficial
1

cross-service-migration-coordination

Coordinate cross-service migrations in a shared tenant database with per-service tracking and prefixes.

Community
Advanced
jstoobzjstoobz
2

aws-env-discovery

Discover AWS RDS instances, databases, and Secrets Manager entries across environments.

Community
Intermediate
kellyson520kellyson520

db-migration-enforcer

Detect schema drift between SQLAlchemy models and database tables.

Community
Advanced