CREATE TABLE `lpStore` (
  `corporationID` int(10) NOT NULL,
  `offerID` int(10) NOT NULL,
  PRIMARY KEY (`corporationID`,`offerID`),
  KEY `offerID` (`offerID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `lpOffer` (
  `offerID` int(11) NOT NULL AUTO_INCREMENT,
  `typeID` int(10) NOT NULL,
  `quantity` int(10) NOT NULL,
  `lpCost` int(10) NOT NULL,
  `iskCost` int(10) NOT NULL,
  PRIMARY KEY (`offerID`),
  KEY `typeID` (`typeID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

CREATE TABLE `lpOfferRequiredItem` (
  `offerID` int(11) NOT NULL,
  `typeID` int(10) NOT NULL,
  `quantity` int(10) NOT NULL,
  PRIMARY KEY (`offerID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;