Aethel Bot OSS repository!
aethel.xyz
scanash.com
bot
fun
ai
discord
discord-bot
aethel
1-- Create reminders table (only if not exists from initial migration)
2CREATE TABLE IF NOT EXISTS reminders (
3 reminder_id TEXT PRIMARY KEY,
4 user_id TEXT NOT NULL,
5 user_tag TEXT NOT NULL,
6 channel_id TEXT,
7 guild_id TEXT,
8 message TEXT NOT NULL,
9 expires_at TIMESTAMPTZ NOT NULL,
10 is_completed BOOLEAN DEFAULT FALSE,
11 completed_at TIMESTAMPTZ,
12 metadata JSONB DEFAULT '{}',
13 created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
14);
15
16-- Index for faster lookups
17CREATE INDEX IF NOT EXISTS idx_reminders_user_id ON reminders(user_id);
18CREATE INDEX IF NOT EXISTS idx_reminders_expires_at ON reminders(expires_at) WHERE is_completed = FALSE;