1
2
3
4
5
6
7
8
9
10

CREATE TABLE `key_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plesk_key_id` varchar(63) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `update_disabled` enum('false','true') NOT NULL DEFAULT 'false',
  `options` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `key_history` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `plesk_key_id` varchar(63) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `filename` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_disabled` enum('false','true') NOT NULL DEFAULT 'false', `options` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1