Merge pull request #36 from Alee14/beta

2.13 Release

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 };