3 files changed, 49 insertions, 0 deletions
diff --git a/bot/src/db/models/blacklist.js b/bot/src/db/models/blacklist.js
new file mode 100644
index 0000000..1542f91
--- /dev/null
+++ b/bot/src/db/models/blacklist.js
@@ -0,0 +1,30 @@
+import { INTEGER, STRING } from 'sequelize';
+import { sequelize } from '../../utils/sequelize.js';
+
+export const blacklistUser = sequelize.define('blacklist-users', {
+    id: {
+        type: INTEGER,
+        primaryKey: true,
+        autoIncrement: true,
+    },
+    userID: {
+        type: STRING,
+        allowNull: false
+    }
+}, {
+    updatedAt: false,
+});
+
+export const blacklistGuild = sequelize.define('blacklist-guilds', {
+    id: {
+        type: INTEGER,
+        primaryKey: true,
+        autoIncrement: true,
+    },
+    guildID: {
+        type: STRING,
+        allowNull: false
+    }
+}, {
+    updatedAt: false,
+});
diff --git a/bot/src/db/models/guild-settings.js b/bot/src/db/models/guild-settings.js
index 09cddd2..79f8fd6 100644
--- a/bot/src/db/models/guild-settings.js
+++ b/bot/src/db/models/guild-settings.js
@@ -1,6 +1,7 @@
 import { INTEGER, STRING, BOOLEAN } from 'sequelize';
 import { sequelize } from '../../utils/sequelize.js';
 
+// potentially rename the table to settings-guilds to stay consistent
 export const guildSettings = sequelize.define('guild-settings', {
     id: {
         type: INTEGER,
diff --git a/bot/src/db/models/user-settings.js b/bot/src/db/models/user-settings.js
new file mode 100644
index 0000000..edaff16
--- /dev/null
+++ b/bot/src/db/models/user-settings.js
@@ -0,0 +1,18 @@
+import { INTEGER, STRING } from 'sequelize';
+import { sequelize } from '../../utils/sequelize.js';
+
+export const userSettings = sequelize.define('user-settings', {
+    id: {
+        type: INTEGER,
+        primaryKey: true,
+        autoIncrement: true,
+    },
+    userID: {
+        type: STRING,
+        allowNull: false
+    },
+    language: {
+        type: STRING,
+        allowNull: true
+    }
+});