-- CY.CASH standalone extension tables.
-- Import AFTER a COPY of your GoldCoders-compatible schema into a separate development DB.
CREATE TABLE IF NOT EXISTS cy_auth_security (
 user_id BIGINT(20) NOT NULL,
 password_hash VARCHAR(255) NOT NULL,
 updated_at DATETIME NOT NULL,
 PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS cy_audit_log (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 user_id BIGINT NULL,
 action VARCHAR(100) NOT NULL,
 context_json LONGTEXT NULL,
 ip VARCHAR(50) NULL,
 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY(id), KEY user_action(user_id,action), KEY created_at(created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS cy_sessions (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 user_id BIGINT NOT NULL,
 session_fingerprint CHAR(64) NOT NULL,
 user_agent VARCHAR(255) NULL,
 ip VARCHAR(50) NULL,
 last_seen_at DATETIME NOT NULL,
 revoked_at DATETIME NULL,
 PRIMARY KEY(id), KEY user_id(user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;