2.0.4_serverdata_overrides.sql

main 23 lines · 1.1 KB Raw
Alex Alex Commit Initial commit 01/10/2026 09:20
1-- ---------------------------------------------------------------------------
2-- ZnoteX 2.0.4 - Server data overrides (config / items / creatures editors)
3--
4-- admin/modules/config_editor.php, items_editor.php and creatures_editor.php
5-- let admins edit or add single records on top of the bulk-uploaded
6-- config.lua / items.xml / monster files handled by admin/modules/serverinfo.php.
7-- Overrides are stored here and merged over the parsed cache at read time
8-- (serverdata_apply_overrides(), called from serverdata_load()), so a later
9-- re-upload of the source file never discards a manual edit.
10-- ---------------------------------------------------------------------------
11
12CREATE TABLE IF NOT EXISTS `znote_serverdata_overrides` (
13 `id` int NOT NULL AUTO_INCREMENT,
14 `source` varchar(16) NOT NULL,
15 `record_key` varchar(191) NOT NULL,
16 `data` text NOT NULL,
17 `deleted` tinyint(1) NOT NULL DEFAULT '0',
18 `updated_by` varchar(64) DEFAULT NULL,
19 `updated_at` int NOT NULL,
20 PRIMARY KEY (`id`),
21 UNIQUE KEY `source_key` (`source`, `record_key`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
23
Top