CREATE TABLE IF NOT EXISTS `digikey_chip_resistors` (
  `DATASHEETS` varchar(255) DEFAULT NULL,
  `IMAGE` varchar(255) DEFAULT NULL,
  `DIGIKEY_PART_NUMBER` varchar(255) NOT NULL DEFAULT '',
  `MANUFACTURER_PART_NUMBER` varchar(255) DEFAULT NULL,
  `MANUFACTURER` varchar(255) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `QUANTITY_AVAILABLE` int(7) DEFAULT NULL,
  `FACTORY_STOCK` int(1) DEFAULT NULL,
  `UNIT_PRICE_USD` varchar(9) DEFAULT NULL,
  `QTY` int(1) DEFAULT NULL,
  `MINIMUM_QUANTITY` int(5) DEFAULT NULL,
  `PACKAGING` varchar(16) DEFAULT NULL,
  `SERIES` varchar(10) DEFAULT NULL,
  `RESISTANCE_OHMS` varchar(16) DEFAULT NULL,
  `TOLERANCE` varchar(6) DEFAULT NULL,
  `POWER_WATTS` varchar(13) DEFAULT NULL,
  `COMPOSITION` varchar(10) DEFAULT NULL,
  `FEATURES` varchar(1) DEFAULT NULL,
  `TEMPERATURE_COEFFICIENT` varchar(17) DEFAULT NULL,
  `PACKAGE_CASE` varchar(18) DEFAULT NULL,
  `SUPPLIER_DEVICE_PACKAGE` int(3) DEFAULT NULL,
  `SIZE_DIMENSION` varchar(37) DEFAULT NULL,
  `HEIGHT` varchar(15) DEFAULT NULL,
  `NUMBER_OF_TERMINATIONS` int(1) DEFAULT NULL,
  `FAILURE_RATE` varchar(10) DEFAULT NULL,
  UNIQUE KEY `DIGIKEY_PART_NUMBER` (`DIGIKEY_PART_NUMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;