IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MAX_Buchungen_LISTE')
INSERT INTO  dbo.PARAMS 
(Param, Beschreibung, Wert, bereich) 
VALUES ('IAPP_MAX_Buchungen_LISTE', 'Gibt an wie viele abgeschlossene Buchungen in der App angezeigt werden sollen.','5', 'CSAPP'), 
('BAPP_AUTO_ABRECHNEN', 'Soll die Rechnung automatisch erstellt werden?','0', 'CSAPP')
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MIN_BEFOR_CANCELLATION')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'IAPP_MIN_BEFOR_CANCELLATION' , -- Param - varchar(50)
          'Gibt die Dauer in Minuten < 0 an, nach der eine nicht angetretene Reservierung gelöscht wird' , -- Beschreibung - varchar(255)
          '-15' , -- Wert - varchar(255)
          '-15' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_CSHARE_URL')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'SAPP_CSHARE_URL' , -- Param - varchar(50)
          'Gibt die URL zum C-Share Webmodul an' , -- Beschreibung - varchar(255)
          'https://kunden2.cx9.de/cx9/c_sharetest/web/' , -- Wert - varchar(255)
          '' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_AUTHCODE')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'SAPP_AUTHCODE' , -- Param - varchar(50)
          'C-Share Authentifizierungscode' , -- Beschreibung - varchar(255)
          'Cx9Demo' , -- Wert - varchar(255)
          '' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MIN_BEFORE_BT')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'IAPP_MIN_BEFORE_BT' , -- Param - varchar(50)
          'Gibt die Zeit in Minuten an, wie weit vor der Reservierung der Bluetooth Key angefordert wird' , -- Beschreibung - varchar(255)
          '30' , -- Wert - varchar(255)
          '30' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_CHECK_FUEL_MIN_AFTER_LAST_RES')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'IAPP_CHECK_FUEL_MIN_AFTER_LAST_RES' , -- Param - varchar(50)
          'Gibt die Zeit in  Minuten an, bis wann vor einer Reservierung das Fahrzeug einen minimalen Ladestand erreicht haben soll' , -- Beschreibung - varchar(255)
          '15' , -- Wert - varchar(255)
          '15' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MIN_CHECK_CHARGE')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'IAPP_MIN_CHECK_CHARGE' , -- Param - varchar(50)
          'Gibt die Zeit in  Minuten an, bis wann nach einer Reservierung das Fahrueg am Ladekabel sein muss' , -- Beschreibung - varchar(255)
          '15' , -- Wert - varchar(255)
          '15' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MIN_CHARGE')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'IAPP_MIN_CHARGE' , -- Param - varchar(50)
          'Gibt den minimalen Ladestand in Prozent an, der vor einer Reservierung erreichts ein soll' , -- Beschreibung - varchar(255)
          '70' , -- Wert - varchar(255)
          '70' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_CANCELLATION_TIME')
insert into params (Param, Beschreibung, Wert, Defaultwert, bereich) VALUES('IAPP_CANCELLATION_TIME', 'Gibt die Zeit in Minuten an, ab der eine Storno-Gebühr vor der Reservierung berechnet wird', '1440', '1440', 'CSAPP')
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_CANCELLATION_POSSIBLE_TIME')
insert into params (Param, Beschreibung, Wert, Defaultwert, bereich) VALUES('IAPP_CANCELLATION_POSSIBLE_TIME', 'Gibt die Zeit in Minuten an, bis wie lange vor einer Reservierung eine Stornierung möglich ist', '1', '1', 'CSAPP')
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'BAPP_CALC_CANCELLATION_FEE')
insert into params (Param, Beschreibung, Wert, Defaultwert, bereich) VALUES('BAPP_CALC_CANCELLATION_FEE', 'Gibt an, ob eine Storno-Gebühr berechnet wird', '0', 'NOSHOW', 'CSAPP')
IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_CANCELLATION_RATE')
insert into params (Param, Beschreibung, Wert, Defaultwert, bereich) VALUES('SAPP_CANCELLATION_RATE', 'Gibt den Namen der Storno-Rate an', 'NOSHOW', 'NOSHOW', 'CSAPP')

