1
2
3
4
5
6
7
8
9
10

CREATE TABLE `SBResellers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int(10) unsigned NOT NULL,
  `sb_client_login` varchar(255) CHARACTER SET utf8 NOT NULL,
  `sb_reseller_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `client_id` (`client_id`),
  UNIQUE KEY `sb_client_login` (`sb_client_login`),
  UNIQUE KEY `sb_reseller_id` (`sb_reseller_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `SBResellers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `client_id` int(10) unsigned NOT NULL, `sb_client_login` varchar(255) CHARACTER SET utf8 NOT NULL, `sb_reseller_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `client_id` (`client_id`), UNIQUE KEY `sb_client_login` (`sb_client_login`), UNIQUE KEY `sb_reseller_id` (`sb_reseller_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1