10 lines
272 B
SQL
10 lines
272 B
SQL
CREATE TABLE IF NOT EXISTS activity_log (
|
|
id TEXT PRIMARY KEY NOT NULL,
|
|
timestamp TEXT NOT NULL,
|
|
event_type TEXT NOT NULL,
|
|
detail TEXT NOT NULL,
|
|
channel_id TEXT
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_activity_log_timestamp ON activity_log(timestamp DESC);
|