INSERT INTO `vtiger_field` (`tabid`, `fieldid`, `columnname`, `tablename`, `generatedtype`, `uitype`, `fieldname`, `fieldlabel`, `readonly`, `presence`, `defaultvalue`, `maximumlength`, `sequence`, `block`, `displaytype`, `typeofdata`, `quickcreate`, `quickcreatesequence`, `info_type`, `masseditable`, `helpinfo`, `summaryfield`, `headerfield`, `isunique`)
VALUES
	(7, 1820, 'last_open_trade', 'vtiger_leaddetails', 2, '5', 'last_open_trade', 'Last open trade', 1, 2, '', 100, 36, 13, 1, 'D~O', 1, 0, 'BAS', 1, '', 0, 0, 0);

ALTER TABLE vtiger_leaddetails ADD COLUMN last_open_trade TEXT

INSERT INTO `vtiger_def_org_field` (`tabid`, `fieldid`, `visible`, `readonly`)
VALUES
	(8, 1820, 0, 0);

INSERT INTO `vtiger_profile2field` (`profileid`, `tabid`, `fieldid`, `visible`, `readonly`)
VALUES
	(1, 8, 1820, 0, 0),
	(6, 8, 1820, 0, 0),
	(7, 8, 1820, 0, 0),
	(9, 8, 1820, 0, 0),
	(10, 8, 1820, 0, 0),
	(11, 8, 1820, 0, 0),
	(12, 8, 1820, 0, 0),
	(13, 8, 1820, 0, 0),
	(14, 8, 1820, 0, 0),
	(15, 8, 1820, 0, 0),
	(16, 8, 1820, 0, 0),
	(17, 8, 1820, 0, 0),
	(18, 8, 1820, 0, 0),
	(19, 8, 1820, 0, 0),
	(20, 8, 1820, 0, 0),
	(21, 8, 1820, 0, 0),
	(24, 8, 1820, 0, 0),
	(25, 8, 1820, 0, 0),
	(26, 8, 1820, 0, 0),
	(27, 8, 1820, 0, 0);