Tuesday, March 23, 2010

Add a new contact in vtiger crm

vtiger_contactaddress(insert)-->
INSERT INTO `vtiger_contactaddress` VALUES (210, '', '', '', '', '', '', '', '', '', '', '', '');

vtiger_contactdetails(insert)-->
INSERT INTO `vtiger_contactdetails` VALUES (210, 'CON16', 0, '--None--', 'Jyoti', 'Sahoo', '', '', '', '', '', '', '0', NULL, NULL, NULL, NULL, '', '0', '0', '', '0', '0');

vtiger_contactscf(indert)-->
INSERT INTO `vtiger_contactscf` VALUES (210, '', '');

vtiger_contactsubdetails(insert)-->
INSERT INTO `vtiger_contactsubdetails` VALUES (210, '', '', '', '', NULL, 0, 0, '--None--');

vtiger_crmentity(insert)-->
INSERT INTO `vtiger_crmentity` VALUES (210, 1, 1, 0, 'Contacts', '', '2010-03-23 05:21:53', '2010-03-23 05:21:53', '2010-03-23 05:21:59', NULL, 0, 1, 0);

vtiger_crmentity_seq(update)-->increase id value
INSERT INTO `vtiger_crmentity_seq` VALUES (210);

vtiger_customerdetails(insert)-->
INSERT INTO `vtiger_customerdetails` VALUES (210, '0', '2010-03-23', '2011-03-23');

vtiger_modentity_num(update) -> 4 -> "Contacts"(cur_id) is updated to the required value
INSERT INTO `vtiger_modentity_num` VALUES (4, 'Contacts', 'CON', '1', '17', '1');


not required -->
vtiger_tracker
vtiger_users