SCM_UpdateDataBase_64bit_v1.6.0.3

Changes made to this version

• Tables, DisqualifyCode and DisqualifyType, were missing their table permissions.
• The update script for the SCMSystem table had an erroneous 'patch' field that should have read 'build' (versions 1.1.5.0 thru 1.1.5.3).
• Fixed FireDAC connection string for MSSQL Server 2022. Microsoft changed SQL Server security settings!

Available 'updates' in this release...

• v1.0.0.0 to v1.1.5.0 Updates the original closed version to GitHub release version.
• v1.1.0.0 to v1.1.5.0
• v1.1.5.0 to v1.1.5.1 Improved scalar functions. Table permissions updated.
• v1.1.5.1 to v1.1.5.2 FINA disqualification codes, club logo and schedule events.
• v1.1.5.2 to v1.1.5.3 Team events (relays).

SCM UpdateDataBase_64bit_v1.6.0.2.exe

SCM UpdateDataBase_64bit_v1.6.0.2.exe 2024/03/24

Select the update you wish to apply to the MSSQL SwimClubMeet Database.

Available in this release...

• v1.0.0.0 to v1.1.5.0 Updates the original closed version to GitHub release version.
• v1.1.0.0 to v1.1.5.0
• v1.1.5.0 to v1.1.5.1 Improved scalar functions. Table permissions updated.
• v1.1.5.1 to v1.1.5.2 New tables for FINA disqualification codes. New fields for club logo and schedule events.
• v1.1.5.2 to v1.1.5.3 Team events. (RELEASE)

SCM UpdateDataBase_64bit_v1.6.0.1.exe

SCM UpdateDataBase_64bit_v1.6.0.1.exe 2024/03/24

Universal update. This version allows you to pick the update you wish to apply on the MSSQL SwimClubMeet Database.

Available in this release...

• v1.0.0.0 to v1.1.5.0 Updates the original closed version to GitHub release version.
• v1.1.5.0 to v1.1.5.1 Improved scalar functions. Table permissions updated.
• v1.1.5.1 to v1.1.5.2 New tables for FINA disqualification codes. New fields for club logo and schedule events.
• v1.1.5.2 to v1.1.5.3 Pre-release Team events. WARNING: UNTESTED.

SCM UpdateDataBase_64bit_v1.5.1.0.exe

SCM UpdateDataBase_64bit_v1.5.1.0.exe 2023/02/23

For users running database SCMSystem values: (1,1,5,0).

It takes your (1,1,5,0) database and turns it into (1,1,5,1)

Any of these core applications can run on this database.

• SCM_SwimClubMeet_32bit_v1.5.5.0
• SCM_SwimClubMeet_32bit_v1.5.4.0
• SCM_SwimClubMeet_32bit_v1.5.3.0
• SCM_SwimClubMeet_x32_v1.5.2.0
• SCM_SwimClubMeet_x32_v1.5.1.0

Notes on this update.

• Fixes scalar function. dbo.IsMemberNominated.UserDefinedFunction.sql.
• New field: SwimClubMeet.dbo.Member.IsSwimmer (BIT).
• Sets DEFAULT on fields IsArchived, IsActive and IsSwimmer in SwimClubMeet.dbo.Member.
• Re-index (changed field orders) in table dbo.Member.
• Repairs default values for fields IsArchived and IsActive on existing records in SwimClubMeet.dbo.Member. (If they read NULL.)
• Updates SCMSystem values to: (1,1,5,1).

Special note:

After the update a temporary table with the name Member_ followed by a large hash number will appear in the database. After testing, you may remove this table. It's also safe to leave it.

SCM_UpdateDataBase_x64_v1.1.0.0

SCM UpdateDataBase_x64_v1.1.0.0.exe 09/09/2022

Who should use this update?

For use ONLY by early adopters of the SCM project.

If you created your database by using SCM_BuildMeAClub_x64_v1.1.0.0 then you DON'T need this update! 😃.

Notes on this update.

• Takes a very old 1.0.0.0 version and bring it up to date.
• It requires delivery of SQL scripts from the developer!
• Updates [SwimClubMeet].[dbo].[SCMSystem] values to: (1,1,5,0)