SCM_BuildMeAClub_64bit_v2.0.1.8

Changes in this version, SCM_BuildMeAClub_64bit_v2.0.1.8 2024/04/27

• Fix FireDAC connection string for MSSQL Server 2022. Microsoft changed SQL Server security settings!

SCM_BuildMeAClub_64bit_v2.0.1.7.exe

SCM_BuildMeAClub_64bit_v2.0.1.7 2024/03/24

• Build DBv1.1.5.3 is RELEASED.

SCM_BuildMeAClub_64bit_v2.0.1.6

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. Select the SCM database you wish to build on your MS SQLEXPRESS database server. Available in this release v1.0.0.0 (Birth: depreciated), v1.1.5.0 (depreciated), v1.1.5.1 (depreciated), v1.1.5.2 (release), v1.1.5.3 (pre-release)

---

ChangeLog

SCM_BuildMeAClub_64bit_v2.0.1.6 2024/03/10

• Modified relationships to dbo.DisqualifyCode in SwimClubMeet v1.1.5.2 MSSQL database.

---

It's suggested you select database v1.1.5.2 and run the core application SCM_SwimClubMeet_x32bit_v1.5.5.3

If you are a little more adventurous and want to explore the next iteration, then select database v1.1.5.3 and run the PRE-RELEASE SCM_SwimClubMeet_x32bit_v1.7.0.4. The pre-release has functions to schedule events, build relays and FINA codes.

SCM_BuildMeAClub_64bit_v2.0.1.5

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. Select the SCM database you wish to build on your MS SQLEXPRESS database server. Available in this release v1.0.0.0 (Birth: depreciated), v1.1.5.0 (depreciated), v1.1.5.1 (depreciated), v1.1.5.2 (release), v1.1.5.3 (pre-release)

---

ChangeLog

SCM_BuildMeAClub_64bit_v2.0.1.4 2024/03/03

• The select database dialogue now displays the states Release, Pre-Release and Depreciated for each database version.

---

It's suggested you install version v1.1.5.2 and run the core application SCM_SwimClubMeet_x32bit_v1.5.5.3

If you are a little more adventurous and want to explore the next iteration, then install v1.1.5.3 and run the PRE-RELEASE SCM_SwimClubMeet_x32bit_v1.7.0.4

SCM_BuildMeAClub_64bit_v2.0.1.4

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. Select the SCM database you wish to build on your MS SQLEXPRESS database server. Available in this release v1.0.0.0 (Birth: depreciated), v1.1.5.0 (depreciated), v1.1.5.1 (depreciated), v1.1.5.2 (release), v1.1.5.3 (pre-release)

---

ChangeLog

SCM_BuildMeAClub_64bit_v2.0.1.4 2025/02/24

• Update to all build scripts located in sub-folder \BMAC_SCRIPTS\...
• Unify BIT data fields now NOT NULL with DEFAULT set across all builds.
• Unify all Scalar Functions on all builds.
• and other misc. database housework
• RELEASE

---

It's suggested you install version v1.1.5.2 and run the core application SCM_SwimClubMeet_x32bit_v1.5.5.3

If you are a little more adventurous and want to explore the next iteration, then install v1.1.5.3 and run the PRE-RELEASE SCM_SwimClubMeet_x32bit_v1.7.0.4

SCM_BuildMeAClub_x64_v2.0.1.3

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. Select the SCM database you wish to build on your MS SQLEXPRESS database server. Available in this release v1.1.5.0, v1.1.5.1, v1.1.5.2, v1.1.5.3

ChangeLog

SCM_BuildMeAClub_64bit_v2.0.1.3 2024/01/02

• Update to build scripts located in sub-folder \BMAC_SCRIPTS\v1.1.5.3
• Introduced new fields into DB for split-times and better scheduling of events and heats. (Lap, RallyOpenDT. RallyCloseDT, OpenDT, CloseDT).

SCM_BuildMeAClub_x64_v2.0.1.2

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. Select the SCM database you wish to build on your MS SQLEXPRESS database server. Available in this release v1.1.5.0, v1.1.5.1, v1.1.5.2, v1.1.5.3

ChangeLog

SCM_BuildMeAClub_64bit_v2.0.1.2 2023/12/24

• Update to build scripts located in sub-folder \BMAC_SCRIPTS\v1.1.5.3. SQL to assign starter data in dbo.TeamName.
• Minor UI changes

SCM_BuildMeAClub_x64_v2.0.1.1

SCM_BuildMeAClub

A universal database builder for SwimClubMeet. You select which SCM database you wish to build on your MS SQLEXPRESS database server.

ChangeLog

---

SCM_BuildMeAClub_64bit_v2.0.1.1 2023/12/23

• New folder BMAC_SCRIPTS created on install. This folder contains different versions of the SwimClubMeet database.
• New button and select database dialogue to pick the SCM database you wish to install.
• Available in this release v1.1.5.0, v1.1.5.1, v1.1.5.2, v1.1.5.3

To help understand the SCM database versions and how they match SCM applications, follow this wiki link Version Information

SCM_BuildMeAClub_x64_v1.5.1.3

SCM_BuildMeAClub

It builds a SCM database version 1.1.5.1 on your MS SQLEXPRESS database server.

This version of the database is designed to run with

• SCM_SwimClubMeet_32bit_v1.5.5.1

ChangeLog

---

SCM_BuildMeAClub_64bit_v1.5.1.3 2023/11/26

• Created single SQL script to build database. (Verified.)
• Application build number (3) shown in UI.
• Modified license display text.
• GNU v3 license RTF file added.
• ReadMe.txt, script changes.

SCM_BuildMeAClub_x64_v1.5.1.2

This special build REPLACES SCM_BuildMeAClub_x64_v1.5.1.1
This build has added a TDateTime field into the table [Event].

File modified - 30_SCHEMA_Updated20230201.sql

CREATE TABLE [dbo].[Event](

[EventID] [int] IDENTITY(1,1) NOT NULL,
[EventNum] [int] NULL,
[Caption] [nvarchar](128) NULL,
[ClosedDT] [datetime] NULL,
[SessionID] [int] NULL,
[EventTypeID] [int] NULL,
[StrokeID] [int] NULL,
[DistanceID] [int] NULL,
[EventStatusID] [int] NULL,
[ScheduleDT] [datetime] NULL,	

CONSTRAINT [PK_Event] PRIMARY KEY NONCLUSTERED
(
[EventID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO