version 4.2.0 creating a new table in the database

[simbawoomba]

Hi

I am fairly new to SugarCRM and was wondering if anybody would be able to help me, I am developing a new module for version 4.2.0 and want to be able to add a new table to the database maybe through the manifest.php file when the module installs.

Is there anybody who knows if this is possible and if so how would i go about doing it?? If it is not possible then i would just like to check the database for the table before i access it, and if it isnt there then add it and add some default data, if it is there then i want to read the data into an array,

Also when i finish the module, i am looking to port it to the 4.5.0 version and think this is going to be pretty easy as the module i have built is gonna be completely independant of sugar, apart from i want to import a few contact details, any info on this too would be great.

please get back to me asap as it is quite an urgent project to be completed pretty soon.

thanks.

simbahttp://www.sugarcrm.com/forums/images/icons/icon7.gif
Smile

[kpit]

A good resource for developing modules is to look in the developer wiki. There has been lots of documentation put there by core developers at sugarcrm and the community.

In paticullar there is a section on module development here. Vardefs are what define the database table structure and relationships to other modules. The SugarBean is extended by a module. this bean will act as a go between for you module and the database. the manifest defines the install and creation of tables as well as installing the modules. You might want to check out some of the recorded webinars in the Dev User Groups on SugarForge here.