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 = '<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.3-*" 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 UPPER(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 is missing!'
	GOTO ONERROR
END
PRINT @tab+'SyncServerProperties records were succesfully updated!'

IF EXISTS (SELECT * FROM sysobjects WHERE UPPER(name)='SYNCRELATIONSHIPS' AND xtype='U') 
BEGIN
	UPDATE [SyncRelationships] 
	SET [isChildDependent]=0, [isParentDependent]=1
	WHERE ([parentID]=100 AND [childID]=6507)
	IF @@ERROR<>0
	BEGIN
		PRINT @tab+'ERROR: Error happened during updating records of SyncRelationships table!'	
		GOTO ONERROR
	END
END
ELSE
BEGIN
	PRINT @tab+'ERROR: Error happened during updating records of SyncRelationships, table is missing!'
	GOTO ONERROR
END
PRINT @tab+'SyncRelationships 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!'