From 2f117a22cd21fa4fb67a3b2d687485795f86d030 Mon Sep 17 00:00:00 2001
From: Wu Cheng-Han
Date: Sat, 30 Jul 2016 11:21:38 +0800
Subject: Add support of saving authors and authorship

---
 lib/models/author.js | 43 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 43 insertions(+)
 create mode 100644 lib/models/author.js

(limited to 'lib/models/author.js')

diff --git a/lib/models/author.js b/lib/models/author.js
new file mode 100644
index 00000000..0b0f149d
--- /dev/null
+++ b/lib/models/author.js
@@ -0,0 +1,43 @@
+"use strict";
+
+// external modules
+var Sequelize = require("sequelize");
+
+// core
+var logger = require("../logger.js");
+
+module.exports = function (sequelize, DataTypes) {
+    var Author = sequelize.define("Author", {
+        id: {
+            type: Sequelize.INTEGER,
+            primaryKey: true,
+            autoIncrement: true
+        },
+        color: {
+            type: DataTypes.STRING
+        }
+    }, {
+        indexes: [
+            {
+                unique: true,
+                fields: ['noteId', 'userId']
+            }
+        ],
+        classMethods: {
+            associate: function (models) {
+                Author.belongsTo(models.Note, {
+                    foreignKey: "noteId",
+                    as: "note",
+                    constraints: false
+                });
+                Author.belongsTo(models.User, {
+                    foreignKey: "userId",
+                    as: "user",
+                    constraints: false
+                });
+            }
+        }
+    });
+    
+    return Author;
+};
\ No newline at end of file
-- 
cgit v1.2.3