CREATE TABLE IF NOT EXISTS `def_ai_bot_memory` (
`MemoryId` BIGINT NOT NULL AUTO_INCREMENT,
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjAi',
`SessionUser` VARCHAR(120) NOT NULL DEFAULT '',
`Mode` VARCHAR(20) NOT NULL DEFAULT 'builder',
`PromptText` LONGTEXT DEFAULT NULL,
`ResponseText` LONGTEXT DEFAULT NULL,
`Source` VARCHAR(30) NOT NULL DEFAULT '',
`ModelUsed` VARCHAR(160) NOT NULL DEFAULT '',
`MetaJson` LONGTEXT DEFAULT NULL,
`CreatedAt` DATETIME NOT NULL
DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`MemoryId`),
KEY `idx_ai_memory_lookup`
(`Package`, `SessionUser`,
`Mode`, `CreatedAt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation}