migrations/004_create_ai_usage_table.sql at dev · scanash.com/aethel

scanash.com / aethel

Aethel Bot OSS repository! aethel.xyz

bot fun ai discord discord-bot aethel

aethel / migrations / 004_create_ai_usage_table.sql

at dev 411 B view raw

 1-- Create ai_usage table for tracking AI command usage
 2CREATE TABLE IF NOT EXISTS ai_usage (
 3    user_id TEXT NOT NULL,
 4    usage_date DATE NOT NULL,
 5    count INTEGER DEFAULT 1,
 6    PRIMARY KEY (user_id, usage_date),
 7    FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE
 8);
 9
10-- Create index for faster lookups
11CREATE INDEX IF NOT EXISTS idx_ai_usage_user_date ON ai_usage(user_id, usage_date);