Add discord_id

[ndwebbie.git] / database / discord.sql

diff --git a/database/discord.sql b/database/discord.sql
new file mode 100644 (file)
index 0000000..f5c950f
--- /dev/null
+++ b/database/discord.sql
@@ -0,0 +1,3 @@
+ALTER TABLE users ADD COLUMN IF NOT EXISTS discord_id text DEFAULT NULL UNIQUE;
+ALTER TABLE users ALTER COLUMN pnick DROP NOT NULL;
+ALTER TABLE users ALTER COLUMN hostmask DROP NOT NULL;