azerothcore / azerothcore/Keira3

Support a 3rd primary key (named extra field) through mysql-query-service

Open
#3,103 0 comments 0 reactions 0 assignees View on GitHub
feature request
Dominant language
TypeScript
Stars
450
Forks
183
Avg merge
23h 42m
Merged PRs (30d)
18

Description

editor related: creature-text (and any with 3 Primary Keys)
the goal is to support 3 primary keys at the same time by the mysql-query-service using the "extra id" field implemented here https://github.com/azerothcore/Keira3/pull/3038

Expected behavior in creature-text:
a user should be able to manage 2 rows with the same GroupID but different IDs

Could be related (or the same) to https://github.com/azerothcore/Keira3/issues/2242

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reviewing the extra-id implementation in Keira3 pull request 3038 and the related issue 2242, then trace how creature-text is handled through mysql-query-service. Done means users can manage two rows with the same GroupID when their IDs differ, while supporting the third primary key for other affected tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, typescript
Domain
database, tooling
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.