Indexes (Again)

[Tugatech]

Trying to install on version 2.0 on Windows XP. Indexes are not created, although the db user has has all permissions. I have checked the php install files and can't find the sql cmds for creating the indexes (so i can create them manualy). It's a little strange as version 1.5 installed ok. Any suggestions, or the location of the sql commands file for creating the indexes.

[jlz78]

here are the instructions for creating indexes :

a
modules\Calls\Call.php(221): $this->create_index("create index idx_call_name on calls (name)");
modules\Calls\Call.php(222): $this->create_index("create index idx_usr_call_call on $this->rel_users_table (call_id)");
modules\Calls\Call.php(223): $this->create_index("create index idx_usr_call_usr on $this->rel_users_table (user_id)");
modules\Calls\Call.php(224): $this->create_index("create index idx_con_call_call on $this->rel_contacts_table (call_id)");
modules\Calls\Call.php(225): $this->create_index("create index idx_con_call_con on $this->rel_contacts_table (contact_id)");
modules\Cases\Case.php(193): $this->create_index("create index idx_case_name on cases (name)");
modules\Cases\Case.php(194): $this->create_index("create index idx_con_case_con on contacts_cases (contact_id)");
modules\Cases\Case.php(195): $this->create_index("create index idx_con_case_case on contacts_cases (case_id)");
modules\Contacts\Contact.php(305): $this->create_index("create index idx_cont_last_first on contacts (last_name, first_name, deleted)");
modules\Contacts\Contact.php(306): $this->create_index("create index idx_acc_cont_acc on accounts_contacts (account_id)");
modules\Contacts\Contact.php(307): $this->create_index("create index idx_acc_cont_cont on accounts_contacts (contact_id)");
modules\Currencies\Currency.php(116): $this->create_index("create index idx_cont_name on ".$this->table_name." ( name, deleted)");
modules\Emails\Email.php(242): $this->create_index("create index idx_email_name on emails (name)");
modules\Emails\Email.php(243): $this->create_index("create index idx_usr_email_email on $this->rel_users_table (email_id)");
modules\Emails\Email.php(244): $this->create_index("create index idx_usr_email_usr on $this->rel_users_table (user_id)");
modules\Emails\Email.php(245): $this->create_index("create index idx_con_email_email on $this->rel_contacts_table (email_id)");
modules\Emails\Email.php(246): $this->create_index("create index idx_con_email_con on $this->rel_contacts_table (contact_id)");
modules\Emails\Email.php(248): $this->create_index("create index idx_acc_email_email on $this->rel_accounts_table (email_id)");
modules\Emails\Email.php(249): $this->create_index("create index idx_acc_email_acc on $this->rel_accounts_table (account_id)");
modules\Emails\Email.php(251): $this->create_index("create index idx_case_email_email on $this->rel_cases_table (email_id)");
modules\Emails\Email.php(252): $this->create_index("create index idx_case_email_case on $this->rel_cases_table (case_id)");
modules\Emails\Email.php(253): $this->create_index("create index idx_opp_email_email on $this->rel_opportunities_table (email_id)");
modules\Emails\Email.php(254): $this->create_index("create index idx_opp_email_opp on $this->rel_opportunities_table(opportunity_id)");
modules\Import\ImportMap.php(101): $this->create_index("create index idx_cont_owner_id_module_and_name on ".$this->table_name." (assigned_user_id, module, name, deleted)");
modules\Import\SugarFile.php(89): $this->create_index("create index idx_cont_owner_id_and_name on files (assigned_user_id, name, deleted)");
modules\Import\UsersLastImport.php(88): $this->create_index("create index idx_user_id on ".$this->table_name." (assigned_user_id)");
modules\Leads\Lead.php(308): $this->create_index("create index idx_lead_last_first on leads (last_name, first_name, deleted)");
modules\Meetings\Meeting.php(211): $this->create_index("create index idx_mtg_name on meetings (name)");
modules\Meetings\Meeting.php(212): $this->create_index("create index idx_usr_mtg_mtg on $this->rel_users_table (meeting_id)");
modules\Meetings\Meeting.php(213): $this->create_index("create index idx_usr_mtg_usr on $this->rel_users_table (user_id)");
modules\Meetings\Meeting.php(214): $this->create_index("create index idx_con_mtg_mtg on $this->rel_contacts_table (meeting_id)");
modules\Meetings\Meeting.php(215): $this->create_index("create index idx_con_mtg_con on $this->rel_contacts_table (contact_id)");
modules\Notes\Note.php(144): $this->create_index("create index idx_note_name on notes (name)");
modules\Opportunities\Opportunity.php(220): $this->create_index("create index idx_opp_name on opportunities (name)");
modules\Opportunities\Opportunity.php(221): $this->create_index("create index idx_acc_opp_acc on $this->rel_account_table (account_id)");
modules\Opportunities\Opportunity.php(222): $this->create_index("create index idx_acc_opp_opp on $this->rel_account_table (opportunity_id)");
modules\Opportunities\Opportunity.php(223): $this->create_index("create index idx_con_opp_con on $this->rel_contact_table (contact_id)");
modules\Opportunities\Opportunity.php(224): $this->create_index("create index idx_con_opp_opp on $this->rel_contact_table (opportunity_id)");
modules\Tasks\Task.php(181): $this->create_index("create index idx_tsk_name on tasks (name)");

hope this help