UPDATE vtiger_field SET uitype = 16, typeofdata = 'V~O' WHERE columnname = 'transaction_type'

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

INSERT INTO `vtiger_transaction_type` (`transaction_typeid`, `transaction_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_transaction_type_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



UPDATE vtiger_field SET uitype = 16, typeofdata = 'V~O' WHERE columnname = 'payments_type'

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

INSERT INTO `vtiger_payments_type` (`payments_typeid`, `payments_type`, `sortorderid`, `presence`, `color`)
VALUES
	(1, 'Adgroup', 0, 1, NULL),
	(2, 'Xpate', 0, 1, NULL),
	(3, 'RoyalPay', 0, 1, NULL),
	(4, 'Payboutique', 0, 1, NULL),
	(5, 'Interkassa', 0, 1, NULL),
	(6, 'Introrix', 0, 1, NULL),
	(7, 'Neteller', 0, 1, NULL),
	(8, 'Skrill', 0, 1, NULL),
	(9, 'Wire Transfer', 0, 1, NULL),
	(10, 'Advcash', 0, 1, NULL),
	(11, 'FX Ownr', 0, 1, NULL),
	(12, 'Flutter Rave', 0, 1, NULL),
	(13, 'Ipay', 0, 1, NULL);

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