Analyse indexes

• Primary keys ARE needed, usually our exports have all primary keys, but you'll need to verify this.
• Remove double indexes

ALTER TABLE `Analyse`
  ADD KEY `status` (`status`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Ansprechpartner`
  ADD KEY `gesellschaftId` (`gesellschaftId`);
 
ALTER TABLE `ApplicationState`
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Arbeitgeber`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Asset`
  ADD KEY `angebotsType` (`angebotsType`),
  ADD KEY `tarifTypeId` (`tarifTypeId`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `AssetAttribut`
  ADD KEY `fx_assetattribut_assetId` (`assetId`);
 
ALTER TABLE `Bankverbindung`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Bedarf`
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `BedarfAttribut`
  ADD KEY `bedarfId` (`bedarfId`);
 
ALTER TABLE `Berater`
  ADD KEY `salutationId` (`salutationId`),
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `BeraterAction`
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `BeraterAssistant`
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `assistantId` (`assistantId`);
 
ALTER TABLE `BeraterBeraterRole`
  ADD PRIMARY KEY (`beraterId`,`beraterRoleId`);
 
ALTER TABLE `BeraterHomepage`
  ADD KEY `beraterId` (`beraterId`);
 
ALTER TABLE `BeraterSnippet`
  ADD KEY `beraterId` (`beraterId`);
 
ALTER TABLE `BeraterVorgesetzter`
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `vorgesetzterId` (`vorgesetzterId`);
 
ALTER TABLE `Bestandsuebertragung`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `BestandsuebertragungAsset`
  ADD KEY `bestandsuebertragungId` (`bestandsuebertragungId`),
  ADD KEY `assetId` (`assetId`);
 
ALTER TABLE `CalculationProfile`
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `contextId` (`contextId`),
  ADD KEY `tariftype` (`tariftype`(255));
 
ALTER TABLE `CalculationResults`
  ADD KEY `assetId` (`assetId`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Context`
  ADD KEY `uuid` (`uuid`),
  ADD KEY `parentContextId` (`parentContextId`);
 
ALTER TABLE `ContextAttribut`
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `ContextSubContext`
  ADD KEY `contextId` (`contextId`),
  ADD KEY `parentContextId` (`parentContextId`);
 
ALTER TABLE `Dokument`
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `synchId` (`synchId`);
 
ALTER TABLE `DokumentAttribut`
  ADD KEY `dokumentId` (`dokumentId`);
 
ALTER TABLE `Empfehlung`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ErweiterteBerufsfragen`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `EventLog`
  ADD KEY `loginId` (`loginId`,`sessionId`);
 
ALTER TABLE `EventLogParam`
  ADD KEY `eventLogId` (`eventLogId`);
 
ALTER TABLE `ExternalId`
  ADD KEY `system` (`system`(255)),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `loginId` (`loginId`),
  ADD KEY `mandantGroupId` (`mandantGroupId`),
  ADD KEY `mandantMandantGroupId` (`mandantMandantGroupId`),
  ADD KEY `bankverbindungId` (`bankverbindungId`),
  ADD KEY `externalId` (`externalId`(255));
 
ALTER TABLE `ExternalProductId`
  ADD KEY `efpId` (`efpId`),
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `productId` (`productId`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `File`
  ADD KEY `fk_File_Berater` (`beraterId`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `innolink` (`innolink`(255)),
  ADD KEY `folder` (`folder`),
  ADD KEY `groupId` (`groupId`),
  ADD KEY `purpose` (`purpose`),
  ADD KEY `synchId` (`synchId`);
 
ALTER TABLE `GandavVBeruf`
  ADD KEY `such` (`such`(255));
 
ALTER TABLE `Gesellschaft`
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `GesellschaftTarifTypeId`
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `tarifTypeId` (`tarifTypeId`(255));
 
ALTER TABLE `Handlungsempfehlung`
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `tarifTypeId` (`tarifTypeId`),
  ADD KEY `aktuelAssetId` (`aktuelAssetId`);
 
ALTER TABLE `IhreErwartungen`
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `InnoFilter`
  ADD KEY `gesnr` (`gesnr`),
  ADD KEY `tarifTypeId` (`tarifTypeId`(255)),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `InsignSession`
  ADD KEY `session` (`session`(255));
 
ALTER TABLE `IntegerIdMapping`
  ADD KEY `uuid` (`uuid`);
 
ALTER TABLE `Kontakt`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Kundenbedarf`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Login`
  ADD UNIQUE KEY `login` (`login`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `contextId` (`contextId`),
  ADD KEY `sessionId` (`sessionId`),
  ADD KEY `mobileSessionId` (`mobileSessionId`);
 
ALTER TABLE `LoginAttribut`
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Mandant`
  ADD KEY `userId` (`beraterId`),
  ADD KEY `username` (`username`),
  ADD KEY `mandantSessionId` (`mandantSessionId`);
 
ALTER TABLE `MandantAttribut`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `MandantBerechnung`
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `MandantGroup`
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `MandantMandantGroup`
  ADD KEY `fk_MandantMandantGroup_MandantGroup` (`groupeId`),
  ADD KEY `fk_MandantGruppe_Mandant` (`mandantId`);
 
ALTER TABLE `PlzData`
  ADD KEY `plz` (`plz`),
  ADD KEY `ort` (`ort`(255));
 
ALTER TABLE `ProductId`
  ADD KEY `efpId` (`efpId`),
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `RequestLog`
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `logtype` (`logtype`),
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `Sammelmappe`
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `SeminarAttendance`
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `eventId` (`eventId`);
 
ALTER TABLE `ServerMessage`
  ADD KEY `loginId` (`loginId`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Steuern`
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `UserAnalyse`
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `Verlauf`
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Vorschaeden`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Wiedervorlage`
  ADD KEY `externeReferenz` (`externeReferenz`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ZielWunsch`
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ZielWunschAttribut`
  ADD KEY `zielwunschId` (`zielwunschId`);

ALTER TABLE `Analyse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Ansprechpartner`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gesellschaftId` (`gesellschaftId`);
 
ALTER TABLE `ApplicationState`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Arbeitgeber`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Asset`
  ADD PRIMARY KEY (`id`),
  ADD KEY `angebotsType` (`angebotsType`),
  ADD KEY `tarifTypeId` (`tarifTypeId`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `AssetAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fx_assetattribut_assetId` (`assetId`);
 
ALTER TABLE `AssetAusbildung`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetDreadDisease`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetPrivatrente`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetRiester`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetRisiko`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetRuerup`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `AssetUnfall`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `Bankverbindung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Bedarf`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `BedarfAsset`
  ADD PRIMARY KEY (`bedarfId`,`assetId`);
 
ALTER TABLE `BedarfAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bedarfId` (`bedarfId`);
 
ALTER TABLE `Berater`
  ADD PRIMARY KEY (`id`),
  ADD KEY `salutationId` (`salutationId`),
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `BeraterAction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `BeraterAssistant`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `assistantId` (`assistantId`);
 
ALTER TABLE `BeraterBeraterRole`
  ADD PRIMARY KEY (`beraterId`,`beraterRoleId`);
 
ALTER TABLE `BeraterHomepage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`);
 
ALTER TABLE `BeraterHomepageTeam`
  ADD PRIMARY KEY (`beraterHomepageId`,`beraterId`);
 
ALTER TABLE `BeraterRole`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `BeraterSnippet`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`);
 
ALTER TABLE `BeraterVorgesetzter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `vorgesetzterId` (`vorgesetzterId`);
 
ALTER TABLE `Bestandsuebertragung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `BestandsuebertragungAsset`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bestandsuebertragungId` (`bestandsuebertragungId`),
  ADD KEY `assetId` (`assetId`);
 
ALTER TABLE `CalculationProfile`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `contextId` (`contextId`),
  ADD KEY `tariftype` (`tariftype`(255));
 
ALTER TABLE `CalculationResults`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Context`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uuid` (`uuid`),
  ADD KEY `parentContextId` (`parentContextId`);
 
ALTER TABLE `ContextAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `ContextSubContext`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contextId` (`contextId`),
  ADD KEY `parentContextId` (`parentContextId`);
 
ALTER TABLE `Dokument`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `synchId` (`synchId`);
 
ALTER TABLE `DokumentAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `dokumentId` (`dokumentId`);
 
ALTER TABLE `Empfehlung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ErweiterteBerufsfragen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `EventLog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loginId` (`loginId`,`sessionId`);
 
ALTER TABLE `EventLogParam`
  ADD PRIMARY KEY (`id`),
  ADD KEY `eventLogId` (`eventLogId`);
 
ALTER TABLE `ExpertCondition`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `ExternalGesellschaft`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `ExternalId`
  ADD PRIMARY KEY (`id`),
  ADD KEY `system` (`system`(255)),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `loginId` (`loginId`),
  ADD KEY `mandantGroupId` (`mandantGroupId`),
  ADD KEY `mandantMandantGroupId` (`mandantMandantGroupId`),
  ADD KEY `bankverbindungId` (`bankverbindungId`),
  ADD KEY `externalId` (`externalId`(255));
 
ALTER TABLE `ExternalProductId`
  ADD PRIMARY KEY (`id`),
  ADD KEY `efpId` (`efpId`),
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `productId` (`productId`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `File`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_File_Berater` (`beraterId`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `innolink` (`innolink`(255)),
  ADD KEY `folder` (`folder`),
  ADD KEY `groupId` (`groupId`),
  ADD KEY `purpose` (`purpose`),
  ADD KEY `synchId` (`synchId`);
 
ALTER TABLE `Folder`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `GandavVBeruf`
  ADD PRIMARY KEY (`id`),
  ADD KEY `such` (`such`(255));
 
ALTER TABLE `GandavVBeruf_old`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `Gesellschaft`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `GesellschaftTarifTypeId`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `tarifTypeId` (`tarifTypeId`(255));
 
ALTER TABLE `Handlungsempfehlung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analyseId` (`analyseId`),
  ADD KEY `tarifTypeId` (`tarifTypeId`),
  ADD KEY `aktuelAssetId` (`aktuelAssetId`);
 
ALTER TABLE `IhreErwartungen`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `InnoBeruf`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `InnoFilter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gesnr` (`gesnr`),
  ADD KEY `tarifTypeId` (`tarifTypeId`(255)),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `InsignSession`
  ADD PRIMARY KEY (`id`),
  ADD KEY `session` (`session`(255));
 
ALTER TABLE `IntegerIdMapping`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uuid` (`uuid`);
 
ALTER TABLE `Kontakt`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Kundenbedarf`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Login`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `login` (`login`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `contextId` (`contextId`),
  ADD KEY `sessionId` (`sessionId`),
  ADD KEY `mobileSessionId` (`mobileSessionId`);
 
ALTER TABLE `LoginAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Mandant`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userId` (`beraterId`),
  ADD KEY `username` (`username`),
  ADD KEY `mandantSessionId` (`mandantSessionId`);
 
ALTER TABLE `MandantAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `MandantBerechnung`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `MandantGroup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `MandantMandantGroup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_MandantMandantGroup_MandantGroup` (`groupeId`),
  ADD KEY `fk_MandantGruppe_Mandant` (`mandantId`);
 
ALTER TABLE `PlzData`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plz` (`plz`),
  ADD KEY `ort` (`ort`(255));
 
ALTER TABLE `ProductId`
  ADD PRIMARY KEY (`id`),
  ADD KEY `efpId` (`efpId`),
  ADD KEY `gesellschaftId` (`gesellschaftId`),
  ADD KEY `contextId` (`contextId`);
 
ALTER TABLE `RequestLog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `logtype` (`logtype`),
  ADD KEY `efpId` (`efpId`);
 
ALTER TABLE `Salutation`
  ADD PRIMARY KEY (`id`);
 
ALTER TABLE `Sammelmappe`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `SeminarAttendance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `beraterId` (`beraterId`),
  ADD KEY `eventId` (`eventId`);
 
ALTER TABLE `ServerMessage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loginId` (`loginId`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Steuern`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mandantId` (`mandantId`);
 
ALTER TABLE `UserAnalyse`
  ADD PRIMARY KEY (`userId`,`analyseId`),
  ADD KEY `analyseId` (`analyseId`);
 
ALTER TABLE `Verlauf`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`),
  ADD KEY `loginId` (`loginId`);
 
ALTER TABLE `Vorschaeden`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `Wiedervorlage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `externeReferenz` (`externeReferenz`),
  ADD KEY `assetId` (`assetId`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ZielWunsch`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mandantId` (`mandantId`);
 
ALTER TABLE `ZielWunschAttribut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `zielwunschId` (`zielwunschId`);