aboutsummaryrefslogtreecommitdiff
path: root/bot/src/models/quote.js
diff options
context:
space:
mode:
Diffstat (limited to 'bot/src/models/quote.js')
-rw-r--r--bot/src/models/quote.js64
1 files changed, 64 insertions, 0 deletions
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
+ }
+
+});