====== Analyse indexes ======

===== Things to take note of =====

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

===== Without Primary Key =====

<code sql>
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`);
</code>

===== With Primary Key =====

<code sql>
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`);
</code>