1
2
3
4
5
6
7
8
9
10

CREATE TABLE `SBSites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `virtualHost_id` int(10) unsigned NOT NULL,
  `sb_site_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `sb_siteowner_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `sb_siteowner_login` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtualHost_id` (`virtualHost_id`),
  UNIQUE KEY `sb_site_id` (`sb_site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `SBSites` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `virtualHost_id` int(10) unsigned NOT NULL, `sb_site_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `sb_siteowner_id` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `sb_siteowner_login` varchar(255) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `virtualHost_id` (`virtualHost_id`), UNIQUE KEY `sb_site_id` (`sb_site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1