From c68d06b89bf69cb5323ad7793070fb188855259c Mon Sep 17 00:00:00 2001 From: kambizzandi Date: Mon, 4 Apr 2022 20:42:44 +0430 Subject: [PATCH] change session lastrenew to bigint --- ...220404_203854_AAA_change_session_lastrenew_to_bigint.sql | 6 ++++++ conf/api.conf | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 Modules/Account/migrations/db/m20220404_203854_AAA_change_session_lastrenew_to_bigint.sql diff --git a/Modules/Account/migrations/db/m20220404_203854_AAA_change_session_lastrenew_to_bigint.sql b/Modules/Account/migrations/db/m20220404_203854_AAA_change_session_lastrenew_to_bigint.sql new file mode 100644 index 00000000..7a63ad20 --- /dev/null +++ b/Modules/Account/migrations/db/m20220404_203854_AAA_change_session_lastrenew_to_bigint.sql @@ -0,0 +1,6 @@ +/* Migration File: m20220404_203854_AAA_change_session_lastrenew_to_bigint */ + +DELETE FROM `tblActiveSessions` WHERE ssnLastRenew IS NOT NULL; + +ALTER TABLE `tblActiveSessions` + CHANGE COLUMN `ssnLastRenew` `ssnLastRenew` BIGINT UNSIGNED NULL DEFAULT NULL AFTER `ssnLastActivity`; diff --git a/conf/api.conf b/conf/api.conf index c54e6a9d..71b9b6e9 100644 --- a/conf/api.conf +++ b/conf/api.conf @@ -198,7 +198,7 @@ WarningLevel = 9 # Valid values: 0 to 65535 # Default value: 300 #--------------------------------------- -TTL = 36000 +TTL = 30 #%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% # @@@ Logger SECTION @@@