aboutsummaryrefslogtreecommitdiff
path: root/cmd/marabot/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'cmd/marabot/schema.sql')
-rw-r--r--cmd/marabot/schema.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/cmd/marabot/schema.sql b/cmd/marabot/schema.sql
index 10a01fd..15d884d 100644
--- a/cmd/marabot/schema.sql
+++ b/cmd/marabot/schema.sql
@@ -67,3 +67,13 @@ CREATE TABLE IF NOT EXISTS discord_emoji (
name TEXT NOT NULL,
url TEXT NOT NULL
);
+
+CREATE TABLE IF NOT EXISTS irc_messages (
+ id SERIAL PRIMARY KEY,
+ nick TEXT NOT NULL,
+ user TEXT NOT NULL,
+ host TEXT NOT NULL,
+ channel TEXT NOT NULL,
+ content TEXT NOT NULL,
+ tags TEXT NOT NULL
+);