CREATE TABLE IF NOT EXISTS `digikey_leds` ( `DATASHEETS` varchar(255) NOT NULL, `IMAGE` varchar(255) NOT NULL, `DIGIKEY_PART_NUMBER` varchar(255) NOT NULL, `MANUFACTURER_PART_NUMBER` varchar(255) NOT NULL, `MANUFACTURER` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) NOT NULL, `QUANTITY_AVAILABLE` int(11) unsigned NOT NULL, `FACTORY_STOCK` int(11) unsigned NOT NULL, `UNIT_PRICE_USD` varchar(11) NOT NULL, `QTY` int(11) unsigned NOT NULL, `MINIMUM_QUANTITY` int(11) unsigned NOT NULL, `PACKAGING` varchar(255) NOT NULL, `SERIES` varchar(255) NOT NULL, `COLOR` varchar(255) NOT NULL, `WAVELENGTH_DOMINANT` varchar(255) NOT NULL, `WAVELENGTH_PEAK` varchar(255) NOT NULL, `MILLICANDELA_RATING` varchar(255) NOT NULL, `VOLTAGE_FORWARD_TYP` varchar(255) NOT NULL, `CURRENT_TEST` varchar(255) NOT NULL, `VIEWING_ANGLE` varchar(255) NOT NULL, `LENS_TYPE` varchar(255) NOT NULL, `LENS_STYLE_SIZE` varchar(255) NOT NULL, `PACKAGE_CASE` varchar(255) NOT NULL, `SIZE_DIMENSION` varchar(255) NOT NULL, `HEIGHT` varchar(255) NOT NULL, `MOUNTING_TYPE` varchar(255) NOT NULL, PRIMARY KEY (`DIGIKEY_PART_NUMBER`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;