2.0.0_admin_log.sql

main 29 lines · 1.1 KB Raw
Alex Alex Commit Initial commit 01/10/2026 09:20
1-- ---------------------------------------------------------------------------
2-- ZnoteX 2.0.0 - admin action log
3--
4-- Only needed for databases created BEFORE this feature. A fresh import of
5-- SQL/znote_schema.sql already contains the table.
6--
7-- Records mutating actions taken from the admin panel (bans, skill edits,
8-- points, settings changes, plugin lifecycle, etc). Written by acp_log() in
9-- engine/function/adminlog.php, read from Admin Panel > Admin Log.
10--
11-- Run once:
12-- mysql -u <user> -p <database> < SQL/migrations/2.0.0_admin_log.sql
13-- ---------------------------------------------------------------------------
14
15CREATE TABLE IF NOT EXISTS `znote_admin_log` (
16 `id` int NOT NULL AUTO_INCREMENT,
17 `admin_id` int NOT NULL DEFAULT '0',
18 `admin_name` varchar(50) NOT NULL DEFAULT '',
19 `action` varchar(64) NOT NULL,
20 `target` varchar(191) NOT NULL DEFAULT '',
21 `details` text NOT NULL,
22 `ip` varchar(45) NOT NULL DEFAULT '',
23 `created` int NOT NULL,
24 PRIMARY KEY (`id`),
25 KEY `admin_created` (`admin_id`, `created`),
26 KEY `action_created` (`action`, `created`),
27 KEY `created` (`created`)
28) ENGINE=InnoDB;
29
Top