Table ...User...: Whats the field "...IsLegacyFormat" for?

Wednesday, October 29, 2014 10:41:00 AM
Dear reader,

My collegue in our system operations department does a direct export of certain data from the spirateam database to another system. Can anyone explain him shortly what's the purpose of the fields "...IsLegacyFormat" and what's the meaning of the "0" and "1" in the field?

Best Regards,

Christoph
1 Replies
Friday, October 31, 2014 3:15:58 PM
Avatar
re: ChristophBr on Wednesday, October 29, 2014 10:41:00 AM
Hi Christoph

That field is used to determine the algorithm used to hash the passwords. For SpiraTeam v3.2 and earlier a simple MD5 hash was used, for SpiraTeam v4.0 and later, a SHA1 hash is used plus all the hashes are salted. To avoid having to make every user change their password upon upgrade, the system has the flag to determine if it's using the new format or old format (1 = old format, 0 = new format).

Regards

Sarah
Statistics
  • Started: Wednesday, October 29, 2014 10:41:00 AM
  • Last Reply: Friday, October 31, 2014 3:15:58 PM
  • Replies: 1
  • Views: 3072