aboutsummaryrefslogtreecommitdiff
path: root/bot/src/db/migrations/20250401223204-rename-logchannelid.js
diff options
context:
space:
mode:
Diffstat (limited to 'bot/src/db/migrations/20250401223204-rename-logchannelid.js')
-rw-r--r--bot/src/db/migrations/20250401223204-rename-logchannelid.js45
1 files changed, 45 insertions, 0 deletions
diff --git a/bot/src/db/migrations/20250401223204-rename-logchannelid.js b/bot/src/db/migrations/20250401223204-rename-logchannelid.js
new file mode 100644
index 0000000..2313c4f
--- /dev/null
+++ b/bot/src/db/migrations/20250401223204-rename-logchannelid.js
@@ -0,0 +1,45 @@
+'use strict';
+
+/** @type {import('sequelize-cli').Migration} */
+export const up = async (queryInterface, Sequelize) => {
+// Assuming we have a table in SQLite created as follows:
+ await queryInterface.createTable('guild-settings', {
+ id: {
+ type: Sequelize.INTEGER,
+ primaryKey: true,
+ autoIncrement: true,
+ },
+ guildID: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ memberLogChannelID: {
+ type: Sequelize.STRING,
+ allowNull: true
+ },
+ messageLogChannelID: {
+ type: Sequelize.STRING,
+ allowNull: true
+ },
+ suggestionsChannelID: {
+ type: Sequelize.STRING,
+ allowNull: true
+ },
+ qotdChannelID: {
+ type: Sequelize.STRING,
+ allowNull: true
+ },
+ qotdToggle: {
+ type: Sequelize.BOOLEAN,
+ allowNull: true
+ },
+ ollamaEnabled: {
+ type: Sequelize.BOOLEAN,
+ allowNull: true
+ },
+ });
+};
+
+export const down = async (queryInterface) => {
+
+};