Miscellany

CREATE TEMPORARY TABLE offers_temp_02_21 (
  `offerid` int(6) NOT NULL default '0',
  `supply_item_id` int(6) NOT NULL default '0',
  `showable` tinyint(1) NOT NULL default '1',
  `sell_price` decimal(8,2) default NULL,
  `email_price` tinyint(1) NOT NULL default '0',
  `merch_rank` decimal(6,4) NOT NULL default '0.0000',
  `show_button` tinyint(1) NOT NULL default '1',
  `price_display` set('web','email','phone') NOT NULL default 'web,email,phone',
  `allow_purchase_via` set('web','phone') NOT NULL default 'web,phone',
  PRIMARY KEY  (`offerid`,`supply_item_id`),
  KEY `merch_rank` (`merch_rank`),
  KEY `supplier_item_id` (`supply_item_id`),
  CONSTRAINT FOREIGN KEY (`offerid`) REFERENCES `sites` (`offerid`),
  CONSTRAINT FOREIGN KEY (`supply_item_id`) REFERENCES `supply_items` (`supply_item_id`));