From 2c25f53ddf418bdedd94c6142b03c80e49fc584d Mon Sep 17 00:00:00 2001
From: gumi <git@gumi.ca>
Date: Fri, 14 Feb 2020 12:18:00 -0500
Subject: add support for Vault + major refactor

---
 src/routers/vault/models/evol/login.js | 94 ++++++++++++++++++++++++++++++++++
 1 file changed, 94 insertions(+)
 create mode 100644 src/routers/vault/models/evol/login.js

(limited to 'src/routers/vault/models/evol/login.js')

diff --git a/src/routers/vault/models/evol/login.js b/src/routers/vault/models/evol/login.js
new file mode 100644
index 0000000..be37f07
--- /dev/null
+++ b/src/routers/vault/models/evol/login.js
@@ -0,0 +1,94 @@
+const Sequelize = require("sequelize"); // from npm registry
+
+module.exports = {
+    fields: {
+        accountId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            primaryKey: true,
+            autoIncrement: true,
+            allowNull: false,
+        },
+        userid: { // username
+            type: Sequelize.STRING(23),
+            allowNull: false,
+            defaultValue: "",
+        },
+        userPass: { // plaintext
+            type: Sequelize.STRING(32),
+            allowNull: false,
+            defaultValue: "",
+        },
+        sex: { // NOTE: we must exclude S
+            type: Sequelize.ENUM("M", "F", "S"), // TODO: add N when evol-hercules supports it
+            allowNull: false,
+            defaultValue: "M", // TODO: change to N
+        },
+        email: { // limited email length
+            type: Sequelize.STRING(39),
+            allowNull: false,
+            defaultValue: "",
+        },
+        groupId: {
+            type: Sequelize.INTEGER,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        state: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        unbanTime: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        expirationTime: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        logincount: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        lastlogin: {
+            type: Sequelize.DATE,
+            allowNull: true,
+        },
+        lastIp: {
+            type: Sequelize.STRING(100),
+            allowNull: false,
+            defaultValue: "",
+        },
+        birthdate: {
+            type: Sequelize.DATE,
+            allowNull: true,
+        },
+        characterSlots: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0, // 0 means MAX_CHARS(12)
+        },
+        pincode: {
+            type: Sequelize.STRING(4), // TODO: use this for TOTP
+            allowNull: false,
+            defaultValue: "",
+        },
+        pincodeChange: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+    },
+    options: {
+        engine: "InnoDB",
+        initialAutoIncrement: 2000000,
+        indexes: [
+            {
+                fields: ["userid"],
+            }
+        ]
+    }
+};
-- 
cgit v1.2.3-60-g2f50