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;