From fd7f8eba960981482fabf350995bf753feebb176 Mon Sep 17 00:00:00 2001 From: Andrew Lee Date: Mon, 3 Mar 2025 11:42:27 -0500 Subject: More commands ported; Almost all 2.x features have been added --- bot/src/models/guild-settings.js | 27 +++++++++++++++++ bot/src/models/quote.js | 64 ++++++++++++++++++++++++++++++++++++++++ 2 files changed, 91 insertions(+) create mode 100644 bot/src/models/guild-settings.js create mode 100644 bot/src/models/quote.js (limited to 'bot/src/models') diff --git a/bot/src/models/guild-settings.js b/bot/src/models/guild-settings.js new file mode 100644 index 0000000..81cfbc2 --- /dev/null +++ b/bot/src/models/guild-settings.js @@ -0,0 +1,27 @@ +import { INTEGER, STRING } from 'sequelize'; +import { sequelize } from '../utils/sequelize.js'; + +export const guildSettings = sequelize.define('guild-settings', { + id: { + type: INTEGER, + primaryKey: true, + autoIncrement: true, + }, + guildID: { + type: STRING, + allowNull: false + }, + logChannelID: { + type: STRING, + allowNull: true + } + // qotdChannelID: { + // type: Sequelize.STRING, + // allowNull: true + // }, + // qotdToggle: { + // type: Sequelize.BOOLEAN, + // allowNull: true + // } + +}); diff --git a/bot/src/models/quote.js b/bot/src/models/quote.js new file mode 100644 index 0000000..25c8f01 --- /dev/null +++ b/bot/src/models/quote.js @@ -0,0 +1,64 @@ +import { INTEGER, STRING, TEXT } from 'sequelize'; +import { sequelize } from '../utils/sequelize.js'; + +export const quote = sequelize.define('quotes', { + id: { + type: INTEGER, + autoIncrement: true, + primaryKey: true + }, + author: { + type: STRING, + allowNull: false + }, + authorImage: { + type: STRING, + allowNull: false + }, + quote: { + type: TEXT, + allowNull: false + }, + year: { + type: STRING, + allowNull: false + }, + submitter: { + type: STRING, + allowNull: false + } + +}) + +export const pendingQuote = sequelize.define('pending-quotes', { + id: { + type: INTEGER, + autoIncrement: true, + primaryKey: true + }, + author: { + type: STRING, + allowNull: false + }, + authorImage: { + type: STRING, + allowNull: false + }, + quote: { + type: TEXT, + allowNull: false + }, + year: { + type: STRING, + allowNull: false + }, + submitterAuthor: { + type: STRING, + allowNull: false + }, + submitterID: { + type: STRING, + allowNull: false + } + +}); -- cgit v1.2.3