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
Jeff Shepherd wrote:
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.
I guess any errors would show missing tables. The full database schema is available on the FTP server: ftp://ftp.otrs.org/pub/otrs/misc/ Nils Breunese.
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/
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/
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/
participants (3)
-
Jeff Shepherd -
Laurent Minost -
Nils Breunese (Lemonbit)