Mentoring Systems database https://wiki.mentoringsystems.be/ 2026-09-07T04:46:23+02:00 Mentoring Systems https://wiki.mentoringsystems.be/ https://wiki.mentoringsystems.be/lib/tpl/starter-bootstrap/images/favicon.ico text/html 2018-04-20T12:42:30+02:00 database:analyse-indexes https://wiki.mentoringsystems.be/database/analyse-indexes?rev=1524220950&do=diff 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 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…