DROP TABLE IF EXISTS `vendor_to_site`;

CREATE TABLE `vendor_to_site` (
`vendor_id` INT NOT NULL,
`site_id` TINYINT NOT NULL DEFAULT 0,
PRIMARY KEY (`vendor_id`,`site_id`)
);

CREATE INDEX IF NOT EXISTS `vendor_to_site_site` ON `vendor_to_site` (`site_id`);
