SET NOCOUNT ON

BEGIN TRANSACTION

DECLARE @tab VARCHAR(1)
DECLARE @nl VARCHAR(2)
SET @tab=CHAR(09)
SET @nl=CHAR(0x0D)+CHAR(0x0A)

PRINT 'Script running started!'
PRINT @nl

-- updating SyncServerProperties
IF EXISTS (SELECT * FROM sysobjects WHERE UPPER(name)='SYNCSERVERPROPERTIES' AND xtype='U') 
BEGIN
	UPDATE SyncServerProperties SET [value]=
	N'<upg:ClientModuleRegistry xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xmlns:upg="http://infomatix.hu/mango/upgrades"
		xsi:schemaLocation="http://infomatix.hu/mango/upgrades ..\client-module-registry.xsd">

		<DateUpdated>2008-04-01T12:08:00.000</DateUpdated>

		<ClientModule id="MOBISYNC_CLIENT">

			<VersionInformation clientTypeID="15728640">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu /installers/uploads/desktopclient</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download/desktopclient</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="1048576">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu /installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="2097152">
				<SupportedModuleVersion version="2.0.0-*" published="true"/>
				<UploadURI>file://service.infomatix.hu /installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="3145728">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu /installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="4194304">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu /installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

		</ClientModule>

		<ClientModule id="MOBIVISION_CLIENT">

			<VersionInformation clientTypeID="15728640">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads/mobivisiondesktop</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download/mobivisiondesktop</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="1048576">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads/</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="2097152">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="3145728">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>

			<VersionInformation clientTypeID="4194304">
				<SupportedModuleVersion version="2.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download</DownloadURL>
			</VersionInformation>
			
		</ClientModule>

		<ClientModule id="MY_APPLICATION">

			<VersionInformation clientTypeID="15728640">
				<SupportedModuleVersion version="1.0.0.0-*" published="true" />
				<UploadURI>file://service.infomatix.hu/installers/uploads/mobivisiondesktop</UploadURI>
				<DownloadURL>http://service.infomatix.hu/installers/download/mobivisiondesktop</DownloadURL>
			</VersionInformation>

		</ClientModule>

	</upg:ClientModuleRegistry>'
	WHERE name='ClientModuleRegistry'
	
	IF @@ERROR<>0
	BEGIN
		PRINT @tab+'ERROR: Error happened during updating records of SyncServerProperties table!'	
		GOTO ONERROR
	END
END
ELSE
BEGIN
	PRINT @tab+'ERROR: Error happened during updating records of SyncServerProperties table, table is missing!'
	GOTO ONERROR
END

PRINT @tab+'SyncServerProperties records were succesfully updated!'
COMMIT
GOTO DOEXIT

ONERROR:
	PRINT @tab+'ERROR: Some error happened during running the script, modifications were rolled back!'
	RAISERROR('ERROR: Some error happened during running the script, modifications were rolled back!', 16, 10)
	ROLLBACK
	GOTO DOEXIT
	
DOEXIT:
	PRINT @nl+'Script finished running!'