1 files changed, 64 insertions, 0 deletions
diff --git a/src/routers/vault/models/legacy/login.js b/src/routers/vault/models/legacy/login.js
new file mode 100644
index 0000000..12e17b9
--- /dev/null
+++ b/src/routers/vault/models/legacy/login.js
@@ -0,0 +1,64 @@
+const Sequelize = require("sequelize"); // from npm registry
+
+module.exports = {
+    fields: {
+        accountId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            primaryKey: true,
+            allowNull: false,
+        },
+        revoltId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: true,
+        },
+        userid: { // username
+            type: Sequelize.STRING(23),
+            allowNull: false,
+            defaultValue: "",
+        },
+        userPass: { // weak athena hashing
+            type: Sequelize.STRING(32),
+            allowNull: false,
+            defaultValue: "",
+        },
+        lastlogin: {
+            type: Sequelize.DATE,
+            allowNull: true,
+        },
+        logincount: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        state: { // ideally this should've been an enum, but whatever
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        email: { // tmwa has a very limited email length
+            type: Sequelize.STRING(39),
+            allowNull: true,
+        },
+        lastIp: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+        unbanTime: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+            defaultValue: 0,
+        },
+    },
+    options: {
+        indexes: [
+            {
+                fields: ["revolt_id"],
+                unique: true,
+            },
+            {
+                fields: ["userid"],
+            }
+        ]
+    }
+};