aboutsummaryrefslogtreecommitdiff
path: root/cmd/marabot/schema.sql
diff options
context:
space:
mode:
authorXe Iaso <me@xeiaso.net>2023-06-16 11:36:13 -0400
committerXe Iaso <me@xeiaso.net>2023-06-16 11:36:13 -0400
commitf3d2b8386a188041b823d02b65dad347a324a089 (patch)
tree33f54cee9e8da6c48715f310c1279cc215c2d781 /cmd/marabot/schema.sql
parent636850d4e9b025d4f799ca5fd2aa7a936c1971f0 (diff)
downloadx-f3d2b8386a188041b823d02b65dad347a324a089.tar.xz
x-f3d2b8386a188041b823d02b65dad347a324a089.zip
fix the bot
Signed-off-by: Xe Iaso <me@xeiaso.net>
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
new file mode 100644
index 0000000..7d4046f
--- /dev/null
+++ b/cmd/marabot/schema.sql
@@ -0,0 +1,10 @@
+CREATE TABLE IF NOT EXISTS roles (
+ id SERIAL PRIMARY KEY,
+ discord_server TEXT NOT NULL,
+ discord_id TEXT NOT NULL,
+ revolt_server TEXT NOT NULL,
+ revolt_id TEXT NOT NULL,
+ name TEXT NOT NULL,
+ color TEXT NOT NULL,
+ hoist BOOLEAN NOT NULL
+); \ No newline at end of file