
/****** Object:  Table [dbo].[Contract]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Contract] ON
INSERT [dbo].[Contract] ([Contractid], [BankAccount], [KSHNumber], [KUJNumber], [TradeRegister], [TaxNumber], [TaxIdentifier], [MotherName], [IdentityCardNumber], [TownShipIdentifier], [Address], [ValidStart], [ValidEnd], [StatusFlag], [MVHNumber]) VALUES (CAST(1 AS Decimal(18, 0)), N'11775544-05347854-23768965', N'234234', N'11111', N'22222', N'33333', N'44444', N'Juliska', N'HA132422', N'TSID', N'nincs neki címe', NULL, NULL, NULL, N'9999')
SET IDENTITY_INSERT [dbo].[Contract] OFF
/****** Object:  Table [dbo].[Containers]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Containers] ON
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(1 AS Decimal(18, 0)), NULL, N'240 literes műanyag', NULL)
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(2 AS Decimal(18, 0)), NULL, N'550 literes fém', NULL)
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(3 AS Decimal(18, 0)), NULL, N'6 m3-es fém', NULL)
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(4 AS Decimal(18, 0)), NULL, N'9 m3-es fém', NULL)
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(5 AS Decimal(18, 0)), NULL, N'Euro', NULL)
INSERT [dbo].[Containers] ([ContainersId], [ContainerCode], [ContainerName], [ContainerPrice]) VALUES (CAST(6 AS Decimal(18, 0)), NULL, N'Vérszállító', NULL)
SET IDENTITY_INSERT [dbo].[Containers] OFF
/****** Object:  Table [dbo].[CompanyDepots]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[CompanyDepots] ON
INSERT [dbo].[CompanyDepots] ([CompanyDepotsId], [Name], [Place], [Address]) VALUES (CAST(1 AS Decimal(18, 0)), N'ATEV Debreceni Gyára', N'Debrecen', N'Debrecen-Bánk')
INSERT [dbo].[CompanyDepots] ([CompanyDepotsId], [Name], [Place], [Address]) VALUES (CAST(2 AS Decimal(18, 0)), N'ATEV Solti Gyára', N'Solt', N'Solt_')
INSERT [dbo].[CompanyDepots] ([CompanyDepotsId], [Name], [Place], [Address]) VALUES (CAST(3 AS Decimal(18, 0)), N'ATEV valahol', N'Valahol', N'gfghfdg')
SET IDENTITY_INSERT [dbo].[CompanyDepots] OFF
/****** Object:  Table [dbo].[Classes]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Classes] ON
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(1 AS Decimal(18, 0)), N'I', CAST(102082 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(2 AS Decimal(18, 0)), N'I', CAST(102413 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(3 AS Decimal(18, 0)), N'II', CAST(102001 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(4 AS Decimal(18, 0)), N'II', CAST(102002 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(5 AS Decimal(18, 0)), N'III', CAST(102422 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(7 AS Decimal(18, 0)), N'III', CAST(102166 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(8 AS Decimal(18, 0)), N'IIIB', CAST(102195 AS Decimal(18, 0)), NULL, NULL)
INSERT [dbo].[Classes] ([ClassesId], [ClassNumber], [ItemNumber], [ItemName], [EwcNumber]) VALUES (CAST(9 AS Decimal(18, 0)), N'IIIB', CAST(102175 AS Decimal(18, 0)), NULL, NULL)
SET IDENTITY_INSERT [dbo].[Classes] OFF
/****** Object:  Table [dbo].[ContractTypes]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[ContractTypes] ON
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(1 AS Decimal(18, 0)), N'Kis létszámú állattartó', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(2 AS Decimal(18, 0)), N'Nagy létszámú állattartó', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(3 AS Decimal(18, 0)), N'Önkormányzat', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(4 AS Decimal(18, 0)), N'Vágóhídi', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(5 AS Decimal(18, 0)), N'Kereskedelmi', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(6 AS Decimal(18, 0)), N'Élelmiszerhulladékos', NULL)
INSERT [dbo].[ContractTypes] ([ContractTypesId], [ContractTypeName], [ContractTypeComment]) VALUES (CAST(7 AS Decimal(18, 0)), N'Egyedi', NULL)
SET IDENTITY_INSERT [dbo].[ContractTypes] OFF
/****** Object:  Table [dbo].[Modality]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Modality] ON
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(1 AS Decimal(18, 0)), N'Baromfi Telep', N'BT')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(2 AS Decimal(18, 0)), N'Sertés Telep', N'ST')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(4 AS Decimal(18, 0)), N'Marha Telep', N'MT')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(5 AS Decimal(18, 0)), N'Juh Telep', N'JT')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(6 AS Decimal(18, 0)), N'Baromfi Feldolgozó', N'BF')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(7 AS Decimal(18, 0)), N'Vágóhíd', N'VH')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(8 AS Decimal(18, 0)), N'Gyepmesteri Telep', N'GYT')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(9 AS Decimal(18, 0)), N'-', N'EP')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(10 AS Decimal(18, 0)), N'-', N'EAT')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(11 AS Decimal(18, 0)), N'-', N'EEK')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(12 AS Decimal(18, 0)), N'-', N'GYH')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(13 AS Decimal(18, 0)), N'-', N'HH')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(14 AS Decimal(18, 0)), N'-', N'KER')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(15 AS Decimal(18, 0)), N'-', N'KGY')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(16 AS Decimal(18, 0)), N'-', N'LAK')
INSERT [dbo].[Modality] ([ModalityId], [Modality], [ShortModality]) VALUES (CAST(17 AS Decimal(18, 0)), N'-', N'BGY')
SET IDENTITY_INSERT [dbo].[Modality] OFF
/****** Object:  Table [dbo].[Groups]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Groups] ON
INSERT [dbo].[Groups] ([groupId], [groupName], [isActive], [details]) VALUES (CAST(1 AS Decimal(18, 0)), N'Administrators', CAST(1 AS Decimal(18, 0)), NULL)
INSERT [dbo].[Groups] ([groupId], [groupName], [isActive], [details]) VALUES (CAST(2 AS Decimal(18, 0)), N'Only watch', CAST(1 AS Decimal(18, 0)), NULL)
SET IDENTITY_INSERT [dbo].[Groups] OFF
/****** Object:  Table [dbo].[RouteCodes]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[RouteCodes] ON
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(1 AS Decimal(18, 0)), N'A', N'Bihari')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(2 AS Decimal(18, 0)), N'B', N'Füredi')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(3 AS Decimal(18, 0)), N'C', N'Füzesgyarmati')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(4 AS Decimal(18, 0)), N'D', N'Hevesi')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(5 AS Decimal(18, 0)), N'E', N'Nyírségi I.')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(6 AS Decimal(18, 0)), N'F', N'Nyírségi II.')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(7 AS Decimal(18, 0)), N'G', N'Polgári')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(8 AS Decimal(18, 0)), N'H', N'Jászsági')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(9 AS Decimal(18, 0)), N'I', N'Vágóhídi I.')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(10 AS Decimal(18, 0)), N'J', N'Vágóhídi II.')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(11 AS Decimal(18, 0)), N'X', N'Célfuvar')
INSERT [dbo].[RouteCodes] ([RouteCodesId], [Code], [Details]) VALUES (CAST(12 AS Decimal(18, 0)), N'U', N'Saját beszállítás')
SET IDENTITY_INSERT [dbo].[RouteCodes] OFF
/****** Object:  Table [dbo].[Regions]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Regions] ON
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), N'Bács-Kiskun')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), N'Baranya')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), N'Békés')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), N'Borsod-Abaúj-Zemplén')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), N'Csongrád')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(6 AS Decimal(18, 0)), N'Fejér')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(7 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)), N'Győr-Moson-Sopron')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(8 AS Decimal(18, 0)), CAST(8 AS Decimal(18, 0)), N'Hajdú-Bihar')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(9 AS Decimal(18, 0)), CAST(9 AS Decimal(18, 0)), N'Heves')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(10 AS Decimal(18, 0)), CAST(10 AS Decimal(18, 0)), N'Jász-Nagykun-Szolnok')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(11 AS Decimal(18, 0)), CAST(11 AS Decimal(18, 0)), N'Komárom-Esztergom')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(12 AS Decimal(18, 0)), CAST(12 AS Decimal(18, 0)), N'Nógrád')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(13 AS Decimal(18, 0)), CAST(13 AS Decimal(18, 0)), N'Pest')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(14 AS Decimal(18, 0)), CAST(14 AS Decimal(18, 0)), N'Somogy')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(15 AS Decimal(18, 0)), CAST(15 AS Decimal(18, 0)), N'Szabolcs-Szatmár-Bereg')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(16 AS Decimal(18, 0)), CAST(16 AS Decimal(18, 0)), N'Tolna')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(17 AS Decimal(18, 0)), CAST(17 AS Decimal(18, 0)), N'Vas')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(18 AS Decimal(18, 0)), CAST(18 AS Decimal(18, 0)), N'Veszprém')
INSERT [dbo].[Regions] ([RegionsId], [regionCode], [regionName]) VALUES (CAST(19 AS Decimal(18, 0)), CAST(19 AS Decimal(18, 0)), N'Zala')
SET IDENTITY_INSERT [dbo].[Regions] OFF
/****** Object:  Table [dbo].[ProgramModules]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[ProgramModules] ON
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(11 AS Decimal(18, 0)), N'Show Partners', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(12 AS Decimal(18, 0)), N'Add/Edit Partners', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(51 AS Decimal(18, 0)), N'Show Partner Search', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(61 AS Decimal(18, 0)), N'Show Depot Search', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(21 AS Decimal(18, 0)), N'Show Partner Contract', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(22 AS Decimal(18, 0)), N'Add/Edit Partner Contract', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(7 AS Decimal(18, 0)), CAST(31 AS Decimal(18, 0)), N'Show Depots', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(8 AS Decimal(18, 0)), CAST(32 AS Decimal(18, 0)), N'Add/Edit Depots', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(9 AS Decimal(18, 0)), CAST(41 AS Decimal(18, 0)), N'Show Depot Contracts', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(10 AS Decimal(18, 0)), CAST(42 AS Decimal(18, 0)), N'Add/Edit Depot Contracts', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(11 AS Decimal(18, 0)), CAST(71 AS Decimal(18, 0)), N'Show Report', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(12 AS Decimal(18, 0)), CAST(999 AS Decimal(18, 0)), N'Admin tools', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(13 AS Decimal(18, 0)), CAST(13 AS Decimal(18, 0)), N'Delete Partner', NULL)
INSERT [dbo].[ProgramModules] ([ProgramModulesId], [ModuleCode], [ModuleName], [ModuleDetails]) VALUES (CAST(14 AS Decimal(18, 0)), CAST(33 AS Decimal(18, 0)), N'Delete Depot', NULL)
SET IDENTITY_INSERT [dbo].[ProgramModules] OFF
/****** Object:  Table [dbo].[ProcessingCodes]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[ProcessingCodes] ON
INSERT [dbo].[ProcessingCodes] ([ProcessingCodesId], [ProcessingCode], [ProcessingName]) VALUES (CAST(1 AS Decimal(18, 0)), N'B', N'Bio gáz')
INSERT [dbo].[ProcessingCodes] ([ProcessingCodesId], [ProcessingCode], [ProcessingName]) VALUES (CAST(2 AS Decimal(18, 0)), N'Á', N'Átszállításos')
INSERT [dbo].[ProcessingCodes] ([ProcessingCodesId], [ProcessingCode], [ProcessingName]) VALUES (CAST(3 AS Decimal(18, 0)), N'F', N'Feldolgozásos')
SET IDENTITY_INSERT [dbo].[ProcessingCodes] OFF
/****** Object:  Table [dbo].[PartnerData]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[PartnerData] ON
INSERT [dbo].[PartnerData] ([PartnerId], [Name], [Place], [ZipCode], [Address], [PartnerNumber], [OrderNumber], [Administrator], [LetterAddress], [Owner], [ContactPerson], [ValidStart], [ValidEnd], [StatusFlag], [RegionsId], [ContractTypesId], [PartnerDataComment], [ContractId]) VALUES (CAST(2 AS Decimal(18, 0)), N'Lóránd Árpád', N'Debrecen', N'4031', N'Derék utca 100.', N'00112233', N'5544332211', NULL, NULL, N'óóóó az én vagyok :)', N'julika', CAST(0x4C320B00 AS Date), NULL, N'A', CAST(8 AS Decimal(18, 0)), NULL, NULL, CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[PartnerData] ([PartnerId], [Name], [Place], [ZipCode], [Address], [PartnerNumber], [OrderNumber], [Administrator], [LetterAddress], [Owner], [ContactPerson], [ValidStart], [ValidEnd], [StatusFlag], [RegionsId], [ContractTypesId], [PartnerDataComment], [ContractId]) VALUES (CAST(4 AS Decimal(18, 0)), N'Kiss Elek', N'Józsa', N'4225', N'Sereg utca 8.', N'00123456', N'654321', N'másik admin', N'van levelezés', N'nem én', N'palika', CAST(0x26350B00 AS Date), NULL, N'A', CAST(9 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)), NULL, NULL)
SET IDENTITY_INSERT [dbo].[PartnerData] OFF
/****** Object:  Table [dbo].[Users]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Users] ON
INSERT [dbo].[Users] ([usersId], [groupId], [userName], [userPassword], [userFullName], [isActive]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), N'Pisti', N'73b51211e5433b1288a1ddaa9938a225', N'Nagy István', CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[Users] ([usersId], [groupId], [userName], [userPassword], [userFullName], [isActive]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), N'Nudli', N'73b51211e5433b1288a1ddaa9938a225', N'Nudli', CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[Users] ([usersId], [groupId], [userName], [userPassword], [userFullName], [isActive]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), N'User', N'5b1c9649834273f78a897721acc3cfae', N'USER', CAST(1 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[Users] OFF
/****** Object:  Table [dbo].[GrantedModules]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[GrantedModules] ON
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(6 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(8 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(9 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(7 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(10 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(8 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(11 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(11 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(12 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(12 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(13 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(13 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(14 AS Decimal(18, 0)))
INSERT [dbo].[GrantedModules] ([ProgramModulesId], [groupId], [grantedModulesId]) VALUES (CAST(14 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(15 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[GrantedModules] OFF
/****** Object:  Table [dbo].[DepotData]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[DepotData] ON
INSERT [dbo].[DepotData] ([DepotId], [PartnerId], [DepotAddress], [DepotCode], [SiteDirectorName], [SiteDircetorPhone], [DepotPlace], [Weighing], [WeighingPlace], [Comments], [ValidStart], [ValidEnd], [StatusFlag], [RegionsId], [DepotName], [isTransportByNotification]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), N'4032 Tisza utca 35.', N'55445544', N'vki', NULL, N'Debrecen', N'ATEV', N'', N'no comment', NULL, NULL, N'A', CAST(9 AS Decimal(18, 0)), N'TesztFelrakó1', N'N')
INSERT [dbo].[DepotData] ([DepotId], [PartnerId], [DepotAddress], [DepotCode], [SiteDirectorName], [SiteDircetorPhone], [DepotPlace], [Weighing], [WeighingPlace], [Comments], [ValidStart], [ValidEnd], [StatusFlag], [RegionsId], [DepotName], [isTransportByNotification]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), N'4225 Debrecen-Józsa, Sereg utca 11.', N'11223344', N'másik vki', N'van', N'Józsa', N'ATEV', NULL, N'van comment', NULL, NULL, N'A', CAST(13 AS Decimal(18, 0)), N'TesztFelrakó2', N'I')
SET IDENTITY_INSERT [dbo].[DepotData] OFF
/****** Object:  Table [dbo].[PartnerPhoneBook]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[Transports]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[Routes]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[Routes] ON
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[Routes] ([RoutesId], [RouteCodesId], [DepotId], [Priority]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[Routes] OFF
/****** Object:  Table [dbo].[DistanceBetweenDepots]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[DistanceBetweenDepots] ON
INSERT [dbo].[DistanceBetweenDepots] ([DistanceBetweenDepotsId], [CompanyDepotsId], [DepotId], [Distance], [Priority]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(120 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[DistanceBetweenDepots] ([DistanceBetweenDepotsId], [CompanyDepotsId], [DepotId], [Distance], [Priority]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(400 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[DistanceBetweenDepots] ([DistanceBetweenDepotsId], [CompanyDepotsId], [DepotId], [Distance], [Priority]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(200 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[DistanceBetweenDepots] ([DistanceBetweenDepotsId], [CompanyDepotsId], [DepotId], [Distance], [Priority]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(100 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[DistanceBetweenDepots] OFF
/****** Object:  Table [dbo].[DepotsAndModalities]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[DepotsAndModalities] ON
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(9 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(10 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(11 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(12 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(13 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(6 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[DepotsAndModalities] ([DepotsAndModalitiesId], [DepotId], [ModalityId], [Priority]) VALUES (CAST(14 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[DepotsAndModalities] OFF
/****** Object:  Table [dbo].[DepotPhoneBook]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[DepotContract]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[DepotContainers]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[DepotContainers] ON
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)))
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)))
INSERT [dbo].[DepotContainers] ([DepotContainersId], [DepotId], [ContainersId], [Number]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[DepotContainers] OFF
/****** Object:  Table [dbo].[DeliveryQuantity]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[DefaultTransportDays]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[DefaultTransportDays] ON
INSERT [dbo].[DefaultTransportDays] ([DtdId], [DepotId], [isWinter], [monday], [tuesday], [wednesday], [thursday], [friday], [saturday], [sunday], [weeklyTransport]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), N'I', N'I', NULL, N'I', NULL, N'I', NULL, NULL, CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[DefaultTransportDays] ([DtdId], [DepotId], [isWinter], [monday], [tuesday], [wednesday], [thursday], [friday], [saturday], [sunday], [weeklyTransport]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), N'N', NULL, N'I', NULL, N'I', NULL, N'I', NULL, CAST(4 AS Decimal(18, 0)))
INSERT [dbo].[DefaultTransportDays] ([DtdId], [DepotId], [isWinter], [monday], [tuesday], [wednesday], [thursday], [friday], [saturday], [sunday], [weeklyTransport]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), N'N', NULL, N'I', N'I', N'I', NULL, NULL, N'I', CAST(5 AS Decimal(18, 0)))
INSERT [dbo].[DefaultTransportDays] ([DtdId], [DepotId], [isWinter], [monday], [tuesday], [wednesday], [thursday], [friday], [saturday], [sunday], [weeklyTransport]) VALUES (CAST(4 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), N'I', NULL, N'I', NULL, N'I', NULL, NULL, NULL, CAST(2 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[DefaultTransportDays] OFF
/****** Object:  Table [dbo].[ClassesForDepots]    Script Date: 05/02/2010 22:32:10 ******/
SET IDENTITY_INSERT [dbo].[ClassesForDepots] ON
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(1 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(3 AS Decimal(18, 0)), CAST(4 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(5 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(6 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(7 AS Decimal(18, 0)), CAST(5 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(1 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(8 AS Decimal(18, 0)), CAST(7 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
INSERT [dbo].[ClassesForDepots] ([ClassesForDepotsId], [ClassesId], [DepotId], [ProcessingCodesId]) VALUES (CAST(9 AS Decimal(18, 0)), CAST(8 AS Decimal(18, 0)), CAST(3 AS Decimal(18, 0)), CAST(2 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[ClassesForDepots] OFF
/****** Object:  Table [dbo].[GarbageList]    Script Date: 05/02/2010 22:32:10 ******/
/****** Object:  Table [dbo].[ContractContainers]    Script Date: 05/02/2010 22:32:10 ******/
