Aethel Bot OSS repository!
aethel.xyz
scanash.com
bot
fun
ai
discord
discord-bot
aethel
1-- Database schema for Aethel
2
3CREATE TABLE IF NOT EXISTS users (
4 user_id TEXT PRIMARY KEY,
5 api_key_encrypted TEXT,
6 custom_model TEXT,
7 custom_api_url TEXT,
8 language VARCHAR(10) DEFAULT 'en',
9 created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
10);
11
12-- Create index for users table
13CREATE INDEX IF NOT EXISTS idx_users_language ON users(language);
14
15CREATE TABLE IF NOT EXISTS reminders (
16 reminder_id TEXT PRIMARY KEY,
17 user_id TEXT REFERENCES users(user_id),
18 user_tag TEXT,
19 channel_id TEXT,
20 guild_id TEXT,
21 message TEXT,
22 expires_at TIMESTAMPTZ NOT NULL,
23 is_completed BOOLEAN DEFAULT FALSE,
24 completed_at TIMESTAMPTZ,
25 metadata JSONB DEFAULT '{}',
26 created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP
27);