USE `registration`;
CREATE TABLE `license_sub_link` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(50) NOT NULL,
  `legacy_license_key` varchar(64) NOT NULL,
  `new_license_key` varchar(100) NOT NULL,
  `legacy_start_date` timestamp NULL DEFAULT NULL,
  `is_test` tinyint(1) DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `reference` (`reference`),
  KEY `legacy_license_key` (`legacy_license_key`),
  KEY `new_license_key` (`new_license_key`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
