* Extended tmw_accounts table with columns for lastlogin and registration date. Modified account-server to fill the new columns on registration and login. Recreation of database needed!

* Added createIndex function to create indexes on tables.

1 files changed, 21 insertions, 1 deletions

diff --git a/src/account-server/dalstorage.hpp b/src/account-server/dalstorage.hpp
index af3546f2..7a8208ff 100644
--- a/src/account-server/dalstorage.hpp
+++ b/src/account-server/dalstorage.hpp
@@ -109,7 +109,6 @@ class DALStorage
         void
         addAccount(Account *account);
 
-
         /**
          * Delete an account.
          *
@@ -118,6 +117,13 @@ class DALStorage
         void delAccount(Account *account);
 
         /**
+         * Update the date and time of the last login.
+         *
+         * @param account the account that recently logged in.
+         */
+        void updateLastLogin(const Account *account);
+
+        /**
          * Sets a ban on an account (hence on all its characters).
          *
          * @param id character identifier.
@@ -246,6 +252,20 @@ class DALStorage
 
 
         /**
+         * Create an index on the specified column.
+         *
+         * @param indxName the name of the index.
+         * @param tblName the name of the table.
+         * @param columnName the name of the columns
+         *
+         * @exception dal::DbSqlQueryExecFailure.
+         */
+        void
+        createIndex(const std::string& indxName,
+                    const std::string& tblName,
+                    const std::string& columnName );
+
+        /**
          * Gets an account by using a SQL query string.
          *
          * @param query the query for the account