USE `registration`;
CREATE TABLE `blocklist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `product_code` varchar(10) NOT NULL DEFAULT '',
  `license_key` varchar(64) NOT NULL DEFAULT '',
  `reason` varchar(100) DEFAULT NULL,
  `reason_note` varchar(400) DEFAULT NULL,
  `is_test` tinyint(1) NOT NULL DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
