1
2
3
4
5
6
7
8

CREATE TABLE `secret_keys` (
  `key_id` varchar(255) CHARACTER SET ascii NOT NULL,
  `ip_address` varchar(39) CHARACTER SET ascii NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 NOT NULL,
  `client_id` int(10) unsigned NOT NULL DEFAULT '1',
  KEY `key_id` (`key_id`),
  KEY `client_id` (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `secret_keys` ( `key_id` varchar(255) CHARACTER SET ascii NOT NULL, `ip_address` varchar(39) CHARACTER SET ascii NOT NULL, `description` varchar(255) CHARACTER SET utf8 NOT NULL, `client_id` int(10) unsigned NOT NULL DEFAULT '1', KEY `key_id` (`key_id`), KEY `client_id` (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1