IF NOT EXISTS (SELECT * FROM next_pks WHERE Tablename = 'CSAPP_PROTOCOL')
INSERT INTO dbo.next_pks
        ( Tablename, PK )
VALUES  ( 'CSAPP_PROTOCOL', -- Tablename - varchar(30)
          1  -- PK - bigint
          )

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_NEWCUSTOMER_MAIL')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich
        )
VALUES  ( 'SAPP_NEWCUSTOMER_MAIL' , -- Param - varchar(50)
          'E-Mail-Adresse, an die Kundendaten bei Änderungen oder Neuanlage gesendet werden' , -- Beschreibung - varchar(255)
          '' , -- Wert - varchar(255)
          '' , -- Defaultwert - varchar(255)
          'CSAPP'  -- bereich - varchar(255)
        )

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_PRIVACY_URL')
insert into PARAMS (Param, Beschreibung, Wert, bereich)
VALUES('SAPP_PRIVACY_URL', 'Gibt die URL zu den Datenschutzbestimmungen der APP an.', 'https://www.crent.de/datenschutz/', 'CSAPP'),('SAPP_IMPRINT_URL', 'Gibt die URL zu dem Impressum der APP an.', 'https://www.crent.de/impressum.php', 'CSAPP')

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'SAPP_MAIL_DAMAGE')
insert into PARAMS (Param, Beschreibung, Wert, bereich)
values('SAPP_MAIL_DAMAGE', 'Adresse für die Schadenaufnahme', 'f.wedemeier@cx9.de', 'CSAPP')

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'BAPP_POSTIDENT')
INSERT INTO Params (Param, Beschreibung, Wert, Defaultwert, bereich) 
VALUES ('BAPP_POSTIDENT', 'Gibt an ob ein Dienstleister für die kundenvalidierung eingesetzt werden soll', '1', '0', 'CSAPP')

exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.confirm',  -- nvarchar(100)
    @text = N'Bestätigen', -- varchar(255)
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.message.passwordnotequal', -- nvarchar(100)
    @text= N'Falsches Passwort!',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.message.passwordtooshort', -- nvarchar(100)
    @text= N'Passwort muss mindestens 8 Zeichen lang sein!',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.message.pininvalid', -- nvarchar(100)
    @text= N'PIN muss eine vierstellige Ganzzahl sein!',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.pinreset.title', -- nvarchar(100)
    @text= N'',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.passwordreset.title', -- nvarchar(100)
    @text= N'',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.pinresetmail.title', -- nvarchar(100)
    @text= N'Sicherheitscode verifizieren',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.passwordresetmail.title', -- nvarchar(100)
    @text= N'Passwort verifizieren',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.pinresetmail.subject', -- nvarchar(100)
    @text= N'Pin zurücksetzen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.passwordresetmail.subject', -- nvarchar(100)
    @text= N'Passwort zurücksetzen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.pinresetmail.text', -- nvarchar(100)
    @text= N'Sie haben für Ihre Carsharing-App einen neuen Sicherheitscode angefordert.<br />   Um den Prozess abzuschließen, klicken Sie bitte <a>hier</a><br />   Sollten Sie keinen neuen Sicherheitscode angefordert haben, so ignorieren Sie bitte diese E-Mail.<br />',  --varchar(255) @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.passwordresetmail.text', -- nvarchar(100)
    @text= N'Sie haben für Ihre Carsharing-App ein neues Passwort angefordert.<br />   Um den Prozess abzuschließen, klicken Sie bitte <a>hier</a><br />   Sollten Sie kein neues Passwort angefordert haben, so ignorieren Sie bitte diese E-Mail.<br />',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.message.pinnotequal', -- nvarchar(100)
    @text= N'Falsche PIN!',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.message.required', -- nvarchar(100)
    @text= N'Dies ist ein Pflichtfeld',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.password', -- nvarchar(100)
    @text= N'Passwort',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.password.repeat', -- nvarchar(100)
    @text= N'Passwort wiederholen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.password.set', -- nvarchar(100)
    @text= N'Passwort festlegen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.pin', -- nvarchar(100)
    @text= N'PIN',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.pin.repeat', -- nvarchar(100)
    @text= N'PIN wiederholen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.pin.set', -- nvarchar(100)
    @text= N'PIN festlegen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.titel', -- nvarchar(100)
    @text= N'Passwort und PIN Verifizierung',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.registrationmail.subject', -- nvarchar(100)
    @text= N'Registrierung bei C-Share!',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.registrationmail.regards', -- nvarchar(100)
    @text= N'<br />Grüße,<br />Ihr C-Share-Team',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.registrationmail.sender', -- nvarchar(100)
    @text= N'Ihr C-Share - Team',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.registrationmail.salutation', -- nvarchar(100)
    @text= N'Sehr geehrte/r',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.registrationmail.text', -- nvarchar(100)
    @text= N'<br />Herzlich Willkommen bei C-Share.<br />  Bitte klicken Sie <a>hier</a>, um Ihre Registrierung abzuschließen.<br />  Ihr Authentifizierungscode/Betreibercode für den Login lautet: <br /><br />  <br />Wir wünschen Ihnen viel Spaß.<br /><br />',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.register.finished', -- nvarchar(100)
    @text= N'Password und Sicherheitscode Verifizierung abgeschlossen',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit
     exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.protocol.subject', -- nvarchar(100)
    @text= N'Protokoll C-Cheq',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit

    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.protocol.salutation', -- nvarchar(100)
    @text= N'Sehr geehrte Damen und Herren, <br />',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit

    exec dbo.LANG_ADD_COMPONENT 
    @comp = 'cshare.protocol.text', -- nvarchar(100)
    @text= N'Unter dem Link finden Sie das angeforderte Protokoll: <br /><a></a><br /><br />Dies ist eine automatisch generierte E-Mail. Bitte antworten Sie daher nicht darauf.<br /><br />',  --varchar(255) 
    @lang = 'DE', -- varchar(3)
    @update = NULL -- bit

    if NOT EXISTS (SELECT TOP 1 * FROM CSAPP_API_UPDATE)
    insert into CSAPP_API_UPDATE (LAST_UPDATE) VALUES ('1970-01-01 00:00:00')

IF NOT EXISTS (SELECT * FROM FARBEN WHERE CODE = 'CCOCI_CHECKED_COLOR')
insert into FARBEN (CODE, Beschreibung, Color)
VALUES('CCOCI_CHECKED_COLOR', '', 5094851)

IF NOT EXISTS (SELECT * FROM FARBEN WHERE CODE = 'CCOCI_UNCHECKED_COLOR')
insert into FARBEN (CODE, Beschreibung, Color)
VALUES('CCOCI_UNCHECKED_COLOR', '', 3618615)


IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_CAMERA_VIEWS)
BEGIN

  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (5, N'Interieur', N'INSIDE', N'ICON_Insideview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (1, N'Frontansicht', N'OUTSIDE', N'ICON_Frontview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (2, N'Seitenansicht (L)', N'OUTSIDE', N'ICON_leftview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (3, N'Heckansicht', N'OUTSIDE', N'ICON_Backview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (4, N'Seitenansicht (R)', N'OUTSIDE', N'ICON_rightview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (10, N'Interieur', N'OVERVIEW', N'ICON_Insideview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (6, N'Frontansicht', N'OVERVIEW', N'ICON_Frontview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (7, N'Seitenansicht (L)', N'OVERVIEW', N'ICON_leftview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (8, N'Heckansicht', N'OVERVIEW', N'ICON_Backview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (9, N'Seitenansicht (R)', N'OVERVIEW', N'ICON_rightview', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (11, N'Fahrzeug mit Umgebung', N'DAMAGE', N'', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (12, N'Beschädigtes Bauteil (2m)', N'DAMAGE', N'', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (13, N'Schaden', N'DAMAGE', N'', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (14, N'Schaden', N'DAMAGE', N'', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (15, N'Schaden', N'DAMAGE', N'', NULL)
  
  INSERT [dbo].[CSAPP_CAMERA_VIEWS] ([PK], [TEXT], [VIEWTYPE], [IMAGES], [MARKABLE]) VALUES (16, N'Schaden', N'DAMAGE', N'', NULL)

END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_INVENTORY)
BEGIN
  SET IDENTITY_INSERT [dbo].[CSAPP_INVENTORY] ON 

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (87, 0, NULL, N'1', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (88, 0, NULL, N'1', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (89, 0, NULL, N'1', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (90, 0, NULL, N'1', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (91, 0, NULL, N'1', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (92, 0, NULL, N'1', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (93, 0, NULL, N'1', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (94, 0, NULL, N'1', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (95, 0, NULL, N'3', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (96, 0, NULL, N'3', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (97, 0, NULL, N'3', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (98, 0, NULL, N'3', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (99, 0, NULL, N'3', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (100, 0, NULL, N'3', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (101, 0, NULL, N'3', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (102, 0, NULL, N'3', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (103, 0, NULL, N'5', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (104, 0, NULL, N'5', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (105, 0, NULL, N'5', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (106, 0, NULL, N'5', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (107, 0, NULL, N'5', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (108, 0, NULL, N'5', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (109, 0, NULL, N'5', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (110, 0, NULL, N'5', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (111, 0, NULL, N'2', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (112, 0, NULL, N'2', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (113, 0, NULL, N'2', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (114, 0, NULL, N'2', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (115, 0, NULL, N'2', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (116, 0, NULL, N'2', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (117, 0, NULL, N'2', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (118, 0, NULL, N'2', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (119, 0, NULL, N'2', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (120, 0, NULL, N'4', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (121, 0, NULL, N'4', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (122, 0, NULL, N'4', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (123, 0, NULL, N'4', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (124, 0, NULL, N'4', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (125, 0, NULL, N'4', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (126, 0, NULL, N'4', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (127, 0, NULL, N'4', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (128, 0, NULL, N'4', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (129, 0, NULL, N'6', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (130, 0, NULL, N'6', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (131, 0, NULL, N'6', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (132, 0, NULL, N'6', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (133, 0, NULL, N'6', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (134, 0, NULL, N'6', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (135, 0, NULL, N'6', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (136, 0, NULL, N'6', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (137, 0, NULL, N'6', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (138, 0, NULL, N'7', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (139, 0, NULL, N'7', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (140, 0, NULL, N'7', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (141, 0, NULL, N'7', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (142, 0, NULL, N'7', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (143, 0, NULL, N'7', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (144, 0, NULL, N'7', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (145, 0, NULL, N'7', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (146, 0, NULL, N'13', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (147, 0, NULL, N'13', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (148, 0, NULL, N'13', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (149, 0, NULL, N'13', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (150, 0, NULL, N'13', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (151, 0, NULL, N'13', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (152, 0, NULL, N'13', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (153, 0, NULL, N'13', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (154, 0, NULL, N'13', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (155, 0, NULL, N'8', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (156, 0, NULL, N'8', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (157, 0, NULL, N'8', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (158, 0, NULL, N'8', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (159, 0, NULL, N'8', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (160, 0, NULL, N'8', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (161, 0, NULL, N'8', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (162, 0, NULL, N'8', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (163, 0, NULL, N'8', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (164, 0, NULL, N'9', 0, 1, N'Schlüssel')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (165, 0, NULL, N'9', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (166, 0, NULL, N'9', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (167, 0, NULL, N'9', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (168, 0, NULL, N'9', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (169, 0, NULL, N'9', 0, 8, N'COC-Papiere')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (170, 0, NULL, N'9', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (171, 0, NULL, N'9', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (172, 0, NULL, N'9', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (173, 0, NULL, N'9', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (174, 0, NULL, N'9', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (175, 0, NULL, N'9', 0, 14, N'Schlüssel Standheizung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (176, 0, NULL, N'9', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (177, 0, NULL, N'10', 0, 1, N'Schlüssel')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (178, 0, NULL, N'10', 0, 2, N'Zubehörtüte')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (179, 0, NULL, N'10', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (180, 0, NULL, N'10', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (181, 0, NULL, N'10', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (182, 0, NULL, N'10', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (183, 0, NULL, N'10', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (184, 0, NULL, N'10', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (185, 0, NULL, N'10', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (186, 0, NULL, N'10', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (187, 0, NULL, N'10', 0, 14, N'Schlüssel Standheizung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (188, 0, NULL, N'10', 0, 15, N'Transportsicherung aktiv')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (189, 0, NULL, N'10', 0, 16, N'Parfümpacket')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (190, 0, NULL, N'10', 0, 17, N'Fussmatten')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (191, 0, NULL, N'10', 0, 18, N'Gepäcknetz')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (192, 0, NULL, N'10', 0, 19, N'Multimediazubehör')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (193, 0, NULL, N'10', 0, 21, N'Bestätigung Ablieferungskontrolle vorhanden')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (194, 0, NULL, N'10', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (195, 0, NULL, N'14', 0, 1, N'Schlüssel')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (196, 0, NULL, N'14', 0, 2, N'Zubehörtüte')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (197, 0, NULL, N'14', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (198, 0, NULL, N'14', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (199, 0, NULL, N'14', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (200, 0, NULL, N'14', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (201, 0, NULL, N'14', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (202, 0, NULL, N'14', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (203, 0, NULL, N'14', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (204, 0, NULL, N'14', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (205, 0, NULL, N'14', 0, 14, N'Schlüssel Standheizung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (206, 0, NULL, N'14', 0, 15, N'Transportsicherung aktiv')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (207, 0, NULL, N'14', 0, 16, N'Parfümpacket')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (208, 0, NULL, N'14', 0, 17, N'Fussmatten')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (209, 0, NULL, N'14', 0, 18, N'Gepäcknetz')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (210, 0, NULL, N'14', 0, 19, N'Multimediazubehör')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (211, 0, NULL, N'14', 0, 21, N'Bestätigung Ablieferungskontrolle vorhanden')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (212, 0, NULL, N'14', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (213, 0, NULL, N'15', 0, 1, N'Schlüssel')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (214, 0, NULL, N'15', 0, 2, N'Zubehörtüte')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (215, 0, NULL, N'15', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (216, 0, NULL, N'15', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (217, 0, NULL, N'15', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (218, 0, NULL, N'15', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (219, 0, NULL, N'15', 0, 9, N'Räder / Reifen (2-Satz)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (220, 0, NULL, N'15', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (221, 0, NULL, N'15', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (222, 0, NULL, N'15', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (223, 0, NULL, N'15', 0, 14, N'Schlüssel Standheizung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (224, 0, NULL, N'15', 0, 15, N'Transportsicherung aktiv')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (225, 0, NULL, N'15', 0, 16, N'Parfümpacket')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (226, 0, NULL, N'15', 0, 17, N'Fussmatten')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (227, 0, NULL, N'15', 0, 18, N'Gepäcknetz')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (228, 0, NULL, N'15', 0, 19, N'Multimediazubehör')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (229, 0, NULL, N'15', 0, 21, N'Bestätigung Ablieferungskontrolle vorhanden')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (230, 0, NULL, N'15', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (231, 0, NULL, N'17', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (232, 0, NULL, N'17', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (233, 0, NULL, N'17', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (234, 0, NULL, N'17', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (235, 0, NULL, N'17', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (236, 0, NULL, N'17', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (237, 0, NULL, N'17', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (238, 0, NULL, N'17', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (239, 0, NULL, N'17', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (240, 0, NULL, N'12', 0, 1, N'Schlüssel')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (241, 0, NULL, N'12', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (242, 0, NULL, N'12', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (243, 0, NULL, N'12', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (244, 0, NULL, N'12', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (245, 0, NULL, N'12', 0, 8, N'COC-Papiere')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (246, 0, NULL, N'12', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (247, 0, NULL, N'12', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (248, 0, NULL, N'12', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (249, 0, NULL, N'12', 0, 13, N'Fundsachen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (250, 0, NULL, N'12', 0, 14, N'Schlüssel Standheizung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (251, 0, NULL, N'12', 0, 22, N'Weiteres Zubehör (Freitext)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (252, 0, NULL, N'16', 0, 2, N'Zubehörtüte')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (253, 0, NULL, N'16', 0, 3, N'Sicherheitspaket vollständig')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (254, 0, NULL, N'16', 0, 4, N'Fahrzeugdokumente')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (255, 0, NULL, N'16', 0, 5, N'Navigation')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (256, 0, NULL, N'16', 0, 6, N'Gepäckraumabdeckung')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (257, 0, NULL, N'16', 0, 10, N'Ladekabel + Tasche(Haushalt)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (258, 0, NULL, N'16', 0, 11, N'Ladekabel + Tasche(E-Stadion)')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (259, 0, NULL, N'16', 0, 12, N'Windschott')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (260, 0, NULL, N'16', 0, 20, N'Sommer- / Winter- / Ganzjahresreifen')

  INSERT [dbo].[CSAPP_INVENTORY] ([PK], [PK_INVENTORY], [GROUP], [TYPE], [MANDATORY], [SORT], [DESCRIPTION]) VALUES (261, 0, NULL, N'16', 0, 22, N'Weiteres Zubehör (Freitext)')

  SET IDENTITY_INSERT [dbo].[CSAPP_INVENTORY] OFF
END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_PROTOCOL_GROUPS)
BEGIN
  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] ON 

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] ([PK], [name]) VALUES (1, N'MV')

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] ([PK], [name]) VALUES (2, N'SERVICE')

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] ([PK], [name]) VALUES (3, N'AUTO')

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] ([PK], [name]) VALUES (4, N'LOGISTIK')

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_GROUPS] OFF
END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_PROTOCOL_GROUPS_REL_TYPES)
BEGIN
  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ON 

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (1, 1, 19)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (1, 2, 20)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 3, 21)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 4, 22)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 5, 23)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 6, 24)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (2, 7, 25)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (2, 13, 26)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 8, 27)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 9, 28)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 10, 29)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 11, 30)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 12, 31)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 1, 32)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 2, 33)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (4, 17, 34)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 7, 35)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 13, 36)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 14, 37)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 15, 38)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 16, 39)

  INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] ([group], [type], [PK]) VALUES (3, 17, 40)

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_GROUPS_REL_TYPES] OFF

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] ON 

  INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] ([PK], [name]) VALUES (1, N'Kunde verweigert Unterschrift')

  INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] ([PK], [name]) VALUES (2, N'Nachteinwurf')

  INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] ([PK], [name]) VALUES (3, N'Wurde beim Unfall ein Polizeibericht abgegeben?')

  INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] ([PK], [name]) VALUES (4, N'Wurde beim Unfall der Unfallbericht eingefordert?')

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_OPTIONS] OFF
END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_PROTOCOL_TYPES)
BEGIN
  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ON 

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail], [saveDamageReport]) VALUES (1, N'Mietfahrzeug Übergabe', NULL, 0)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail], [saveDamageReport]) VALUES (2, N'Mietfahrzeug Rücknahme', NULL, 1)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (3, N'Probefahrt Übergabe', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (4, N'Probefahrt Rücknahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (5, N'Dienstwagen Übergabe', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (6, N'Dienstwagen Rücknahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (7, N'Kundenfahrzeuge Annahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (8, N'Leasingfahrzeug Übergabe', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (9, N'Leasingfahrzeug Rücknahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (10, N'Neuwagen Annahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (12, N'Gebrauchtwagen Inzahlungnahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (13, N'Kundenfahrzeuge Annahme (Hol & Bring)', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (14, N'Vorführwagen Annahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (15, N'Lagerwagen Annahme', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (16, N'Infleet / Defleet', NULL)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES] ([PK], [name], [mail]) VALUES (17, N'Logistikübergabe', NULL)

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_TYPES] OFF
END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_PROTOCOL_TYPES_REL_OPTIONS)
BEGIN
  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ON 

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 1, 1)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 2, 2)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 3, 3)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 4, 4)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 5, 5)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 6, 6)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 7, 7)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 8, 8)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 9, 9)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 10, 10)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 11, 11)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 12, 12)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (1, 13, 13)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 1, 14)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 2, 15)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 3, 16)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 4, 17)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 5, 18)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 6, 19)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 7, 20)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 8, 21)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 9, 22)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 10, 23)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 11, 24)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 12, 25)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (2, 13, 26)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 1, 27)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 2, 28)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 3, 29)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 4, 30)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 5, 31)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 6, 32)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 7, 33)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 8, 34)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 9, 35)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 10, 36)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 11, 37)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 12, 38)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (3, 13, 39)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 1, 40)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 2, 41)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 3, 42)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 4, 43)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 5, 44)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 6, 45)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 7, 46)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 8, 47)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 9, 48)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 10, 49)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 11, 50)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 12, 51)

  INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] ([option], [type], [PK]) VALUES (4, 13, 52)

  SET IDENTITY_INSERT [dbo].[CSAPP_PROTOCOL_TYPES_REL_OPTIONS] OFF
END

IF NOT EXISTS (SELECT * FROM Params WHERE PARAM = 'IAPP_MAX_RESULTS')
INSERT INTO dbo.PARAMS
        ( Param ,
          Beschreibung ,
          Wert ,
          Defaultwert ,
          bereich 
        )
VALUES  ( 'IAPP_MAX_RESULTS' , -- Param - varchar(50)
          'Gibt die menge der vom Webservice abzufragenen Elemente an' , -- Beschreibung - varchar(255)
          '20' , -- Wert - varchar(255)
          '0' , -- Defaultwert - varchar(255)
          'CSAPP'
        )


IF NOT EXISTS (SELECT TOP 1 * FROM csapp_damagetypes)
BEGIN
  SET IDENTITY_INSERT [dbo].[csapp_damagetypes] ON 

INSERT [dbo].[csapp_damagetypes] ([PK], [Name]) VALUES (1, N'Beule')

INSERT [dbo].[csapp_damagetypes] ([PK], [Name]) VALUES (2, N'Delle')

INSERT [dbo].[csapp_damagetypes] ([PK], [Name]) VALUES (3, N'Kratzer')

INSERT [dbo].[csapp_damagetypes] ([PK], [Name]) VALUES (4, N'Unfall')

INSERT [dbo].[csapp_damagetypes] ([PK], [Name]) VALUES (5, N'Starke Verschmutzung')

SET IDENTITY_INSERT [dbo].[csapp_damagetypes] OFF

END

IF NOT EXISTS (SELECT TOP 1 * FROM CSAPP_PROTOCOL_TYPES_REL_MAIL)
BEGIN

insert into CSAPP_PROTOCOL_TYPES_REL_MAIL SELECT PK, (SELECT EMail from MAND_GLOBAL) FROM CSAPP_PROTOCOL_TYPES

END