Diff

/var/www/vhosts/3dshawn.com/site1/_schema/drift_sense_key_encryption.sql

deleted on local at 2026-07-12 01:52:02

Added

lines

Removed

-30

lines

Context

unchanged

Blobs

from eede8caf8916
to

Unified diff

Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.

1		-- DriftSense -- Encrypted SSH-key storage
2		--
3		-- Adds two columns to SERVERS:
4		-- ssh_key_blob -- base64 ciphertext of a full PEM private key
5		-- ssh_key_enc -- indicator of how the blob was encrypted
6		-- (currently 'aes-256-cbc-pbkdf2', for future migration)
7		--
8		-- Idempotent: uses the same _drift_add_col procedure as
9		-- drift_sense_agent_mode.sql.
10
11		DELIMITER $$
12		DROP PROCEDURE IF EXISTS _drift_add_col $$
13		CREATE PROCEDURE _drift_add_col(IN t_name VARCHAR(64), IN c_name VARCHAR(64), IN c_ddl VARCHAR(500))
14		BEGIN
15		IF NOT EXISTS (
16		SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS
17		WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = t_name AND COLUMN_NAME = c_name
18		) THEN
19		SET @sql = CONCAT('ALTER TABLE ', t_name, ' ADD COLUMN ', c_name, ' ', c_ddl);
20		PREPARE stmt FROM @sql;
21		EXECUTE stmt;
22		DEALLOCATE PREPARE stmt;
23		END IF;
24		END $$
25		DELIMITER ;
26
27		CALL _drift_add_col('SERVERS', 'ssh_key_blob', 'TEXT DEFAULT NULL');
28		CALL _drift_add_col('SERVERS', 'ssh_key_enc', "VARCHAR(40) DEFAULT NULL");
29
30		DROP PROCEDURE _drift_add_col;