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
	(56, 1821, 'operation_type', 'vtiger_payments', 1, '16', 'operation_type', 'Operation Type', 1, 2, '', 100, 3, 205, 1, 'V~O', 1, 0, 'BAS', 1, '', 0, NULL, 0);

ALTER TABLE vtiger_payments ADD COLUMN operation_type VARCHAR(255)

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

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

CREATE TABLE `vtiger_operation_type` (
  `operation_typeid` int(11) NOT NULL AUTO_INCREMENT,
  `operation_type` varchar(200) NOT NULL,
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`operation_typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `vtiger_operation_type` (`operation_typeid`, `operation_type`, `sortorderid`, `presence`, `color`)
VALUES
	(1, 'Deposit', 0, 1, NULL),
	(2, 'Bonus', 0, 1, NULL),
	(3, 'Cash', 0, 1, NULL),
	(4, 'Withdraw', 0, 1, NULL);

CREATE TABLE `vtiger_operation_type_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;