summaryrefslogtreecommitdiff
path: root/data/sql/base
AgeCommit message (Collapse)Author
2025-07-19feat(DB): Release ACDB 13.0.0 (#22508)Kitzunu
2025-06-28refactor(db-scripts): replace PowerShell database tools with Bash scripts ↵Kitzunu
and update documentation (#22372) * closes https://github.com/azerothcore/azerothcore-wotlk/issues/4343 This pull request replaces the PowerShell implementation of the AzerothCore database export and squash tools with Bash scripts, streamlining the process and improving compatibility. It also updates the documentation to reflect these changes. The most important changes include the creation of new Bash scripts for exporting databases, squashing databases, and updating versions, as well as the removal of the previous PowerShell script and its associated documentation. ### Script Replacement and Enhancements: * [`apps/DatabaseSquash/DatabaseExporter/DatabaseExporter.sh`](diffhunk://#diff-af0bd252ac095aaad91b842c75b60a689792e6dc9ce88f5e2e4b6f68acf84dcaR1-R69): Introduced a Bash script to replace the PowerShell implementation for exporting database tables, with added features such as formatted SQL output and dynamic directory creation. * [`apps/DatabaseSquash/DatabaseSquash.sh`](diffhunk://#diff-79ff4f749c045a7d91e9b43aefb5d6fbebdc5fdfb430fbcba329e4d96d71a4fbR1-R52): Added a Bash script to automate the database squash process, integrating the version updater and database exporter tools. * [`apps/DatabaseSquash/VersionUpdater/VersionUpdater.sh`](diffhunk://#diff-3abc69c645cb80aff30824739e317c9e847e743eeab15ab4825951d10179b265R1-R84): Created a Bash script for automatically updating the version in `acore.json` and generating SQL update files with proper versioning. ### Documentation Updates: * [`apps/DatabaseSquash/DatabaseExporter/databaseexporter.md`](diffhunk://#diff-b2b291286f2b900a022474f00754ebfe78410780c010d46752335a372d688aefR1-R16): Rewritten documentation to reflect the usage of the new Bash script for database exporting. * [`apps/DatabaseSquash/VersionUpdater/versionupdater.md`](diffhunk://#diff-f12e21f8a404957c90d9120cf9df0724ff27a7efdb5de0798d974079cfe8adadR1-R10): Added documentation for the new version updater tool, explaining its functionality and usage. * [`apps/DatabaseSquash/databasesquash.md`](diffhunk://#diff-4a559f6e7404b529714bac65ad22744feb7b9f88343864a20e0a46974233767eR1-R11): Documented the overall database squash tool, detailing its integration of the version updater and database exporter scripts. ### Removal of Legacy Code: * [`apps/DatabaseExporter/DatabaseExporter.ps1`](diffhunk://#diff-2b4e49f704d88a372b5160c7278839668c81dbecaf52a4edd327873e30b9ae70L1-L234): Removed the PowerShell script for database exporting, along with its associated functionality and settings. * [`apps/DatabaseExporter/databaseexporter.md`](diffhunk://#diff-0618d62def0d611be6e0d4fc524df6f702f493cb87870d9382402aaf52f484e8L1-L85): Deleted outdated documentation for the PowerShell-based database exporter tool.
2025-02-05fix(DB/world): delete base/db_world/player_classlevelstats.sql (#21329)sudlud
2024-12-18feat(DB): Release ACDB 12.0.1 (#20954)sudlud
2024-12-16feat(DB): New DB exporter and versioning tools for DB squashes (#20920)Kitzunu
2024-12-15feat(DB): Release ACDB 12.0.0 (#20921)Kitzunu
2024-11-15chore(DB): move 2023 update files (#20470)Francesco Borzì
* chore(DB): move 2023 update files * chore: flag files as archied
2024-07-18docs(DB): Database Squash (#19415)Kitzunu
2024-07-18fix(DB): Correct collation for c_t_model (#19428)Kitzunu
2024-07-17feat(DB): Release ACDB 11.0.0 (#19414)Kitzunu
2024-01-20fix(DB): Collation error (#18204)Kitzunu
* fix(DB): Collation error * closes https://github.com/azerothcore/azerothcore-wotlk/issues/18202 * Update 2024_01_20_06.sql
2024-01-20feat(DB): Release ACDB 10.0.0 (#18197)Kitzunu
* move archived files into old dir * auth * characters * world * mistake * revert some stuff * Squash time! * newline
2023-05-23fix(DB/Character): Allow names to be accent senstive (#16344)Kitzunu
* fix(DB/Character): Allow names to be accent senstive * closes https://github.com/azerothcore/azerothcore-wotlk/issues/16314 * Cherry-pick commit (https://github.com/TrinityCore/TrinityCore/commit/fb388298a0bf76402a6f1de35bdfcb33223d51bb) Co-authored-by: Shauren <shauren.trinity@gmail.com>
2023-04-25feat(DB): Release ACDB 9.0.0 (#16069)Gultask
* squishy
2023-02-11fix(DB): Separate INSERTs from base sql into smaller sections part 2 (#14938)Gultask
2023-02-08fix(DB): Separate INSERTs from base sql into smaller sections (#14881)Gultask
2023-02-01fix(DB): MariaDB Imports (#14841)Revision
2023-02-01feat(DB): release ACDB 8.0.0 (#14833)Gultask
2022-08-23fix(sql): Squash fix for mariadb (#12830)M'Dic
Update log_money.sql
2022-08-21feat(DB): release ACDB 7.0.0 (#12811)Kitzunu
* feat(DB): release ACDB 7.0.0 * cleanup * we try sourcery
2022-04-24fix(DB): Weird leftover (#11518)Kitzunu
2022-04-24feat(DB): release ACDB 6.0.0 (#11515)Kitzunu
2022-03-03feat(DB/Account): Delete auto increment in account table (#10879)Walter Pagani
2022-02-14refactor(Core/DB/playercreateinfo_spell_custom): Load empty (#10595)Kitzunu
2022-01-29feat(DB): release ACDB 5.0.0 (#10292)Kargatum
* auth * char * world * archive * new files * v * correct auth db * add support get last file from archive * correct world updates * fix auth * pendinig to normal * add pending auth * add pendings * smallint * MEDIUMINT
2021-10-20feat(DB): release ACDB 4.0.0 (#8494)Kargatum
***ATTENTION*** - To avoid mistakes need to update the core to https://github.com/azerothcore/azerothcore-wotlk/commit/9e3949232cc0ad1703eb4b8bba66dd54b4246ceb to add support correct archive dir and after can merge to actual commit
2021-06-27feat(Core/DBUpdater): implement db auto update (#6576)Kargatum
* feat(Core/DBUpdater): implement db auto update * 1 * 2 * 3 * Some minor improvements * add find bin for mysql 8.0 * lic Co-authored-by: Kitzunu <24550914+Kitzunu@users.noreply.github.com>
2021-06-17feat(Common/IPLocation): replace ip2nation by ip2location (#5653)Kargatum
2021-04-15fix(DB/Account): Remove default accounts (#5292)Kitzunu
2021-03-24refactor(DB/SQL): Update integer & utf to MySQL's new standards (#4929)Kitzunu
2021-01-25release: DB squash & begin AC 4.0.0 development (#4341)Francesco Borzì
2020-03-24fix(DB): error on default MySQL install (#2776)Viste
2019-02-17fix(DB): update chain after releaseFrancesco Borzì
2019-02-17DB squash & begin AC 3.0.0 developmentFrancesco Borzì
2019-02-16fix(setup): MySQL 5.7 (#1445)Francesco Borzì
2018-09-03DB/Characters: Remove unused tables "uptime" and "cheaters" (#1000)Barbz
* DB/Characters: Remove unused tables "uptime" and "cheaters"
2017-09-17Implement banned_addons (#647)barncastle
2017-08-21Revert changes to base account tableYehonal
We MUST NOT change the base sql if we've the update sql file otherwise db updating will fail
2017-06-30fix account.sqlNefertumm
2017-06-30Implement ip2nation and ip2nationCountriesNefertumm
2016-11-18Archived old sql files, they are now integrated in baseYehonal
2016-09-05[DB] fix on characters base tablesYehonal
Don't worry, you don't need to change anything in your db characters
2016-09-05[DB] Fixed Some strange missing data/fix on base dbYehonal
I've exported the database again starting from 0.x base and applying archived updates again We strongly suggest to reset your world db with new base and applying updates again. To save time, use our db_assembler script
2016-08-25Better names for sql folders + added custom and pendingYehonal
2016-08-21Script/Commands: fix all command permissionsShinDarth
2016-08-14Merge branch 'master' of github.com:azerothcore/azerothcore-wotlkYehonal
2016-08-14wrong db exportedYehonal
2016-08-14DB/Characters: fix code indentationShinDarth
2016-08-14DB/Characters: fix base dumpsShinDarth
2016-08-14base db is now splitted in multiple sqlYehonal
you can use db_assembler crossplatform tool from our repository to assemble it in a single sql file