|
|
Error in Schema Compare - CTP5 |
|
Author |
Message |
EDV Gradl
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
In my database I have several CLR functions in one assembly. I use most of the functions in table to calulate something. A typical table would look like:
ID bigint IDENTITY PRIMARY KEY Name varchar(50) Result dbo.CalcSomething(ID)
where CalcSomething is a CLR function. When I change the assembly (e.g. add a function etc.), the columns in the table are not dropped, but the CLR functions are re-recreated. Since these functions are in use (no dropping) the script will fail ever time.
Would be nice to fix this in RTM
Visual Studio Team System36
|
|
|
|
|
Brian Ku MSFT
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
Hi EDV Gradl,
Would you mind explaining the process of how you go about with the Schema Compare How do you deploy the assembly changes to the database and how are you viewing the assembly differences I would like to get a repro of your steps in house.
Thanks
Brian
|
|
|
|
|
StevenPo - MSFT
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
EDV Gradl -
Has your issue been resolved with CTP6 If it has not been resolved, then please provide the additional information requested by BrianKu and we will see if we can diagnose the problem. If we don't hear back from you within 7 days, we will remove this post. We do this to keep the system full of useful information for customers searching for answers and focus expert attention on active unanswered questions.
thanks,
|
|
|
|
|
EDV Gradl
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
Sadly, the problem still exisit. I try to describe what I do:
I have a database with CLR functions like this one:
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString GetBarcodeObjekt(SqlInt32 ID)
{
if (ID.IsNull || ID < 0)
return "---";
else
{
string Barcode = ID.ToString();
Barcode = "92" + Barcode.PadLeft(10, '0');
return Barcode;
}
}
and I have a table like this
CREATE TABLE [dbo].[ObjektTeile]
(
[ID] [bigint] NOT NULL IDENTITY(1, 1),
[Kostenstelle] [bigint] NOT NULL CONSTRAINT [DF_ObjektTeile_Kostenstelle] DEFAULT ((0)),
[Artikel] [bigint] NOT NULL CONSTRAINT [DF_ObjektTeile_Artikel] DEFAULT ((0)),
[Barcode] AS ([dbo].[GetBarcodeObjekt]([ID])),
[Teilenummer] AS ([dbo].[GetTeilenummerObjekt]([ID])),
[Bemerkung] [varchar] (50) NULL,
[Drucken] [bit] NOT NULL CONSTRAINT [DF_ObjektTeile_Drucken] DEFAULT ((1)),
[Waschen] [smallint] NOT NULL CONSTRAINT [DF_ObjektTeile_Waschen] DEFAULT ((0))
) ON [PRIMARY]
As you can see the CLR function is used in the table and I get a a 12 digit string for every ID
No I copy this database and get database A and database B
To database A I add add function to the assembly like this:
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString Test()
{
return new SqlString("Hello");
}
and now I compile the assembly and alter the assembly in database A
ALTER ASSEMBLY WGPNextGENCLR
FROM 'D:\WGP Next Generation\SQLServer\WGPNextGenCLR\WGPNextGenCLR\bin\Release\WGPNextGENCLR.dll'
WITH UNCHECKED DATA
go
No I do a schema compare again. Source A and Target B
the only different object is the assembly and this script is created:
/*
This script was created by Visual Studio on 20.10.2006 at 08:52.
Run this script on WGPLeer to make it the same as WGPNG.
Please back up your target database before running this script.
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
PRINT N'Dropping [dbo].[CalcTageinRange]'
GO
DROP FUNCTION [dbo].[CalcTageinRange]
GO
GO
GO
PRINT N'Dropping [dbo].[ShowWochentag]'
GO
DROP FUNCTION [dbo].[ShowWochentag]
GO
GO
GO
PRINT N'Dropping [dbo].[CalcDay]'
GO
DROP FUNCTION [dbo].[CalcDay]
GO
GO
GO
PRINT N'Dropping [dbo].[GetFirstDayInYear]'
GO
DROP FUNCTION [dbo].[GetFirstDayInYear]
GO
GO
GO
PRINT N'Dropping [dbo].[GetLastDayInYear]'
GO
DROP FUNCTION [dbo].[GetLastDayInYear]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeContainer]'
GO
DROP FUNCTION [dbo].[GetBarcodeContainer]
GO
GO
GO
PRINT N'Dropping [dbo].[GetTeilenummerBKL]'
GO
DROP FUNCTION [dbo].[GetTeilenummerBKL]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeFMW]'
GO
DROP FUNCTION [dbo].[GetBarcodeFMW]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeBKL]'
GO
DROP FUNCTION [dbo].[GetBarcodeBKL]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeKostenstelle]'
GO
DROP FUNCTION [dbo].[GetBarcodeKostenstelle]
GO
GO
GO
PRINT N'Dropping [dbo].[ShowBonNummer]'
GO
DROP FUNCTION [dbo].[ShowBonNummer]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeObjekt]'
GO
DROP FUNCTION [dbo].[GetBarcodeObjekt]
GO
GO
GO
PRINT N'Dropping [dbo].[StringToInt]'
GO
DROP FUNCTION [dbo].[StringToInt]
GO
GO
GO
PRINT N'Dropping [dbo].[UseKreis]'
GO
DROP FUNCTION [dbo].[UseKreis]
GO
GO
GO
PRINT N'Dropping [dbo].[ShowDatum]'
GO
DROP FUNCTION [dbo].[ShowDatum]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeHeim]'
GO
DROP FUNCTION [dbo].[GetBarcodeHeim]
GO
GO
GO
PRINT N'Dropping [dbo].[GetTeilenummerHeim]'
GO
DROP FUNCTION [dbo].[GetTeilenummerHeim]
GO
GO
GO
PRINT N'Dropping [dbo].[IsFBC]'
GO
DROP FUNCTION [dbo].[IsFBC]
GO
GO
GO
PRINT N'Dropping [dbo].[GetPreis]'
GO
DROP FUNCTION [dbo].[GetPreis]
GO
GO
GO
PRINT N'Dropping [dbo].[HexToInt]'
GO
DROP FUNCTION [dbo].[HexToInt]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeIdent]'
GO
DROP FUNCTION [dbo].[GetBarcodeIdent]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeBunnyBon]'
GO
DROP FUNCTION [dbo].[GetBarcodeBunnyBon]
GO
GO
GO
PRINT N'Dropping [dbo].[IsMRChip]'
GO
DROP FUNCTION [dbo].[IsMRChip]
GO
GO
GO
PRINT N'Dropping [dbo].[IsChipOrMRChip]'
GO
DROP FUNCTION [dbo].[IsChipOrMRChip]
GO
GO
GO
PRINT N'Dropping [dbo].[ShowMonat]'
GO
DROP FUNCTION [dbo].[ShowMonat]
GO
GO
GO
PRINT N'Dropping [dbo].[IsWGPBarcode]'
GO
DROP FUNCTION [dbo].[IsWGPBarcode]
GO
GO
GO
PRINT N'Dropping [dbo].[GetBarcodeArtikel]'
GO
DROP FUNCTION [dbo].[GetBarcodeArtikel]
GO
GO
GO
PRINT N'Dropping [dbo].[GetTeilenummerObjekt]'
GO
DROP FUNCTION [dbo].[GetTeilenummerObjekt]
GO
GO
GO
PRINT N'Dropping [dbo].[CalcAlter]'
GO
DROP FUNCTION [dbo].[CalcAlter]
GO
GO
GO
PRINT N'Dropping [dbo].[CheckArtikeltypen]'
GO
DROP FUNCTION [dbo].[CheckArtikeltypen]
GO
GO
GO
PRINT N'Dropping [dbo].[IsChip]'
GO
DROP FUNCTION [dbo].[IsChip]
GO
GO
GO
PRINT N'Dropping [dbo].[GetTeilenummerFMW]'
GO
DROP FUNCTION [dbo].[GetTeilenummerFMW]
GO
GO
GO
PRINT N'Dropping CLR assemblies'
GO
DROP ASSEMBLY [WGPNextGENCLR]
GO
PRINT N'Creating CLR assemblies'
GO
--Assembly wgpnextgenclr, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil
CREATE ASSEMBLY [WGPNextGENCLR]
AUTHORIZATION [dbo]
FROM
0x4d5a90000300000004000000ffff0000b800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000e1fba0e00b409cd21b8014ccd21546869732070726f6772616d2063616e6e6f742062652072756e20696e20444f53206d6f64652e0d0d0a2400000000000000\
504500004c010300e27138450000000000000000e0000e210b0108000030000000200000000000008e4e000000200000006000000000400000200000001000000400000000000000040000000000000000a000000010000000000000030000040000100000100000000010000010000000000000100000000000000000000000\
384e00005300000000600000a003000000000000000000000000000000000000008000000c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002e74657874000000\
942e0000002000000030000000100000000000000000000000000000200000602e72737263000000a0030000006000000010000000400000000000000000000000000000400000402e72656c6f6300000c0000000080000000100000005000000000000000000000000000004000004200000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
704e0000000000004800000002000500cc3400006c190000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300300b5010000010000110f00280e00000a2c0b7201000070280f00000a2a02281000000a0a1200281100000a0b12\
00281200000a0c1200281300000a0d731400000a1304071f0a2f0a11041f306f1500000a2611041201281600000a7209000070281700000a6f1800000a2608130511051759450c0000000500000017000000290000003b0000004d0000005c0000006b0000007a0000008900000098000000a7000000b600000038c000000011\
04720d0000706f1800000a2638bb000000110472170000706f1800000a2638a9000000110472210000706f1800000a2638970000001104722b0000706f1800000a263885000000110472350000706f1800000a262b761104723f0000706f1800000a262b67110472490000706f1800000a262b58110472530000706f1800000a\
262b491104725d0000706f1800000a262b3a110472670000706f1800000a262b2b110472710000706f1800000a262b1c1104727b0000706f1800000a262b0d110472850000706f1800000a260920d0070000310a0920d0070000590d2b0809206c070000590d091f0a2f0a11041f306f1500000a2611041203281600000a6f18\
00000a2611046f1900000a280f00000a2a00000013300300ef0000000200001116731a00000a0a16731a00000a0b17731a00000a0c16731a00000a0d0f00281b00000a2d0c02281c00000a281d00000a0c0f01281e00000a2d0703281f00000a0a0f02281e00000a2d0704281f00000a0b0f03282000000a2d0705282100000a\
0d0616731a00000a282200000a2c3a0716731a00000a282200000a2c130809282300000a18282400000a282500000a2a0807282300000a09282300000a18282400000a282500000a2a0716731a00000a282200000a2c190806282300000a09282300000a18282400000a282500000a2a0807282300000a06282300000a092823\
00000a18282400000a282500000a2a001330020045000000030000110f00282600000a2c0716282700000a2a0f00fe16050000016f1900000a0a066f2800000a1f0c2e0716282700000a2a0628270000062d0716282700000a2a17282700000a2a000000133002004e000000030000110f00282600000a2c0716282700000a2a\
0f00fe16050000016f1900000a0a066f2800000a1e2e11066f2800000a1f0c2e0716282700000a2a0628270000062c0716282700000a2a17282700000a2a0000133002004e000000030000110f00282600000a2c0716282700000a2a0f00fe16050000016f1900000a0a066f2800000a1e2e11066f2800000a1f0a2e07162827\
00000a2a0628260000062d0716282700000a2a17282700000a2a00001330020044000000030000110f00282600000a2c0716282700000a2a0f00fe16050000016f1900000a0a066f2800000a1e2e0716282700000a2a0628270000062c0716282700000a2a17282700000a2a1330020045000000030000110f00282600000a2c\
0716282700000a2a0f00fe16050000016f1900000a0a066f2800000a1f0c2e0716282700000a2a0628260000062d0716282700000a2a17282700000a2a0000001330020065000000040000110f00280e00000a2c08166a282900000a2a02281000000a0a1200282a00000a0d1203282b00000a282c00000a0b1201282d00000a\
6c0c08230000000000000000340a2300000000000000000c08230000000000703e405b0c0818282e00000a732f00000a2a0000001330050059000000050000110f00281b00000a2d090f01281b00000a2c0b7201000070280f00000a2a02281c00000a0a03281c00000a0b728f0000701200281600000a1b1f306f3000000a12\
01281600000a1c1f306f3000000a283100000a280f00000a2a00000013300500b9000000060000110f00280e00000a2c0716283200000a2a0304283300000a283400000a2c0716283200000a2a02281000000a0a1200281200000a0b1200281300000a0c1203080717283500000a120408070807283600000a283500000a0913\
050f01280e00000a2d0803281000000a1305110413060f02280e00000a2d0804281000000a13061613072b18120523000000000000f03f283700000a13051107175813071205282b00000a1206282b00000a283800000a2dd31107283200000a2a00000013300200d3010000070000110f01283900000a2d090f00280e00000a\
2c0b7201000070280f00000a2a02281000000a0a1200281200000a0b03283a00000a39ce000000070c081759450c00000005000000100000001b00000026000000310000003c00000047000000520000005d00000068000000730000007e00000038840000007293000070280f00000a2a729b000070280f00000a2a72a30000\
70280f00000a2a72ab000070280f00000a2a72b3000070280f00000a2a72bb000070280f00000a2a72c3000070280f00000a2a72cb000070280f00000a2a72d3000070280f00000a2a72db000070280f00000a2a72e3000070280f00000a2a72eb000070280f00000a2a7201000070280f00000a2a070d091759450c00000005\
000000100000001b00000026000000310000003c00000047000000520000005d00000068000000730000007e000000388400000072f3000070280f00000a2a720b010070280f00000a2a7225010070280f00000a2a7239010070280f00000a2a724f010070280f00000a2a7261010070280f00000a2a7275010070280f00000a\
2a7289010070280f00000a2a72a1010070280f00000a2a72bf010070280f00000a2a72d9010070280f00000a2a72f5010070280f00000a2a7201000070280f00000a2a001b3002003e000000080000110f00282600000a2c08166a283b00000a2a0f00fe16050000016f1900000a0a061f10283c00000a0b07283b00000a0cde\
0b26166a283b00000a0cde00082a000001100000000011002031000b010000011b3002003e000000080000110f00282600000a2c08166a283b00000a2a0f00fe16050000016f1900000a0a061f0a283c00000a0b07283b00000a0cde0b26166a283b00000a0cde00082a000001100000000011002031000b0100000113300300\
1d0000000900001102281c00000a0a1200281600000a1f0c1f306f3000000a280f00000a2a00000013300400ee0000000a0000110f01282600000a2c610f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f190000\
0a0a7211020070061f0b1f306f3000000a281700000a0a06280f00000a2a0f01fe16050000016f1900000a250b2c60077215020070283f00000a2d1a07721d020070283f00000a2d0d077227020070283f00000a2c390f00281b00000a2c0b7201000070280f00000a2a0f01fe16050000016f1900000a0f00fe16080000016f\
1900000a281700000a280f00000a2a0f01fe16050000016f1900000a280f00000a2a000013300400ee0000000a0000110f01282600000a2c610f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a0a7235\
020070061f0b1f306f3000000a281700000a0a06280f00000a2a0f01fe16050000016f1900000a250b2c60077215020070283f00000a2d1a07721d020070283f00000a2d0d077227020070283f00000a2c390f00281b00000a2c0b7201000070280f00000a2a0f01fe16050000016f1900000a0f00fe16080000016f1900000a\
281700000a280f00000a2a0f01fe16050000016f1900000a280f00000a2a000013300400120100000b0000110f02282600000a39820000000f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a0a03283a\
00000a0b072c177239020070061f0b1f306f3000000a281700000a0a2b15723d020070061f0b1f306f3000000a281700000a0a06280f00000a2a0f02fe16050000016f1900000a250c2c60087215020070283f00000a2d1a08721d020070283f00000a2d0d087227020070283f00000a2c390f00281b00000a2c0b7201000070\
280f00000a2a0f02fe16050000016f1900000a0f00fe16080000016f1900000a281700000a280f00000a2a0f02fe16050000016f1900000a280f00000a2a00001330040061000000030000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00\
000a2a0f00fe16080000016f1900000a0a7241020070061f0b1f306f3000000a281700000a0a06280f00000a2a0000001330040061000000030000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a\
0a7245020070061f0a1f306f3000000a281700000a0a06280f00000a2a0000001330040061000000030000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a0a724b020070061f0b1f306f3000000a\
281700000a0a06280f00000a2a0000001330040061000000030000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a0a724f020070061f0a1f306f3000000a281700000a0a06280f00000a2a000000\
1330040061000000030000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070280f00000a2a0f00fe16080000016f1900000a0a7255020070061f0a1f306f3000000a281700000a0a06280f00000a2a000000133002003a0000000c0000110f00280e\
00000a2d090f01281b00000a2c0b282a00000a284000000a2a02281000000a0a03281c00000a0b1200076c283700000a284000000a2a00001330030055000000090000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070734100000a2a02281c0000\
0a0a725b020070061b2824000006281700000a280f00000a2a0000001330030055000000090000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070734100000a2a02281c00000a0a725f020070061b2824000006281700000a280f00000a2a000000\
1330030055000000090000110f00281b00000a282700000a25283400000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070734100000a2a02281c00000a0a7263020070061b2824000006281700000a280f00000a2a0000001330030055000000090000110f00281b00000a282700000a25283400\
000a2d110216283200000a283d00000a283e00000a283400000a2c0b7201000070734100000a2a02281c00000a0a7267020070061b2824000006281700000a280f00000a2a00000013300400690000000d000011160a160b0f00281b00000a2c11282a00000a13041204281300000a0a2b0702281c00000a0a0f01281b00000a\
2c04170b2b0703281c00000a0b1202061717283500000a070d2b11120223000000000000f03f283700000a0c1202284200000a0933e508284000000a2a00000013300400350000000e000011160a0f00281b00000a2c10282a00000a0c1202281300000a0a2b0702281c00000a0a1201061f0c1f1f283500000a07284000000a\
2a000000133002004a0000000f0000110f00280e00000a2d090f01280e00000a2c0716282700000a2a02281000000a0a03281000000a0b1200282b00000a1201282b00000a284300000a2c0717282700000a2a16282700000a2a00001330030079000000100000117e4400000a0a0f00282600000a2c0872010000700a2b0e0f\
00fe16050000016f1900000a0a7e4400000a0b0f02281b00000a2c08723d0200700b2b0e0f02fe16080000016f1900000a0b160c0f01281b00000a2c041b0c2b0703281c00000a0c07081f306f3000000a0b0607281700000a0a06734100000a2a0000001330010030010000110000110f00280e00000a2d090f01283900000a\
2c0b7201000070280f00000a2a02281000000a0a1200284200000a0b03283a00000a2c7e070c08450700000044000000020000000d00000018000000230000002e000000390000002b4d726b020070280f00000a2a7271020070280f00000a2a7277020070280f00000a2a727d020070280f00000a2a7283020070280f00000a\
2a7289020070280f00000a2a728f020070280f00000a2a7201000070280f00000a2a070d09450700000044000000020000000d00000018000000230000002e000000390000002b4d7295020070280f00000a2a72a3020070280f00000a2a72b5020070280f00000a2a72c7020070280f00000a2a72dd020070280f00000a2a72\
ed020070280f00000a2a72fd020070280f00000a2a7201000070280f00000a2a13300200230000001200001102284500000a690a03284500000a690b06075f2c0717282700000a2a16282700000a2a2e720d030070734100000a2a1e02284600000a2a00133004003800000009000011031733070228250000062a2300000000\
000042400317596c284700000a690a02065b282500000602065d0317592824000006281700000a2a133002002200000013000011021f0a2f08021f305810002b06021f3758100002284800000a0a1200284900000a2a0000133002002b00000014000011020c160d2b1808096f4a00000a0a06284b00000a2d04160bde0f0917\
580d09086f2800000a32df172a072a00133002004900000014000011020c160d2b3608096f4a00000a0a06284b00000a2d22061f412e1d061f422e18061f432e13061f442e0e061f452e09061f462e04160bde0f0917580d09086f2800000a32c1172a072a1a72190300702a1e027b1b0000042a133002001200000015000011\
1200fe15050000021200177d1b000004062a00001330010019000000150000110f00282600000a2c06282a0000062a1200fe1505000002062a1a720d0300702a2e720d030070734100000a2a42534a4201000100000000000c00000076322e302e35303732370000000005006c000000000a0000237e00006c0a000038080000\
23537472696e677300000000a41200001c03000023555300c0150000100000002347554944000000d01500009c03000023426c6f620000000000000002000001571fa2010902000000fa0133001600000100000027000000050000001b0000002d00000039000000010000004e000000180000002c0000001500000001000000\
020000000200000001000000020000000100000000000a0001000000000006006e00670006007500670006007a0067000a00a50090000a00af0090000a00b90090000a00cf0090000a00d80090000a00e10090000a00f50090000a006901900006001904070406005104320406006504070406007e0407040600990407040600\
b40407040600cd0407040600e60407040600050507040600220507040600590539050600790539050a00b20597050600d905670006001506090606002a06670006003006670006004a06670006006a06670006009b06670006002a0767000600730767000600cd0767000600de0767000a00f40797050a001008970506001708\
320406002d0832040000000001000000000001000100010010001c0000000500010001000301000031000000090001002400810110003f00450005001a00240009211000530000000d001a0028000606d402aa005680dc02ad005680e402ad005680e802ad005680ec02ad005680fb02ad0056800103ad0056800803ad005680\
1203ad0056802003ad0056802503ad0056802903ad0056803103ad0056803903ad0056804203ad0056804703ad0056805303ad0056805903ad0056805f03ad0056806603ad0056806c03ad0056807a03ad0056808203ad0056808903ad0056808d03ad000600ef03aa000100f4034d015020000000009600c5000a0001001422\
000000009600ec0011000200102300000000960000011e000600642300000000960007011e000700c02300000000960016011e0008001c240000000096001c011e0009006c2400000000960025011e000a00c024000000009600320125000b0034250000000096003c012c000c009c250000000096004f0135000e0064260000\
000096005f01400011004428000000009600720149001300a0280000000096007b0149001400fc280000000096008701500015002829000000009600950157001600242a000000009600a30157001800202b000000009600b10160001a00402c000000009600c00150001d00b02c000000009600d20150001e00202d00000000\
9600e60150001f00902d000000009600f60150002000002e0000000096000d0250002100702e0000000096001e026b002200b82e0000000096002602500024001c2f000000009600380250002500802f0000000096004b0250002600e42f0000000096005d02500027004830000000009600720274002800c030000000009600\
84027d002a000431000000009600950284002b005c31000000009600a0028d002d00e431000000009600a902400030002033000000009600b702980032004f33000000009600c902a10034005b33000000008618ce02a60034006433000000009300910329013400a8330000000093009c032f013600d833000000009300a803\
340137001034000000009300b10334013800653400000000c600bc03390139006c3400000000e609c5033d0139007434000000009608d003410139009434000000009600d90346013900b934000000008600df0339013a00c034000000009600e703a1003a0000000100c705000001003e060000020031030000030029030000\
0400440600000100750600000100750600000100750600000100750600000100750600000100c70500000100b60600000200c30600000100c70500000200d20600000300d80600000100c705000002001b07000001002107000001003a0700000100400700000100440700000200470700000100440700000200470700000100\
440700000200000100000300470700000100440700000100440700000100440700000100440700000100440700000100c705000002006507000001004407000001004407000001004407000001004407000001006a07000002006f07000001006a07000001008b07000002009207000001009907000002009f0700000300c306\
00000100c705000002001b0700000100ad0700000200b20700000100b60700000200bb0700000100b60700000100d20700000100d20700000100d207050011006100ce0259016900ce025e017100ce0259017900ce0259018100ce0259018900ce0259019100ce0259019900ce025901a100ce025901a900ce025901b100ce02\
6301b900ce02a600c100ce02a6003100c5033d012900cd0568013100e2056e01c900ee057501c900f6057501c90000067501d100ce02a600d10023067901d900bc033901e10037067f01d100230685010900bc033901e900ce0263014100c5033d014100e2059601e900cd059c014900c5033d014900e205a2013900c5033d01\
3900e205a901e9005206b001e9005e06b801f1006f06c1013900cd05c9012900c5033d015100cd05db01e1007d0675014900cd05e501c9008806eb01c9009206f001c900a406f501f900ad067501f1006f06fc014900ce020202e100ca061102e100370617024100cd0523023100dd0684005100ec062902c900ce022f02c900\
f4063602c90000073c02c900080742025100c5033d015100e20529025900cd05620201013207680241004c077902510058078202e10052068b023100cd059c022900ce025901c9007d07a902c90052064202e100a707ca025900e205e1020900ce02a600f100c207ee020101c607f4021101bc033901e100d407fd021101a803\
02031901ce02a6002101ce020e033101ce021e0308000800b10008000c00b60008001000bb0008001400c00008001800c50008001c00ca0008002000cf0008002400d40008002800d90008002c00de0008003000e30008003400e80008003800ed0008003c00f20008004000f70008004400fc0008004800010108004c000601\
080050000b0108005400100108005800150108005c001a01080060001f0108006400240120006b00b6002e0043002a032e00530051032e00330051032e004b002a032e005b0073032e0063007c032e003b0064032e0013002a032e0023002a032e002b00300340006b00b60060006b00b60080006b00b600a0006b00b600a300\
6b021503c0006b00b600e0006b00b60000016b00b60020016b00b60040016b00b60060016b00b60080016b00b600c0016b00b600e0016b00b60000026b00b60020026b00b60040026b00b60060026b00b60080026b00b600a0026b00b600c0026b00b600e0026b00b60000036b00b60020036b00b60040036b00b60060036b00\
b60080036b00b600a0036b00b600c0036b00b600e0036b00b60000046b00b60020046b00b60040046b00b6008b01d001e10107021e024a025a026e02750291029602a302af02bb02c302cd02d302e702f90207032503050001000000fb03500100000204540102002900030002002a0005000480000001000000b40939370000\
000000004500000002000000000000000000000001005e000000000002000000000000000000000001008400000000000300020000000000003c4d6f64756c653e005747504e65787447656e434c522e646c6c0055736572446566696e656446756e6374696f6e7300574750417274696b656c747970005574696c7300574750\
4e65787447656e434c5200576f6368656e74616765006d73636f726c69620053797374656d004f626a65637400456e756d0056616c7565547970650053797374656d2e446174610053797374656d2e446174612e53716c547970657300494e756c6c61626c650053716c537472696e670053716c4461746554696d650053686f\
77446174756d0053716c4d6f6e65790053716c496e7433320053716c446563696d616c0047657450726569730053716c426f6f6c65616e00497343686970004973436869704f724d52436869700049734642430049734d5243686970004973574750426172636f64650043616c63416c74657200476574426172636f64654275\
6e6e79426f6e0043616c6354616765696e52616e67650053686f774d6f6e61740053716c496e74363400486578546f496e7400537472696e67546f496e740053686f77426f6e4e756d6d657200476574426172636f6465424b4c00476574426172636f6465464d5700476574426172636f64654865696d00476574426172636f\
6465417274696b656c00476574426172636f6465436f6e7461696e657200476574426172636f64654964656e7400476574426172636f64654b6f7374656e7374656c6c6500476574426172636f64654f626a656b740043616c63446179004765745465696c656e756d6d6572424b4c004765745465696c656e756d6d65724865\
696d004765745465696c656e756d6d6572464d57004765745465696c656e756d6d65724f626a656b74004765744669727374446179496e59656172004765744c617374446179496e5965617200497353616d6544617465005573654b726569730053686f77576f6368656e74616700436865636b417274696b656c747970656e\
0054657374002e63746f720076616c75655f5f004b65696e54797000414e5300424b4c00424b4c45696e7269636874756e670042756e6e790043686172676500436f6e7461696e6572004469656e73746c656974756e67004672656900464d5700466cc3a463686500476577696368740048616e6474756368004865696d0049\
6e436f6e7461696e6572004b61737365004d61747465004f626a656b74004f5053657400536f6e646572617274696b656c0053746174696f6e005374c3bc636b0057656200416c6c00496e74546f4d794865780056616c7565546f436861720049734e756d62657200497348657856616c756500546f537472696e6700676574\
5f49734e756c6c006765745f4e756c6c005061727365004d6574686f6431004d6574686f64320076617231006d5f4e756c6c0049734e756c6c004e756c6c0053797374656d2e5265666c656374696f6e00417373656d626c7956657273696f6e4174747269627574650053797374656d2e52756e74696d652e496e7465726f70\
536572766963657300436f6d56697369626c6541747472696275746500417373656d626c7943756c7475726541747472696275746500417373656d626c7954726164656d61726b41747472696275746500417373656d626c79436f7079726967687441747472696275746500417373656d626c7950726f647563744174747269\
6275746500417373656d626c79436f6d70616e7941747472696275746500417373656d626c79436f6e66696775726174696f6e41747472696275746500417373656d626c794465736372697074696f6e41747472696275746500417373656d626c795469746c654174747269627574650053797374656d2e52756e74696d652e\
436f6d70696c6572536572766963657300436f6d70696c6174696f6e52656c61786174696f6e734174747269627574650052756e74696d65436f6d7061746962696c697479417474726962757465004d6963726f736f66742e53716c5365727665722e5365727665720053716c46756e6374696f6e4174747269627574650044\
6174756d006f705f496d706c69636974004461746554696d65006f705f4578706c69636974006765745f446179006765745f4d6f6e7468006765745f596561720053797374656d2e5465787400537472696e674275696c64657200417070656e6400496e74333200537472696e6700436f6e636174004d656e67650050726569\
7300446563696d616c006f705f457175616c697479006f705f4d756c7469706c79004d61746800526f756e6400426172636f6465006765745f4c656e677468006765745f546f646179006765745f446174650054696d655370616e005375627472616374006765745f44617973004b6f7374656e7374656c6c65004e756d6d65\
72005061644c65667400537461727400456e6465006f705f477265617465725468616e006f705f547275650044617973496e4d6f6e74680041646444617973006f705f4c6573735468616e4f72457175616c0053686f72740048657856616c756500436f6e7665727400546f496e7436340056616c756500426f6e0049440043\
686970006f705f4c6573735468616e006f705f426974776973654f720054616765004a61687200546167004461794f665765656b006765745f4461794f665765656b00446174756d3100446174756d32004b72656973005374656c6c656e00456d70747900536f6c6c0049737400576572740044696769747300506f7700546f\
4368617200436861720073006765745f43686172730053657269616c697a61626c654174747269627574650053716c55736572446566696e65645479706541747472696275746500466f726d6174005374727563744c61796f7574417474726962757465004c61796f75744b696e640000072d002d002d0001032e0000094a00\
61006e002e0000094600650062002e0000094d00610072002e0000094100700072002e0000094d00610069002e0000094a0075006e002e0000094a0075006c002e0000094100750067002e0000095300650070002e0000094f006b0074002e0000094e006f0076002e000009440065007a002e0000092d002d002d002e000103\
380000074a0061006e00000746006500620000074d0072007a00000741007000720000074d006100690000074a0075006e0000074a0075006c000007410075006700000753006500700000074f006b00740000074e006f0076000007440065007a0000173000310020002d0020004a0061006e00750061007200011930003200\
20002d002000460065006200750072006100720001133000330020002d0020004d00e40072007a0001153000340020002d00200041007000720069006c0001113000350020002d0020004d006100690001133000360020002d0020004a0075006e00690001133000370020002d0020004a0075006c0069000117300038002000\
2d002000410075006700750073007400011d3000390020002d002000530065007000740065006d0062006500720001193100300020002d0020004f006b0074006f00620065007200011b3100310020002d0020004e006f00760065006d00620065007200011b3100320020002d002000440065007a0065006d00620065007200\
01033200000746004200430000094300680069007000000d4d0052004300680069007000000334000003370000033100000330000005390030000003330000053900310000053900320000034200000348000003460000034f0000054d006f0000054400690000054d006900000544006f000005460072000005530061000005\
53006f00000d4d006f006e0074006100670000114400690065006e00730074006100670000114d0069007400740077006f0063006800001544006f006e006e00650072007300740061006700000f4600720065006900740061006700000f530061006d007300740061006700000f53006f006e006e00740061006700000b4800\
65006c006c006f000001000004c91d1a4c458c418ee530ba6014e7770008b77a5c561934e089060001111511190c0004111d112111251125111d06000111291115060001112511190800021115112111210a00031121111911191119080002111511191129060001112d1115060001111511210800021115112111150a000311\
15112111291115080002111911191121080002111911211121060001111911210800021129111911190a000311151115112111210800021129112d112d0400001115032000010206080306110c040000000004010000000402000000040400000004080000000410000000042000000004400000000480000000040001000004\
0002000004000400000400080000040010000004002000000400400000040080000004000001000400000200040000040004000008000400001000040000200004ffff3f000500020e08080400010e08040001020e0320000e03200002040000111406000111141115020602032800020408001114042001010e042001010204\
2001010805000111150e06000111651119032000080520011269030500020e0e0e05200112690e0a07061165080808126908050001081121050001117508060001117511250600011175111d07000202117511750800021175117511750700021175117508060001111d11750a07041175117511751175050001112902030701\
0e05000111250a04000011650420001165062001117d11650500020d0d08042001010d0907041165117d0d11650520020e08030600030e0e0e0e04070208080500011121080500010211290620030108080805000208080805200111650d07000202116511650f07081165080811651165116511650807070411650808080500\
01112d0a0500020a0e080607030e0a112d03070108080002112911211121080002112911291129050002020e0e0407020e0e0507030e020e060001111911650507021165080520001180850b070508081165118085116507070308116511650607021165116502060e0507030e0e080d07041165118085118085118085050001\
0a112d060702110c110c0500020d0d0d0400010308030701030420010308040001020306070403020e08062001011180950801000100000000000620010111809d04070111140501000000002001001b436f7079726967687420c2a92045445620477261646c203230303600001201000d5747504e65787447656e434c520000\
0e01000945445620477261646c00000801000800000000001e01000100540216577261704e6f6e457863657074696f6e5468726f77730100604e000000000000000000007e4e0000002000000000000000000000000000000000000000000000704e000000000000000000000000000000005f436f72446c6c4d61696e006d73\
636f7265652e646c6c0000000000ff2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058600000480300000000000000000000480334000000560053005f00560045005200530049004f004e005f0049004e0046004f0000000000\
bd04effe00000100000001003937b409000001003937b4093f000000000000000400000002000000000000000000000000000000440000000100560061007200460069006c00650049006e0066006f00000000002400040000005400720061006e0073006c006100740069006f006e00000000000000b004a802000001005300\
7400720069006e006700460069006c00650049006e0066006f00000084020000010030003000300030003000340062003000000034000a00010043006f006d00700061006e0079004e0061006d00650000000000450044005600200047007200610064006c00000044000e000100460069006c00650044006500730063007200\
69007000740069006f006e00000000005700470050004e00650078007400470065006e0043004c005200000040000f000100460069006c006500560065007200730069006f006e000000000031002e0030002e0032003400380034002e00310034003100330037000000000044001200010049006e007400650072006e006100\
6c004e0061006d00650000005700470050004e00650078007400470065006e0043004c0052002e0064006c006c0000005c001b0001004c006500670061006c0043006f007000790072006900670068007400000043006f0070007900720069006700680074002000a9002000450044005600200047007200610064006c002000\
3200300030003600000000004c00120001004f0072006900670069006e0061006c00460069006c0065006e0061006d00650000005700470050004e00650078007400470065006e0043004c0052002e0064006c006c0000003c000e000100500072006f0064007500630074004e0061006d006500000000005700470050004e00\
650078007400470065006e0043004c005200000044000f000100500072006f006400750063007400560065007200730069006f006e00000031002e0030002e0032003400380034002e00310034003100330037000000000048000f00010041007300730065006d0062006c0079002000560065007200730069006f006e000000\
31002e0030002e0032003400380034002e003100340031003300370000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
004000000c000000903e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET=SAFE
GO
GO
GO
PRINT N'Creating [dbo].[IsChip]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[IsChip]
GO
GO
GO
PRINT N'Creating [dbo].[CheckArtikeltypen]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[CheckArtikeltypen]
GO
GO
GO
PRINT N'Creating [dbo].[IsChipOrMRChip]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[IsChipOrMRChip]
GO
GO
GO
PRINT N'Creating [dbo].[CalcAlter]'
GO
RETURNS [decimal] (9, 2)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[CalcAlter]
GO
GO
GO
PRINT N'Creating [dbo].[GetTeilenummerObjekt]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetTeilenummerObjekt]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeArtikel]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeArtikel]
GO
GO
GO
PRINT N'Creating [dbo].[ShowMonat]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[ShowMonat]
GO
GO
GO
PRINT N'Creating [dbo].[IsMRChip]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[IsMRChip]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeBunnyBon]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeBunnyBon]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeIdent]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeIdent]
GO
GO
GO
PRINT N'Creating [dbo].[HexToInt]'
GO
RETURNS [bigint]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[HexToInt]
GO
GO
GO
PRINT N'Creating [dbo].[GetPreis]'
GO
RETURNS [money]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetPreis]
GO
GO
GO
PRINT N'Creating [dbo].[IsFBC]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[IsFBC]
GO
GO
GO
PRINT N'Creating [dbo].[GetTeilenummerHeim]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetTeilenummerHeim]
GO
GO
GO
PRINT N'Creating [dbo].[StringToInt]'
GO
RETURNS [bigint]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[StringToInt]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeHeim]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeHeim]
GO
GO
GO
PRINT N'Creating [dbo].[ShowDatum]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[ShowDatum]
GO
GO
GO
PRINT N'Creating [dbo].[IsWGPBarcode]'
GO
RETURNS [bit]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[IsWGPBarcode]
GO
GO
GO
PRINT N'Creating [dbo].[GetTeilenummerFMW]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetTeilenummerFMW]
GO
GO
GO
PRINT N'Creating [dbo].[UseKreis]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[UseKreis]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeObjekt]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeObjekt]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeKostenstelle]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeKostenstelle]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeFMW]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeFMW]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeBKL]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeBKL]
GO
GO
GO
PRINT N'Creating [dbo].[GetTeilenummerBKL]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetTeilenummerBKL]
GO
GO
GO
PRINT N'Creating [dbo].[GetBarcodeContainer]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetBarcodeContainer]
GO
GO
GO
PRINT N'Creating [dbo].[ShowBonNummer]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[ShowBonNummer]
GO
GO
GO
PRINT N'Creating [dbo].[GetLastDayInYear]'
GO
RETURNS [datetime]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetLastDayInYear]
GO
GO
GO
PRINT N'Creating [dbo].[GetFirstDayInYear]'
GO
RETURNS [datetime]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[GetFirstDayInYear]
GO
GO
GO
PRINT N'Creating [dbo].[CalcDay]'
GO
RETURNS [datetime]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[CalcDay]
GO
GO
GO
PRINT N'Creating [dbo].[ShowWochentag]'
GO
RETURNS [nvarchar] (4000)
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[ShowWochentag]
GO
GO
GO
PRINT N'Creating [dbo].[CalcTageinRange]'
GO
RETURNS [int]
WITH EXECUTE AS CALLER
EXTERNAL NAME [WGPNextGENCLR].[UserDefinedFunctions].[CalcTageinRange]
GO
GO
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO
The CLR functions are dropped but not the usages in the tables, therefore the script fails :-(
Th error is something: Cannot Drop function GetBarcodeObjekt because it is refenced by obect 'ObjektTeile'
I hop that helps to hunt down the error
Marco, EDVGradl
|
|
|
|
|
EDV Gradl
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
In CTP 7 the problem is still there.
|
|
|
|
|
Brian Ku MSFT
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
Christian is working with you offline now. Thanks!
|
|
|
|
|
EDV Gradl
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
Sadly in the RTM version is still does not work. I am somewhat dissapointed.
|
|
|
|
|
BobFr
|
Posted: Visual Studio Team System - Database Professionals, Error in Schema Compare - CTP5 |
Top |
A year later and still doesn't work!
If you use a function in a computed column in a table definition you will encounter the message saying you cannot drop a function because it is being used even if you made not change to that particular function.
|
|
|
|
|
|
|