Different SugarCRM table name....?

[tamilnandhu]

Hi,

OS : FC5
Sugar : v4.5.1.e
WebServer : Apache v2.2.0
php : v5.1.2
mysql : v5.0.45

I installed the SugarOS successfully and is working now. But I want to use different table names and field names instead of the default ones. So how can I change them..? Either during or before or after the Sugar installation...?

Pls help me in this regard.

[HolmesA]

Typically you can use table prefix to change the table names . But Sugar has no support for table prefixes for now.

Cannot recommend changing field names at all.

[tamilnandhu]

hI,
Thanks for your reply..

Now I have another issue,,

I want to perform some additional actions every time a new user created or modified in SugarCRM. So I want to know which source file contains the "Insert into users values (......); and update users set...........;" SQL command. So that I can add the additional commands below this SQL query.

I searched throughout the source but not able to find it..

So can you please tell me how to find the source file that contains the query...?

I am expecting your reply...

Thanks,

[susiewilliams]

Hi there,


This capability is built into the product (it's the Workflow Management feature), but it's available only in the Professional and Enterprise editions of the product. Business Hooks may be able to do what you describe.

[HolmesA]

Sugar does not have the specific sql query for it. The architecture is much more flexible - sql queries are generated on the fly for simple operatoins. You will need to jump into the base classes in order to do it. Actually this is a task for a developer.