aboutsummaryrefslogtreecommitdiff
path: root/models
diff options
context:
space:
mode:
Diffstat (limited to 'models')
-rw-r--r--models/guild-settings.js29
-rw-r--r--models/quote.js66
2 files changed, 95 insertions, 0 deletions
diff --git a/models/guild-settings.js b/models/guild-settings.js
new file mode 100644
index 0000000..8cc7478
--- /dev/null
+++ b/models/guild-settings.js
@@ -0,0 +1,29 @@
+const Sequelize = require("sequelize");
+const sequelize = require('../utils/sequelize');
+
+const guildSettings = sequelize.define('guild-settings', {
+ id: {
+ type: Sequelize.INTEGER,
+ primaryKey: true,
+ autoIncrement: true,
+ },
+ guildID: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ logChannelID: {
+ type: Sequelize.STRING,
+ allowNull: true
+ }
+ // qotdChannelID: {
+ // type: Sequelize.STRING,
+ // allowNull: true
+ // },
+ // qotdToggle: {
+ // type: Sequelize.BOOLEAN,
+ // allowNull: true
+ // }
+
+})
+
+module.exports = { guildSettings }
diff --git a/models/quote.js b/models/quote.js
new file mode 100644
index 0000000..ceef241
--- /dev/null
+++ b/models/quote.js
@@ -0,0 +1,66 @@
+const Sequelize = require("sequelize");
+const sequelize = require('../utils/sequelize');
+
+const quote = sequelize.define('quotes', {
+ id: {
+ type: Sequelize.INTEGER,
+ autoIncrement: true,
+ primaryKey: true
+ },
+ author: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ authorImage: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ quote: {
+ type: Sequelize.TEXT,
+ allowNull: false
+ },
+ year: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ submitter: {
+ type: Sequelize.STRING,
+ allowNull: false
+ }
+
+})
+
+const pendingQuote = sequelize.define('pending-quotes', {
+ id: {
+ type: Sequelize.INTEGER,
+ autoIncrement: true,
+ primaryKey: true
+ },
+ author: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ authorImage: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ quote: {
+ type: Sequelize.TEXT,
+ allowNull: false
+ },
+ year: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ submitterAuthor: {
+ type: Sequelize.STRING,
+ allowNull: false
+ },
+ submitterID: {
+ type: Sequelize.STRING,
+ allowNull: false
+ }
+
+})
+
+module.exports = { quote, pendingQuote };