CREATE TABLE IF NOT EXISTS data_rag_index (
Guid VARCHAR(64) NOT NULL,
Collection VARCHAR(255) NOT NULL,
FilePath VARCHAR(512) NOT NULL,
ChunkCount INT DEFAULT 0,
IndexedAt DATETIME DEFAULT CURRENT_TIMESTAMP,
FileHash VARCHAR(64),
PRIMARY KEY (Collection, FilePath),
KEY idx_rag_guid (Guid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};