File size: 422 Bytes
1b4b6d2 | 1 2 3 4 5 6 7 8 9 10 11 12 | -- Migration: 005_ai_learning_memory
-- Description: Creates the qto_memory_rules table to store user-specific AI mappings and global rules.
CREATE TABLE IF NOT EXISTS qto_ai_category_mappings (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NULL,
original_text TEXT NOT NULL,
mapped_category TEXT NOT NULL,
status VARCHAR(50) DEFAULT 'pending',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
|