Changing Customers To Waivers Not Signed
Changing Customers To Waivers Not Signed
**Please confirm script with level 2 before you use**
--Setup so that every customer has not signed a waiver
-- Backup the following folders
C:\ClubSpeed\CustomerSignatures
C:\ClubSpeed\CustomerSignatures2
C:\ClubSpeed\CustomerWaivers
C:\ClubSpeed\CustomerWaivers2
-- Delete images from the following the directories
C:\ClubSpeed\CustomerSignatures
C:\ClubSpeed\CustomerSignatures2
C:\ClubSpeed\CustomerWaivers
C:\ClubSpeed\CustomerWaivers2
-- Take a backup of the database
SELECT TOP 1000 [RuleID]
,[DoWhen]
,[ChangeStatus1]
,[ChangeStatus2]
,[ChangeStatus3]
,[ChangeStatus4]
FROM [ClubspeedV8].[dbo].[Rules]
-- Depending on the rules will determine the update statements (exact status #s can vary)
-- Very likely that most locations have the same rules
update Customers set Status1=1 where Status1=2
update Customers set Status2=0 where Status2=3