Jeff, As I mentioned in my last email, 59 tables *by default*, so just after a fresh installation of OTRS v2.2.2 without any packages.
My current pre-production OTRS is using 79 tables and some add-on packages are installed : Survey / FAQ / Webmail ...) : mysql> show tables; +------------------------------+ | Tables_in_otrs | +------------------------------+ | RENAMED_customer_company | | RENAMED_customer_user | | article | | article_attachment | | article_flag | | article_plain | | article_sender_type | | article_type | | auto_response | | auto_response_type | | bench_test | | calendar_event | | calendar_event_involved | | customer_preferences | | faq_attachment | | faq_category | | faq_category_group | | faq_history | | faq_item | | faq_language | | faq_state | | faq_state_type | | faq_voting | | follow_up_possible | | generic_agent_jobs | | group_customer_user | | group_role | | group_user | | groups | | notifications | | object_link | | package_repository | | personal_queues | | pop3_account | | postmaster_filter | | process_id | | queue | | queue_auto_response | | queue_standard_response | | role_user | | roles | | salutation | | search_profile | | service | | service_customer_user | | sessions | | signature | | sla | | standard_attachment | | standard_response | | standard_response_attachment | | survey | | survey_answer | | survey_question | | survey_request | | survey_vote | | system_address | | system_user | | theme | | ticket | | ticket_history | | ticket_history_type | | ticket_index | | ticket_lock_index | | ticket_lock_type | | ticket_loop_protection | | ticket_priority | | ticket_state | | ticket_state_type | | ticket_type | | ticket_watcher | | time_accounting | | user_preferences | | valid | | web_upload_cache | | webwatcher_job | | webwatcher_job_archive | | webwatcher_job_schedule | | xml_storage | +------------------------------+ 79 rows in set (0.01 sec) BR, Laurent Minost Le jeudi 30 août 2007 à 08:20 -0700, Jeff Shepherd a écrit : > Hi Laurent, > 59 tables? Are you sure? I'm showing 77 in my database. Are there > ones created depending on features/setup options? Such as the > additional items you can install? > > -Jeff > > Laurent Minost wrote: > > Hi, > > > > Hard to say, it depends on your OTRS version I think and also > > additional packages installed. > > > > It seems that with OTRS v2.2.2, 59 tables by default. > > > > BR, > > > > Laurent Minost > > > > > > Le jeudi 30 août 2007 à 07:33 -0700, Jeff Shepherd a écrit : > >> Hello, > >> I was wondering how many tables OTRS v2.2.2 should have for the MySQL > >> database. I'm having a few MySQL problems and I just want to make sure > >> that I'm not missing any tables. > >> > >> Thanks! > >> > >> -Jeff > >> > >> _______________________________________________ > >> OTRS mailing list: otrs - Webpage: http://otrs.org/ > >> Archive: http://lists.otrs.org/pipermail/otrs > >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > >> Support or consulting for your OTRS system? > >> => http://www.otrs.com/ > >> > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > OTRS mailing list: otrs - Webpage: http://otrs.org/ > > Archive: http://lists.otrs.org/pipermail/otrs > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > Support or consulting for your OTRS system? > > => http://www.otrs.com/ > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > => http://www.otrs.com/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
