14 lines
314 B
PL/PgSQL
14 lines
314 B
PL/PgSQL
BEGIN;
|
|
|
|
CREATE TABLE voicelog_guilds(
|
|
guildid BIGINT PRIMARY KEY,
|
|
webhook_url TEXT,
|
|
created_at TIMESTAMPTZ DEFAULT NOW(),
|
|
_timestamp TIMESTAMPTZ DEFAULT NOW()
|
|
);
|
|
|
|
CREATE TRIGGER voicelog_guilds_timestamp BEFORE UPDATE ON voicelog_guilds
|
|
FOR EACH ROW EXECUTE FUNCTION update_timestamp_column();
|
|
|
|
COMMIT;
|