1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE `APSLicenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key_number` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `source` text CHARACTER SET utf8 NOT NULL,
  `ka_url` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `expiration_date` date DEFAULT NULL,
  `update_date` date DEFAULT NULL,
  `license_type_id` int(10) unsigned NOT NULL,
  `personal` enum('false','true') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key_number` (`key_number`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `APSLicenses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `key_number` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `source` text CHARACTER SET utf8 NOT NULL, `ka_url` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `expiration_date` date DEFAULT NULL, `update_date` date DEFAULT NULL, `license_type_id` int(10) unsigned NOT NULL, `personal` enum('false','true') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`), UNIQUE KEY `key_number` (`key_number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1