1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `APSLicenseTypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `application_name` varchar(122) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `application_versions` varchar(122) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `application_features` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `license_type_hash` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `license_type_hash` (`license_type_hash`),
  UNIQUE KEY `application_name` (`application_name`,`application_versions`,`application_features`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `APSLicenseTypes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `application_name` varchar(122) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `application_versions` varchar(122) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `application_features` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `license_type_hash` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `license_type_hash` (`license_type_hash`), UNIQUE KEY `application_name` (`application_name`,`application_versions`,`application_features`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1