Aethel Bot OSS repository!
aethel.xyz
scanash.com
bot
fun
ai
discord
discord-bot
aethel
1CREATE TABLE IF NOT EXISTS votes (
2 id SERIAL PRIMARY KEY,
3 user_id TEXT NOT NULL,
4 server_id TEXT,
5 vote_timestamp TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
6 claimed BOOLEAN DEFAULT FALSE,
7 credits_awarded INTEGER DEFAULT 10,
8 UNIQUE(user_id, server_id, vote_timestamp)
9);
10
11CREATE INDEX idx_votes_user ON votes(user_id, claimed);
12CREATE INDEX idx_votes_server ON votes(server_id, claimed) WHERE server_id IS NOT NULL;
13
14CREATE TABLE IF NOT EXISTS message_credits (
15 id SERIAL PRIMARY KEY,
16 user_id TEXT NOT NULL,
17 server_id TEXT,
18 credits_remaining INTEGER NOT NULL DEFAULT 0,
19 last_reset TIMESTAMP WITH TIME ZONE DEFAULT NOW()
20);
21
22CREATE UNIQUE INDEX idx_message_credits_user ON message_credits(user_id) WHERE server_id IS NULL;
23CREATE UNIQUE INDEX idx_message_credits_server ON message_credits(user_id, server_id) WHERE server_id IS NOT NULL;