ALTER TABLE `ma_LicenseTribe` ADD `subscriberId` VARCHAR(255) NULL DEFAULT NULL AFTER `paymentId`; 
ALTER TABLE `ma_LicenseTribe` ADD `subscriberEnabled` ENUM('y','n') NOT NULL DEFAULT 'y' AFTER `subscriberId`; 
ALTER TABLE `ma_LicenseTribe` ADD `lastReminder` DATE NULL DEFAULT NULL AFTER `subscriberEnabled`; 

UPDATE `ma_LicenseTribe` SET `subscriberId` =  MD5(CONCAT(RAND(),UNIX_TIMESTAMP(NOW())));

INSERT INTO `ma_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'LicensePremium\\Unsubscribe\\', 'Unsubscribe Premium Reminder', '1600'); 