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

Wednesday, October 29, 2014
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,

1 Replies
Friday, October 31, 2014
re: ChristophBr Wednesday, October 29, 2014
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).



Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Wednesday, October 29, 2014
  • Last Reply: Friday, October 31, 2014
  • Replies: 1
  • Views: 9125