1 files changed, 49 insertions, 0 deletions
diff --git a/src/routers/vault/models/vault/account_log.js b/src/routers/vault/models/vault/account_log.js
new file mode 100644
index 0000000..1f8b05b
--- /dev/null
+++ b/src/routers/vault/models/vault/account_log.js
@@ -0,0 +1,49 @@
+const Sequelize = require("sequelize"); // from npm registry
+
+module.exports = {
+    fields: {
+        id: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            primaryKey: true,
+            autoIncrement: true,
+            allowNull: false,
+        },
+        vaultId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+        },
+        accountType: {
+            type: Sequelize.ENUM("EVOL", "LEGACY", "FORUMS", "WIKI"),
+            allowNull: false,
+        },
+        accountId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+        },
+        actionType: {
+            type: Sequelize.ENUM("CREATE", "DELETE", "LINK", "UNLINK", "UPDATE"),
+            allowNull: false,
+            defaultValue: "CREATE",
+        },
+        details: {
+            type: Sequelize.STRING,
+            allowNull: true,
+        },
+        ip: {
+            type: "VARBINARY(16)",
+            allowNull: false,
+        },
+        date: {
+            type: Sequelize.DATE,
+            allowNull: false,
+            defaultValue: Sequelize.NOW,
+        },
+    },
+    options: {
+        indexes: [
+            { fields: ["vault_id"] },
+            { fields: ["account_id"] },
+            { fields: ["ip"] },
+        ]
+    }
+};