Milton Gonzalez
30bb546b84
Migracion 027 (device_accounts). Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
13 lines
679 B
SQL
13 lines
679 B
SQL
-- Cuentas del equipo que reporta el agente: usuarios con sesion iniciada (USERS), usuarios locales
|
|
-- (LOCAL_USERS) y grupos locales (LOCAL_GROUPS). Se reemplazan completas en cada reporte. Idempotente.
|
|
CREATE TABLE IF NOT EXISTS device_accounts (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
device_id INT NOT NULL,
|
|
kind ENUM('session','local_user','local_group') NOT NULL,
|
|
name VARCHAR(190) NOT NULL,
|
|
domain VARCHAR(190) NULL,
|
|
sid VARCHAR(190) NULL,
|
|
KEY idx_device_accounts_device (device_id, kind),
|
|
CONSTRAINT fk_device_accounts_device FOREIGN KEY (device_id) REFERENCES devices(id) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|