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/