forked from mirror/azerothcore-wotlk
Compare commits
382 Commits
| Author | SHA1 | Date | |
|---|---|---|---|
| 0f107f2cd4 | |||
| 5239460d10 | |||
| 1ca428e8bb | |||
| 4d5c23e191 | |||
| 28f803a828 | |||
| fee9709b3e | |||
| 55de765eb4 | |||
| dfde5c2d94 | |||
| 8c82af0d57 | |||
| 0b1808057f | |||
| 8900c564ec | |||
| ca790ef408 | |||
| fe82e9faf8 | |||
| 523bd83ad6 | |||
| 0ef916fdf5 | |||
| c5d2632e6f | |||
| 2ca73b789f | |||
| b79f7c3312 | |||
| 971a3f46f7 | |||
| f507858139 | |||
| 8cca034053 | |||
| 3586fc9593 | |||
| f38a08dbff | |||
| 583a38237e | |||
| c09afb0803 | |||
| 3776f464e5 | |||
| 14d3c78b4c | |||
| 157ec27d85 | |||
| 7e8ebca4a1 | |||
| b42ffa5cdd | |||
| 0dd3fcd7c1 | |||
| ad5b63ee02 | |||
| f76595cf80 | |||
| f8a0c2f608 | |||
| b6328fa9bb | |||
| b4f2e6f8f7 | |||
| acd519b9a5 | |||
| 9c80943df9 | |||
| 931201d31d | |||
| 50a56682f1 | |||
| 779160a3d6 | |||
| 88b541ea32 | |||
| 035fc81c7e | |||
| 4f619a6c54 | |||
| b0eaad2fb1 | |||
| c606a246bf | |||
| b66ea07190 | |||
| 9e664a81de | |||
| 9b0ffec040 | |||
| 7e1d2b81c4 | |||
| a69d477e00 | |||
| 232637f8ae | |||
| 4af8775056 | |||
| 489fb48639 | |||
| 43ceb0ac42 | |||
| 35196af895 | |||
| 91f7be9f39 | |||
| 0fe897fae3 | |||
| be01c9fc48 | |||
| 8009bde474 | |||
| 2f07cd4c8a | |||
| 1bd5fb7037 | |||
| 30cea3f081 | |||
| 7c48b53950 | |||
| 44573bc040 | |||
| e658ef00ca | |||
| 01afac9bb5 | |||
| 7bb995f9b3 | |||
| d1c6a2428a | |||
| 7a66aa94c1 | |||
| 2f13ace75f | |||
| 89fde96ae2 | |||
| f7ee2f47e0 | |||
| 17d98abcb0 | |||
| ea220a857a | |||
| 6c48841e97 | |||
| 2945514f45 | |||
| 398c69e5aa | |||
| 827a5a1d7e | |||
| fae74bf652 | |||
| 9b9bab9a4f | |||
| b5ddd6f8bd | |||
| 0769f095e0 | |||
| c975d05eab | |||
| f94cce06a4 | |||
| ff14b7ef96 | |||
| 933e3e17c4 | |||
| 8b81e3da33 | |||
| 505e3a5430 | |||
| f5b21bb21e | |||
| 5e35520ace | |||
| f907ce0d83 | |||
| 7de731b86a | |||
| d83c5c7ada | |||
| 60e9b53589 | |||
| 27e4ad8725 | |||
| a0fd340489 | |||
| 96593c03e8 | |||
| e668cc117d | |||
| cf4171fa69 | |||
| 4e65712d75 | |||
| 1ad5374773 | |||
| c0c5cf2f6b | |||
| dc310a6e9e | |||
| 661dd71f73 | |||
| 8f6de287c8 | |||
| dd7af13fb3 | |||
| a625997533 | |||
| eb9261aa06 | |||
| b5ceb7fc18 | |||
| b177b7f628 | |||
| e1bf2635cd | |||
| 2c8b571503 | |||
| ed6043e638 | |||
| a8bdd0725e | |||
| 4f70f7a4e0 | |||
| 9e5addfef3 | |||
| 5197d9110d | |||
| 23c6909eb6 | |||
| ef2cb22f76 | |||
| 8037e4c719 | |||
| 0c4bb984ae | |||
| 3c0f02a21b | |||
| 164f3c2a56 | |||
| e6f8d4e2f5 | |||
| 8cb229172a | |||
| aa08e113d4 | |||
| 0a8612b28a | |||
| 723b24ce9a | |||
| 5025594ad0 | |||
| 61c6cc2b64 | |||
| 32bf232bf8 | |||
| 3596fc11f4 | |||
| 252ed0fecf | |||
| 5efc00e0ef | |||
| 158caddf91 | |||
| 8ba0c75e1b | |||
| 98e7a05caa | |||
| 72fbcd35d7 | |||
| b3787bd3b7 | |||
| aed42e7b24 | |||
| 0d07c33611 | |||
| 42ea2271ed | |||
| 7e9dcf2421 | |||
| 80b6016528 | |||
| 7b26de4e58 | |||
| 67f2fbdf91 | |||
| 35a561849b | |||
| 583d6e8da0 | |||
| f0addd172d | |||
| 778bf18d1d | |||
| edf34ed6d9 | |||
| 1e39a1bc1f | |||
| 5dfe06614e | |||
| 0b359eab0f | |||
| 1f6bdc4f34 | |||
| 5ca52a6f48 | |||
| 1237b4f55d | |||
| 72385804fa | |||
| 6b428cd92b | |||
| 94525ccc70 | |||
| ddff3ba3fa | |||
| 6966986c04 | |||
| b9100544a8 | |||
| faedf206bf | |||
| f5917881ca | |||
| 1e0c3c824b | |||
| cf0d86a9ff | |||
| eb3cdd1d1f | |||
| a319c1120d | |||
| a6f5f98a31 | |||
| d157d4f60d | |||
| 79bdca26ef | |||
| 7513ff498d | |||
| 5db7fea67c | |||
| fe7daf2d87 | |||
| e1262cd99a | |||
| 4a4de647cb | |||
| 133167b0ae | |||
| d2cbba20bf | |||
| 04f35f7923 | |||
| df82d1be97 | |||
| afa7000b61 | |||
| 6c4c1e8869 | |||
| 80fd8c057a | |||
| 13b7a8064f | |||
| a623dd2383 | |||
| 81457d95f2 | |||
| 12f1834d41 | |||
| 8d0a1aaf6f | |||
| c04698c5c1 | |||
| c5b96f65ba | |||
| 230da2a878 | |||
| 009ea3890b | |||
| a9db3544e2 | |||
| 674c45537b | |||
| f86d5a019a | |||
| 83207c6779 | |||
| 6ef2da3565 | |||
| 15f84f6154 | |||
| 884289af20 | |||
| 8262514a36 | |||
| 6d124440dd | |||
| eacdef831e | |||
| c95842f7d0 | |||
| acd37246aa | |||
| 61c62a12ad | |||
| e20e6984da | |||
| e8e0f7c9b7 | |||
| 901d575695 | |||
| 040ed18aea | |||
| 185d6656b7 | |||
| 6552c21479 | |||
| 8f54bce467 | |||
| 4f777aa0b4 | |||
| eb168e9f28 | |||
| 024c83e963 | |||
| deaf25c1f4 | |||
| 93c97581c0 | |||
| 28c0b203a4 | |||
| 2849807967 | |||
| 7cfccde954 | |||
| 9ca5999194 | |||
| 5748140469 | |||
| 3494808d9a | |||
| 53b31f4590 | |||
| 3319c3b140 | |||
| 782af65001 | |||
| 157e974751 | |||
| 3891616eaf | |||
| 61160df393 | |||
| d6153a3e42 | |||
| 2f5943d8d1 | |||
| 796647f3fe | |||
| 4d26913310 | |||
| 4a940e4983 | |||
| 9af568a4a5 | |||
| f32f6d422f | |||
| 36d6cce4bc | |||
| a4dee23e17 | |||
| c53c7dc93b | |||
| 83ff6057c8 | |||
| 28d2efc2dc | |||
| 71837cf3e3 | |||
| 52ba1e07f3 | |||
| 19414fe61f | |||
| ffc7d4df8e | |||
| ee29d59902 | |||
| 4d9d1d4b57 | |||
| bbea93b558 | |||
| b927b716f2 | |||
| 8b8ba243d8 | |||
| 333ba2f9ec | |||
| d0d3c0be26 | |||
| 482d348f50 | |||
| 51f3ebebc0 | |||
| 1b026d2e0b | |||
| 87a92873de | |||
| f8ceac0468 | |||
| 919eefef7e | |||
| 2b932e5cb0 | |||
| d67cf56812 | |||
| c5d44c54ff | |||
| f0808fba8b | |||
| 046dd2e89b | |||
| ec3cba8c1d | |||
| 111ebf715e | |||
| 942751c775 | |||
| efb8fa54a4 | |||
| c914ef3233 | |||
| f009288a29 | |||
| df16ebd894 | |||
| 87e0aa4ff6 | |||
| 5f053117d5 | |||
| 46be8a5080 | |||
| dab09941a5 | |||
| cbb4937ee6 | |||
| f7019beda4 | |||
| e675151983 | |||
| 4f1745483d | |||
| 46f0d4033a | |||
| c029eab828 | |||
| dabb8f722c | |||
| 43e16de514 | |||
| 419af5796e | |||
| 74da7dda12 | |||
| c1baf53887 | |||
| 1cccafbe0c | |||
| 74b798c8b5 | |||
| ffc5094300 | |||
| f8205c8b67 | |||
| 0a9c55f308 | |||
| e588638749 | |||
| ae8866ac46 | |||
| 5f38fc7a6f | |||
| a73b1b2269 | |||
| d9d011727b | |||
| 1ff5147b85 | |||
| 08e458a62b | |||
| 7094270b8e | |||
| af2c766a8c | |||
| fd256afab3 | |||
| 30a0a9a816 | |||
| 7f736fb4ba | |||
| e312aa547b | |||
| e7cf13a4a8 | |||
| 3b58c9afad | |||
| d7fca81ac2 | |||
| 25bf0f9f07 | |||
| 503735c540 | |||
| 110cb0874d | |||
| 921caed718 | |||
| f05d5375aa | |||
| cd2c30d73e | |||
| f6bbbcc67f | |||
| e0046d8ba8 | |||
| 8bf01db849 | |||
| 0f1f1615e2 | |||
| e1beea25e9 | |||
| 34a5902e04 | |||
| 5183bd1032 | |||
| b99d6c7698 | |||
| 90f635b147 | |||
| 2d92b338d7 | |||
| 027306fa0a | |||
| eda6343164 | |||
| 7a942fea38 | |||
| e944605b9b | |||
| 169e31f2c6 | |||
| a5c11d081d | |||
| b9e2bcd680 | |||
| e897d22e8f | |||
| 2a48cbc9e1 | |||
| ed3a6a1bd0 | |||
| 771253f43d | |||
| dfa1009869 | |||
| 3474fb94fb | |||
| e9840ab602 | |||
| 47046c4cb6 | |||
| f79b594261 | |||
| e5ba1bde34 | |||
| 693e20535e | |||
| d7b037f242 | |||
| 36234f03ad | |||
| 08a01ab6f7 | |||
| 53f2c04b32 | |||
| 7e229e99fa | |||
| 6a21c7419c | |||
| 5cdd837edf | |||
| 00bbc7c6b4 | |||
| 1624d908ec | |||
| 2430168263 | |||
| 380f6cb60f | |||
| 108039fdb7 | |||
| 32759d7078 | |||
| 56ba43501a | |||
| af3f304a37 | |||
| 5e3050c2d3 | |||
| 48f37cc3d0 | |||
| 6350a611d0 | |||
| 9722cd4f13 | |||
| b97fc0a873 | |||
| c3214bade4 | |||
| 8f293d00ee | |||
| 5f5c287cd3 | |||
| ac12f5d27c | |||
| d45e01e1ea | |||
| 9cdcccff30 | |||
| 076016836e | |||
| 84a66e345b | |||
| c0c86d21da | |||
| 9d182cf129 | |||
| f0f61042eb | |||
| cefdcb92b7 | |||
| 04dff51418 | |||
| 46a649c6f6 | |||
| de9461976d | |||
| 0b30b3f99f | |||
| 61e99f9c44 | |||
| b1e226db96 | |||
| 485769354c | |||
| 1dd2236a06 |
@@ -0,0 +1,83 @@
|
||||
# yaml-language-server: $schema=https://coderabbit.ai/integrations/schema.v2.json
|
||||
# CodeRabbit review config. Mirrors the hard rules in CLAUDE.md so the AI
|
||||
# reviewer enforces project conventions on every PR.
|
||||
language: en-US
|
||||
|
||||
reviews:
|
||||
profile: chill
|
||||
request_changes_workflow: false
|
||||
high_level_summary: false
|
||||
poem: false
|
||||
review_status: false
|
||||
collapse_walkthrough: true
|
||||
sequence_diagrams: false
|
||||
auto_review:
|
||||
enabled: true
|
||||
# Review on PR open only; don't re-post a walkthrough on every push.
|
||||
auto_incremental_review: false
|
||||
drafts: false
|
||||
|
||||
# Skip generated, vendored, and immutable content so reviews stay focused.
|
||||
path_filters:
|
||||
- "!deps/**"
|
||||
- "!data/sql/updates/db_*/**"
|
||||
|
||||
path_instructions:
|
||||
- path: "**/*.{cpp,h,hpp}"
|
||||
instructions: |
|
||||
AzerothCore C++ conventions (CI enforces these with -Werror; flag violations):
|
||||
- C++20. 4-space indent, tabs forbidden. UTF-8, LF, max 120 columns, trailing newline.
|
||||
- Allman braces. No braces around single-line statements. `if (x)`, never `if(x)` or `if ( x )`.
|
||||
- `auto const&` (not `const auto&`); `Type const*` (not `const Type*`).
|
||||
- Use fmt-style `{}` format specifiers, never printf-style `%u`/`%s`.
|
||||
- Logging: `LOG_INFO("category.sub", "msg {}", arg)` (also LOG_WARN/ERROR/DEBUG/TRACE).
|
||||
No printf, no `sLog->`, no `TC_LOG_*`.
|
||||
- Random: use Random.h helpers (urand, irand, frand, rand32, rand_chance,
|
||||
roll_chance_f/i). Never `std::rand` or `<random>` directly.
|
||||
- Strings: `Acore::StringFormat(fmt, args...)`.
|
||||
- Config: `sConfigMgr->GetOption<T>("Name", default)`.
|
||||
- Namespace is `Acore::` — flag any leftover `Trinity::` from upstream ports.
|
||||
- Use typed helpers instead of raw flag access: IsPlayer()/IsCreature()/IsItem();
|
||||
GetNpcFlags()/HasNpcFlag()/SetNpcFlag()/RemoveNpcFlag()/ReplaceAllNpcFlags();
|
||||
IsRefundable()/IsBOPTradable()/IsWrapped(); HasFlag(ItemFlag)/HasFlag2()/HasFlagCu();
|
||||
ObjectGuid::ToString().c_str() instead of GetCounter().
|
||||
- Never store a raw Player*/Creature*/Unit* past the current call/tick — store the
|
||||
ObjectGuid and resolve at use time (ObjectAccessor::FindPlayer,
|
||||
ObjectAccessor::GetCreature(*from, guid), Map::GetCreature, …).
|
||||
- DB access: use PreparedStatement, not raw query strings. Non-blocking reads go through
|
||||
the async path (_queryProcessor.AddCallback(db.AsyncQuery(...))). Multi-statement
|
||||
writes wrap in SQLTransaction.
|
||||
- Timed AI actions: use EventMap or TaskScheduler, not hand-rolled tick counters.
|
||||
- Prefer SmartAI (DB) for new creature behaviour; reach for CreatureScript only when the
|
||||
SmartAI vocabulary isn't enough. New creature AI prefers RegisterCreatureAI(ClassName).
|
||||
- Script registration: spell/aura scripts use RegisterSpellScript(ClassName) or
|
||||
RegisterSpellAndAuraScriptPair(...) inside AddSC_(); creature AI uses
|
||||
RegisterCreatureAI(ClassName) (preferred) or new ClassName() (legacy). Declare and
|
||||
call AddSC_() from the regional loader (e.g. Spells/spells_script_loader.cpp,
|
||||
EasternKingdoms/eastern_kingdoms_script_loader.cpp). Module hooks inherit from
|
||||
PlayerScript/WorldScript/etc. and register with new MyClass() in AddSC_().
|
||||
- path: "data/sql/updates/pending_db_*/**/*.sql"
|
||||
instructions: |
|
||||
AzerothCore SQL update conventions (enforced by apps/codestyle/codestyle-sql.py):
|
||||
- Every INSERT must be preceded by a matching DELETE for idempotency, and that DELETE must include a WHERE clause scoped precisely to the intended rows. A predicate that is too broad will remove unrelated data, so confirm it matches exactly what the INSERT will re-add.
|
||||
- 4-space indent (no tabs), trailing newline, no double semicolons, no multiple blank lines.
|
||||
- Tables must use the InnoDB engine.
|
||||
- path: "data/sql/base/**"
|
||||
instructions: |
|
||||
This SQL directory is immutable. Changes here should not happen in a normal PR —
|
||||
flag any modification. New SQL belongs in data/sql/updates/pending_db_*/.
|
||||
- path: "data/sql/archive/**"
|
||||
instructions: |
|
||||
This SQL directory is immutable. Changes here should not happen in a normal PR —
|
||||
flag any modification. New SQL belongs in data/sql/updates/pending_db_*/.
|
||||
|
||||
knowledge_base:
|
||||
code_guidelines:
|
||||
enabled: true
|
||||
# CLAUDE.md is in CodeRabbit's defaults, but list it explicitly so the project's
|
||||
# full guideline doc is always pulled into review context.
|
||||
filePatterns:
|
||||
- "CLAUDE.md"
|
||||
|
||||
chat:
|
||||
auto_reply: true
|
||||
+2
-2
@@ -5,7 +5,7 @@ indent_size = 4
|
||||
tab_width = 4
|
||||
insert_final_newline = true
|
||||
trim_trailing_whitespace = true
|
||||
max_line_length = 80
|
||||
max_line_length = 120
|
||||
|
||||
[*.{json,ts,js,yml,sh}]
|
||||
charset = utf-8
|
||||
@@ -14,4 +14,4 @@ indent_size = 2
|
||||
tab_width = 2
|
||||
insert_final_newline = true
|
||||
trim_trailing_whitespace = true
|
||||
max_line_length = 80
|
||||
max_line_length = 120
|
||||
|
||||
@@ -1,9 +1,11 @@
|
||||
### TITLE
|
||||
## Type(Scope/Subscope): Commit ultra short explanation
|
||||
## |---- Write below the examples with a maximum of 50 characters ----|
|
||||
## |---- Write below the examples with a maximum of 72 characters ----|
|
||||
## Example 1: fix(DB/SAI): Missing spell to NPC Hogger
|
||||
## Example 2: fix(CORE/Raid): Phase 2 of Ragnaros
|
||||
## Example 3: feat(CORE/Commands): New GM command to do something
|
||||
## Example 2: feat(Scripts/Commands): Add .mail list and .mail return commands
|
||||
## Example 3: refactor(Scripts/Ulduar): Leverage DoorData and persistent data
|
||||
## Example 4: fix(Scripts/SlavePens): Despawn Frozen Core after Ahune emerges
|
||||
## Example 5: fix(Scripts/VioletHold): Prevent Sinclari from despawning
|
||||
|
||||
|
||||
### DESCRIPTION
|
||||
@@ -46,7 +48,7 @@
|
||||
## More info here https://www.conventionalcommits.org/en/v1.0.0-beta.2/
|
||||
## =======================================================
|
||||
## "Scope" can be:
|
||||
## CORE (core related, c++)
|
||||
## Core (core related, c++)
|
||||
## DB (database related, sql)
|
||||
## =======================================================
|
||||
## "Subscope" is optional and depends on the nature of the commit.
|
||||
|
||||
@@ -24,7 +24,7 @@ Based on CLAUDE.md, always verify:
|
||||
- 4-space indentation for C++ (no tabs)
|
||||
- 2-space indentation for JSON, YAML, shell scripts
|
||||
- UTF-8 encoding, LF line endings
|
||||
- Max 80 character line length
|
||||
- Max 120 character line length
|
||||
- No braces around single-line statements
|
||||
- Format variables in output using {} placeholders instead of printf-style format specifiers like %u
|
||||
|
||||
|
||||
@@ -2,6 +2,7 @@
|
||||
# AzerothCore
|
||||
#
|
||||
|
||||
.cache
|
||||
/conf/*
|
||||
!/conf/dist
|
||||
/modules/*
|
||||
@@ -101,6 +102,10 @@ local.properties
|
||||
/vcpkg/
|
||||
/vcpkg-ports/
|
||||
|
||||
# Python bytecode cache
|
||||
__pycache__/
|
||||
*.py[cod]
|
||||
|
||||
|
||||
# ==================
|
||||
#
|
||||
|
||||
Vendored
+6
-1
@@ -1,4 +1,9 @@
|
||||
{
|
||||
"github.copilot.chat.commitMessageGeneration.instructions": [
|
||||
{
|
||||
"file": ".git_commit_template.txt"
|
||||
},
|
||||
],
|
||||
"files.associations": {
|
||||
"*.dist": "properties",
|
||||
"*.crash": "properties",
|
||||
@@ -120,7 +125,7 @@
|
||||
"deno.path": "deps/deno/bin/deno",
|
||||
"deno.lint": true,
|
||||
"C_Cpp.default.compileCommands": "${workspaceFolder}/build/compile_commands.json",
|
||||
"C_Cpp.default.cppStandard": "c++17",
|
||||
"C_Cpp.default.cppStandard": "c++20",
|
||||
"C_Cpp.default.configurationProvider": "ms-vscode.cmake-tools",
|
||||
"C_Cpp.default.compilerPath": "/usr/bin/clang",
|
||||
"cmake.sourceDirectory": ["${workspaceFolder}"],
|
||||
|
||||
@@ -1,126 +1,104 @@
|
||||
# CLAUDE.md
|
||||
|
||||
This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.
|
||||
AzerothCore is a C++ MMORPG server emulator for World of Warcraft 3.3.5a (WotLK), built with CMake, backed by MySQL.
|
||||
|
||||
## Project Overview
|
||||
## Agent rules
|
||||
|
||||
AzerothCore is an open-source MMORPG server emulator for World of Warcraft patch 3.3.5a (Wrath of the Lich King). It's a C++ project built with CMake, using MySQL for data storage. Licensed under GNU GPL v2.
|
||||
- **Do not configure or build unless explicitly asked.** Builds are slow (CMake + compile of a large C++ codebase) and rarely needed to make code changes.
|
||||
- **Never edit SQL files outside `data/sql/updates/pending_db_*/`.** `data/sql/base/`, `data/sql/archive/`, and `data/sql/updates/db_*/` are immutable (do not modify).
|
||||
- **Do not run git commands that modify repo state** (commit, branch, merge, rebase, reset, push, …) unless explicitly requested, and do not include them in plans. Read-only git (status, diff, log) is fine.
|
||||
|
||||
## Build Commands
|
||||
## Build
|
||||
|
||||
### Configure and build (out-of-source build required)
|
||||
|
||||
- Skip building unless explicitly requested.
|
||||
Out-of-source build is required (in-source is blocked by CMake).
|
||||
|
||||
```bash
|
||||
# Create build directory and configure
|
||||
mkdir -p build && cd build
|
||||
cmake .. -DCMAKE_INSTALL_PREFIX=$HOME/azeroth-server -DCMAKE_BUILD_TYPE=RelWithDebInfo \
|
||||
-DSCRIPTS=static -DMODULES=static
|
||||
|
||||
# Build (use appropriate core count)
|
||||
make -j$(nproc)
|
||||
make install
|
||||
make -j$(nproc) && make install
|
||||
```
|
||||
|
||||
### Key CMake options
|
||||
Compiler: **C++20** required (`CMAKE_CXX_STANDARD 20`). Useful CMake flags: `BUILD_TESTING=ON` (Google Test), `NOPCH=1` (disable precompiled headers). Full flag set in `conf/dist/config.cmake`. `compile_commands.json` is exported automatically.
|
||||
|
||||
- `SCRIPTS`: none, static, dynamic, minimal-static, minimal-dynamic (default: static)
|
||||
- `MODULES`: none, static, dynamic (default: static)
|
||||
- `APPS_BUILD`: none, all, auth-only, world-only (default: all)
|
||||
- `TOOLS_BUILD`: none, all, db-only, maps-only (default: none)
|
||||
- `BUILD_TESTING`: Enable unit tests (default: OFF)
|
||||
- `USE_COREPCH` / `USE_SCRIPTPCH`: Precompiled headers (default: ON)
|
||||
Tests (Google Test, in `src/test/`): configure with `-DBUILD_TESTING=ON`, then `ctest` or `./src/test/unit_tests` from the build dir.
|
||||
|
||||
### Unit tests
|
||||
## Repository layout
|
||||
|
||||
- `src/common/` — networking (Asio), crypto, config, logging, shared utilities.
|
||||
- `src/server/game/` — core gameplay; compiled into worldserver.
|
||||
- `src/server/scripts/` — content scripts grouped by region (`EasternKingdoms/`, `Northrend/`, …), class (`Spells/spell_mage.cpp`, …), and domain (`Commands/`, `Pet/`, `OutdoorPvP/`, `World/`).
|
||||
- `src/server/database/` — DB abstraction and schema updater.
|
||||
- `src/server/shared/` — code shared by auth and world servers.
|
||||
- `src/server/apps/{authserver,worldserver}/` — entry points (ports 3724 and 8085).
|
||||
- `src/test/` — Google Test unit tests + mocks.
|
||||
- `data/sql/` — `base/` (historical schema), `updates/db_*/` (merged), `updates/pending_db_*/` (in-flight, **edit here**), `custom/` (gitignored).
|
||||
- `modules/` — external modules (each a subdir with its own `CMakeLists.txt`). Disable with `-DDISABLED_AC_MODULES="mod1;mod2"`. See `modules/how_to_make_a_module.md`.
|
||||
- `apps/` — helper scripts; `apps/codestyle/` holds the lint scripts (see below).
|
||||
- `conf/dist/` — distributed config templates; `conf/*.conf` is gitignored.
|
||||
- `deps/` — vendored third-party dependencies.
|
||||
|
||||
## Adding SQL updates
|
||||
|
||||
1. `cd data/sql/updates/pending_db_world/` (or `pending_db_auth` / `pending_db_characters`).
|
||||
2. `./create_sql.sh` generates an empty `rev_<timestamp>.sql` you write into.
|
||||
3. Required SQL conventions (enforced by `apps/codestyle/codestyle-sql.py`):
|
||||
- Every `INSERT` must be preceded by a matching `DELETE` (idempotency).
|
||||
- 4-space indent (no tabs), trailing newline, no double semicolons, no multiple blank lines.
|
||||
- Tables must use the InnoDB engine.
|
||||
|
||||
The three databases:
|
||||
|
||||
- `acore_auth` — accounts, realm list, IP/account bans, session keys. Shared across all realms.
|
||||
- `acore_characters` — per-character state: characters, inventory, in-progress quests, mail, guilds, arena teams, achievements. One per realm.
|
||||
- `acore_world` — static game content: creature/gameobject/item/quest templates, spawn lists, loot tables, SmartAI scripts, gossip, conditions. Read-mostly; rebuilt from SQL.
|
||||
|
||||
## Code style
|
||||
|
||||
Run the linters before claiming a change is done:
|
||||
|
||||
```bash
|
||||
# Configure with testing enabled
|
||||
cmake .. -DBUILD_TESTING=ON
|
||||
make -j$(nproc)
|
||||
|
||||
# Run tests
|
||||
./src/test/unit_tests
|
||||
# or
|
||||
ctest
|
||||
python apps/codestyle/codestyle-cpp.py # C++
|
||||
python apps/codestyle/codestyle-sql.py # SQL (compares to origin/master)
|
||||
```
|
||||
|
||||
Tests use Google Test and live in `src/test/`. The test binary links against the `game` library.
|
||||
Hard rules (also enforced by CI with `-Werror`):
|
||||
|
||||
## Architecture
|
||||
- 4-space indent for C++ (tabs forbidden); 2-space for JSON/YAML/sh/ts/js. UTF-8, LF, max 120 cols, trailing newline.
|
||||
- Allman braces. No braces around single-line statements. `if (x)` — never `if(x)` or `if ( x )`.
|
||||
- `auto const&` (not `const auto&`); `Type const*` (not `const Type*`).
|
||||
- Use `{}` format specifiers (`fmt`-style), not `%u`/`%s`.
|
||||
- Use the typed helpers, not raw flag access:
|
||||
- `IsPlayer()`, `IsCreature()`, `IsItem()`, … instead of `GetTypeId() == TYPEID_*`.
|
||||
- `GetNpcFlags()`, `HasNpcFlag()`, `SetNpcFlag()`, `RemoveNpcFlag()`, `ReplaceAllNpcFlags()` instead of `*Flag(UNIT_NPC_FLAGS, …)`.
|
||||
- `IsRefundable()`, `IsBOPTradable()`, `IsWrapped()` instead of `HasFlag(ITEM_FIELD_FLAGS, …)`.
|
||||
- `HasFlag(ItemFlag)` / `HasFlag2(ItemFlag2)` / `HasFlagCu(ItemFlagsCustom)` instead of bitwise `Flags & ITEM_FLAG…`.
|
||||
- `ObjectGuid::ToString().c_str()` instead of `ObjectGuid::GetCounter()`.
|
||||
|
||||
### Two server executables
|
||||
- **authserver** (`src/server/apps/authserver/`): Handles authentication and realm selection (port 3724)
|
||||
- **worldserver** (`src/server/apps/worldserver/`): Main game server handling all gameplay (port 8085)
|
||||
CI also runs `cppcheck`.
|
||||
|
||||
### Source layout (`src/`)
|
||||
## Project conventions
|
||||
|
||||
- **`src/common/`** - Shared libraries: networking (Asio), cryptography, configuration, logging, threading, collision detection, utilities
|
||||
- **`src/server/game/`** - Core game logic (~52 subsystems), the heart of the worldserver
|
||||
- **`src/server/scripts/`** - Content scripts (bosses, spells, commands, instances)
|
||||
- **`src/server/database/`** - Database abstraction layer and schema updater
|
||||
- **`src/server/shared/`** - Code shared between auth and world servers (packets, network, realm definitions)
|
||||
- **`src/test/`** - Unit tests (Google Test)
|
||||
- **Logging**: `LOG_INFO("category.sub", "msg with {}", arg)` (also `LOG_WARN`, `LOG_ERROR`, `LOG_DEBUG`, `LOG_TRACE`). Categories are hierarchical, dot-separated (e.g. `server.loading`, `entities.player`, `sql.dev`). No `printf`-style; no `sLog->`; no `TC_LOG_*`. Macro in `src/common/Logging/Log.h`.
|
||||
- **Random**: use project helpers from `src/common/Utilities/Random.h` — `urand`, `irand`, `frand`, `rand32`, `rand_chance`, `roll_chance_f`, `roll_chance_i`. Do not use `std::rand` or `<random>` directly.
|
||||
- **Strings**: `Acore::StringFormat(fmt, args...)` (wraps `fmt::format`, `{}` placeholders) — `src/common/Utilities/StringFormat.h`.
|
||||
- **Config**: read options with `sConfigMgr->GetOption<T>("Name", default)`.
|
||||
- **Namespace**: project-wide is `Acore::` (no `Trinity::` remnants — agents porting from upstream forks must rename).
|
||||
- **Long-lived references**: do not store a raw `Player*` / `Creature*` / `Unit*` past the current call/tick — the object can be removed (logout, despawn, instance unload) and the pointer dangles. Store the `ObjectGuid` and resolve at use time via `ObjectAccessor::FindPlayer(guid)`, `ObjectAccessor::GetCreature(*from, guid)`, `Map::GetCreature(guid)`, etc.
|
||||
- **DB queries**: use `PreparedStatement` (via `WorldDatabase` / `CharacterDatabase` / `LoginDatabase` and the prepared-statement enums) rather than raw query strings. Reads that don't need to block the world tick go through the async path: `_queryProcessor.AddCallback(db.AsyncQuery(stmt).WithPreparedCallback(...))` (or `WithCallback` for non-prepared). Multi-statement writes wrap in `SQLTransaction` + `Execute` / `AppendPreparedStatement`.
|
||||
- **Timed actions in AI**: use `EventMap` (event id → delay; simple) or `TaskScheduler` (lambdas, repeats, cancellation). Both are members of `CreatureAI`; see any boss script under `src/server/scripts/` for examples — don't roll your own tick counters.
|
||||
|
||||
### Key game subsystems (`src/server/game/`)
|
||||
## Scripting registration
|
||||
|
||||
- **Entities/** - Core game objects: `Player`, `Creature`, `Unit`, `Item`, `GameObject`
|
||||
- **Spells/** - Spell mechanics, aura system, spell effects
|
||||
- **Maps/** - Map management, grid system, instancing
|
||||
- **Handlers/** - Client packet handlers (one file per system: `MovementHandler.cpp`, `SpellHandler.cpp`, etc.). These are methods on `WorldSession`
|
||||
- **AI/** - Creature AI framework
|
||||
- **Scripting/** - Script system with typed base classes (`ScriptObject` subclasses: `CreatureScript`, `SpellScript`, `InstanceMapScript`, `GameObjectScript`, `CommandScript`, etc.)
|
||||
- **Server/** - `WorldSession` (per-player connection), `World` (global state), opcode definitions
|
||||
Scripts inherit from a `ScriptObject` subclass (`SpellScript`, `AuraScript`, `CreatureScript`, `InstanceMapScript`, `GameObjectScript`, `CommandScript`, …). Two registration styles coexist:
|
||||
|
||||
### Scripting system
|
||||
- **Spell / aura scripts**: use the `RegisterSpellScript(ClassName)` (or `RegisterSpellAndAuraScriptPair(...)`) macro inside `AddSC_<name>()`.
|
||||
- **Creature scripts**: prefer `RegisterCreatureAI(ClassName)` for new code; legacy zones still use `new ClassName();`. Match the surrounding pattern.
|
||||
|
||||
Scripts follow a registration pattern:
|
||||
1. Define a class inheriting from `SpellScript`, `CreatureScript`, etc.
|
||||
2. Implement an `AddSC_*()` function that calls `RegisterSpellScript(ClassName)` (or similar)
|
||||
3. The `AddSC_*()` is declared and called from the regional `*_script_loader.cpp`
|
||||
4. Script loaders per region: `spells_script_loader.cpp`, `eastern_kingdoms_script_loader.cpp`, `northrend_script_loader.cpp`, etc.
|
||||
5. Spell script files are organized by class: `spell_dk.cpp`, `spell_mage.cpp`, `spell_generic.cpp`, etc.
|
||||
Then declare and call `AddSC_<name>()` from the regional loader: `Spells/spells_script_loader.cpp`, `EasternKingdoms/eastern_kingdoms_script_loader.cpp`, etc.
|
||||
|
||||
### Three databases
|
||||
- **acore_auth** - Accounts, realm list, bans (`data/sql/base/db_auth/`)
|
||||
- **acore_characters** - Character data, inventories, progress (`data/sql/base/db_characters/`)
|
||||
- **acore_world** - Game content: creatures, items, quests, spells, loot (`data/sql/base/db_world/`)
|
||||
**SmartAI** (data-driven creature behaviour) lives in the world DB's `smart_scripts` table — not in C++. Engine: `src/server/game/AI/SmartScripts/`. For new creature behaviour prefer SmartAI (added via the SQL update workflow); reach for `CreatureScript` only when SmartAI's event/action vocabulary isn't enough.
|
||||
|
||||
- SQL updates go in `data/sql/updates/pending_*` with separate subdirectories per database until pull request is merged. Pending SQL files are assigned random names.
|
||||
- SQL updates go in `data/sql/updates/` with separate subdirectories per database after their pull request is merged.
|
||||
- SQL files outside the `data/sql/updates/pending_*` folders should never be updated.
|
||||
**Module hooks** (e.g. `OnPlayerLogin`, `OnWorldUpdate`, `OnSpellCast`) are declared in `src/server/game/Scripting/ScriptDefines/*.h`. Implement by inheriting the matching base (`PlayerScript`, `WorldScript`, …) and registering with `new MyClass();` (or its `RegisterXxxScript` macro where one exists) inside `AddSC_<name>()`. Full hook list: https://www.azerothcore.org/wiki/hooks-script.
|
||||
|
||||
### Module system
|
||||
|
||||
External modules are loaded from the `modules/` directory. Each module is a subdirectory with its own `CMakeLists.txt`. Disable specific modules with `-DDISABLED_AC_MODULES="mod1;mod2"`. Module skeleton: https://github.com/azerothcore/skeleton-module/
|
||||
|
||||
### Dependencies
|
||||
|
||||
Bundled in `deps/`: boost, MySQL client, OpenSSL, zlib, recastnavigation (pathfinding), g3dlite (geometry), fmt, argon2, jemalloc, and others.
|
||||
|
||||
## Commit Message Format
|
||||
|
||||
Uses Conventional Commits:
|
||||
```
|
||||
Type(Scope/Subscope): Short description (max 50 chars)
|
||||
```
|
||||
|
||||
- **Types**: feat, fix, refactor, style, docs, test, chore
|
||||
- **Scopes**: Core (C++ changes), DB (SQL changes)
|
||||
- **Examples**: `fix(Core/Spells): Fix damage calculation for Fireball`, `fix(DB/SAI): Missing spell to NPC Hogger`
|
||||
|
||||
## Code Style
|
||||
|
||||
- 4-space indentation for C++ (no tabs)
|
||||
- 2-space indentation for JSON, YAML, shell scripts
|
||||
- UTF-8 encoding, LF line endings
|
||||
- Max 80 character line length
|
||||
- No braces around single-line statements
|
||||
- Use {} to parse variables into output instead of %u etc.
|
||||
- CI enforces code style checks and compiles with `-Werror`
|
||||
|
||||
## PR Requirements
|
||||
|
||||
- AI tool usage must be disclosed in PRs
|
||||
- In-game testing expected
|
||||
- Changes to generic code require regression testing of related systems
|
||||
Custom (non-upstream) scripts go in `src/server/scripts/Custom/` (gitignored).
|
||||
|
||||
+1
-1
@@ -1,5 +1,5 @@
|
||||
{
|
||||
"name": "azerothcore-wotlk",
|
||||
"version": "16.0.0-dev",
|
||||
"version": "17.0.0-dev",
|
||||
"license": "GPL2"
|
||||
}
|
||||
|
||||
@@ -210,6 +210,36 @@ def insert_delete_safety_check(file: io, file_path: str) -> None:
|
||||
error_handler = True
|
||||
results["INSERT & DELETE safety usage check"] = "Failed"
|
||||
|
||||
# Strip a trailing "-- ..." line comment while ignoring any "--" that appears
|
||||
# inside a single- or double-quoted string literal (e.g. descriptions).
|
||||
def strip_inline_comment(text: str) -> str:
|
||||
in_single_quote = False
|
||||
in_double_quote = False
|
||||
index = 0
|
||||
while index < len(text):
|
||||
char = text[index]
|
||||
# Skip backslash-escaped characters inside string literals (e.g. \')
|
||||
if char == '\\' and (in_single_quote or in_double_quote):
|
||||
index += 2
|
||||
continue
|
||||
if char == "'" and not in_double_quote:
|
||||
in_single_quote = not in_single_quote
|
||||
elif char == '"' and not in_single_quote:
|
||||
in_double_quote = not in_double_quote
|
||||
elif (char == '-' and index + 1 < len(text) and text[index + 1] == '-'
|
||||
and not in_single_quote and not in_double_quote):
|
||||
return text[:index].strip()
|
||||
index += 1
|
||||
return text.strip()
|
||||
|
||||
# Count how many parentheses are still open on a line, ignoring any that appear
|
||||
# inside string literals. A positive result means a value tuple continues on the
|
||||
# following line(s).
|
||||
def open_paren_balance(text: str) -> int:
|
||||
without_strings = re.sub(r"'(?:\\.|[^'])*'", "", text)
|
||||
without_strings = re.sub(r'"(?:\\.|[^"])*"', "", without_strings)
|
||||
return without_strings.count('(') - without_strings.count(')')
|
||||
|
||||
def semicolon_check(file: io, file_path: str) -> None:
|
||||
global error_handler, results
|
||||
|
||||
@@ -255,8 +285,8 @@ def semicolon_check(file: io, file_path: str) -> None:
|
||||
if not stripped_line and not inside_values_block:
|
||||
continue
|
||||
|
||||
# Remove inline comments after SQL
|
||||
stripped_line = stripped_line.split('--', 1)[0].strip()
|
||||
# Remove inline comments after SQL (ignoring "--" inside string literals)
|
||||
stripped_line = strip_inline_comment(stripped_line)
|
||||
|
||||
if stripped_line.upper().startswith("SET") and not stripped_line.endswith(";"):
|
||||
print(f"❌ Missing semicolon in {file_path} at line {line_number}")
|
||||
@@ -266,10 +296,29 @@ def semicolon_check(file: io, file_path: str) -> None:
|
||||
if not query_open and any(keyword in stripped_line.upper() for keyword in ["SELECT", "INSERT", "UPDATE", "DELETE", "REPLACE"]):
|
||||
query_open = True
|
||||
|
||||
# Detect start of multi-line VALUES block
|
||||
if any(kw in stripped_line.upper() for kw in ["INSERT", "REPLACE"]) and "VALUES" in stripped_line.upper():
|
||||
inside_values_block = True
|
||||
# Detect start of a VALUES block
|
||||
upper_line = stripped_line.upper()
|
||||
if any(kw in upper_line for kw in ["INSERT", "REPLACE"]) and "VALUES" in upper_line:
|
||||
query_open = True # Ensure query is marked open too
|
||||
# Look at whatever follows the VALUES keyword on this same line
|
||||
tail = stripped_line[upper_line.rfind("VALUES") + len("VALUES"):].strip()
|
||||
if not tail or tail.endswith(','):
|
||||
# Multi-line VALUES block: value rows follow on subsequent lines
|
||||
inside_values_block = True
|
||||
elif open_paren_balance(stripped_line) > 0:
|
||||
# A value tuple is still open (row split across lines, or the line
|
||||
# ends with '('); leave the statement open so the terminator is
|
||||
# validated once the tuple closes on a following line.
|
||||
pass
|
||||
elif tail.endswith(';'):
|
||||
# Complete single-line insert
|
||||
query_open = False
|
||||
else:
|
||||
# Inline insert whose value tuple(s) are complete on this same line
|
||||
# but the statement is not terminated with a semicolon
|
||||
print(f"❌ Missing semicolon in {file_path} at line {line_number}")
|
||||
check_failed = True
|
||||
query_open = False
|
||||
|
||||
if inside_values_block:
|
||||
if not stripped_line:
|
||||
|
||||
+15
-11
@@ -1,4 +1,4 @@
|
||||
ARG UBUNTU_VERSION=22.04 # lts
|
||||
ARG UBUNTU_VERSION=24.04 # lts
|
||||
|
||||
# This target lays out the general directory skeleton for AzerothCore,
|
||||
# This target isn't intended to be directly used
|
||||
@@ -67,7 +67,7 @@ RUN apt-get update \
|
||||
build-essential ccache libtool cmake-data make cmake clang \
|
||||
git lsb-base curl unzip default-mysql-client openssl \
|
||||
default-libmysqlclient-dev libboost-all-dev libssl-dev libmysql++-dev \
|
||||
libreadline-dev zlib1g-dev libbz2-dev libncurses5-dev \
|
||||
libreadline-dev zlib1g-dev libbz2-dev libncurses5-dev liblzma-dev \
|
||||
&& rm -rf /var/lib/apt/lists/*
|
||||
|
||||
COPY CMakeLists.txt /azerothcore/CMakeLists.txt
|
||||
@@ -117,11 +117,12 @@ ARG DOCKER_USER=acore
|
||||
ENV ACORE_COMPONENT=undefined
|
||||
|
||||
# Install base dependencies for azerothcore
|
||||
RUN apt-get update && \
|
||||
apt-get install -y --no-install-recommends \
|
||||
libmysqlclient21 libreadline8 \
|
||||
gettext-base default-mysql-client && \
|
||||
rm -rf /var/lib/apt/lists/*
|
||||
RUN apt-get update \
|
||||
&& apt-get install -y --no-install-recommends \
|
||||
libmysqlclient21 libreadline8 libicu74 libncurses5-dev \
|
||||
gettext-base default-mysql-client \
|
||||
adduser \
|
||||
&& rm -rf /var/lib/apt/lists/*
|
||||
|
||||
COPY --from=build /azerothcore/env/dist/etc/ /azerothcore/env/ref/etc
|
||||
|
||||
@@ -129,10 +130,13 @@ VOLUME /azerothcore/env/dist/etc
|
||||
|
||||
ENV PATH="/azerothcore/env/dist/bin:$PATH"
|
||||
|
||||
RUN groupadd --gid "$GROUP_ID" "$DOCKER_USER" && \
|
||||
useradd -d /azerothcore --uid "$USER_ID" --gid "$GROUP_ID" "$DOCKER_USER" && \
|
||||
passwd -d "$DOCKER_USER" && \
|
||||
chown -R "$DOCKER_USER:$DOCKER_USER" /azerothcore
|
||||
# To use GID/UID 1000 in ubuntu > 23.04 the existing user must be deleted
|
||||
# See https://bugs.launchpad.net/cloud-images/+bug/2005129
|
||||
RUN userdel --remove ubuntu \
|
||||
&& addgroup --gid "$GROUP_ID" "$DOCKER_USER" \
|
||||
&& adduser --disabled-password --gecos '' --uid "$USER_ID" --gid "$GROUP_ID" "$DOCKER_USER" \
|
||||
&& passwd -d "$DOCKER_USER" \
|
||||
&& chown -R "$DOCKER_USER:$DOCKER_USER" /azerothcore
|
||||
|
||||
COPY --chown=$USER_ID:$GROUP_ID \
|
||||
--chmod=755 \
|
||||
|
||||
@@ -68,4 +68,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:00
|
||||
-- Dump completed on 2026-06-01 22:41:20
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:00
|
||||
-- Dump completed on 2026-06-01 22:41:20
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:00
|
||||
-- Dump completed on 2026-06-01 22:41:21
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:00
|
||||
-- Dump completed on 2026-06-01 22:41:21
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:01
|
||||
-- Dump completed on 2026-06-01 22:41:21
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:01
|
||||
-- Dump completed on 2026-06-01 22:41:21
|
||||
|
||||
@@ -64,4 +64,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:01
|
||||
-- Dump completed on 2026-06-01 22:41:22
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:01
|
||||
-- Dump completed on 2026-06-01 22:41:22
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:02
|
||||
-- Dump completed on 2026-06-01 22:41:22
|
||||
|
||||
@@ -51,4 +51,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:02
|
||||
-- Dump completed on 2026-06-01 22:41:22
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:02
|
||||
-- Dump completed on 2026-06-01 22:41:23
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:03
|
||||
-- Dump completed on 2026-06-01 22:41:23
|
||||
|
||||
@@ -0,0 +1,52 @@
|
||||
-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64)
|
||||
--
|
||||
-- Host: localhost Database: acore_auth
|
||||
-- ------------------------------------------------------
|
||||
-- Server version 8.4.3
|
||||
|
||||
/*!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 */;
|
||||
/*!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 `rbac_account_permissions`
|
||||
--
|
||||
|
||||
DROP TABLE IF EXISTS `rbac_account_permissions`;
|
||||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||||
/*!50503 SET character_set_client = utf8mb4 */;
|
||||
CREATE TABLE `rbac_account_permissions` (
|
||||
`accountId` int unsigned NOT NULL COMMENT 'Account id',
|
||||
`permissionId` int unsigned NOT NULL COMMENT 'Permission id',
|
||||
`granted` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Granted = 1, Denied = 0',
|
||||
`realmId` int NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
|
||||
PRIMARY KEY (`accountId`,`permissionId`,`realmId`),
|
||||
KEY `fk__rbac_account_roles__rbac_permissions` (`permissionId`),
|
||||
CONSTRAINT `fk__rbac_account_permissions__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
|
||||
CONSTRAINT `fk__rbac_account_roles__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Account-Permission relation';
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
|
||||
--
|
||||
-- Dumping data for table `rbac_account_permissions`
|
||||
--
|
||||
|
||||
LOCK TABLES `rbac_account_permissions` WRITE;
|
||||
/*!40000 ALTER TABLE `rbac_account_permissions` DISABLE KEYS */;
|
||||
/*!40000 ALTER TABLE `rbac_account_permissions` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
/*!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 2026-06-01 22:41:23
|
||||
@@ -0,0 +1,55 @@
|
||||
-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64)
|
||||
--
|
||||
-- Host: localhost Database: acore_auth
|
||||
-- ------------------------------------------------------
|
||||
-- Server version 8.4.3
|
||||
|
||||
/*!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 */;
|
||||
/*!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 `rbac_default_permissions`
|
||||
--
|
||||
|
||||
DROP TABLE IF EXISTS `rbac_default_permissions`;
|
||||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||||
/*!50503 SET character_set_client = utf8mb4 */;
|
||||
CREATE TABLE `rbac_default_permissions` (
|
||||
`secId` int unsigned NOT NULL COMMENT 'Security Level id',
|
||||
`permissionId` int unsigned NOT NULL COMMENT 'permission id',
|
||||
`realmId` int NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
|
||||
PRIMARY KEY (`secId`,`permissionId`,`realmId`),
|
||||
KEY `fk__rbac_default_permissions__rbac_permissions` (`permissionId`),
|
||||
CONSTRAINT `fk__rbac_default_permissions__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`)
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Default permission to assign to different account security levels';
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
|
||||
--
|
||||
-- Dumping data for table `rbac_default_permissions`
|
||||
--
|
||||
|
||||
LOCK TABLES `rbac_default_permissions` WRITE;
|
||||
/*!40000 ALTER TABLE `rbac_default_permissions` DISABLE KEYS */;
|
||||
INSERT INTO `rbac_default_permissions` VALUES
|
||||
(3,192,-1),
|
||||
(2,193,-1),
|
||||
(1,194,-1),
|
||||
(0,195,-1);
|
||||
/*!40000 ALTER TABLE `rbac_default_permissions` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
/*!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 2026-06-01 22:41:23
|
||||
@@ -0,0 +1,685 @@
|
||||
-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64)
|
||||
--
|
||||
-- Host: localhost Database: acore_auth
|
||||
-- ------------------------------------------------------
|
||||
-- Server version 8.4.3
|
||||
|
||||
/*!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 */;
|
||||
/*!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 `rbac_linked_permissions`
|
||||
--
|
||||
|
||||
DROP TABLE IF EXISTS `rbac_linked_permissions`;
|
||||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||||
/*!50503 SET character_set_client = utf8mb4 */;
|
||||
CREATE TABLE `rbac_linked_permissions` (
|
||||
`id` int unsigned NOT NULL COMMENT 'Permission id',
|
||||
`linkedId` int unsigned NOT NULL COMMENT 'Linked Permission id',
|
||||
PRIMARY KEY (`id`,`linkedId`),
|
||||
KEY `fk__rbac_linked_permissions__rbac_permissions1` (`id`),
|
||||
KEY `fk__rbac_linked_permissions__rbac_permissions2` (`linkedId`),
|
||||
CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions1` FOREIGN KEY (`id`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE,
|
||||
CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions2` FOREIGN KEY (`linkedId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Permission - Linked Permission relation';
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
|
||||
--
|
||||
-- Dumping data for table `rbac_linked_permissions`
|
||||
--
|
||||
|
||||
LOCK TABLES `rbac_linked_permissions` WRITE;
|
||||
/*!40000 ALTER TABLE `rbac_linked_permissions` DISABLE KEYS */;
|
||||
INSERT INTO `rbac_linked_permissions` VALUES
|
||||
(192,7),
|
||||
(192,21),
|
||||
(192,42),
|
||||
(192,43),
|
||||
(192,193),
|
||||
(192,196),
|
||||
(193,45),
|
||||
(193,48),
|
||||
(193,52),
|
||||
(193,53),
|
||||
(193,194),
|
||||
(193,197),
|
||||
(194,1),
|
||||
(194,2),
|
||||
(194,9),
|
||||
(194,11),
|
||||
(194,13),
|
||||
(194,14),
|
||||
(194,15),
|
||||
(194,16),
|
||||
(194,17),
|
||||
(194,18),
|
||||
(194,19),
|
||||
(194,20),
|
||||
(194,22),
|
||||
(194,23),
|
||||
(194,25),
|
||||
(194,26),
|
||||
(194,27),
|
||||
(194,28),
|
||||
(194,29),
|
||||
(194,30),
|
||||
(194,31),
|
||||
(194,32),
|
||||
(194,33),
|
||||
(194,34),
|
||||
(194,35),
|
||||
(194,36),
|
||||
(194,37),
|
||||
(194,38),
|
||||
(194,39),
|
||||
(194,40),
|
||||
(194,41),
|
||||
(194,44),
|
||||
(194,46),
|
||||
(194,47),
|
||||
(194,51),
|
||||
(194,195),
|
||||
(194,198),
|
||||
(194,632),
|
||||
(194,798),
|
||||
(195,3),
|
||||
(195,4),
|
||||
(195,5),
|
||||
(195,6),
|
||||
(195,24),
|
||||
(195,49),
|
||||
(195,199),
|
||||
(196,200),
|
||||
(196,201),
|
||||
(196,202),
|
||||
(196,203),
|
||||
(196,204),
|
||||
(196,205),
|
||||
(196,206),
|
||||
(196,219),
|
||||
(196,220),
|
||||
(196,224),
|
||||
(196,226),
|
||||
(196,227),
|
||||
(196,228),
|
||||
(196,229),
|
||||
(196,258),
|
||||
(196,259),
|
||||
(196,260),
|
||||
(196,261),
|
||||
(196,262),
|
||||
(196,265),
|
||||
(196,266),
|
||||
(196,278),
|
||||
(196,281),
|
||||
(196,282),
|
||||
(196,289),
|
||||
(196,290),
|
||||
(196,350),
|
||||
(196,351),
|
||||
(196,352),
|
||||
(196,353),
|
||||
(196,354),
|
||||
(196,355),
|
||||
(196,356),
|
||||
(196,357),
|
||||
(196,359),
|
||||
(196,360),
|
||||
(196,361),
|
||||
(196,362),
|
||||
(196,363),
|
||||
(196,364),
|
||||
(196,365),
|
||||
(196,366),
|
||||
(196,463),
|
||||
(196,464),
|
||||
(196,465),
|
||||
(196,503),
|
||||
(196,511),
|
||||
(196,524),
|
||||
(196,607),
|
||||
(196,608),
|
||||
(196,609),
|
||||
(196,610),
|
||||
(196,611),
|
||||
(196,612),
|
||||
(196,613),
|
||||
(196,614),
|
||||
(196,615),
|
||||
(196,616),
|
||||
(196,617),
|
||||
(196,618),
|
||||
(196,619),
|
||||
(196,620),
|
||||
(196,621),
|
||||
(196,622),
|
||||
(196,623),
|
||||
(196,624),
|
||||
(196,625),
|
||||
(196,626),
|
||||
(196,627),
|
||||
(196,629),
|
||||
(196,630),
|
||||
(196,631),
|
||||
(196,633),
|
||||
(196,634),
|
||||
(196,635),
|
||||
(196,636),
|
||||
(196,637),
|
||||
(196,638),
|
||||
(196,639),
|
||||
(196,640),
|
||||
(196,641),
|
||||
(196,642),
|
||||
(196,643),
|
||||
(196,644),
|
||||
(196,645),
|
||||
(196,646),
|
||||
(196,647),
|
||||
(196,648),
|
||||
(196,649),
|
||||
(196,650),
|
||||
(196,651),
|
||||
(196,652),
|
||||
(196,653),
|
||||
(196,654),
|
||||
(196,655),
|
||||
(196,656),
|
||||
(196,657),
|
||||
(196,658),
|
||||
(196,659),
|
||||
(196,660),
|
||||
(196,661),
|
||||
(196,662),
|
||||
(196,663),
|
||||
(196,664),
|
||||
(196,665),
|
||||
(196,666),
|
||||
(196,667),
|
||||
(196,668),
|
||||
(196,669),
|
||||
(196,670),
|
||||
(196,671),
|
||||
(196,672),
|
||||
(196,673),
|
||||
(196,674),
|
||||
(196,675),
|
||||
(196,676),
|
||||
(196,677),
|
||||
(196,678),
|
||||
(196,679),
|
||||
(196,680),
|
||||
(196,681),
|
||||
(196,682),
|
||||
(196,683),
|
||||
(196,684),
|
||||
(196,685),
|
||||
(196,686),
|
||||
(196,687),
|
||||
(196,688),
|
||||
(196,689),
|
||||
(196,690),
|
||||
(196,691),
|
||||
(196,692),
|
||||
(196,693),
|
||||
(196,694),
|
||||
(196,695),
|
||||
(196,696),
|
||||
(196,697),
|
||||
(196,698),
|
||||
(196,699),
|
||||
(196,701),
|
||||
(196,702),
|
||||
(196,703),
|
||||
(196,704),
|
||||
(196,706),
|
||||
(196,707),
|
||||
(196,708),
|
||||
(196,709),
|
||||
(196,710),
|
||||
(196,711),
|
||||
(196,712),
|
||||
(196,713),
|
||||
(196,714),
|
||||
(196,715),
|
||||
(196,716),
|
||||
(196,717),
|
||||
(196,718),
|
||||
(196,719),
|
||||
(196,720),
|
||||
(196,721),
|
||||
(196,722),
|
||||
(196,723),
|
||||
(196,724),
|
||||
(196,726),
|
||||
(196,727),
|
||||
(196,728),
|
||||
(196,729),
|
||||
(196,730),
|
||||
(196,731),
|
||||
(196,732),
|
||||
(196,733),
|
||||
(196,734),
|
||||
(196,735),
|
||||
(196,736),
|
||||
(196,748),
|
||||
(196,753),
|
||||
(196,757),
|
||||
(196,773),
|
||||
(196,777),
|
||||
(196,779),
|
||||
(196,780),
|
||||
(196,781),
|
||||
(196,782),
|
||||
(196,783),
|
||||
(196,784),
|
||||
(196,785),
|
||||
(196,786),
|
||||
(196,787),
|
||||
(196,788),
|
||||
(196,789),
|
||||
(196,790),
|
||||
(196,791),
|
||||
(196,792),
|
||||
(196,793),
|
||||
(196,839),
|
||||
(196,840),
|
||||
(196,843),
|
||||
(196,866),
|
||||
(196,867),
|
||||
(196,872),
|
||||
(196,873),
|
||||
(196,880),
|
||||
(196,881),
|
||||
(196,886),
|
||||
(196,887),
|
||||
(196,888),
|
||||
(196,891),
|
||||
(196,894),
|
||||
(196,896),
|
||||
(196,905),
|
||||
(196,906),
|
||||
(196,907),
|
||||
(196,908),
|
||||
(196,912),
|
||||
(196,915),
|
||||
(196,922),
|
||||
(197,231),
|
||||
(197,232),
|
||||
(197,233),
|
||||
(197,234),
|
||||
(197,235),
|
||||
(197,236),
|
||||
(197,237),
|
||||
(197,238),
|
||||
(197,267),
|
||||
(197,268),
|
||||
(197,269),
|
||||
(197,270),
|
||||
(197,271),
|
||||
(197,272),
|
||||
(197,274),
|
||||
(197,275),
|
||||
(197,276),
|
||||
(197,279),
|
||||
(197,280),
|
||||
(197,283),
|
||||
(197,284),
|
||||
(197,285),
|
||||
(197,286),
|
||||
(197,287),
|
||||
(197,292),
|
||||
(197,293),
|
||||
(197,294),
|
||||
(197,295),
|
||||
(197,296),
|
||||
(197,297),
|
||||
(197,298),
|
||||
(197,299),
|
||||
(197,300),
|
||||
(197,343),
|
||||
(197,344),
|
||||
(197,346),
|
||||
(197,347),
|
||||
(197,367),
|
||||
(197,368),
|
||||
(197,369),
|
||||
(197,370),
|
||||
(197,371),
|
||||
(197,372),
|
||||
(197,373),
|
||||
(197,376),
|
||||
(197,377),
|
||||
(197,388),
|
||||
(197,389),
|
||||
(197,390),
|
||||
(197,391),
|
||||
(197,392),
|
||||
(197,393),
|
||||
(197,394),
|
||||
(197,396),
|
||||
(197,397),
|
||||
(197,398),
|
||||
(197,399),
|
||||
(197,401),
|
||||
(197,402),
|
||||
(197,403),
|
||||
(197,404),
|
||||
(197,405),
|
||||
(197,406),
|
||||
(197,407),
|
||||
(197,409),
|
||||
(197,410),
|
||||
(197,411),
|
||||
(197,413),
|
||||
(197,414),
|
||||
(197,415),
|
||||
(197,416),
|
||||
(197,417),
|
||||
(197,419),
|
||||
(197,420),
|
||||
(197,421),
|
||||
(197,422),
|
||||
(197,423),
|
||||
(197,424),
|
||||
(197,425),
|
||||
(197,426),
|
||||
(197,427),
|
||||
(197,428),
|
||||
(197,429),
|
||||
(197,431),
|
||||
(197,432),
|
||||
(197,433),
|
||||
(197,434),
|
||||
(197,435),
|
||||
(197,436),
|
||||
(197,437),
|
||||
(197,438),
|
||||
(197,439),
|
||||
(197,440),
|
||||
(197,441),
|
||||
(197,445),
|
||||
(197,448),
|
||||
(197,449),
|
||||
(197,451),
|
||||
(197,452),
|
||||
(197,453),
|
||||
(197,454),
|
||||
(197,457),
|
||||
(197,458),
|
||||
(197,460),
|
||||
(197,461),
|
||||
(197,472),
|
||||
(197,473),
|
||||
(197,474),
|
||||
(197,475),
|
||||
(197,476),
|
||||
(197,477),
|
||||
(197,478),
|
||||
(197,479),
|
||||
(197,480),
|
||||
(197,481),
|
||||
(197,482),
|
||||
(197,483),
|
||||
(197,484),
|
||||
(197,485),
|
||||
(197,486),
|
||||
(197,487),
|
||||
(197,488),
|
||||
(197,489),
|
||||
(197,490),
|
||||
(197,491),
|
||||
(197,492),
|
||||
(197,493),
|
||||
(197,494),
|
||||
(197,495),
|
||||
(197,497),
|
||||
(197,498),
|
||||
(197,499),
|
||||
(197,500),
|
||||
(197,502),
|
||||
(197,504),
|
||||
(197,506),
|
||||
(197,508),
|
||||
(197,509),
|
||||
(197,512),
|
||||
(197,513),
|
||||
(197,514),
|
||||
(197,516),
|
||||
(197,518),
|
||||
(197,519),
|
||||
(197,520),
|
||||
(197,521),
|
||||
(197,522),
|
||||
(197,523),
|
||||
(197,526),
|
||||
(197,527),
|
||||
(197,528),
|
||||
(197,529),
|
||||
(197,530),
|
||||
(197,531),
|
||||
(197,533),
|
||||
(197,535),
|
||||
(197,536),
|
||||
(197,537),
|
||||
(197,538),
|
||||
(197,539),
|
||||
(197,540),
|
||||
(197,541),
|
||||
(197,542),
|
||||
(197,543),
|
||||
(197,544),
|
||||
(197,545),
|
||||
(197,546),
|
||||
(197,547),
|
||||
(197,548),
|
||||
(197,549),
|
||||
(197,550),
|
||||
(197,551),
|
||||
(197,552),
|
||||
(197,553),
|
||||
(197,554),
|
||||
(197,555),
|
||||
(197,556),
|
||||
(197,557),
|
||||
(197,558),
|
||||
(197,559),
|
||||
(197,560),
|
||||
(197,561),
|
||||
(197,562),
|
||||
(197,563),
|
||||
(197,564),
|
||||
(197,565),
|
||||
(197,566),
|
||||
(197,567),
|
||||
(197,568),
|
||||
(197,569),
|
||||
(197,571),
|
||||
(197,572),
|
||||
(197,573),
|
||||
(197,574),
|
||||
(197,575),
|
||||
(197,576),
|
||||
(197,577),
|
||||
(197,578),
|
||||
(197,579),
|
||||
(197,580),
|
||||
(197,581),
|
||||
(197,582),
|
||||
(197,583),
|
||||
(197,584),
|
||||
(197,585),
|
||||
(197,586),
|
||||
(197,587),
|
||||
(197,588),
|
||||
(197,589),
|
||||
(197,590),
|
||||
(197,591),
|
||||
(197,592),
|
||||
(197,593),
|
||||
(197,594),
|
||||
(197,595),
|
||||
(197,596),
|
||||
(197,597),
|
||||
(197,598),
|
||||
(197,599),
|
||||
(197,600),
|
||||
(197,601),
|
||||
(197,602),
|
||||
(197,603),
|
||||
(197,604),
|
||||
(197,605),
|
||||
(197,606),
|
||||
(197,737),
|
||||
(197,738),
|
||||
(197,739),
|
||||
(197,740),
|
||||
(197,741),
|
||||
(197,762),
|
||||
(197,763),
|
||||
(197,764),
|
||||
(197,766),
|
||||
(197,767),
|
||||
(197,768),
|
||||
(197,769),
|
||||
(197,770),
|
||||
(197,771),
|
||||
(197,772),
|
||||
(197,774),
|
||||
(197,794),
|
||||
(197,795),
|
||||
(197,796),
|
||||
(197,798),
|
||||
(197,837),
|
||||
(197,838),
|
||||
(197,841),
|
||||
(197,856),
|
||||
(197,857),
|
||||
(197,858),
|
||||
(197,859),
|
||||
(197,860),
|
||||
(197,861),
|
||||
(197,862),
|
||||
(197,863),
|
||||
(197,864),
|
||||
(197,865),
|
||||
(197,868),
|
||||
(197,874),
|
||||
(197,875),
|
||||
(197,876),
|
||||
(197,877),
|
||||
(197,884),
|
||||
(197,885),
|
||||
(197,889),
|
||||
(197,890),
|
||||
(197,892),
|
||||
(197,893),
|
||||
(197,895),
|
||||
(197,897),
|
||||
(197,909),
|
||||
(197,910),
|
||||
(197,911),
|
||||
(197,913),
|
||||
(197,916),
|
||||
(197,917),
|
||||
(197,918),
|
||||
(197,919),
|
||||
(197,923),
|
||||
(197,924),
|
||||
(197,925),
|
||||
(198,240),
|
||||
(198,241),
|
||||
(198,242),
|
||||
(198,243),
|
||||
(198,245),
|
||||
(198,246),
|
||||
(198,247),
|
||||
(198,249),
|
||||
(198,250),
|
||||
(198,251),
|
||||
(198,253),
|
||||
(198,254),
|
||||
(198,255),
|
||||
(198,256),
|
||||
(198,462),
|
||||
(198,466),
|
||||
(198,467),
|
||||
(198,468),
|
||||
(198,469),
|
||||
(198,470),
|
||||
(198,510),
|
||||
(198,515),
|
||||
(198,517),
|
||||
(198,532),
|
||||
(198,632),
|
||||
(198,742),
|
||||
(198,743),
|
||||
(198,744),
|
||||
(198,745),
|
||||
(198,746),
|
||||
(198,747),
|
||||
(198,749),
|
||||
(198,750),
|
||||
(198,751),
|
||||
(198,752),
|
||||
(198,754),
|
||||
(198,755),
|
||||
(198,756),
|
||||
(198,758),
|
||||
(198,759),
|
||||
(198,760),
|
||||
(198,914),
|
||||
(199,217),
|
||||
(199,218),
|
||||
(199,221),
|
||||
(199,222),
|
||||
(199,223),
|
||||
(199,225),
|
||||
(199,263),
|
||||
(199,374),
|
||||
(199,375),
|
||||
(199,442),
|
||||
(199,443),
|
||||
(199,444),
|
||||
(199,446),
|
||||
(199,447),
|
||||
(199,450),
|
||||
(199,455),
|
||||
(199,456),
|
||||
(199,459),
|
||||
(199,496),
|
||||
(199,501),
|
||||
(199,505),
|
||||
(199,507),
|
||||
(199,525),
|
||||
(199,534),
|
||||
(199,725),
|
||||
(199,797),
|
||||
(199,898),
|
||||
(199,899),
|
||||
(199,900),
|
||||
(199,901),
|
||||
(199,902),
|
||||
(199,903),
|
||||
(199,904),
|
||||
(300,920),
|
||||
(300,921);
|
||||
/*!40000 ALTER TABLE `rbac_linked_permissions` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
/*!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 2026-06-01 22:41:24
|
||||
@@ -0,0 +1,682 @@
|
||||
-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64)
|
||||
--
|
||||
-- Host: localhost Database: acore_auth
|
||||
-- ------------------------------------------------------
|
||||
-- Server version 8.4.3
|
||||
|
||||
/*!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 */;
|
||||
/*!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 `rbac_permissions`
|
||||
--
|
||||
|
||||
DROP TABLE IF EXISTS `rbac_permissions`;
|
||||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||||
/*!50503 SET character_set_client = utf8mb4 */;
|
||||
CREATE TABLE `rbac_permissions` (
|
||||
`id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id',
|
||||
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Permission name',
|
||||
PRIMARY KEY (`id`)
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Permission List';
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
|
||||
--
|
||||
-- Dumping data for table `rbac_permissions`
|
||||
--
|
||||
|
||||
LOCK TABLES `rbac_permissions` WRITE;
|
||||
/*!40000 ALTER TABLE `rbac_permissions` DISABLE KEYS */;
|
||||
INSERT INTO `rbac_permissions` VALUES
|
||||
(1,'Instant logout'),
|
||||
(2,'Skip Queue'),
|
||||
(3,'Join Normal Battleground'),
|
||||
(4,'Join Random Battleground'),
|
||||
(5,'Join Arenas'),
|
||||
(6,'Join Dungeon Finder'),
|
||||
(7,'Skip idle connection check'),
|
||||
(8,'Cannot earn achievements'),
|
||||
(9,'Cannot earn realm first achievements'),
|
||||
(11,'Log GM trades'),
|
||||
(13,'Skip Instance required bosses check'),
|
||||
(14,'Skip character creation team mask check'),
|
||||
(15,'Skip character creation class mask check'),
|
||||
(16,'Skip character creation race mask check'),
|
||||
(17,'Skip character creation reserved name check'),
|
||||
(18,'Skip character creation death knight min level check'),
|
||||
(19,'Skip needed requirements to use channel check'),
|
||||
(20,'Skip disable map check'),
|
||||
(21,'Skip reset talents when used more than allowed check'),
|
||||
(22,'Skip spam chat check'),
|
||||
(23,'Skip over-speed ping check'),
|
||||
(24,'Two side faction characters on the same account'),
|
||||
(25,'Allow say chat between factions'),
|
||||
(26,'Allow channel chat between factions'),
|
||||
(27,'Two side mail interaction'),
|
||||
(28,'See two side who list'),
|
||||
(29,'Add friends of other faction'),
|
||||
(30,'Save character without delay with .save command'),
|
||||
(31,'Use params with .unstuck command'),
|
||||
(32,'Can be assigned tickets with .assign ticket command'),
|
||||
(33,'Notify if a command was not found'),
|
||||
(34,'Check if should appear in list using .gm ingame command'),
|
||||
(35,'See all security levels with who command'),
|
||||
(36,'Filter whispers'),
|
||||
(37,'Use staff badge in chat'),
|
||||
(38,'Resurrect with full Health Points'),
|
||||
(39,'Restore saved gm setting states'),
|
||||
(40,'Allows to add a gm to friend list'),
|
||||
(41,'Use Config option START_GM_LEVEL to assign new character level'),
|
||||
(42,'Allows to use CMSG_WORLD_TELEPORT opcode'),
|
||||
(43,'Allows to use CMSG_WHOIS opcode'),
|
||||
(44,'Receive global GM messages/texts'),
|
||||
(45,'Join channels without announce'),
|
||||
(46,'Change channel settings without being channel moderator'),
|
||||
(47,'Can ignore lower security checks'),
|
||||
(48,'Enable IP, Last Login and EMail output in pinfo'),
|
||||
(49,'Forces to enter the email for confirmation on password change'),
|
||||
(50,'Allow user to check his own email with .account'),
|
||||
(51,'Allow trading between factions'),
|
||||
(52,'No battleground deserter debuff'),
|
||||
(53,'Can be AFK on the battleground'),
|
||||
(192,'Role: Sec Level Administrator'),
|
||||
(193,'Role: Sec Level Gamemaster'),
|
||||
(194,'Role: Sec Level Moderator'),
|
||||
(195,'Role: Sec Level Player'),
|
||||
(196,'Role: Administrator Commands'),
|
||||
(197,'Role: Gamemaster Commands'),
|
||||
(198,'Role: Moderator Commands'),
|
||||
(199,'Role: Player Commands'),
|
||||
(200,'Command: rbac'),
|
||||
(201,'Command: rbac account'),
|
||||
(202,'Command: rbac account list'),
|
||||
(203,'Command: rbac account grant'),
|
||||
(204,'Command: rbac account deny'),
|
||||
(205,'Command: rbac account revoke'),
|
||||
(206,'Command: rbac list'),
|
||||
(217,'Command: account'),
|
||||
(218,'Command: account addon'),
|
||||
(219,'Command: account create'),
|
||||
(220,'Command: account delete'),
|
||||
(221,'Command: account lock'),
|
||||
(222,'Command: account lock country'),
|
||||
(223,'Command: account lock ip'),
|
||||
(224,'Command: account onlinelist'),
|
||||
(225,'Command: account password'),
|
||||
(226,'Command: account set'),
|
||||
(227,'Command: account set addon'),
|
||||
(228,'Command: account set gmlevel'),
|
||||
(229,'Command: account set password'),
|
||||
(231,'Command: achievement add'),
|
||||
(232,'Command: achievement checkall'),
|
||||
(233,'Command: arena captain'),
|
||||
(234,'Command: arena create'),
|
||||
(235,'Command: arena disband'),
|
||||
(236,'Command: arena info'),
|
||||
(237,'Command: arena lookup'),
|
||||
(238,'Command: arena rename'),
|
||||
(240,'Command: ban account'),
|
||||
(241,'Command: ban character'),
|
||||
(242,'Command: ban ip'),
|
||||
(243,'Command: ban playeraccount'),
|
||||
(245,'Command: baninfo account'),
|
||||
(246,'Command: baninfo character'),
|
||||
(247,'Command: baninfo ip'),
|
||||
(249,'Command: banlist account'),
|
||||
(250,'Command: banlist character'),
|
||||
(251,'Command: banlist ip'),
|
||||
(253,'Command: unban account'),
|
||||
(254,'Command: unban character'),
|
||||
(255,'Command: unban ip'),
|
||||
(256,'Command: unban playeraccount'),
|
||||
(258,'Command: bf start'),
|
||||
(259,'Command: bf stop'),
|
||||
(260,'Command: bf switch'),
|
||||
(261,'Command: bf timer'),
|
||||
(262,'Command: bf enable'),
|
||||
(263,'Command: account email'),
|
||||
(265,'Command: account set sec email'),
|
||||
(266,'Command: account set sec regmail'),
|
||||
(267,'Command: cast'),
|
||||
(268,'Command: cast back'),
|
||||
(269,'Command: cast dist'),
|
||||
(270,'Command: cast self'),
|
||||
(271,'Command: cast target'),
|
||||
(272,'Command: cast dest'),
|
||||
(274,'Command: character customize'),
|
||||
(275,'Command: character changefaction'),
|
||||
(276,'Command: character changerace'),
|
||||
(278,'Command: character deleted delete'),
|
||||
(279,'Command: character deleted list'),
|
||||
(280,'Command: character deleted restore'),
|
||||
(281,'Command: character deleted old'),
|
||||
(282,'Command: character erase'),
|
||||
(283,'Command: character level'),
|
||||
(284,'Command: character rename'),
|
||||
(285,'Command: character reputation'),
|
||||
(286,'Command: character titles'),
|
||||
(287,'Command: levelup'),
|
||||
(289,'Command: pdump load'),
|
||||
(290,'Command: pdump write'),
|
||||
(292,'Command: cheat casttime'),
|
||||
(293,'Command: cheat cooldown'),
|
||||
(294,'Command: cheat explore'),
|
||||
(295,'Command: cheat god'),
|
||||
(296,'Command: cheat power'),
|
||||
(297,'Command: cheat status'),
|
||||
(298,'Command: cheat taxi'),
|
||||
(299,'Command: cheat waterwalk'),
|
||||
(300,'Command: debug'),
|
||||
(343,'Command: deserter bg add'),
|
||||
(344,'Command: deserter bg remove'),
|
||||
(346,'Command: deserter instance add'),
|
||||
(347,'Command: deserter instance remove'),
|
||||
(350,'Command: disable add achievement_criteria'),
|
||||
(351,'Command: disable add battleground'),
|
||||
(352,'Command: disable add map'),
|
||||
(353,'Command: disable add mmap'),
|
||||
(354,'Command: disable add outdoorpvp'),
|
||||
(355,'Command: disable add quest'),
|
||||
(356,'Command: disable add spell'),
|
||||
(357,'Command: disable add vmap'),
|
||||
(359,'Command: disable remove achievement_criteria'),
|
||||
(360,'Command: disable remove battleground'),
|
||||
(361,'Command: disable remove map'),
|
||||
(362,'Command: disable remove mmap'),
|
||||
(363,'Command: disable remove outdoorpvp'),
|
||||
(364,'Command: disable remove quest'),
|
||||
(365,'Command: disable remove spell'),
|
||||
(366,'Command: disable remove vmap'),
|
||||
(367,'Command: event info'),
|
||||
(368,'Command: event activelist'),
|
||||
(369,'Command: event start'),
|
||||
(370,'Command: event stop'),
|
||||
(371,'Command: gm'),
|
||||
(372,'Command: gm chat'),
|
||||
(373,'Command: gm fly'),
|
||||
(374,'Command: gm ingame'),
|
||||
(375,'Command: gm list'),
|
||||
(376,'Command: gm visible'),
|
||||
(377,'Command: go'),
|
||||
(388,'Command: gobject activate'),
|
||||
(389,'Command: gobject add'),
|
||||
(390,'Command: gobject add temp'),
|
||||
(391,'Command: gobject delete'),
|
||||
(392,'Command: gobject info'),
|
||||
(393,'Command: gobject move'),
|
||||
(394,'Command: gobject near'),
|
||||
(396,'Command: gobject set phase'),
|
||||
(397,'Command: gobject set state'),
|
||||
(398,'Command: gobject target'),
|
||||
(399,'Command: gobject turn'),
|
||||
(401,'Command: guild'),
|
||||
(402,'Command: guild create'),
|
||||
(403,'Command: guild delete'),
|
||||
(404,'Command: guild invite'),
|
||||
(405,'Command: guild uninvite'),
|
||||
(406,'Command: guild rank'),
|
||||
(407,'Command: guild rename'),
|
||||
(409,'Command: honor add'),
|
||||
(410,'Command: honor add kill'),
|
||||
(411,'Command: honor update'),
|
||||
(413,'Command: instance listbinds'),
|
||||
(414,'Command: instance unbind'),
|
||||
(415,'Command: instance stats'),
|
||||
(416,'Command: instance savedata'),
|
||||
(417,'Command: learn'),
|
||||
(419,'Command: learn all my'),
|
||||
(420,'Command: learn all my class'),
|
||||
(421,'Command: learn my pettalents'),
|
||||
(422,'Command: learn all my spells'),
|
||||
(423,'Command: learn all talents'),
|
||||
(424,'Command: learn all gm'),
|
||||
(425,'Command: learn all crafts'),
|
||||
(426,'Command: learn all default'),
|
||||
(427,'Command: learn all lang'),
|
||||
(428,'Command: learn all recipes'),
|
||||
(429,'Command: unlearn'),
|
||||
(431,'Command: lfg player'),
|
||||
(432,'Command: lfg group'),
|
||||
(433,'Command: lfg queue'),
|
||||
(434,'Command: lfg clean'),
|
||||
(435,'Command: lfg options'),
|
||||
(436,'Command: lfg cooldown'),
|
||||
(437,'Command: list creature'),
|
||||
(438,'Command: list item'),
|
||||
(439,'Command: list object'),
|
||||
(440,'Command: list auras'),
|
||||
(441,'Command: list mail'),
|
||||
(442,'Command: lookup'),
|
||||
(443,'Command: lookup area'),
|
||||
(444,'Command: lookup creature'),
|
||||
(445,'Command: lookup event'),
|
||||
(446,'Command: lookup faction'),
|
||||
(447,'Command: lookup item'),
|
||||
(448,'Command: lookup itemset'),
|
||||
(449,'Command: lookup object'),
|
||||
(450,'Command: lookup quest'),
|
||||
(451,'Command: lookup player'),
|
||||
(452,'Command: lookup player ip'),
|
||||
(453,'Command: lookup player account'),
|
||||
(454,'Command: lookup player email'),
|
||||
(455,'Command: lookup skill'),
|
||||
(456,'Command: lookup spell'),
|
||||
(457,'Command: lookup spell id'),
|
||||
(458,'Command: lookup taxinode'),
|
||||
(459,'Command: lookup tele'),
|
||||
(460,'Command: lookup title'),
|
||||
(461,'Command: lookup map'),
|
||||
(462,'Command: announce'),
|
||||
(463,'Command: channel'),
|
||||
(464,'Command: channel set'),
|
||||
(465,'Command: channel set ownership'),
|
||||
(466,'Command: gmannounce'),
|
||||
(467,'Command: gmnameannounce'),
|
||||
(468,'Command: gmnotify'),
|
||||
(469,'Command: nameannounce'),
|
||||
(470,'Command: notify'),
|
||||
(472,'Command: group'),
|
||||
(473,'Command: group leader'),
|
||||
(474,'Command: group disband'),
|
||||
(475,'Command: group remove'),
|
||||
(476,'Command: group join'),
|
||||
(477,'Command: group list'),
|
||||
(478,'Command: group summon'),
|
||||
(479,'Command: pet'),
|
||||
(480,'Command: pet create'),
|
||||
(481,'Command: pet learn'),
|
||||
(482,'Command: pet unlearn'),
|
||||
(483,'Command: send'),
|
||||
(484,'Command: send items'),
|
||||
(485,'Command: send mail'),
|
||||
(486,'Command: send message'),
|
||||
(487,'Command: send money'),
|
||||
(488,'Command: additem'),
|
||||
(489,'Command: additemset'),
|
||||
(490,'Command: appear'),
|
||||
(491,'Command: aura'),
|
||||
(492,'Command: bank'),
|
||||
(493,'Command: bindsight'),
|
||||
(494,'Command: combatstop'),
|
||||
(495,'Command: cometome'),
|
||||
(496,'Command: commands'),
|
||||
(497,'Command: cooldown'),
|
||||
(498,'Command: damage'),
|
||||
(499,'Command: dev'),
|
||||
(500,'Command: die'),
|
||||
(501,'Command: dismount'),
|
||||
(502,'Command: distance'),
|
||||
(503,'Command: flusharenapoints'),
|
||||
(504,'Command: freeze'),
|
||||
(505,'Command: gps'),
|
||||
(506,'Command: guid'),
|
||||
(507,'Command: help'),
|
||||
(508,'Command: hidearea'),
|
||||
(509,'Command: itemmove'),
|
||||
(510,'Command: kick'),
|
||||
(511,'Command: linkgrave'),
|
||||
(512,'Command: listfreeze'),
|
||||
(513,'Command: maxskill'),
|
||||
(514,'Command: movegens'),
|
||||
(515,'Command: mute'),
|
||||
(516,'Command: neargrave'),
|
||||
(517,'Command: pinfo'),
|
||||
(518,'Command: playall'),
|
||||
(519,'Command: possess'),
|
||||
(520,'Command: recall'),
|
||||
(521,'Command: repairitems'),
|
||||
(522,'Command: respawn'),
|
||||
(523,'Command: revive'),
|
||||
(524,'Command: saveall'),
|
||||
(525,'Command: save'),
|
||||
(526,'Command: setskill'),
|
||||
(527,'Command: showarea'),
|
||||
(528,'Command: summon'),
|
||||
(529,'Command: unaura'),
|
||||
(530,'Command: unbindsight'),
|
||||
(531,'Command: unfreeze'),
|
||||
(532,'Command: unmute'),
|
||||
(533,'Command: unpossess'),
|
||||
(534,'Command: unstuck'),
|
||||
(535,'Command: wchange'),
|
||||
(536,'Command: mmap'),
|
||||
(537,'Command: mmap loadedtiles'),
|
||||
(538,'Command: mmap loc'),
|
||||
(539,'Command: mmap path'),
|
||||
(540,'Command: mmap stats'),
|
||||
(541,'Command: mmap testarea'),
|
||||
(542,'Command: morph'),
|
||||
(543,'Command: demorph'),
|
||||
(544,'Command: modify'),
|
||||
(545,'Command: modify arenapoints'),
|
||||
(546,'Command: modify bit'),
|
||||
(547,'Command: modify drunk'),
|
||||
(548,'Command: modify energy'),
|
||||
(549,'Command: modify faction'),
|
||||
(550,'Command: modify gender'),
|
||||
(551,'Command: modify honor'),
|
||||
(552,'Command: modify hp'),
|
||||
(553,'Command: modify mana'),
|
||||
(554,'Command: modify money'),
|
||||
(555,'Command: modify mount'),
|
||||
(556,'Command: modify phase'),
|
||||
(557,'Command: modify rage'),
|
||||
(558,'Command: modify reputation'),
|
||||
(559,'Command: modify runicpower'),
|
||||
(560,'Command: modify scale'),
|
||||
(561,'Command: modify speed'),
|
||||
(562,'Command: modify speed all'),
|
||||
(563,'Command: modify speed backwalk'),
|
||||
(564,'Command: modify speed fly'),
|
||||
(565,'Command: modify speed walk'),
|
||||
(566,'Command: modify speed swim'),
|
||||
(567,'Command: modify spell'),
|
||||
(568,'Command: modify standstate'),
|
||||
(569,'Command: modify talentpoints'),
|
||||
(571,'Command: npc add'),
|
||||
(572,'Command: npc add formation'),
|
||||
(573,'Command: npc add item'),
|
||||
(574,'Command: npc add move'),
|
||||
(575,'Command: npc add temp'),
|
||||
(576,'Command: npc delete'),
|
||||
(577,'Command: npc delete item'),
|
||||
(578,'Command: npc follow'),
|
||||
(579,'Command: npc follow stop'),
|
||||
(580,'Command: npc set'),
|
||||
(581,'Command: npc set allowmove'),
|
||||
(582,'Command: npc set entry'),
|
||||
(583,'Command: npc set factionid'),
|
||||
(584,'Command: npc set flag'),
|
||||
(585,'Command: npc set level'),
|
||||
(586,'Command: npc set link'),
|
||||
(587,'Command: npc set model'),
|
||||
(588,'Command: npc set movetype'),
|
||||
(589,'Command: npc set phase'),
|
||||
(590,'Command: npc set spawndist'),
|
||||
(591,'Command: npc set spawntime'),
|
||||
(592,'Command: npc set data'),
|
||||
(593,'Command: npc info'),
|
||||
(594,'Command: npc near'),
|
||||
(595,'Command: npc move'),
|
||||
(596,'Command: npc playemote'),
|
||||
(597,'Command: npc say'),
|
||||
(598,'Command: npc textemote'),
|
||||
(599,'Command: npc whisper'),
|
||||
(600,'Command: npc yell'),
|
||||
(601,'Command: npc tame'),
|
||||
(602,'Command: quest'),
|
||||
(603,'Command: quest add'),
|
||||
(604,'Command: quest complete'),
|
||||
(605,'Command: quest remove'),
|
||||
(606,'Command: quest reward'),
|
||||
(607,'Command: reload'),
|
||||
(608,'Command: reload access_requirement'),
|
||||
(609,'Command: reload achievement_criteria_data'),
|
||||
(610,'Command: reload achievement_reward'),
|
||||
(611,'Command: reload all'),
|
||||
(612,'Command: reload all achievement'),
|
||||
(613,'Command: reload all area'),
|
||||
(614,'Command: reload broadcast_text'),
|
||||
(615,'Command: reload all gossips'),
|
||||
(616,'Command: reload all item'),
|
||||
(617,'Command: reload all locales'),
|
||||
(618,'Command: reload all loot'),
|
||||
(619,'Command: reload all npc'),
|
||||
(620,'Command: reload all quest'),
|
||||
(621,'Command: reload all scripts'),
|
||||
(622,'Command: reload all spell'),
|
||||
(623,'Command: reload areatrigger_involvedrelation'),
|
||||
(624,'Command: reload areatrigger_tavern'),
|
||||
(625,'Command: reload areatrigger_teleport'),
|
||||
(626,'Command: reload auctions'),
|
||||
(627,'Command: reload autobroadcast'),
|
||||
(629,'Command: reload conditions'),
|
||||
(630,'Command: reload config'),
|
||||
(631,'Command: reload battleground_template'),
|
||||
(632,'Command: mutehistory'),
|
||||
(633,'Command: reload creature_linked_respawn'),
|
||||
(634,'Command: reload creature_loot_template'),
|
||||
(635,'Command: reload creature_onkill_reputation'),
|
||||
(636,'Command: reload creature_questender'),
|
||||
(637,'Command: reload creature_queststarter'),
|
||||
(638,'Command: reload creature_summon_groups'),
|
||||
(639,'Command: reload creature_template'),
|
||||
(640,'Command: reload creature_text'),
|
||||
(641,'Command: reload disables'),
|
||||
(642,'Command: reload disenchant_loot_template'),
|
||||
(643,'Command: reload event_scripts'),
|
||||
(644,'Command: reload fishing_loot_template'),
|
||||
(645,'Command: reload graveyard_zone'),
|
||||
(646,'Command: reload game_tele'),
|
||||
(647,'Command: reload gameobject_questender'),
|
||||
(648,'Command: reload gameobject_quest_loot_template'),
|
||||
(649,'Command: reload gameobject_queststarter'),
|
||||
(650,'Command: reload gm_tickets'),
|
||||
(651,'Command: reload gossip_menu'),
|
||||
(652,'Command: reload gossip_menu_option'),
|
||||
(653,'Command: reload item_enchantment_template'),
|
||||
(654,'Command: reload item_loot_template'),
|
||||
(655,'Command: reload item_set_names'),
|
||||
(656,'Command: reload lfg_dungeon_rewards'),
|
||||
(657,'Command: reload achievement_reward_locale'),
|
||||
(658,'Command: reload creature_template_locale'),
|
||||
(659,'Command: reload creature_text_locale'),
|
||||
(660,'Command: reload gameobject_template_locale'),
|
||||
(661,'Command: reload gossip_menu_option_locale'),
|
||||
(662,'Command: reload item_template_locale'),
|
||||
(663,'Command: reload item_set_name_locale'),
|
||||
(664,'Command: reload npc_text_locale'),
|
||||
(665,'Command: reload page_text_locale'),
|
||||
(666,'Command: reload points_of_interest_locale'),
|
||||
(667,'Command: reload quest_template_locale'),
|
||||
(668,'Command: reload mail_level_reward'),
|
||||
(669,'Command: reload mail_loot_template'),
|
||||
(670,'Command: reload milling_loot_template'),
|
||||
(671,'Command: reload npc_spellclick_spells'),
|
||||
(672,'Command: reload trainer'),
|
||||
(673,'Command: reload npc_vendor'),
|
||||
(674,'Command: reload page_text'),
|
||||
(675,'Command: reload pickpocketing_loot_template'),
|
||||
(676,'Command: reload points_of_interest'),
|
||||
(677,'Command: reload prospecting_loot_template'),
|
||||
(678,'Command: reload quest_poi'),
|
||||
(679,'Command: reload quest_template'),
|
||||
(680,'Command: reload rbac'),
|
||||
(681,'Command: reload reference_loot_template'),
|
||||
(682,'Command: reload reserved_name'),
|
||||
(683,'Command: reload reputation_reward_rate'),
|
||||
(684,'Command: reload reputation_spillover_template'),
|
||||
(685,'Command: reload skill_discovery_template'),
|
||||
(686,'Command: reload skill_extra_item_template'),
|
||||
(687,'Command: reload skill_fishing_base_level'),
|
||||
(688,'Command: reload skinning_loot_template'),
|
||||
(689,'Command: reload smart_scripts'),
|
||||
(690,'Command: reload spell_required'),
|
||||
(691,'Command: reload spell_area'),
|
||||
(692,'Command: reload spell_bonus_data'),
|
||||
(693,'Command: reload spell_group'),
|
||||
(694,'Command: reload spell_learn_spell'),
|
||||
(695,'Command: reload spell_loot_template'),
|
||||
(696,'Command: reload spell_linked_spell'),
|
||||
(697,'Command: reload spell_pet_auras'),
|
||||
(698,'Command: character changeaccount'),
|
||||
(699,'Command: reload spell_proc'),
|
||||
(701,'Command: reload spell_target_position'),
|
||||
(702,'Command: reload spell_threats'),
|
||||
(703,'Command: reload spell_group_stack_rules'),
|
||||
(704,'Command: reload acore_string'),
|
||||
(706,'Command: reload waypoint_scripts'),
|
||||
(707,'Command: reload waypoint_data'),
|
||||
(708,'Command: reload vehicle_accessory'),
|
||||
(709,'Command: reload vehicle_template_accessory'),
|
||||
(710,'Command: reset'),
|
||||
(711,'Command: reset achievements'),
|
||||
(712,'Command: reset honor'),
|
||||
(713,'Command: reset level'),
|
||||
(714,'Command: reset spells'),
|
||||
(715,'Command: reset stats'),
|
||||
(716,'Command: reset talents'),
|
||||
(717,'Command: reset all'),
|
||||
(718,'Command: server'),
|
||||
(719,'Command: server corpses'),
|
||||
(720,'Command: server exit'),
|
||||
(721,'Command: server idlerestart'),
|
||||
(722,'Command: server idlerestart cancel'),
|
||||
(723,'Command: server idleshutdown'),
|
||||
(724,'Command: server idleshutdown cancel'),
|
||||
(725,'Command: server info'),
|
||||
(726,'Command: server plimit'),
|
||||
(727,'Command: server restart'),
|
||||
(728,'Command: server restart cancel'),
|
||||
(729,'Command: server set'),
|
||||
(730,'Command: server set closed'),
|
||||
(731,'Command: server set difftime'),
|
||||
(732,'Command: server set loglevel'),
|
||||
(733,'Command: server set motd'),
|
||||
(734,'Command: server shutdown'),
|
||||
(735,'Command: server shutdown cancel'),
|
||||
(736,'Command: server motd'),
|
||||
(737,'Command: tele'),
|
||||
(738,'Command: tele add'),
|
||||
(739,'Command: tele del'),
|
||||
(740,'Command: tele name'),
|
||||
(741,'Command: tele group'),
|
||||
(742,'Command: ticket'),
|
||||
(743,'Command: ticket assign'),
|
||||
(744,'Command: ticket close'),
|
||||
(745,'Command: ticket closedlist'),
|
||||
(746,'Command: ticket comment'),
|
||||
(747,'Command: ticket complete'),
|
||||
(748,'Command: ticket delete'),
|
||||
(749,'Command: ticket escalate'),
|
||||
(750,'Command: ticket escalatedlist'),
|
||||
(751,'Command: ticket list'),
|
||||
(752,'Command: ticket onlinelist'),
|
||||
(753,'Command: ticket reset'),
|
||||
(754,'Command: ticket response'),
|
||||
(755,'Command: ticket response append'),
|
||||
(756,'Command: ticket response appendln'),
|
||||
(757,'Command: ticket togglesystem'),
|
||||
(758,'Command: ticket unassign'),
|
||||
(759,'Command: ticket viewid'),
|
||||
(760,'Command: ticket viewname'),
|
||||
(762,'Command: titles add'),
|
||||
(763,'Command: titles current'),
|
||||
(764,'Command: titles remove'),
|
||||
(766,'Command: titles set mask'),
|
||||
(767,'Command: wp'),
|
||||
(768,'Command: wp add'),
|
||||
(769,'Command: wp event'),
|
||||
(770,'Command: wp load'),
|
||||
(771,'Command: wp modify'),
|
||||
(772,'Command: wp unload'),
|
||||
(773,'Command: wp reload'),
|
||||
(774,'Command: wp show'),
|
||||
(777,'Command: mailbox'),
|
||||
(779,'Command: ahbot items'),
|
||||
(780,'Command: ahbot items gray'),
|
||||
(781,'Command: ahbot items white'),
|
||||
(782,'Command: ahbot items green'),
|
||||
(783,'Command: ahbot items blue'),
|
||||
(784,'Command: ahbot items purple'),
|
||||
(785,'Command: ahbot items orange'),
|
||||
(786,'Command: ahbot items yellow'),
|
||||
(787,'Command: ahbot ratio'),
|
||||
(788,'Command: ahbot ratio alliance'),
|
||||
(789,'Command: ahbot ratio horde'),
|
||||
(790,'Command: ahbot ratio neutral'),
|
||||
(791,'Command: ahbot rebuild'),
|
||||
(792,'Command: ahbot reload'),
|
||||
(793,'Command: ahbot status'),
|
||||
(794,'Command: guild info'),
|
||||
(795,'Command: instance setbossstate'),
|
||||
(796,'Command: instance getbossstate'),
|
||||
(797,'Command: pvpstats'),
|
||||
(798,'Command: modify xp'),
|
||||
(837,'Command: npc evade'),
|
||||
(838,'Command: pet level'),
|
||||
(839,'Command: server shutdown force'),
|
||||
(840,'Command: server restart force'),
|
||||
(841,'Command: neargraveyard'),
|
||||
(843,'Command: reload quest_greeting'),
|
||||
(856,'Command: npc spawngroup'),
|
||||
(857,'Command: npc despawngroup'),
|
||||
(858,'Command: gobject spawngroup'),
|
||||
(859,'Command: gobject despawngroup'),
|
||||
(860,'Command: list respawns'),
|
||||
(861,'Command: group set'),
|
||||
(862,'Command: group set assistant'),
|
||||
(863,'Command: group set maintank'),
|
||||
(864,'Command: group set mainassist'),
|
||||
(865,'Command: npc showloot'),
|
||||
(866,'Command: list spawnpoints'),
|
||||
(867,'Command: reload quest_greeting_locale'),
|
||||
(868,'Command: group revive'),
|
||||
(872,'Command: server debug'),
|
||||
(873,'Command: reload creature_movement_override'),
|
||||
(874,'Command: settings announcer'),
|
||||
(875,'Command: lookup map id'),
|
||||
(876,'Command: lookup item id'),
|
||||
(877,'Command: lookup quest id'),
|
||||
(880,'Command: pdump copy'),
|
||||
(881,'Command: reload vehicle_template'),
|
||||
(884,'Command: bg start'),
|
||||
(885,'Command: bg stop'),
|
||||
(886,'Command: item restore'),
|
||||
(887,'Command: item restore list'),
|
||||
(888,'Command: item refund'),
|
||||
(889,'Command: commentator'),
|
||||
(890,'Command: skirmish'),
|
||||
(891,'Command: string'),
|
||||
(892,'Command: opendoor'),
|
||||
(893,'Command: beastmaster'),
|
||||
(894,'Command: packetlog'),
|
||||
(895,'Command: aura stack'),
|
||||
(896,'Command: respawn all'),
|
||||
(897,'Command: gear repair'),
|
||||
(898,'Command: gear stats'),
|
||||
(899,'Command: spect'),
|
||||
(900,'Command: spect version'),
|
||||
(901,'Command: spect reset'),
|
||||
(902,'Command: spect spectate'),
|
||||
(903,'Command: spect watch'),
|
||||
(904,'Command: spect leave'),
|
||||
(905,'Command: arena season state'),
|
||||
(906,'Command: arena season reward'),
|
||||
(907,'Command: arena season deleteteams'),
|
||||
(908,'Command: arena season start'),
|
||||
(909,'Command: character check bank'),
|
||||
(910,'Command: character check bag'),
|
||||
(911,'Command: character check profession'),
|
||||
(912,'Command: gobject load'),
|
||||
(913,'Command: bf queue'),
|
||||
(914,'Command: pet list'),
|
||||
(915,'Command: pet delete'),
|
||||
(916,'Command: respawn creature guid'),
|
||||
(917,'Command: respawn gameobject guid'),
|
||||
(918,'Command: respawn creature entry'),
|
||||
(919,'Command: respawn gameobject entry'),
|
||||
(920,'Command: debug info'),
|
||||
(921,'Command: debug cosmetic'),
|
||||
(922,'Command: pet rename'),
|
||||
(923,'Command: chatfilter list'),
|
||||
(924,'Command: chatfilter add'),
|
||||
(925,'Command: chatfilter remove');
|
||||
/*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
/*!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 2026-06-01 22:41:24
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:03
|
||||
-- Dump completed on 2026-06-01 22:41:24
|
||||
|
||||
@@ -46,7 +46,7 @@ CREATE TABLE `realmlist` (
|
||||
LOCK TABLES `realmlist` WRITE;
|
||||
/*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
|
||||
INSERT INTO `realmlist` VALUES
|
||||
(1,'AzerothCore','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,12340);
|
||||
(1,'AzerothCore','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,12340);
|
||||
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
@@ -58,4 +58,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:03
|
||||
-- Dump completed on 2026-06-01 22:41:24
|
||||
|
||||
@@ -44,4 +44,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:03
|
||||
-- Dump completed on 2026-06-01 22:41:25
|
||||
|
||||
@@ -45,7 +45,14 @@ INSERT INTO `updates` VALUES
|
||||
('2025_02_16_00.sql','D59DF568B412F0A17B0ACC5C350420B81C87AAB2','RELEASED','2025-07-19 10:16:15',148),
|
||||
('2025_02_16_01.sql','6788795A29BFD097EE5D00E548EFF3831F9CFBCF','RELEASED','2025-07-19 10:16:15',103),
|
||||
('2025_07_03_00.sql','C28996618006B516134EC7FA4E1D58F2DF410548','RELEASED','2025-07-19 10:16:15',135),
|
||||
('2025_07_24_00.sql','FCC937F180EFFAA5B991D9B7CF9E2223B6C0C4D3','RELEASED','2025-12-29 17:51:44',34);
|
||||
('2025_07_24_00.sql','FCC937F180EFFAA5B991D9B7CF9E2223B6C0C4D3','RELEASED','2025-12-29 17:51:44',34),
|
||||
('2026_05_01_00.sql','66CFB76A3289DF9F2C10DAFEB39828665B075AB4','RELEASED','2026-06-01 22:32:00',125),
|
||||
('2026_05_03_00.sql','3815EC8BE2EBA3E7E2D620B5D613B5E448DD017D','RELEASED','2026-06-01 22:32:00',30),
|
||||
('2026_05_09_00.sql','9C9A0E11BED930ED368362224A85213751407D14','RELEASED','2026-06-01 22:32:00',30),
|
||||
('2026_05_14_00.sql','8918B1D9F35208FCE290A7AD72CD6465F3F017F2','RELEASED','2026-06-01 22:32:00',36),
|
||||
('2026_05_17_00.sql','5159474DB3F4D94B13C17139632B5EB55B323716','RELEASED','2026-06-01 22:32:00',60),
|
||||
('2026_05_24_00.sql','65815FE616DE9ACF14671FA5F28854D953C1FFF1','RELEASED','2026-06-01 22:32:00',28),
|
||||
('2026_06_01_00.sql','F6EA2C0136B1C8E97DCABC0FAE37451EFA8E8F64','RELEASED','2026-06-01 22:32:00',29);
|
||||
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
@@ -57,4 +64,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:04
|
||||
-- Dump completed on 2026-06-01 22:41:25
|
||||
|
||||
@@ -49,4 +49,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:04
|
||||
-- Dump completed on 2026-06-01 22:41:25
|
||||
|
||||
@@ -37,16 +37,7 @@ CREATE TABLE `uptime` (
|
||||
LOCK TABLES `uptime` WRITE;
|
||||
/*!40000 ALTER TABLE `uptime` DISABLE KEYS */;
|
||||
INSERT INTO `uptime` VALUES
|
||||
(1,1721169877,0,0,'AzerothCore rev. bdf204f1eb0c 2024-07-16 16:28:59 +0000 (time-for-A-SQUASH branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1734468956,0,0,'AzerothCore rev. 2923a4aa43d0 2024-12-17 12:28:46 -0300 (master branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1734470333,0,0,'AzerothCore rev. 2923a4aa43d0 2024-12-17 12:28:46 -0300 (master branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1734471110,0,0,'AzerothCore rev. 2923a4aa43d0 2024-12-17 12:28:46 -0300 (master branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1752912822,0,0,'AzerothCore rev. 9415d1bef80d 2025-07-05 11:29:15 +0200 (whisper-something-something branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1752913079,0,0,'AzerothCore rev. 9415d1bef80d 2025-07-05 11:29:15 +0200 (whisper-something-something branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1752919589,0,0,'AzerothCore rev. 9415d1bef80d 2025-07-05 11:29:15 +0200 (whisper-something-something branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1767027047,0,0,'AzerothCore rev. 10d105243f47 2025-12-29 17:44:37 +0100 (Last-DB-SQUASH-OF-2025-WOO-HOO-WOOP-WOOP branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1773603132,0,0,'AzerothCore rev. b87240941155 2026-03-15 08:58:27 +0000 (squash-in-mars branch) (Win64, RelWithDebInfo, Static)'),
|
||||
(1,1773603445,0,0,'AzerothCore rev. b87240941155 2026-03-15 08:58:27 +0000 (squash-in-mars branch) (Win64, RelWithDebInfo, Static)');
|
||||
(1,1780345921,0,0,'AzerothCore rev. 8b8ba243d8f7 2026-06-01 22:26:28 +0200 (master branch) (Win64, RelWithDebInfo, Static)');
|
||||
/*!40000 ALTER TABLE `uptime` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
@@ -58,4 +49,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:40:04
|
||||
-- Dump completed on 2026-06-01 22:41:25
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:32
|
||||
-- Dump completed on 2026-06-01 22:40:53
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:32
|
||||
-- Dump completed on 2026-06-01 22:40:53
|
||||
|
||||
@@ -51,4 +51,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:33
|
||||
-- Dump completed on 2026-06-01 22:40:53
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:33
|
||||
-- Dump completed on 2026-06-01 22:40:54
|
||||
|
||||
@@ -68,4 +68,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:33
|
||||
-- Dump completed on 2026-06-01 22:40:54
|
||||
|
||||
@@ -57,4 +57,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:33
|
||||
-- Dump completed on 2026-06-01 22:40:54
|
||||
|
||||
@@ -49,4 +49,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:34
|
||||
-- Dump completed on 2026-06-01 22:40:54
|
||||
|
||||
@@ -53,4 +53,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:34
|
||||
-- Dump completed on 2026-06-01 22:40:55
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:34
|
||||
-- Dump completed on 2026-06-01 22:40:55
|
||||
|
||||
@@ -44,4 +44,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:34
|
||||
-- Dump completed on 2026-06-01 22:40:55
|
||||
|
||||
@@ -24,6 +24,9 @@ CREATE TABLE `bugreport` (
|
||||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
|
||||
`type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||||
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
||||
`State` tinyint NOT NULL DEFAULT '1',
|
||||
`Assignee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||||
`Comment` longtext COLLATE utf8mb4_unicode_ci,
|
||||
PRIMARY KEY (`id`)
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Debug System';
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
@@ -45,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:35
|
||||
-- Dump completed on 2026-06-01 22:40:55
|
||||
|
||||
@@ -51,4 +51,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:35
|
||||
-- Dump completed on 2026-06-01 22:40:56
|
||||
|
||||
@@ -50,4 +50,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:35
|
||||
-- Dump completed on 2026-06-01 22:40:56
|
||||
|
||||
@@ -49,4 +49,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:35
|
||||
-- Dump completed on 2026-06-01 22:40:56
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:36
|
||||
-- Dump completed on 2026-06-01 22:40:56
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:36
|
||||
-- Dump completed on 2026-06-01 22:40:57
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:36
|
||||
-- Dump completed on 2026-06-01 22:40:57
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:36
|
||||
-- Dump completed on 2026-06-01 22:40:57
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:37
|
||||
-- Dump completed on 2026-06-01 22:40:57
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:37
|
||||
-- Dump completed on 2026-06-01 22:40:58
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:37
|
||||
-- Dump completed on 2026-06-01 22:40:58
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:37
|
||||
-- Dump completed on 2026-06-01 22:40:58
|
||||
|
||||
@@ -58,4 +58,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:38
|
||||
-- Dump completed on 2026-06-01 22:40:58
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:38
|
||||
-- Dump completed on 2026-06-01 22:40:59
|
||||
|
||||
@@ -43,4 +43,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:38
|
||||
-- Dump completed on 2026-06-01 22:40:59
|
||||
|
||||
@@ -44,4 +44,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:39
|
||||
-- Dump completed on 2026-06-01 22:40:59
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:39
|
||||
-- Dump completed on 2026-06-01 22:41:00
|
||||
|
||||
@@ -51,4 +51,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:39
|
||||
-- Dump completed on 2026-06-01 22:41:00
|
||||
|
||||
@@ -69,4 +69,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:40
|
||||
-- Dump completed on 2026-06-01 22:41:00
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:40
|
||||
-- Dump completed on 2026-06-01 22:41:00
|
||||
|
||||
@@ -50,4 +50,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:40
|
||||
-- Dump completed on 2026-06-01 22:41:00
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:40
|
||||
-- Dump completed on 2026-06-01 22:41:01
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:41
|
||||
-- Dump completed on 2026-06-01 22:41:01
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:41
|
||||
-- Dump completed on 2026-06-01 22:41:01
|
||||
|
||||
@@ -61,4 +61,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:41
|
||||
-- Dump completed on 2026-06-01 22:41:01
|
||||
|
||||
@@ -50,4 +50,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:41
|
||||
-- Dump completed on 2026-06-01 22:41:02
|
||||
|
||||
@@ -58,4 +58,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:42
|
||||
-- Dump completed on 2026-06-01 22:41:02
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:42
|
||||
-- Dump completed on 2026-06-01 22:41:02
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:42
|
||||
-- Dump completed on 2026-06-01 22:41:02
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:42
|
||||
-- Dump completed on 2026-06-01 22:41:03
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:43
|
||||
-- Dump completed on 2026-06-01 22:41:03
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:43
|
||||
-- Dump completed on 2026-06-01 22:41:03
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:43
|
||||
-- Dump completed on 2026-06-01 22:41:03
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:43
|
||||
-- Dump completed on 2026-06-01 22:41:04
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:44
|
||||
-- Dump completed on 2026-06-01 22:41:04
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:44
|
||||
-- Dump completed on 2026-06-01 22:41:04
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:44
|
||||
-- Dump completed on 2026-06-01 22:41:04
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:44
|
||||
-- Dump completed on 2026-06-01 22:41:05
|
||||
|
||||
@@ -74,4 +74,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:45
|
||||
-- Dump completed on 2026-06-01 22:41:05
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:45
|
||||
-- Dump completed on 2026-06-01 22:41:05
|
||||
|
||||
@@ -125,4 +125,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:45
|
||||
-- Dump completed on 2026-06-01 22:41:05
|
||||
|
||||
@@ -0,0 +1,47 @@
|
||||
-- MySQL dump 10.13 Distrib 8.4.3, for Win64 (x86_64)
|
||||
--
|
||||
-- Host: localhost Database: acore_characters
|
||||
-- ------------------------------------------------------
|
||||
-- Server version 8.4.3
|
||||
|
||||
/*!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 */;
|
||||
/*!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 `chat_filter`
|
||||
--
|
||||
|
||||
DROP TABLE IF EXISTS `chat_filter`;
|
||||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||||
/*!50503 SET character_set_client = utf8mb4 */;
|
||||
CREATE TABLE `chat_filter` (
|
||||
`ID` int unsigned NOT NULL AUTO_INCREMENT,
|
||||
`Word` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
||||
PRIMARY KEY (`ID`) USING BTREE
|
||||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||||
|
||||
--
|
||||
-- Dumping data for table `chat_filter`
|
||||
--
|
||||
|
||||
LOCK TABLES `chat_filter` WRITE;
|
||||
/*!40000 ALTER TABLE `chat_filter` DISABLE KEYS */;
|
||||
/*!40000 ALTER TABLE `chat_filter` ENABLE KEYS */;
|
||||
UNLOCK TABLES;
|
||||
|
||||
/*!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 2026-06-01 22:41:06
|
||||
@@ -62,4 +62,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:45
|
||||
-- Dump completed on 2026-06-01 22:41:06
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:46
|
||||
-- Dump completed on 2026-06-01 22:41:06
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:46
|
||||
-- Dump completed on 2026-06-01 22:41:06
|
||||
|
||||
@@ -45,4 +45,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:46
|
||||
-- Dump completed on 2026-06-01 22:41:07
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:46
|
||||
-- Dump completed on 2026-06-01 22:41:07
|
||||
|
||||
@@ -46,4 +46,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:47
|
||||
-- Dump completed on 2026-06-01 22:41:07
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:47
|
||||
-- Dump completed on 2026-06-01 22:41:07
|
||||
|
||||
@@ -62,4 +62,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:47
|
||||
-- Dump completed on 2026-06-01 22:41:08
|
||||
|
||||
@@ -47,4 +47,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:47
|
||||
-- Dump completed on 2026-06-01 22:41:08
|
||||
|
||||
@@ -60,4 +60,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:48
|
||||
-- Dump completed on 2026-06-01 22:41:08
|
||||
|
||||
@@ -54,4 +54,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:48
|
||||
-- Dump completed on 2026-06-01 22:41:08
|
||||
|
||||
@@ -54,4 +54,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:48
|
||||
-- Dump completed on 2026-06-01 22:41:09
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:48
|
||||
-- Dump completed on 2026-06-01 22:41:09
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:49
|
||||
-- Dump completed on 2026-06-01 22:41:09
|
||||
|
||||
@@ -48,4 +48,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:49
|
||||
-- Dump completed on 2026-06-01 22:41:09
|
||||
|
||||
@@ -52,4 +52,4 @@ UNLOCK TABLES;
|
||||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||||
|
||||
-- Dump completed on 2026-03-15 20:39:49
|
||||
-- Dump completed on 2026-06-01 22:41:10
|
||||
|
||||
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user