CREATE TABLE IF NOT EXISTS `lpOfferRequirements` (
  `offerID` smallint(4) unsigned NOT NULL,
  `typeID` int(10) NOT NULL,
  `quantity` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`offerID`,`typeID`),
  KEY `typeID` (`typeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lpOffers`
--

CREATE TABLE IF NOT EXISTS `lpOffers` (
  `offerID` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `typeID` int(10) NOT NULL,
  `quantity` smallint(5) unsigned NOT NULL,
  `lpCost` int(10) unsigned NOT NULL,
  `iskCost` int(10) unsigned NOT NULL,
  PRIMARY KEY (`offerID`),
  KEY `typeID` (`typeID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1591 ;

-- --------------------------------------------------------

--
-- Table structure for table `lpStore`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `lpVerified`
--

CREATE TABLE IF NOT EXISTS `lpVerified` (
  `corporationID` int(10) NOT NULL,
  `verification` tinyint(2) NOT NULL,
  `verifiedWith` int(10) DEFAULT NULL,
  PRIMARY KEY (`corporationID`),
  KEY `verification` (`verification`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;