Re: Leftover tables in the OTRS database [5s]
Alvaro Cordero <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <CAKzf-ZPN9DH-mpwc9YeKt-xbpRiize+ad146zFnW3kqKCxBV3A@mail.gmail.com> |
Hello Ralf, those tables are created when you install the faq module, and notifications are handled different now, so on a migrated system you may end up with legacy tables that might not be needed for the current system but may be needed for data integrity. Best Regards. 2017-01-25 6:59 GMT-06:00 Ralf Hildebrandt <[email protected]>: > Today I set-up a new instance of OTRS5 and diffed the tables against > our very old, OTRS 5s installation (which has been migrated many times): > > --- vb-otrs.tables 2017-01-25 13:11:31.470065132 +0100 > +++ otrs.tables 2017-01-25 13:11:39.093883923 +0100 > @@ -16,6 +16,14 @@ > | customer_user | > | dynamic_field | > | dynamic_field_value | > +| faq_attachment | > +| faq_category | > +| faq_history | > +| faq_item | > +| faq_language | > +| faq_state | > +| faq_state_type | > +| faq_voting | > | follow_up_possible | > | generic_agent_jobs | > | gi_debugger_entry | > @@ -35,6 +43,7 @@ > | notification_event | > | notification_event_item | > | notification_event_message | > +| notifications | > | package_repository | > | personal_queues | > | personal_services | > > As you can see, out "old" instance has a few additional tables: > faq_* > and > notifications > > Are these still needed? > > > -- > Ralf Hildebrandt Charite Universitätsmedizin Berlin > [email protected] Campus Benjamin Franklin > http://www.charite.de Hindenburgdamm 30, 12203 Berlin > Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155 > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs -- *Alvaro Cordero RetanaConsultor de Tecnologias* *Tel: 22585757 ext 123* *Email:* [email protected] --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs