Work in progress !

OpenCart v 1.5.1

// Memo

ALTER TABLE `opencart_order` ADD `loyalty` INT NOT NULL AFTER `reward`;

// admin
INSERT INTO `opencart_setting` VALUES(21074, 0, 'loyalty_config', 'loyalty_gain', '10', 0);
INSERT INTO `opencart_setting` VALUES(21073, 0, 'loyalty_config', 'loyalty_threshold', '20', 0);
INSERT INTO `opencart_setting` VALUES(21072, 0, 'loyalty_config', 'loyalty_rate', '10', 0);
INSERT INTO `opencart_setting` VALUES(21081, 0, 'loyalty_config', 'loyalty_voucherid', '9', 0);
INSERT INTO `opencart_setting` VALUES(21545, 0, 'loyalty_config', 'loyalty_order_status', '5', 0);
INSERT INTO `opencart_setting` VALUES(21546, 0, 'loyalty_config', 'loyalty_from_name', 'from name', 0);
INSERT INTO `opencart_setting` VALUES(21547, 0, 'loyalty_config', 'loyalty_from_email', 'from@email.tld', 0);
INSERT INTO `opencart_setting` VALUES(21548, 0, 'loyalty_config', 'loyalty_voucher_message', 'voucher message', 0);

CREATE TABLE IF NOT EXISTS `opencart_loyalty` (
  `loyalty_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `loyalty_points` int(11) NOT NULL,
  PRIMARY KEY (`loyalty_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

// ToDo

 - english translation