ddon-server/Arrowgene.Ddon.Database/Files/Database/Script
Nirrudn 38c6efe5be Fix Migration Syntax for Postgres
Corrects two problems that cause migration errors on Postgres, as pointed out by SirArren.
2026-07-29 17:05:33 -04:00
..
abilitypresets_migration_sqlite.sql Review comments. 2024-08-10 15:24:07 -07:00
adapt_ddon_edit_info_and_add_indexes.sql Make pg_loader consume less RAM by batching. 2025-04-18 16:59:06 +02:00
add_more_indexes_for_common_queries.sql Refactor persistence layer, add new 37>38 migration. 2025-04-19 15:23:30 +02:00
AddMissingOnDeleteCascades_migration.sql Avoid manipulating transaction in cascade migration to disable foreign key checks. 2024-08-24 10:53:49 +02:00
binarydata_migration.sql DB stuff for binary data. 2024-08-15 21:22:46 -07:00
bitterblack_maze_migration.sql Code Review Feedback 2024-08-23 15:14:39 -04:00
clan_base_migration.sql Even more clan stuff; DB migration 23 -> 24 2024-11-22 02:14:50 -08:00
clan_migration.sql make clan_id an autoincrement column 2024-12-22 19:50:46 -05:00
crest_migration.sql Add migration strategy 2024-08-02 08:24:19 -04:00
ddon_job_master_active_orders_progress_key_migration.sql refactor: Improve Job Training 2026-05-09 15:34:07 -04:00
ddon_job_master_active_orders_progress_primary_key_migration.sql Handle Postgres-specific autoincrement failures. 2025-05-05 00:15:55 +02:00
ddon_stamp_bonus_minimum_date_migration.sql Produce PSQL&SQLite compatible, safe minimum dates for stamp bonus. 2025-05-25 15:53:51 -04:00
equip_migration_sqlite.sql fix data type of boolean column so postgres works 2024-12-22 19:50:46 -05:00
equippoints_migration.sql DB Migration 2024-08-03 15:22:34 +02:00
group_chat_migration.sql feat: Add Sub Story Quest Handlers 2026-04-21 23:02:46 -04:00
item_safety_setting_migration.sql Add DB Migration 21 -> 22 2024-10-28 14:18:58 -07:00
item_uid_type_to_text_migration_postgresql.sql Add new UUIDv7 based item UID approach; migrates DB to v39. 2025-04-27 17:33:55 +02:00
item_uid_type_to_text_migration_sqlite.sql Add new UUIDv7 based item UID approach; migrates DB to v39. 2025-04-27 17:33:55 +02:00
migration_achievements.sql Actually remember to include a migration. Fix gathering bug. Fix migration. Fix dispel handler DB lock. 2025-04-09 18:21:26 -07:00
migration_arearank.sql Area Rank stuff in the DB. Migrates DB version 27 -> 28. 2025-02-21 21:37:43 -08:00
migration_bbm_paid_reset.sql Fix Migration Syntax for Postgres 2026-07-29 17:05:33 -04:00
migration_connection_characterid.sql Fix: General Bugfixes, April 2026 (#1031) 2026-04-30 21:28:52 -07:00
migration_dispel_seals.sql Fix: Bugfix Stack 08-21 ~ 09-02 (#958) 2025-09-17 02:17:30 -07:00
migration_epitaph_road.sql implement new packets, handlers and database queries 2024-11-24 19:01:03 -05:00
migration_equipment_limit_break.sql feat: Limit Break 2025-03-27 00:18:46 -04:00
migration_equipment_limit_break_datatype.sql Fix Postgres migration... again. 2025-08-27 01:38:28 -07:00
migration_extreme_mission_rewards.sql feat: Improve quest rewards 2026-05-03 22:02:46 -04:00
migration_hibo_3.0.sql fix: Fix issues reported 6/13/2025 2025-06-13 08:50:37 -04:00
migration_instanced_rewards.sql code review: Fix issues reported 2026-05-03 22:02:47 -04:00
migration_job_emblem.sql feat: Job Emblems 2025-05-23 23:00:13 -04:00
migration_job_item_storage_slot.sql Generate job items on BBM reset 2025-03-25 16:50:31 -07:00
migration_job_master.sql feat: Job Masters and Job Training 2025-04-16 09:33:33 -04:00
migration_job_master_skill_data.json Increase usage of AbilityId and CustomSkillId when possible. Move skill/ability data into an asset so Visual Studio screams less about that file. Pawns learn EX skills when their Arisen learns them. Newly created pawns inherit these. Migrate DB 49 -> 50. Fix bug with secret augment UI. 2025-08-24 22:58:16 -07:00
migration_job_stat_fix.sql Fix bad migration strategy sorry. 2025-03-27 22:37:02 -07:00
migration_light_quest_refactor.sql Remove skiptutorial. Add /ql for quest lookup due to ID changes. 2025-06-06 20:50:28 -07:00
migration_light_quest_type.sql Review comments. DB Migration 22 -> 23. 2024-10-24 18:50:45 -07:00
migration_mail_sqlite.sql fix data type of boolean column so postgres works 2024-12-22 19:50:46 -05:00
migration_msq_2.0.sql fix: Fix issue with 2.x migration 2024-10-01 09:53:08 -04:00
migration_msq_2.1.sql fix: Fix issue with 2.x migration 2024-10-01 09:53:08 -04:00
migration_msq_2.2.sql fix: Fix issue with 2.x migration 2024-10-01 09:53:08 -04:00
migration_msq_2.3.sql fix: Fix issue with 2.x migration 2024-10-01 09:53:08 -04:00
migration_msq_3.0.sql fix: Add migration files 2025-06-07 21:32:55 -04:00
migration_msq_3.1.sql feat: Season 3.1 main story quests 2025-06-15 11:31:35 -04:00
migration_partner_pawn.sql fixes diplicate private key name 2025-03-15 17:52:11 -04:00
migration_partner_pawn_pending_rewards_pk.sql Fix latest db migration 2026-03-19 01:31:45 +01:00
migration_pawn_favorites.sql feat: Add pawn favorites 2025-05-31 16:31:48 -04:00
migration_pawn_rental.sql Update Empty String in Migration Script 2025-07-21 15:50:49 -04:00
migration_pawn_state.sql Save pawn state in the database 2024-12-10 17:47:06 +01:00
migration_pp_sqlite.sql Address review comments, change DB PlayPoint stuff to use character_id instead of character_common_id. 2024-07-29 13:24:14 -07:00
migration_quest_delivery_progress.sql feat: Add support for partial deliveries 2026-05-09 08:57:52 -04:00
migration_quest_variant.sql Implemented review changes and updated sql to not delete but update entries 2024-09-03 10:03:15 +01:00
migration_quest_variant_refactor.sql DB Migration 2024-10-08 21:25:12 -04:00
migration_rank_records.sql Ranking Boards. 2025-02-21 21:55:15 -08:00
migration_recycle_equipment.sql feat: Add support for "Arms Resource Disassembly" 2025-03-24 22:39:20 -04:00
migration_rename_craft_remain_time_sqlite.sql Merged Migrations and minor adjustments. Final PR. 2026-03-17 00:28:39 +01:00
migration_rented_pawn.sql feat: Add support to hire pawns 2024-08-26 15:21:32 -04:00
migration_scheduling.sql feat: Implement a task scheduler 2024-12-15 08:29:07 -05:00
migration_serverside_localization.sql Fix Migration Syntax for Postgres 2026-07-29 17:05:33 -04:00
migration_skill_augmentation.sql feat: Add support for "Skill Augmentation" 2025-05-10 15:19:53 -04:00
migration_stamp_sqlite.sql Actually get stamp DB stuff fixed. 2024-08-05 01:32:56 -07:00
migration_substory_progress.sql feat: Add Sub Story Quest Handlers 2026-04-21 23:02:46 -04:00
migration_world_quest_rewards.sql feat: World Quest Rewards 2026-04-24 20:07:16 -04:00
migration_world_quest_rotation.sql feat: Implement World Quest Rotation 2026-04-05 08:02:02 -04:00
pawncraftingdata_migration.sql Add craft progress table to base schema & fix some syntax errors. 2024-08-11 20:42:14 +02:00
schema_sqlite.sql Feature: Serverside Localization 2026-07-07 11:26:47 -04:00
uid_migration.sql equippoints now load correctly when viewing the enhance menu 2024-08-02 18:21:03 +02:00