-- MySQL dump 9.11 -- -- Host: nycrm.osotite.com Database: osotite_parts2 -- ------------------------------------------------------ -- Server version 5.0.67-log -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `code` char(2) NOT NULL, `group` varchar(255) default NULL, PRIMARY KEY (`id`), KEY `name` (`name`), KEY `group` (`group`) ) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=utf8; -- -- Dumping data for table `countries` -- INSERT INTO `countries` VALUES (1,'AFGHANISTAN','AF',NULL); INSERT INTO `countries` VALUES (2,'LAND ISLANDS','AX',NULL); INSERT INTO `countries` VALUES (3,'ALBANIA','AL',NULL); INSERT INTO `countries` VALUES (4,'ALGERIA','DZ',NULL); INSERT INTO `countries` VALUES (5,'AMERICAN SAMOA','AS',NULL); INSERT INTO `countries` VALUES (6,'ANDORRA','AD',NULL); INSERT INTO `countries` VALUES (7,'ANGOLA','AO',NULL); INSERT INTO `countries` VALUES (8,'ANGUILLA','AI',NULL); INSERT INTO `countries` VALUES (9,'ANTARCTICA','AQ',NULL); INSERT INTO `countries` VALUES (10,'ANTIGUA AND BARBUDA','AG',NULL); INSERT INTO `countries` VALUES (11,'ARGENTINA','AR',NULL); INSERT INTO `countries` VALUES (12,'ARMENIA','AM',NULL); INSERT INTO `countries` VALUES (13,'ARUBA','AW',NULL); INSERT INTO `countries` VALUES (14,'AUSTRALIA','AU',NULL); INSERT INTO `countries` VALUES (15,'AUSTRIA','AT',NULL); INSERT INTO `countries` VALUES (16,'AZERBAIJAN','AZ',NULL); INSERT INTO `countries` VALUES (17,'BAHAMAS','BS',NULL); INSERT INTO `countries` VALUES (18,'BAHRAIN','BH',NULL); INSERT INTO `countries` VALUES (19,'BANGLADESH','BD',NULL); INSERT INTO `countries` VALUES (20,'BARBADOS','BB',NULL); INSERT INTO `countries` VALUES (21,'BELARUS','BY',NULL); INSERT INTO `countries` VALUES (22,'BELGIUM','BE',NULL); INSERT INTO `countries` VALUES (23,'BELIZE','BZ',NULL); INSERT INTO `countries` VALUES (24,'BENIN','BJ',NULL); INSERT INTO `countries` VALUES (25,'BERMUDA','BM',NULL); INSERT INTO `countries` VALUES (26,'BHUTAN','BT',NULL); INSERT INTO `countries` VALUES (27,'BOLIVIA','BO',NULL); INSERT INTO `countries` VALUES (28,'BOSNIA AND HERZEGOVINA','BA',NULL); INSERT INTO `countries` VALUES (29,'BOTSWANA','BW',NULL); INSERT INTO `countries` VALUES (30,'BOUVET ISLAND','BV',NULL); INSERT INTO `countries` VALUES (31,'BRAZIL','BR',NULL); INSERT INTO `countries` VALUES (32,'BRITISH INDIAN OCEAN TERRITORY','IO',NULL); INSERT INTO `countries` VALUES (33,'BRUNEI DARUSSALAM','BN',NULL); INSERT INTO `countries` VALUES (34,'BULGARIA','BG',NULL); INSERT INTO `countries` VALUES (35,'BURKINA FASO','BF',NULL); INSERT INTO `countries` VALUES (36,'BURUNDI','BI',NULL); INSERT INTO `countries` VALUES (37,'CAMBODIA','KH',NULL); INSERT INTO `countries` VALUES (38,'CAMEROON','CM',NULL); INSERT INTO `countries` VALUES (39,'CANADA','CA',NULL); INSERT INTO `countries` VALUES (40,'CAPE VERDE','CV',NULL); INSERT INTO `countries` VALUES (41,'CAYMAN ISLANDS','KY',NULL); INSERT INTO `countries` VALUES (42,'CENTRAL AFRICAN REPUBLIC','CF',NULL); INSERT INTO `countries` VALUES (43,'CHAD','TD',NULL); INSERT INTO `countries` VALUES (44,'CHILE','CL',NULL); INSERT INTO `countries` VALUES (45,'CHINA','CN',NULL); INSERT INTO `countries` VALUES (46,'CHRISTMAS ISLAND','CX',NULL); INSERT INTO `countries` VALUES (47,'COCOS (KEELING) ISLANDS','CC',NULL); INSERT INTO `countries` VALUES (48,'COLOMBIA','CO',NULL); INSERT INTO `countries` VALUES (49,'COMOROS','KM',NULL); INSERT INTO `countries` VALUES (50,'CONGO','CG',NULL); INSERT INTO `countries` VALUES (51,'CONGO','CD',NULL); INSERT INTO `countries` VALUES (52,'COOK ISLANDS','CK',NULL); INSERT INTO `countries` VALUES (53,'COSTA RICA','CR',NULL); INSERT INTO `countries` VALUES (54,'COTE D\'IVOIRE','CI',NULL); INSERT INTO `countries` VALUES (55,'CROATIA','HR',NULL); INSERT INTO `countries` VALUES (56,'CUBA','CU',NULL); INSERT INTO `countries` VALUES (57,'CYPRUS','CY',NULL); INSERT INTO `countries` VALUES (58,'CZECH REPUBLIC','CZ',NULL); INSERT INTO `countries` VALUES (59,'DENMARK','DK',NULL); INSERT INTO `countries` VALUES (60,'DJIBOUTI','DJ',NULL); INSERT INTO `countries` VALUES (61,'DOMINICA','DM',NULL); INSERT INTO `countries` VALUES (62,'DOMINICAN REPUBLIC','DO',NULL); INSERT INTO `countries` VALUES (63,'ECUADOR','EC',NULL); INSERT INTO `countries` VALUES (64,'EGYPT','EG',NULL); INSERT INTO `countries` VALUES (65,'EL SALVADOR','SV',NULL); INSERT INTO `countries` VALUES (66,'EQUATORIAL GUINEA','GQ',NULL); INSERT INTO `countries` VALUES (67,'ERITREA','ER',NULL); INSERT INTO `countries` VALUES (68,'ESTONIA','EE',NULL); INSERT INTO `countries` VALUES (69,'ETHIOPIA','ET',NULL); INSERT INTO `countries` VALUES (70,'FALKLAND ISLANDS (MALVINAS)','FK',NULL); INSERT INTO `countries` VALUES (71,'FAROE ISLANDS','FO',NULL); INSERT INTO `countries` VALUES (72,'FIJI','FJ',NULL); INSERT INTO `countries` VALUES (73,'FINLAND','FI',NULL); INSERT INTO `countries` VALUES (74,'FRANCE','FR',NULL); INSERT INTO `countries` VALUES (75,'FRENCH GUIANA','GF',NULL); INSERT INTO `countries` VALUES (76,'FRENCH POLYNESIA','PF',NULL); INSERT INTO `countries` VALUES (77,'FRENCH SOUTHERN TERRITORIES','TF',NULL); INSERT INTO `countries` VALUES (78,'GABON','GA',NULL); INSERT INTO `countries` VALUES (79,'GAMBIA','GM',NULL); INSERT INTO `countries` VALUES (80,'GEORGIA','GE',NULL); INSERT INTO `countries` VALUES (81,'GERMANY','DE',NULL); INSERT INTO `countries` VALUES (82,'GHANA','GH',NULL); INSERT INTO `countries` VALUES (83,'GIBRALTAR','GI',NULL); INSERT INTO `countries` VALUES (84,'GREECE','GR',NULL); INSERT INTO `countries` VALUES (85,'GREENLAND','GL',NULL); INSERT INTO `countries` VALUES (86,'GRENADA','GD',NULL); INSERT INTO `countries` VALUES (87,'GUADELOUPE','GP',NULL); INSERT INTO `countries` VALUES (88,'GUAM','GU',NULL); INSERT INTO `countries` VALUES (89,'GUATEMALA','GT',NULL); INSERT INTO `countries` VALUES (90,'GUERNSEY','GG',NULL); INSERT INTO `countries` VALUES (91,'GUINEA','GN',NULL); INSERT INTO `countries` VALUES (92,'GUINEA-BISSAU','GW',NULL); INSERT INTO `countries` VALUES (93,'GUYANA','GY',NULL); INSERT INTO `countries` VALUES (94,'HAITI','HT',NULL); INSERT INTO `countries` VALUES (95,'HEARD ISLAND AND MCDONALD ISLANDS','HM',NULL); INSERT INTO `countries` VALUES (96,'HOLY SEE (VATICAN CITY STATE)','VA',NULL); INSERT INTO `countries` VALUES (97,'HONDURAS','HN',NULL); INSERT INTO `countries` VALUES (98,'HONG KONG','HK',NULL); INSERT INTO `countries` VALUES (99,'HUNGARY','HU',NULL); INSERT INTO `countries` VALUES (100,'ICELAND','IS',NULL); INSERT INTO `countries` VALUES (101,'INDIA','IN',NULL); INSERT INTO `countries` VALUES (102,'INDONESIA','ID',NULL); INSERT INTO `countries` VALUES (103,'IRAN','IR',NULL); INSERT INTO `countries` VALUES (104,'IRAQ','IQ',NULL); INSERT INTO `countries` VALUES (105,'IRELAND','IE',NULL); INSERT INTO `countries` VALUES (106,'ISLE OF MAN','IM',NULL); INSERT INTO `countries` VALUES (107,'ISRAEL','IL',NULL); INSERT INTO `countries` VALUES (108,'ITALY','IT',NULL); INSERT INTO `countries` VALUES (109,'JAMAICA','JM',NULL); INSERT INTO `countries` VALUES (110,'JAPAN','JP',NULL); INSERT INTO `countries` VALUES (111,'JERSEY','JE',NULL); INSERT INTO `countries` VALUES (112,'JORDAN','JO',NULL); INSERT INTO `countries` VALUES (113,'KAZAKHSTAN','KZ',NULL); INSERT INTO `countries` VALUES (114,'KENYA','KE',NULL); INSERT INTO `countries` VALUES (115,'KIRIBATI','KI',NULL); INSERT INTO `countries` VALUES (116,'KOREA','KP',NULL); INSERT INTO `countries` VALUES (117,'KOREA','KR',NULL); INSERT INTO `countries` VALUES (118,'KUWAIT','KW',NULL); INSERT INTO `countries` VALUES (119,'KYRGYZSTAN','KG',NULL); INSERT INTO `countries` VALUES (120,'LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LA',NULL); INSERT INTO `countries` VALUES (121,'LATVIA','LV',NULL); INSERT INTO `countries` VALUES (122,'LEBANON','LB',NULL); INSERT INTO `countries` VALUES (123,'LESOTHO','LS',NULL); INSERT INTO `countries` VALUES (124,'LIBERIA','LR',NULL); INSERT INTO `countries` VALUES (125,'LIBYAN ARAB JAMAHIRIYA','LY',NULL); INSERT INTO `countries` VALUES (126,'LIECHTENSTEIN','LI',NULL); INSERT INTO `countries` VALUES (127,'LITHUANIA','LT',NULL); INSERT INTO `countries` VALUES (128,'LUXEMBOURG','LU',NULL); INSERT INTO `countries` VALUES (129,'MACAO','MO',NULL); INSERT INTO `countries` VALUES (130,'MACEDONIA','MK',NULL); INSERT INTO `countries` VALUES (131,'MADAGASCAR','MG',NULL); INSERT INTO `countries` VALUES (132,'MALAWI','MW',NULL); INSERT INTO `countries` VALUES (133,'MALAYSIA','MY',NULL); INSERT INTO `countries` VALUES (134,'MALDIVES','MV',NULL); INSERT INTO `countries` VALUES (135,'MALI','ML',NULL); INSERT INTO `countries` VALUES (136,'MALTA','MT',NULL); INSERT INTO `countries` VALUES (137,'MARSHALL ISLANDS','MH',NULL); INSERT INTO `countries` VALUES (138,'MARTINIQUE','MQ',NULL); INSERT INTO `countries` VALUES (139,'MAURITANIA','MR',NULL); INSERT INTO `countries` VALUES (140,'MAURITIUS','MU',NULL); INSERT INTO `countries` VALUES (141,'MAYOTTE','YT',NULL); INSERT INTO `countries` VALUES (142,'MEXICO','MX',NULL); INSERT INTO `countries` VALUES (143,'MICRONESIA','FM',NULL); INSERT INTO `countries` VALUES (144,'MOLDOVA','MD',NULL); INSERT INTO `countries` VALUES (145,'MONACO','MC',NULL); INSERT INTO `countries` VALUES (146,'MONGOLIA','MN',NULL); INSERT INTO `countries` VALUES (147,'MONTENEGRO','ME',NULL); INSERT INTO `countries` VALUES (148,'MONTSERRAT','MS',NULL); INSERT INTO `countries` VALUES (149,'MOROCCO','MA',NULL); INSERT INTO `countries` VALUES (150,'MOZAMBIQUE','MZ',NULL); INSERT INTO `countries` VALUES (151,'MYANMAR','MM',NULL); INSERT INTO `countries` VALUES (152,'NAMIBIA','NA',NULL); INSERT INTO `countries` VALUES (153,'NAURU','NR',NULL); INSERT INTO `countries` VALUES (154,'NEPAL','NP',NULL); INSERT INTO `countries` VALUES (155,'NETHERLANDS','NL',NULL); INSERT INTO `countries` VALUES (156,'NETHERLANDS ANTILLES','AN',NULL); INSERT INTO `countries` VALUES (157,'NEW CALEDONIA','NC',NULL); INSERT INTO `countries` VALUES (158,'NEW ZEALAND','NZ',NULL); INSERT INTO `countries` VALUES (159,'NICARAGUA','NI',NULL); INSERT INTO `countries` VALUES (160,'NIGER','NE',NULL); INSERT INTO `countries` VALUES (161,'NIGERIA','NG',NULL); INSERT INTO `countries` VALUES (162,'NIUE','NU',NULL); INSERT INTO `countries` VALUES (163,'NORFOLK ISLAND','NF',NULL); INSERT INTO `countries` VALUES (164,'NORTHERN MARIANA ISLANDS','MP',NULL); INSERT INTO `countries` VALUES (165,'NORWAY','NO',NULL); INSERT INTO `countries` VALUES (166,'OMAN','OM',NULL); INSERT INTO `countries` VALUES (167,'PAKISTAN','PK',NULL); INSERT INTO `countries` VALUES (168,'PALAU','PW',NULL); INSERT INTO `countries` VALUES (169,'PALESTINIAN TERRITORY','PS',NULL); INSERT INTO `countries` VALUES (170,'PANAMA','PA',NULL); INSERT INTO `countries` VALUES (171,'PAPUA NEW GUINEA','PG',NULL); INSERT INTO `countries` VALUES (172,'PARAGUAY','PY',NULL); INSERT INTO `countries` VALUES (173,'PERU','PE',NULL); INSERT INTO `countries` VALUES (174,'PHILIPPINES','PH',NULL); INSERT INTO `countries` VALUES (175,'PITCAIRN','PN',NULL); INSERT INTO `countries` VALUES (176,'POLAND','PL',NULL); INSERT INTO `countries` VALUES (177,'PORTUGAL','PT',NULL); INSERT INTO `countries` VALUES (178,'PUERTO RICO','PR',NULL); INSERT INTO `countries` VALUES (179,'QATAR','QA',NULL); INSERT INTO `countries` VALUES (180,'REUNION','RE',NULL); INSERT INTO `countries` VALUES (181,'ROMANIA','RO',NULL); INSERT INTO `countries` VALUES (182,'RUSSIAN FEDERATION','RU',NULL); INSERT INTO `countries` VALUES (183,'RWANDA','RW',NULL); INSERT INTO `countries` VALUES (184,'SAINT HELENA','SH',NULL); INSERT INTO `countries` VALUES (185,'SAINT KITTS AND NEVIS','KN',NULL); INSERT INTO `countries` VALUES (186,'SAINT LUCIA','LC',NULL); INSERT INTO `countries` VALUES (187,'SAINT PIERRE AND MIQUELON','PM',NULL); INSERT INTO `countries` VALUES (188,'SAINT VINCENT AND THE GRENADINES','VC',NULL); INSERT INTO `countries` VALUES (189,'SAMOA','WS',NULL); INSERT INTO `countries` VALUES (190,'SAN MARINO','SM',NULL); INSERT INTO `countries` VALUES (191,'SAO TOME AND PRINCIPE','ST',NULL); INSERT INTO `countries` VALUES (192,'SAUDI ARABIA','SA',NULL); INSERT INTO `countries` VALUES (193,'SENEGAL','SN',NULL); INSERT INTO `countries` VALUES (194,'SERBIA','RS',NULL); INSERT INTO `countries` VALUES (195,'SEYCHELLES','SC',NULL); INSERT INTO `countries` VALUES (196,'SIERRA LEONE','SL',NULL); INSERT INTO `countries` VALUES (197,'SINGAPORE','SG',NULL); INSERT INTO `countries` VALUES (198,'SLOVAKIA','SK',NULL); INSERT INTO `countries` VALUES (199,'SLOVENIA','SI',NULL); INSERT INTO `countries` VALUES (200,'SOLOMON ISLANDS','SB',NULL); INSERT INTO `countries` VALUES (201,'SOMALIA','SO',NULL); INSERT INTO `countries` VALUES (202,'SOUTH AFRICA','ZA',NULL); INSERT INTO `countries` VALUES (203,'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS',NULL); INSERT INTO `countries` VALUES (204,'SPAIN','ES',NULL); INSERT INTO `countries` VALUES (205,'SRI LANKA','LK',NULL); INSERT INTO `countries` VALUES (206,'SUDAN','SD',NULL); INSERT INTO `countries` VALUES (207,'SURINAME','SR',NULL); INSERT INTO `countries` VALUES (208,'SVALBARD AND JAN MAYEN','SJ',NULL); INSERT INTO `countries` VALUES (209,'SWAZILAND','SZ',NULL); INSERT INTO `countries` VALUES (210,'SWEDEN','SE',NULL); INSERT INTO `countries` VALUES (211,'SWITZERLAND','CH',NULL); INSERT INTO `countries` VALUES (212,'SYRIAN ARAB REPUBLIC','SY',NULL); INSERT INTO `countries` VALUES (213,'TAIWAN','TW',NULL); INSERT INTO `countries` VALUES (214,'TAJIKISTAN','TJ',NULL); INSERT INTO `countries` VALUES (215,'TANZANIA','TZ',NULL); INSERT INTO `countries` VALUES (216,'THAILAND','TH',NULL); INSERT INTO `countries` VALUES (217,'TIMOR-LESTE','TL',NULL); INSERT INTO `countries` VALUES (218,'TOGO','TG',NULL); INSERT INTO `countries` VALUES (219,'TOKELAU','TK',NULL); INSERT INTO `countries` VALUES (220,'TONGA','TO',NULL); INSERT INTO `countries` VALUES (221,'TRINIDAD AND TOBAGO','TT',NULL); INSERT INTO `countries` VALUES (222,'TUNISIA','TN',NULL); INSERT INTO `countries` VALUES (223,'TURKEY','TR',NULL); INSERT INTO `countries` VALUES (224,'TURKMENISTAN','TM',NULL); INSERT INTO `countries` VALUES (225,'TURKS AND CAICOS ISLANDS','TC',NULL); INSERT INTO `countries` VALUES (226,'TUVALU','TV',NULL); INSERT INTO `countries` VALUES (227,'UGANDA','UG',NULL); INSERT INTO `countries` VALUES (228,'UKRAINE','UA',NULL); INSERT INTO `countries` VALUES (229,'UNITED ARAB EMIRATES','AE',NULL); INSERT INTO `countries` VALUES (230,'UNITED KINGDOM','GB',NULL); INSERT INTO `countries` VALUES (231,'UNITED STATES','US',NULL); INSERT INTO `countries` VALUES (232,'UNITED STATES MINOR OUTLYING ISLANDS','UM',NULL); INSERT INTO `countries` VALUES (233,'URUGUAY','UY',NULL); INSERT INTO `countries` VALUES (234,'UZBEKISTAN','UZ',NULL); INSERT INTO `countries` VALUES (235,'VANUATU','VU',NULL); INSERT INTO `countries` VALUES (236,'VENEZUELA','VE',NULL); INSERT INTO `countries` VALUES (237,'VIET NAM','VN',NULL); INSERT INTO `countries` VALUES (238,'VIRGIN ISLANDS','VG',NULL); INSERT INTO `countries` VALUES (239,'VIRGIN ISLANDS','VI',NULL); INSERT INTO `countries` VALUES (240,'WALLIS AND FUTUNA','WF',NULL); INSERT INTO `countries` VALUES (241,'WESTERN SAHARA','EH',NULL); INSERT INTO `countries` VALUES (242,'YEMEN','YE',NULL); INSERT INTO `countries` VALUES (243,'ZAMBIA','ZM',NULL); INSERT INTO `countries` VALUES (244,'ZIMBABWE','ZW',NULL); -- -- Table structure for table `legend` -- CREATE TABLE `legend` ( `id` int(11) unsigned NOT NULL auto_increment, `unique_part_id` int(11) NOT NULL, `status` enum('production','beta','obsolete') NOT NULL, PRIMARY KEY (`id`), KEY `unique_part_id` (`unique_part_id`), KEY `status` (`status`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `legend` -- INSERT INTO `legend` VALUES (1,348,'production'); INSERT INTO `legend` VALUES (2,349,'production'); INSERT INTO `legend` VALUES (3,350,'production'); INSERT INTO `legend` VALUES (4,351,'beta'); -- -- Table structure for table `raw_parts` -- CREATE TABLE `raw_parts` ( `id` int(11) unsigned NOT NULL auto_increment, `part_id` int(11) NOT NULL, `type` varchar(32) NOT NULL, `raw_id` varchar(255) NOT NULL, `raw_text` varchar(255) NOT NULL, `quantity` int(11) NOT NULL, `parent_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `part_id` (`part_id`), KEY `parent_id` (`parent_id`) ) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8; -- -- Dumping data for table `raw_parts` -- INSERT INTO `raw_parts` VALUES (1,348,'module','','Danger Shield v1.0',1,0); INSERT INTO `raw_parts` VALUES (2,352,'pcb','','Danger Shield v1.0 PCB',1,1); INSERT INTO `raw_parts` VALUES (3,334,'component','DIS1','7 Segment LED, red, 0.3in',1,1); INSERT INTO `raw_parts` VALUES (4,336,'component','IC1','74HC595N',1,1); INSERT INTO `raw_parts` VALUES (5,69,'component','JP1','.100 breakaway header',5,1); INSERT INTO `raw_parts` VALUES (6,89,'component','LED1-3','5mm red LED',3,1); INSERT INTO `raw_parts` VALUES (7,55,'component','R1-R3, R7','10K ohm resistor',4,1); INSERT INTO `raw_parts` VALUES (8,41,'component','R4, R5, R9-R11, R19, R6, R12-R18','560 ohm resistor',14,1); INSERT INTO `raw_parts` VALUES (9,58,'component','R8','1M ohm resistor',1,1); INSERT INTO `raw_parts` VALUES (10,102,'component','S1-S4','Omron B3F-1000 Button',4,1); INSERT INTO `raw_parts` VALUES (11,339,'component','SG1, SG2','12mm Piezo Buzzer',2,1); INSERT INTO `raw_parts` VALUES (12,337,'component','SLIDER1-3','Bourns PTL60 Red',3,1); INSERT INTO `raw_parts` VALUES (13,340,'component','IC2','LM35DZ',1,1); INSERT INTO `raw_parts` VALUES (14,341,'component','R20','LDR',1,1); INSERT INTO `raw_parts` VALUES (15,69,'component','JP2','.100 breakaway header',40,1); INSERT INTO `raw_parts` VALUES (16,349,'module','','Sanguino v1.0',1,0); INSERT INTO `raw_parts` VALUES (17,353,'pcb','','Sanguino v1.0 PCB',1,16); INSERT INTO `raw_parts` VALUES (18,344,'component','C1, C2','22pf ceramic capacitor',2,16); INSERT INTO `raw_parts` VALUES (19,33,'component','C3,C4,C5,C8','100 nF ceramic capacitor',4,16); INSERT INTO `raw_parts` VALUES (20,29,'component','C6,C7','100 uF electrolytic capacitor',2,16); INSERT INTO `raw_parts` VALUES (21,9,'component','D1','1N4004',1,16); INSERT INTO `raw_parts` VALUES (22,87,'component','DEBUG','3mm red LED',1,16); INSERT INTO `raw_parts` VALUES (23,86,'component','POWER','3mm green LED',1,16); INSERT INTO `raw_parts` VALUES (24,342,'component','IC1','ATmega644P',1,16); INSERT INTO `raw_parts` VALUES (25,345,'component','','40 pin DIP socket',1,16); INSERT INTO `raw_parts` VALUES (26,346,'component','IC2','7805',1,16); INSERT INTO `raw_parts` VALUES (27,69,'component','','.100 breakaway header',50,16); INSERT INTO `raw_parts` VALUES (28,70,'component','','.100 breakaway header (right-angle)',6,16); INSERT INTO `raw_parts` VALUES (29,141,'component','Q1','16Mhz crystal',1,16); INSERT INTO `raw_parts` VALUES (30,55,'component','R1','10K ohm resistor',1,16); INSERT INTO `raw_parts` VALUES (31,45,'component','R2, R3','1K ohm resistor',2,16); INSERT INTO `raw_parts` VALUES (32,102,'component','','Omron B3F-1000 Button',1,16); INSERT INTO `raw_parts` VALUES (33,105,'component','','6 pin IDC header',1,16); INSERT INTO `raw_parts` VALUES (34,107,'component','','10 pin IDC header',1,16); INSERT INTO `raw_parts` VALUES (35,347,'component','','2.1mm DC socket',1,16); INSERT INTO `raw_parts` VALUES (36,147,'component','','SPDT switch',1,16); INSERT INTO `raw_parts` VALUES (37,68,'component','','.100 shunt',1,16); INSERT INTO `raw_parts` VALUES (38,91,'component','','small heat sink',1,16); INSERT INTO `raw_parts` VALUES (39,150,'fast','','M3 x 10 cap',1,16); INSERT INTO `raw_parts` VALUES (40,149,'fast','','M3 washer',2,16); INSERT INTO `raw_parts` VALUES (41,148,'fast','','M3 nut',1,16); INSERT INTO `raw_parts` VALUES (42,350,'module','','Sanguino Breakout v1.0',1,0); INSERT INTO `raw_parts` VALUES (43,354,'pcb','','Sanguino Breakout v1.0 PCB',1,42); INSERT INTO `raw_parts` VALUES (44,63,'component','','2 pin .200\" connector',4,42); INSERT INTO `raw_parts` VALUES (45,66,'component','','8 pin .200\" terminal block',4,42); INSERT INTO `raw_parts` VALUES (46,81,'component','','20 pin female header',1,42); INSERT INTO `raw_parts` VALUES (47,82,'component','','22 pin female header',1,42); INSERT INTO `raw_parts` VALUES (48,351,'module','','RepRap Motherboard v1.0',1,0); INSERT INTO `raw_parts` VALUES (49,0,'pcb','','RepRap Motherboard v1.0 PCB',1,48); INSERT INTO `raw_parts` VALUES (50,77,'component','','4 pin female header',5,48); INSERT INTO `raw_parts` VALUES (51,81,'component','','20 pin female header',1,48); INSERT INTO `raw_parts` VALUES (52,82,'component','','22 pin female header',1,48); INSERT INTO `raw_parts` VALUES (53,107,'component','','10 pin idc header',5,48); INSERT INTO `raw_parts` VALUES (54,105,'component','','6 pin idc header',3,48); INSERT INTO `raw_parts` VALUES (55,134,'component','','78L33Z',1,48); INSERT INTO `raw_parts` VALUES (56,135,'component','','3M sd card socket',1,48); INSERT INTO `raw_parts` VALUES (57,38,'component','R16','180 ohm resistor',1,48); INSERT INTO `raw_parts` VALUES (58,47,'component','R4, R5, R6, R11, R12','1.8K ohm resistor',5,48); INSERT INTO `raw_parts` VALUES (59,52,'component','R7, R8, R9','3.3K ohm resistor',3,48); INSERT INTO `raw_parts` VALUES (60,53,'component','R10, R15','4.7K ohm resistor',2,48); INSERT INTO `raw_parts` VALUES (61,55,'component','R13, R14','10K ohm resistor',2,48); INSERT INTO `raw_parts` VALUES (62,63,'component','','2 pin .200\" connector',1,48); INSERT INTO `raw_parts` VALUES (63,136,'component','','SN75176A',1,48); INSERT INTO `raw_parts` VALUES (64,33,'component','C9','100 nF ceramic capacitor',1,48); -- -- Table structure for table `supplier_parts` -- CREATE TABLE `supplier_parts` ( `id` int(11) unsigned NOT NULL auto_increment, `supplier_id` int(11) NOT NULL, `part_id` int(11) NOT NULL, `url` varchar(255) NOT NULL, `part_num` varchar(255) NOT NULL, `quantity` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `supplier_id` (`supplier_id`,`part_id`) ) ENGINE=MyISAM AUTO_INCREMENT=532 DEFAULT CHARSET=utf8; -- -- Dumping data for table `supplier_parts` -- INSERT INTO `supplier_parts` VALUES (1,3,1,'','7959K21',304); INSERT INTO `supplier_parts` VALUES (2,4,1,'','4745230',950); INSERT INTO `supplier_parts` VALUES (3,2,1,'','47',4876); INSERT INTO `supplier_parts` VALUES (4,18,2,'','A3977SED-T',1); INSERT INTO `supplier_parts` VALUES (5,18,3,'','620-1082-ND',1); INSERT INTO `supplier_parts` VALUES (6,1,4,'','512-LM78L05ACZX',1); INSERT INTO `supplier_parts` VALUES (7,7,4,'','Z6108',1); INSERT INTO `supplier_parts` VALUES (8,11,4,'','78L05',1); INSERT INTO `supplier_parts` VALUES (9,4,4,'','2174759',1); INSERT INTO `supplier_parts` VALUES (10,5,4,'','9593853',1); INSERT INTO `supplier_parts` VALUES (11,1,5,'','863-MC7805CDTRKG',1); INSERT INTO `supplier_parts` VALUES (12,1,6,'','595-L293DNE',1); INSERT INTO `supplier_parts` VALUES (13,10,6,'','1341966',1); INSERT INTO `supplier_parts` VALUES (14,1,7,'','511-L297',1); INSERT INTO `supplier_parts` VALUES (15,10,7,'','288067',1); INSERT INTO `supplier_parts` VALUES (16,22,7,'','248-1308',1); INSERT INTO `supplier_parts` VALUES (17,1,8,'','511-L298',1); INSERT INTO `supplier_parts` VALUES (18,11,8,'','L298N',1); INSERT INTO `supplier_parts` VALUES (19,10,8,'','245403',1); INSERT INTO `supplier_parts` VALUES (20,22,8,'','248-1310',1); INSERT INTO `supplier_parts` VALUES (21,26,8,'','UK72P',1); INSERT INTO `supplier_parts` VALUES (22,1,9,'','512-1N4005',1); INSERT INTO `supplier_parts` VALUES (23,11,9,'','1N4004',1); INSERT INTO `supplier_parts` VALUES (24,5,9,'','1467510',1); INSERT INTO `supplier_parts` VALUES (25,1,10,'','512-1N4005',1); INSERT INTO `supplier_parts` VALUES (26,6,10,'','ZR1008',1); INSERT INTO `supplier_parts` VALUES (27,11,10,'','1N4005',1); INSERT INTO `supplier_parts` VALUES (28,5,10,'','1467511',1); INSERT INTO `supplier_parts` VALUES (29,1,11,'','512-1N4148',1); INSERT INTO `supplier_parts` VALUES (30,1,12,'','625-1N5817-E3',1); INSERT INTO `supplier_parts` VALUES (31,1,13,'','511-TIP110',1); INSERT INTO `supplier_parts` VALUES (32,11,13,'','TIP110',1); INSERT INTO `supplier_parts` VALUES (33,5,13,'','9803963',1); INSERT INTO `supplier_parts` VALUES (34,1,14,'','511-TIP120',1); INSERT INTO `supplier_parts` VALUES (35,1,15,'','579-PIC16F648A-I/P',1); INSERT INTO `supplier_parts` VALUES (36,6,15,'','ZZ8520',1); INSERT INTO `supplier_parts` VALUES (37,11,15,'','PIC16F648A-I/P',1); INSERT INTO `supplier_parts` VALUES (38,1,16,'','595-MAX232N',1); INSERT INTO `supplier_parts` VALUES (39,6,16,'','ZK8824',1); INSERT INTO `supplier_parts` VALUES (40,11,16,'','MAX232CPE',1); INSERT INTO `supplier_parts` VALUES (41,4,16,'','1951195',1); INSERT INTO `supplier_parts` VALUES (42,5,16,'','1470445',1); INSERT INTO `supplier_parts` VALUES (43,1,17,'','512-HCPL-2631',1); INSERT INTO `supplier_parts` VALUES (44,10,17,'','1550320',1); INSERT INTO `supplier_parts` VALUES (45,18,19,'','ATMEGA168-20AU-ND',1); INSERT INTO `supplier_parts` VALUES (46,1,19,'','556-ATMEGA168-20AU',1); INSERT INTO `supplier_parts` VALUES (47,18,20,'','ATMEGA644P-20AU-ND',1); INSERT INTO `supplier_parts` VALUES (48,1,21,'','517-4820-3000-CP',1); INSERT INTO `supplier_parts` VALUES (49,11,21,'','ICS20',1); INSERT INTO `supplier_parts` VALUES (50,18,21,'','3M5465-ND',1); INSERT INTO `supplier_parts` VALUES (51,4,21,'','0402793',1); INSERT INTO `supplier_parts` VALUES (52,1,22,'','517-4818-3000-CP',1); INSERT INTO `supplier_parts` VALUES (53,6,22,'','PI6503',1); INSERT INTO `supplier_parts` VALUES (54,11,22,'','ICS18',1); INSERT INTO `supplier_parts` VALUES (55,18,22,'','3M5464-ND',1); INSERT INTO `supplier_parts` VALUES (56,4,22,'','0402787',1); INSERT INTO `supplier_parts` VALUES (57,26,22,'','HQ76H',1); INSERT INTO `supplier_parts` VALUES (58,1,23,'','517-4816-3000-CP',1); INSERT INTO `supplier_parts` VALUES (59,11,23,'','ICS16',1); INSERT INTO `supplier_parts` VALUES (60,18,23,'','3M5463-ND',1); INSERT INTO `supplier_parts` VALUES (61,4,23,'','0402771',1); INSERT INTO `supplier_parts` VALUES (62,26,23,'','BL19V',1); INSERT INTO `supplier_parts` VALUES (63,1,24,'','517-4814-3000-CP',1); INSERT INTO `supplier_parts` VALUES (64,11,24,'','ICS14',1); INSERT INTO `supplier_parts` VALUES (65,18,24,'','3M5462-ND',1); INSERT INTO `supplier_parts` VALUES (66,4,24,'','0402765',1); INSERT INTO `supplier_parts` VALUES (67,1,25,'','140-XRL50V4700-RC',1); INSERT INTO `supplier_parts` VALUES (68,11,25,'','C4700U25E',1); INSERT INTO `supplier_parts` VALUES (69,1,26,'','140-XRL25V2200-RC',1); INSERT INTO `supplier_parts` VALUES (70,4,26,'','5200924',1); INSERT INTO `supplier_parts` VALUES (71,26,26,'','VH54J',1); INSERT INTO `supplier_parts` VALUES (72,1,27,'','647-UVR1E102MPD',1); INSERT INTO `supplier_parts` VALUES (73,6,27,'','RE6230',1); INSERT INTO `supplier_parts` VALUES (74,11,27,'','C1000U25E',1); INSERT INTO `supplier_parts` VALUES (75,4,27,'','5478329',1); INSERT INTO `supplier_parts` VALUES (76,26,27,'','VH50E',1); INSERT INTO `supplier_parts` VALUES (77,1,28,'','140-XRL50V470-RC',1); INSERT INTO `supplier_parts` VALUES (78,1,29,'','140-XRL50V100-RC',1); INSERT INTO `supplier_parts` VALUES (79,6,29,'','RE6130',1); INSERT INTO `supplier_parts` VALUES (80,11,29,'','C100U25E',1); INSERT INTO `supplier_parts` VALUES (81,4,29,'','5200867',1); INSERT INTO `supplier_parts` VALUES (82,26,29,'','VH37S',1); INSERT INTO `supplier_parts` VALUES (83,1,30,'','140-XRL50V10-RC',1); INSERT INTO `supplier_parts` VALUES (84,26,30,'','VH22Y',1); INSERT INTO `supplier_parts` VALUES (85,1,31,'','140-XRL50V1.0-RC',1); INSERT INTO `supplier_parts` VALUES (86,11,31,'','C001U50E',1); INSERT INTO `supplier_parts` VALUES (87,4,31,'','5201107',1); INSERT INTO `supplier_parts` VALUES (88,26,31,'','VH16S',1); INSERT INTO `supplier_parts` VALUES (89,1,32,'','80-C320C224M5UCA7301',1); INSERT INTO `supplier_parts` VALUES (90,18,32,'','495-3396-1-ND',1); INSERT INTO `supplier_parts` VALUES (91,1,33,'','80-C321C104K5R5HA',1); INSERT INTO `supplier_parts` VALUES (92,11,33,'','C100UC',1); INSERT INTO `supplier_parts` VALUES (93,4,33,'','6530210',1); INSERT INTO `supplier_parts` VALUES (94,26,33,'','BX03D',1); INSERT INTO `supplier_parts` VALUES (95,1,34,'','581-5WH103MACJI',1); INSERT INTO `supplier_parts` VALUES (96,4,34,'','5373785',1); INSERT INTO `supplier_parts` VALUES (97,26,34,'','BX00A',1); INSERT INTO `supplier_parts` VALUES (98,1,35,'','140-50P5-332K-RC',1); INSERT INTO `supplier_parts` VALUES (99,26,35,'','WX74R',1); INSERT INTO `supplier_parts` VALUES (100,1,36,'','581-5OK102KABJH',1); INSERT INTO `supplier_parts` VALUES (101,26,36,'','WX68Y',1); INSERT INTO `supplier_parts` VALUES (102,1,37,'','140-50P2-681K-RC',1); INSERT INTO `supplier_parts` VALUES (103,1,38,'','291-180-RC',1); INSERT INTO `supplier_parts` VALUES (104,11,38,'','R180R14W',1); INSERT INTO `supplier_parts` VALUES (105,5,38,'','9339299',1); INSERT INTO `supplier_parts` VALUES (106,1,39,'','291-220-RC',1); INSERT INTO `supplier_parts` VALUES (107,11,39,'','R220R14W',1); INSERT INTO `supplier_parts` VALUES (108,1,40,'','291-330-RC',1); INSERT INTO `supplier_parts` VALUES (109,11,40,'','R330R14W',1); INSERT INTO `supplier_parts` VALUES (110,18,40,'','330QBK-ND',1); INSERT INTO `supplier_parts` VALUES (111,1,41,'','291-560-RC',1); INSERT INTO `supplier_parts` VALUES (112,11,41,'','R560R14W',1); INSERT INTO `supplier_parts` VALUES (113,4,41,'','0131227',1); INSERT INTO `supplier_parts` VALUES (114,5,41,'','9339590',1); INSERT INTO `supplier_parts` VALUES (115,1,42,'','291-680-RC',1); INSERT INTO `supplier_parts` VALUES (116,1,43,'','294-0.5-RC',1); INSERT INTO `supplier_parts` VALUES (117,1,44,'','282-0.75-RC',1); INSERT INTO `supplier_parts` VALUES (118,1,45,'','291-1k-RC',1); INSERT INTO `supplier_parts` VALUES (119,11,45,'','R0010K14W',1); INSERT INTO `supplier_parts` VALUES (120,1,46,'','291-1.6k-RC',1); INSERT INTO `supplier_parts` VALUES (121,1,47,'','291-1.8k-RC',1); INSERT INTO `supplier_parts` VALUES (122,11,47,'','R0018K14W',1); INSERT INTO `supplier_parts` VALUES (123,4,47,'','0131283A',1); INSERT INTO `supplier_parts` VALUES (124,1,48,'','652-3362U-1-202',1); INSERT INTO `supplier_parts` VALUES (125,1,49,'','T73YE103KT20',1); INSERT INTO `supplier_parts` VALUES (126,1,50,'','291-2.2k-RC',1); INSERT INTO `supplier_parts` VALUES (127,1,51,'','291-2.7k-RC',1); INSERT INTO `supplier_parts` VALUES (128,11,51,'','R0027K14W',1); INSERT INTO `supplier_parts` VALUES (129,1,52,'','291-3.3k-RC',1); INSERT INTO `supplier_parts` VALUES (130,11,52,'','R0033K14W',1); INSERT INTO `supplier_parts` VALUES (131,1,53,'','291-4.7k-RC',1); INSERT INTO `supplier_parts` VALUES (132,11,53,'','R0047K14W',1); INSERT INTO `supplier_parts` VALUES (133,1,54,'','291-5.6k-RC',1); INSERT INTO `supplier_parts` VALUES (134,11,54,'','R0056K14W',1); INSERT INTO `supplier_parts` VALUES (135,4,54,'','0131340',1); INSERT INTO `supplier_parts` VALUES (136,1,55,'','291-10K-RC',1); INSERT INTO `supplier_parts` VALUES (137,11,55,'','R010K14W',1); INSERT INTO `supplier_parts` VALUES (138,5,55,'','9339060',1); INSERT INTO `supplier_parts` VALUES (139,1,56,'','291-22K-RC',1); INSERT INTO `supplier_parts` VALUES (140,11,56,'','R022K14W',1); INSERT INTO `supplier_parts` VALUES (141,1,57,'','291-100K-RC',1); INSERT INTO `supplier_parts` VALUES (142,1,58,'','291-1M-RC',1); INSERT INTO `supplier_parts` VALUES (143,1,59,'','71-01T1002FP',1); INSERT INTO `supplier_parts` VALUES (144,4,59,'','484-0149',1); INSERT INTO `supplier_parts` VALUES (145,11,59,'','NTC10K',1); INSERT INTO `supplier_parts` VALUES (146,2,59,'','48',1); INSERT INTO `supplier_parts` VALUES (147,1,60,'','871-B57560G104F',1); INSERT INTO `supplier_parts` VALUES (148,1,61,'','538-15-24-4745',1); INSERT INTO `supplier_parts` VALUES (149,1,62,'','152-3409',1); INSERT INTO `supplier_parts` VALUES (150,6,62,'','PS0806',1); INSERT INTO `supplier_parts` VALUES (151,11,62,'','DSUBPCF9',1); INSERT INTO `supplier_parts` VALUES (152,4,62,'','4543753',1); INSERT INTO `supplier_parts` VALUES (153,1,63,'','571-2828372',1); INSERT INTO `supplier_parts` VALUES (154,6,63,'','HM3172',1); INSERT INTO `supplier_parts` VALUES (155,11,63,'','PCBT2',1); INSERT INTO `supplier_parts` VALUES (156,18,63,'','277-1247-ND',1); INSERT INTO `supplier_parts` VALUES (157,26,63,'','RH80B',1); INSERT INTO `supplier_parts` VALUES (158,1,64,'','571-2828374',1); INSERT INTO `supplier_parts` VALUES (159,1,65,'','571-2828376',1); INSERT INTO `supplier_parts` VALUES (160,1,66,'','571-2828378',1); INSERT INTO `supplier_parts` VALUES (161,1,67,'','571-17969492',1); INSERT INTO `supplier_parts` VALUES (162,1,68,'','517-952-10',1); INSERT INTO `supplier_parts` VALUES (163,11,68,'','HDSHOB',1); INSERT INTO `supplier_parts` VALUES (164,4,68,'','0334561',1); INSERT INTO `supplier_parts` VALUES (165,18,69,'','A26514-40-ND',40); INSERT INTO `supplier_parts` VALUES (166,1,70,'','571-9-146304-0',40); INSERT INTO `supplier_parts` VALUES (167,1,71,'','538-22-23-2021',1); INSERT INTO `supplier_parts` VALUES (168,6,71,'','HM3412',1); INSERT INTO `supplier_parts` VALUES (169,11,71,'','POLHDR2',1); INSERT INTO `supplier_parts` VALUES (170,4,71,'','4838461',1); INSERT INTO `supplier_parts` VALUES (171,5,71,'','1462926',1); INSERT INTO `supplier_parts` VALUES (172,1,72,'','538-22-01-3027',1); INSERT INTO `supplier_parts` VALUES (173,6,72,'','HM3402',1); INSERT INTO `supplier_parts` VALUES (174,11,72,'','POLHDCON2',1); INSERT INTO `supplier_parts` VALUES (175,4,72,'','2508879191',1); INSERT INTO `supplier_parts` VALUES (176,5,72,'','1462825',1); INSERT INTO `supplier_parts` VALUES (177,1,73,'','538-22-23-2031',1); INSERT INTO `supplier_parts` VALUES (178,6,73,'','HM3413',1); INSERT INTO `supplier_parts` VALUES (179,11,73,'','POLHDR3',1); INSERT INTO `supplier_parts` VALUES (180,5,73,'','1462950',1); INSERT INTO `supplier_parts` VALUES (181,1,74,'','538-22-01-3037',1); INSERT INTO `supplier_parts` VALUES (182,6,74,'','HM3403',1); INSERT INTO `supplier_parts` VALUES (183,11,74,'','POLHDCON3',1); INSERT INTO `supplier_parts` VALUES (184,5,74,'','1462838',1); INSERT INTO `supplier_parts` VALUES (185,1,75,'','538-22-23-2041',1); INSERT INTO `supplier_parts` VALUES (186,6,75,'','HM3414',1); INSERT INTO `supplier_parts` VALUES (187,11,75,'','POLHDR4',1); INSERT INTO `supplier_parts` VALUES (188,5,75,'','1462920',1); INSERT INTO `supplier_parts` VALUES (189,1,76,'','538-22-01-3047',1); INSERT INTO `supplier_parts` VALUES (190,6,76,'','HM3404',1); INSERT INTO `supplier_parts` VALUES (191,11,76,'','POLHDCON4',1); INSERT INTO `supplier_parts` VALUES (192,5,76,'','1462831',1); INSERT INTO `supplier_parts` VALUES (193,18,77,'','S7037-ND',1); INSERT INTO `supplier_parts` VALUES (194,1,77,'','517-974-01-04',1); INSERT INTO `supplier_parts` VALUES (195,11,77,'','FHEADS4',1); INSERT INTO `supplier_parts` VALUES (196,18,78,'','S7039-ND',1); INSERT INTO `supplier_parts` VALUES (197,1,78,'','517-974-01-06-RK',1); INSERT INTO `supplier_parts` VALUES (198,18,79,'','S4108-ND',1); INSERT INTO `supplier_parts` VALUES (199,18,80,'','S7008-ND',1); INSERT INTO `supplier_parts` VALUES (200,18,81,'','S7018-ND',1); INSERT INTO `supplier_parts` VALUES (201,18,82,'','S7020-ND',1); INSERT INTO `supplier_parts` VALUES (202,1,83,'','538-22-23-2121',1); INSERT INTO `supplier_parts` VALUES (203,6,83,'','HM3406',1); INSERT INTO `supplier_parts` VALUES (204,11,83,'','POLHDR12',1); INSERT INTO `supplier_parts` VALUES (205,1,84,'','538-22-01-3127',1); INSERT INTO `supplier_parts` VALUES (206,6,84,'','HM3416',1); INSERT INTO `supplier_parts` VALUES (207,11,84,'','POLHDCON12',1); INSERT INTO `supplier_parts` VALUES (208,1,85,'','538-08-50-0114',1); INSERT INTO `supplier_parts` VALUES (209,11,85,'','PLHDPIN',1); INSERT INTO `supplier_parts` VALUES (210,4,85,'','1729178',1); INSERT INTO `supplier_parts` VALUES (211,5,85,'','1462641',1); INSERT INTO `supplier_parts` VALUES (212,1,86,'','859-LTL-4231N-1',1); INSERT INTO `supplier_parts` VALUES (213,11,86,'','LED3G',1); INSERT INTO `supplier_parts` VALUES (214,1,87,'','859-LTL-4221',1); INSERT INTO `supplier_parts` VALUES (215,11,87,'','LED3R',1); INSERT INTO `supplier_parts` VALUES (216,1,88,'','696-SSL-LX5093GD',1); INSERT INTO `supplier_parts` VALUES (217,11,88,'','LED5G',1); INSERT INTO `supplier_parts` VALUES (218,4,88,'','6218241',1); INSERT INTO `supplier_parts` VALUES (219,5,88,'','1142572',1); INSERT INTO `supplier_parts` VALUES (220,1,89,'','696-SSL-LX5093HD',1); INSERT INTO `supplier_parts` VALUES (221,11,89,'','LED5R',1); INSERT INTO `supplier_parts` VALUES (222,18,89,'','754-1308-ND',1); INSERT INTO `supplier_parts` VALUES (223,4,89,'','6466670',1); INSERT INTO `supplier_parts` VALUES (224,5,89,'','1142576',1); INSERT INTO `supplier_parts` VALUES (225,1,90,'','567-290-1AB',1); INSERT INTO `supplier_parts` VALUES (226,6,90,'','HH8511',1); INSERT INTO `supplier_parts` VALUES (227,5,90,'','170074',1); INSERT INTO `supplier_parts` VALUES (228,1,91,'','532-507302B00',1); INSERT INTO `supplier_parts` VALUES (229,11,91,'','TO220S',1); INSERT INTO `supplier_parts` VALUES (230,5,91,'','4621141',1); INSERT INTO `supplier_parts` VALUES (231,1,92,'','512-H21LOI',1); INSERT INTO `supplier_parts` VALUES (232,5,92,'','1021134',1); INSERT INTO `supplier_parts` VALUES (233,6,92,'','ZD1901',1); INSERT INTO `supplier_parts` VALUES (234,18,92,'','H21LOI-ND',1); INSERT INTO `supplier_parts` VALUES (235,1,93,'','512-H21LOB',1); INSERT INTO `supplier_parts` VALUES (236,18,93,'','H21LOB-ND',1); INSERT INTO `supplier_parts` VALUES (237,1,94,'','604-WP937EGW',1); INSERT INTO `supplier_parts` VALUES (238,5,94,'','1142488',1); INSERT INTO `supplier_parts` VALUES (239,18,94,'','160-1038-ND',1); INSERT INTO `supplier_parts` VALUES (240,4,94,'','2471167',1); INSERT INTO `supplier_parts` VALUES (241,1,95,'','512-SB360',1); INSERT INTO `supplier_parts` VALUES (242,10,95,'','177990PS',1); INSERT INTO `supplier_parts` VALUES (243,1,96,'','512-MM74HC00N',1); INSERT INTO `supplier_parts` VALUES (244,1,97,'','512-MM74HC04N',1); INSERT INTO `supplier_parts` VALUES (245,1,98,'','538-26-48-1245',24); INSERT INTO `supplier_parts` VALUES (246,1,99,'','538-09-50-3021',1); INSERT INTO `supplier_parts` VALUES (247,1,100,'','538-09-50-3041',1); INSERT INTO `supplier_parts` VALUES (248,1,101,'','538-08-52-0072',1); INSERT INTO `supplier_parts` VALUES (249,1,102,'','653-B3F-1000',1); INSERT INTO `supplier_parts` VALUES (250,18,103,'','AD595AQ-ND',1); INSERT INTO `supplier_parts` VALUES (251,10,103,'','313293',1); INSERT INTO `supplier_parts` VALUES (252,20,104,'','251',1); INSERT INTO `supplier_parts` VALUES (253,1,105,'','649-75869-131LF',1); INSERT INTO `supplier_parts` VALUES (254,1,106,'','649-71600-006LF',1); INSERT INTO `supplier_parts` VALUES (255,1,107,'','649-75869-101LF',1); INSERT INTO `supplier_parts` VALUES (256,1,108,'','649-71600-010LF',1); INSERT INTO `supplier_parts` VALUES (257,1,109,'','647-UUX1H101MNL1GS',1); INSERT INTO `supplier_parts` VALUES (258,1,110,'','647-UUT1H100MCL1GS',1); INSERT INTO `supplier_parts` VALUES (259,1,111,'','661-MKA50VC1R0M',1); INSERT INTO `supplier_parts` VALUES (260,1,112,'','80-C1206C224K5R',1); INSERT INTO `supplier_parts` VALUES (261,1,113,'','80-C1206C104K5R',1); INSERT INTO `supplier_parts` VALUES (262,1,114,'','80-C1206C103K5R',1); INSERT INTO `supplier_parts` VALUES (263,1,115,'','80-C1206C102K5R',1); INSERT INTO `supplier_parts` VALUES (264,1,116,'','77-VJ12A100V150J',1); INSERT INTO `supplier_parts` VALUES (265,1,118,'','645-598-9260-107F',1); INSERT INTO `supplier_parts` VALUES (266,1,119,'','645-598-8210-107F',1); INSERT INTO `supplier_parts` VALUES (267,1,120,'','263-180-RC',1); INSERT INTO `supplier_parts` VALUES (268,1,121,'','263-220-RC',1); INSERT INTO `supplier_parts` VALUES (269,1,122,'','263-560-RC',1); INSERT INTO `supplier_parts` VALUES (270,1,123,'','290-1.0K-RC',1); INSERT INTO `supplier_parts` VALUES (271,1,124,'','263-1.8K-RC',1); INSERT INTO `supplier_parts` VALUES (272,1,125,'','263-2.2K-RC',1); INSERT INTO `supplier_parts` VALUES (273,1,126,'','263-3.3K-RC',1); INSERT INTO `supplier_parts` VALUES (274,1,127,'','263-4.7K-RC',1); INSERT INTO `supplier_parts` VALUES (275,1,128,'','290-10K-RC',1); INSERT INTO `supplier_parts` VALUES (276,1,129,'','66-LR2512LF-01-R250',1); INSERT INTO `supplier_parts` VALUES (277,18,130,'','30W-5-ND',1); INSERT INTO `supplier_parts` VALUES (278,1,131,'','571-5555164-1',1); INSERT INTO `supplier_parts` VALUES (279,1,132,'','653-A6T-4104',1); INSERT INTO `supplier_parts` VALUES (280,1,133,'','28L0138-80R-10',1); INSERT INTO `supplier_parts` VALUES (281,1,134,'','511-L78L33ACZ ',1); INSERT INTO `supplier_parts` VALUES (282,1,135,'','517-SD-RSMT-2-MQ',1); INSERT INTO `supplier_parts` VALUES (283,18,135,'','3M5646CT-ND',1); INSERT INTO `supplier_parts` VALUES (284,1,136,'','595-SN75176APE4',1); INSERT INTO `supplier_parts` VALUES (285,1,137,'','652-3364W-1-103E',1); INSERT INTO `supplier_parts` VALUES (286,1,138,'','863-NIF5002NT1G',1); INSERT INTO `supplier_parts` VALUES (287,1,139,'','863-NIF5003NT1G',1); INSERT INTO `supplier_parts` VALUES (288,1,140,'','815-ABLS-16-B2',1); INSERT INTO `supplier_parts` VALUES (289,1,141,'','695-HC49US-16-U',1); INSERT INTO `supplier_parts` VALUES (290,1,142,'','595-SN75176AD',1); INSERT INTO `supplier_parts` VALUES (291,18,143,'','620-1062-ND',1); INSERT INTO `supplier_parts` VALUES (292,1,144,'','863-MBRA140T3G',1); INSERT INTO `supplier_parts` VALUES (293,1,145,'','511-L78L33ACU',1); INSERT INTO `supplier_parts` VALUES (294,1,146,'','538-39-29-3206',1); INSERT INTO `supplier_parts` VALUES (295,18,146,'','WM7346-ND',1); INSERT INTO `supplier_parts` VALUES (296,1,147,'','10SP001',1); INSERT INTO `supplier_parts` VALUES (297,9,148,'','B000FN0E4Y',25); INSERT INTO `supplier_parts` VALUES (298,3,148,'','90591A121',100); INSERT INTO `supplier_parts` VALUES (299,8,148,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (300,9,149,'','B000FMWW4U',25); INSERT INTO `supplier_parts` VALUES (301,3,149,'','91100A120',100); INSERT INTO `supplier_parts` VALUES (302,8,149,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (303,9,150,'','B000OCW6MY',25); INSERT INTO `supplier_parts` VALUES (304,3,150,'','91290A115',100); INSERT INTO `supplier_parts` VALUES (305,8,150,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (306,9,151,'','B000OD1THG',25); INSERT INTO `supplier_parts` VALUES (307,3,151,'','91290A120',100); INSERT INTO `supplier_parts` VALUES (308,8,151,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (309,9,152,'','B000Q5UN7E',25); INSERT INTO `supplier_parts` VALUES (310,3,152,'','91290A125',100); INSERT INTO `supplier_parts` VALUES (311,8,152,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (312,9,153,'','B000OD1TSA',25); INSERT INTO `supplier_parts` VALUES (313,3,153,'','91290A130',100); INSERT INTO `supplier_parts` VALUES (314,8,153,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (315,9,154,'','B000OD1TTO',10); INSERT INTO `supplier_parts` VALUES (316,3,154,'','91290A135',100); INSERT INTO `supplier_parts` VALUES (317,8,154,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (318,9,155,'','B00067ES2I',25); INSERT INTO `supplier_parts` VALUES (319,3,155,'','91290A136',25); INSERT INTO `supplier_parts` VALUES (320,8,155,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (321,9,156,'','B00067ERVK',25); INSERT INTO `supplier_parts` VALUES (322,3,156,'','91290A137',25); INSERT INTO `supplier_parts` VALUES (323,8,156,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (324,9,157,'','B000NBKLHS',100); INSERT INTO `supplier_parts` VALUES (325,3,157,'','90591A146',100); INSERT INTO `supplier_parts` VALUES (326,8,157,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (327,9,158,'','B000FN160A',100); INSERT INTO `supplier_parts` VALUES (328,3,158,'','91166A240',100); INSERT INTO `supplier_parts` VALUES (329,8,158,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (330,9,159,'','B000OCUU8G',50); INSERT INTO `supplier_parts` VALUES (331,3,159,'','91290A231',100); INSERT INTO `supplier_parts` VALUES (332,8,159,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (333,9,160,'','B000OD1QD8',25); INSERT INTO `supplier_parts` VALUES (334,3,160,'',' 91290A242',100); INSERT INTO `supplier_parts` VALUES (335,8,160,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (336,9,161,'','B000OD1QGU',10); INSERT INTO `supplier_parts` VALUES (337,3,161,'','91290A252',100); INSERT INTO `supplier_parts` VALUES (338,8,161,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (339,9,162,'','B000OD0AGW',25); INSERT INTO `supplier_parts` VALUES (340,3,162,'','91290A254',100); INSERT INTO `supplier_parts` VALUES (341,8,162,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (342,9,163,'','B000OCW3ZE',10); INSERT INTO `supplier_parts` VALUES (343,3,163,'','91290A258',100); INSERT INTO `supplier_parts` VALUES (344,8,163,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (345,9,164,'','B000OD0AOY',10); INSERT INTO `supplier_parts` VALUES (346,3,164,'','91290A262',100); INSERT INTO `supplier_parts` VALUES (347,8,164,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (348,9,165,'','B000NHXKUC',50); INSERT INTO `supplier_parts` VALUES (349,3,165,'','91390A119',100); INSERT INTO `supplier_parts` VALUES (350,8,165,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (351,9,166,'','B000NBGGFY',100); INSERT INTO `supplier_parts` VALUES (352,3,166,'','90591A161',100); INSERT INTO `supplier_parts` VALUES (353,8,166,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (354,9,167,'','B000FMWW9U',100); INSERT INTO `supplier_parts` VALUES (355,3,167,'','91166A270',100); INSERT INTO `supplier_parts` VALUES (356,8,167,'','fasteners',1); INSERT INTO `supplier_parts` VALUES (357,3,168,'','90273A581',50); INSERT INTO `supplier_parts` VALUES (358,3,169,'','90494A030',100); INSERT INTO `supplier_parts` VALUES (359,3,170,'','91083A030',192); INSERT INTO `supplier_parts` VALUES (360,3,171,'','90275A714',10); INSERT INTO `supplier_parts` VALUES (361,3,172,'','95462A033',100); INSERT INTO `supplier_parts` VALUES (362,3,173,'','91083A033',55); INSERT INTO `supplier_parts` VALUES (363,3,174,'','91034A100',1); INSERT INTO `supplier_parts` VALUES (364,3,175,'','98273A255',50); INSERT INTO `supplier_parts` VALUES (365,3,176,'','97828A633',1900); INSERT INTO `supplier_parts` VALUES (366,2,184,'','42',1); INSERT INTO `supplier_parts` VALUES (367,2,185,'','41',1); INSERT INTO `supplier_parts` VALUES (368,2,186,'','33',1); INSERT INTO `supplier_parts` VALUES (369,3,187,'','3498T63',1); INSERT INTO `supplier_parts` VALUES (370,8,187,'','rope',1); INSERT INTO `supplier_parts` VALUES (371,3,188,'','93295A120',1); INSERT INTO `supplier_parts` VALUES (372,2,189,'','55',1); INSERT INTO `supplier_parts` VALUES (373,14,190,'','http://www.sculpt.com/catalog_98/craft/craft.htm#friend',793); INSERT INTO `supplier_parts` VALUES (374,9,191,'','B000S5FAF2',1); INSERT INTO `supplier_parts` VALUES (375,8,192,'','anywhere',1); INSERT INTO `supplier_parts` VALUES (376,8,193,'','epoxy section:85',1); INSERT INTO `supplier_parts` VALUES (377,8,194,'','plumbing section',5000); INSERT INTO `supplier_parts` VALUES (378,2,195,'','32',2268); INSERT INTO `supplier_parts` VALUES (379,8,196,'','tubing section',1); INSERT INTO `supplier_parts` VALUES (380,9,197,'','B00066ISVG',1); INSERT INTO `supplier_parts` VALUES (381,3,198,'','9657K108',12); INSERT INTO `supplier_parts` VALUES (382,5,198,'','7031282',1); INSERT INTO `supplier_parts` VALUES (383,8,199,'','white silicone',1); INSERT INTO `supplier_parts` VALUES (384,8,200,'','lumber',1); INSERT INTO `supplier_parts` VALUES (385,3,202,'','9001K34',96); INSERT INTO `supplier_parts` VALUES (386,3,203,'','88805K57',96); INSERT INTO `supplier_parts` VALUES (387,3,204,'','8735K11',12); INSERT INTO `supplier_parts` VALUES (388,2,205,'','60',8); INSERT INTO `supplier_parts` VALUES (389,9,205,'','B000GAD3C6',1); INSERT INTO `supplier_parts` VALUES (390,3,206,'','9429T34',50); INSERT INTO `supplier_parts` VALUES (391,3,207,'','8968K25',36); INSERT INTO `supplier_parts` VALUES (392,3,208,'','51135K261',12); INSERT INTO `supplier_parts` VALUES (393,3,209,'','9654K167',6); INSERT INTO `supplier_parts` VALUES (394,25,210,'','222',1); INSERT INTO `supplier_parts` VALUES (395,2,223,'','63',1); INSERT INTO `supplier_parts` VALUES (396,2,224,'','63',1); INSERT INTO `supplier_parts` VALUES (397,2,225,'','63',1); INSERT INTO `supplier_parts` VALUES (398,2,232,'','57',1); INSERT INTO `supplier_parts` VALUES (399,2,233,'','70',1); INSERT INTO `supplier_parts` VALUES (400,2,234,'','70',1); INSERT INTO `supplier_parts` VALUES (401,2,235,'','69',1); INSERT INTO `supplier_parts` VALUES (402,2,236,'','69',1); INSERT INTO `supplier_parts` VALUES (403,2,237,'','71',1); INSERT INTO `supplier_parts` VALUES (404,2,238,'','71',1); INSERT INTO `supplier_parts` VALUES (405,2,239,'','71',1); INSERT INTO `supplier_parts` VALUES (406,2,244,'','68',1); INSERT INTO `supplier_parts` VALUES (407,2,245,'','68',1); INSERT INTO `supplier_parts` VALUES (408,2,246,'','68',1); INSERT INTO `supplier_parts` VALUES (409,2,248,'','73',1); INSERT INTO `supplier_parts` VALUES (410,23,248,'','http://nkcelectronics.com/freeduino-arduino-diecimila-compatible-board-complete-kit.html',1); INSERT INTO `supplier_parts` VALUES (411,24,248,'','MKARDIE',1); INSERT INTO `supplier_parts` VALUES (412,19,248,'','50',1); INSERT INTO `supplier_parts` VALUES (413,2,249,'','67',1); INSERT INTO `supplier_parts` VALUES (414,2,250,'','67',1); INSERT INTO `supplier_parts` VALUES (415,2,251,'','67',1); INSERT INTO `supplier_parts` VALUES (416,2,252,'','67',1); INSERT INTO `supplier_parts` VALUES (417,2,253,'','67',1); INSERT INTO `supplier_parts` VALUES (418,2,254,'','66',1); INSERT INTO `supplier_parts` VALUES (419,2,255,'','76',1); INSERT INTO `supplier_parts` VALUES (420,2,256,'','76',1); INSERT INTO `supplier_parts` VALUES (421,2,257,'','80',1); INSERT INTO `supplier_parts` VALUES (422,2,258,'','89',1); INSERT INTO `supplier_parts` VALUES (423,2,260,'','43',1); INSERT INTO `supplier_parts` VALUES (424,15,260,'','http://www.greenweld.co.uk/acatalog/Shop_Gearboxes_55.html',1); INSERT INTO `supplier_parts` VALUES (425,2,261,'','59',1); INSERT INTO `supplier_parts` VALUES (426,5,261,'','4743155',1); INSERT INTO `supplier_parts` VALUES (427,2,262,'','29',1); INSERT INTO `supplier_parts` VALUES (428,2,263,'','28',1); INSERT INTO `supplier_parts` VALUES (429,2,264,'','28',1); INSERT INTO `supplier_parts` VALUES (430,2,265,'','44',1); INSERT INTO `supplier_parts` VALUES (431,2,266,'','44',1); INSERT INTO `supplier_parts` VALUES (432,2,267,'','44',1); INSERT INTO `supplier_parts` VALUES (433,2,268,'','44',1); INSERT INTO `supplier_parts` VALUES (434,2,269,'','45',1); INSERT INTO `supplier_parts` VALUES (435,2,270,'','52',1); INSERT INTO `supplier_parts` VALUES (436,2,271,'','52',1); INSERT INTO `supplier_parts` VALUES (437,2,272,'','51',1); INSERT INTO `supplier_parts` VALUES (438,2,273,'','51',1); INSERT INTO `supplier_parts` VALUES (439,2,274,'','53',1); INSERT INTO `supplier_parts` VALUES (440,2,275,'','53',1); INSERT INTO `supplier_parts` VALUES (441,2,276,'','53',1); INSERT INTO `supplier_parts` VALUES (442,2,281,'','58',1); INSERT INTO `supplier_parts` VALUES (443,2,282,'','58',1); INSERT INTO `supplier_parts` VALUES (444,2,283,'','58',1); INSERT INTO `supplier_parts` VALUES (445,2,284,'','64',1); INSERT INTO `supplier_parts` VALUES (446,2,285,'','64',1); INSERT INTO `supplier_parts` VALUES (447,2,286,'','64',1); INSERT INTO `supplier_parts` VALUES (448,2,287,'','64',1); INSERT INTO `supplier_parts` VALUES (449,2,288,'','64',1); INSERT INTO `supplier_parts` VALUES (450,2,289,'','65',1); INSERT INTO `supplier_parts` VALUES (451,2,290,'','75',1); INSERT INTO `supplier_parts` VALUES (452,2,291,'','75',1); INSERT INTO `supplier_parts` VALUES (453,2,292,'','84',1); INSERT INTO `supplier_parts` VALUES (454,2,293,'','88',1); INSERT INTO `supplier_parts` VALUES (455,3,297,'','44605K105',1); INSERT INTO `supplier_parts` VALUES (456,3,298,'','4549K595',1); INSERT INTO `supplier_parts` VALUES (457,3,299,'','4549K602',1); INSERT INTO `supplier_parts` VALUES (458,3,300,'','4549K765',1); INSERT INTO `supplier_parts` VALUES (459,3,301,'','4549K606',1); INSERT INTO `supplier_parts` VALUES (460,3,302,'','44605K115',1); INSERT INTO `supplier_parts` VALUES (461,3,303,'','68095K121',1); INSERT INTO `supplier_parts` VALUES (462,3,304,'','44605K155',1); INSERT INTO `supplier_parts` VALUES (463,3,305,'','1375K39',1); INSERT INTO `supplier_parts` VALUES (464,3,306,'','1375K39',1); INSERT INTO `supplier_parts` VALUES (465,3,307,'','1375K57',1); INSERT INTO `supplier_parts` VALUES (466,16,308,'','link',1); INSERT INTO `supplier_parts` VALUES (467,17,308,'','link',1); INSERT INTO `supplier_parts` VALUES (468,3,309,'','88625K67',914); INSERT INTO `supplier_parts` VALUES (469,8,309,'','fasteners',1000); INSERT INTO `supplier_parts` VALUES (470,9,310,'','B000FOWGM6',1000); INSERT INTO `supplier_parts` VALUES (471,3,310,'','90024A040',1000); INSERT INTO `supplier_parts` VALUES (472,8,310,'','fasteners',1000); INSERT INTO `supplier_parts` VALUES (473,9,311,'','B00065VD46',1000); INSERT INTO `supplier_parts` VALUES (474,3,311,'','94185A160',1000); INSERT INTO `supplier_parts` VALUES (475,8,311,'','fasteners',1000); INSERT INTO `supplier_parts` VALUES (476,3,312,'','98847A029',36); INSERT INTO `supplier_parts` VALUES (477,9,313,'','B000G0QQRK',1); INSERT INTO `supplier_parts` VALUES (478,8,313,'','tools',1); INSERT INTO `supplier_parts` VALUES (479,9,314,'','B00006IIO9',1); INSERT INTO `supplier_parts` VALUES (480,8,314,'','tools',1); INSERT INTO `supplier_parts` VALUES (481,9,315,'','B0002RI5EO',1); INSERT INTO `supplier_parts` VALUES (482,8,315,'','tools',1); INSERT INTO `supplier_parts` VALUES (483,9,316,'','B00006ANSA',1); INSERT INTO `supplier_parts` VALUES (484,8,316,'','tools',1); INSERT INTO `supplier_parts` VALUES (485,9,317,'','B00004XPVM',1); INSERT INTO `supplier_parts` VALUES (486,8,317,'','tools',1); INSERT INTO `supplier_parts` VALUES (487,9,318,'','B000IYTCG6',1); INSERT INTO `supplier_parts` VALUES (488,8,318,'','electrical',1); INSERT INTO `supplier_parts` VALUES (489,9,319,'','B0009ZD2AG',1); INSERT INTO `supplier_parts` VALUES (490,8,319,'','electronics',1); INSERT INTO `supplier_parts` VALUES (491,9,320,'','B000BDDG8O',1); INSERT INTO `supplier_parts` VALUES (492,8,320,'','tools',1); INSERT INTO `supplier_parts` VALUES (493,9,321,'','B000051WTG',1); INSERT INTO `supplier_parts` VALUES (494,8,321,'','tools',1); INSERT INTO `supplier_parts` VALUES (495,13,322,'','1842',1); INSERT INTO `supplier_parts` VALUES (496,9,323,'','B0006A9MUS',1); INSERT INTO `supplier_parts` VALUES (497,8,323,'','tools',1); INSERT INTO `supplier_parts` VALUES (498,9,324,'','B000RNI6EM',1); INSERT INTO `supplier_parts` VALUES (499,9,325,'','B0000AXD47',1); INSERT INTO `supplier_parts` VALUES (500,8,325,'','electrical',1); INSERT INTO `supplier_parts` VALUES (501,1,325,'','685-MN35',1); INSERT INTO `supplier_parts` VALUES (502,9,326,'','B000V1PB34',100); INSERT INTO `supplier_parts` VALUES (503,9,327,'','B0002ZGBN8',30480); INSERT INTO `supplier_parts` VALUES (504,8,327,'','electrical',15000); INSERT INTO `supplier_parts` VALUES (505,9,328,'','B0002ZGBQA',30480); INSERT INTO `supplier_parts` VALUES (506,8,328,'','electrical',15000); INSERT INTO `supplier_parts` VALUES (507,9,329,'','B000KGZUUO',30480); INSERT INTO `supplier_parts` VALUES (508,8,329,'','electrical',15000); INSERT INTO `supplier_parts` VALUES (509,9,330,'','B000KH0EAE',30480); INSERT INTO `supplier_parts` VALUES (510,8,330,'','electrical',15000); INSERT INTO `supplier_parts` VALUES (511,2,331,'','40',304); INSERT INTO `supplier_parts` VALUES (512,9,332,'','B0002KRAB0',453); INSERT INTO `supplier_parts` VALUES (513,1,333,'','523-191-2801-110FT',12); INSERT INTO `supplier_parts` VALUES (514,1,334,'','630-HDSP-A103',1); INSERT INTO `supplier_parts` VALUES (515,1,335,'','630-HDSP-A903',1); INSERT INTO `supplier_parts` VALUES (516,1,336,'','511-M74HC595',1); INSERT INTO `supplier_parts` VALUES (517,1,337,'','652-PTL60-15R1-103B2',1); INSERT INTO `supplier_parts` VALUES (518,1,338,'','652-PTL60-15G1-103B2',1); INSERT INTO `supplier_parts` VALUES (519,1,339,'','254-PB507-ROX',1); INSERT INTO `supplier_parts` VALUES (520,22,340,'','288-0550',1); INSERT INTO `supplier_parts` VALUES (521,18,340,'','LM35DZ-ND',1); INSERT INTO `supplier_parts` VALUES (522,22,341,'','699-6059',1); INSERT INTO `supplier_parts` VALUES (523,21,341,'','cds',1); INSERT INTO `supplier_parts` VALUES (524,18,342,'','ATMEGA644P-20PU-ND',1); INSERT INTO `supplier_parts` VALUES (525,1,343,'','10SP001',1); INSERT INTO `supplier_parts` VALUES (526,1,344,'','594-CN15A220J',1); INSERT INTO `supplier_parts` VALUES (527,1,345,'','517-4840-6000-CP',1); INSERT INTO `supplier_parts` VALUES (528,1,346,'','512-LM7805ACT',1); INSERT INTO `supplier_parts` VALUES (529,18,347,'','CP-202AH-ND ',1); INSERT INTO `supplier_parts` VALUES (530,2,349,'','81',1); INSERT INTO `supplier_parts` VALUES (531,2,353,'','82',1); -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` int(11) unsigned NOT NULL auto_increment, `prefix` varchar(32) NOT NULL, `name` varchar(255) NOT NULL, `website` varchar(255) NOT NULL, `description` text NOT NULL, `buy_link` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; -- -- Dumping data for table `suppliers` -- INSERT INTO `suppliers` VALUES (1,'M','Mouser','http://www.mouser.com','an electronics distributor. pretty awesome','http://www.mouser.com/search/ProductDetail.aspx?R=%%PARTID%%'); INSERT INTO `suppliers` VALUES (2,'RRRF','RRRF','http://parts.rrrf.org','the non profit Reprap Research foundation','http://parts.rrrf.org/product_info.php?products_id=%%PARTID%%'); INSERT INTO `suppliers` VALUES (3,'MCM','McMaster','http://www.mcmaster.com','a great online hardware supplier','http://www.mcmaster.com/nav/enter.asp?partnum=%%PARTID%%'); INSERT INTO `suppliers` VALUES (4,'RS','RS','http://rswww.com','a UK electronics supplier','http://uk.rs-online.com/web/search/searchBrowseAction.html?method=getProduct&R=%%PARTID%%'); INSERT INTO `suppliers` VALUES (5,'F','Farnell','http://www.farnell.com','a UK hardware supplier',''); INSERT INTO `suppliers` VALUES (6,'J','Jaycar','http://www.jaycar.com.au','an Oceania electronics supplier',''); INSERT INTO `suppliers` VALUES (7,'DSE','Dick Smith Electronics','http://www.dse.com.au','an Oceania electronics supplier',''); INSERT INTO `suppliers` VALUES (8,'H','Hardware Store','http://maps.google.com','your basic hardware store. if you cant find it here, please let us know!',''); INSERT INTO `suppliers` VALUES (9,'A','Amazon','http://www.amazon.com','they sell all sorts of stuff online','http://www.amazon.com/exec/obidos/ASIN/%%PARTID%%/reprresefoun-20'); INSERT INTO `suppliers` VALUES (10,'JA','Jameco','http://www.jameco.com','another excellent electronics supplier','http://www.jameco.com/webapp/wcs/stores/servlet/ProductDisplay?langId=-1&storeId=10001&catalogId=10001&productId=%%PARTID%%'); INSERT INTO `suppliers` VALUES (11,'FUT','Futurlec','http://www.futurlec.com/','Low cost online S.E. Asian electronics supplier',''); INSERT INTO `suppliers` VALUES (12,'DIY','Build It Yourself','http://www.makezine.com','Build it yourself! The hacker ethos.',''); INSERT INTO `suppliers` VALUES (13,'MCP','Microcontroller Pros','http://microcontrollershop.com/','A shop that sells alot of microcontroller based stuff.','http://microcontrollershop.com/product_info.php?products_id=%%PARTID%%'); INSERT INTO `suppliers` VALUES (14,'TCS','The Compleat Sculptor','http://www.sculpt.com','A sculpting and art supply store.','%%PARTID%%'); INSERT INTO `suppliers` VALUES (15,'GW','Greenweld','http://www.greenweld.co.uk/','A robotics supply and various oddities store.','%%PARTID%%'); INSERT INTO `suppliers` VALUES (16,'AP','Alpha Prototypes','http://www.alphaprototypes.com','A rapid prototyping and design firm.','http://www.alphaprototypes.com/'); INSERT INTO `suppliers` VALUES (17,'SPC','Star Prototype China','http://www.star-prototype-china.com/','A rapid prototyping and manufacturing firm.','http://www.star-prototype-china.com/'); INSERT INTO `suppliers` VALUES (18,'DK','Digikey','http://www.digikey.com','An electronics supplier.','http://www.digikey.com/scripts/DkSearch/dksus.dll?Detail?name=%%PARTID%%'); INSERT INTO `suppliers` VALUES (19,'AF','Adafruit Industries','http://www.adafruit.com','a cool, open source supporting electronics store','http://www.adafruit.com/index.php?main_page=product_info&products_id=%%PARTID%%'); INSERT INTO `suppliers` VALUES (20,'SFE','SparkFun Electronics','http://www.sparkfun.com','a nice electronics store that has lots of cool stuff','http://www.sparkfun.com/commerce/product_info.php?products_id=%%PARTID%%'); INSERT INTO `suppliers` VALUES (21,'SB','Solarbotics','http://www.solarbotics.com','a cool hobbyist store for electronics','http://www.solarbotics.com/products/%%PARTID%%/'); INSERT INTO `suppliers` VALUES (22,'AE','Allied Electronics','http://www.alliedelec.com','an online electronics distributor with good prices','http://www.alliedelec.com/Search/ProductDetail.asp?SKU=%%PARTID%%'); INSERT INTO `suppliers` VALUES (23,'NKC','NKC Electronics','http://www.nkcelectronics.com/','a cool online electronics store','%%PARTID%%'); INSERT INTO `suppliers` VALUES (24,'MAKE','MAKE Magazine','http://www.makezine.com','an awesome DIY community magazine that also sells stuff','http://www.makershed.com/ProductDetails.asp?ProductCode=%%PARTID%%'); INSERT INTO `suppliers` VALUES (25,'AMT','Arnold Magnetic Technologies','http://www.arnoldmagnetics.com','a site that sells various magnetic things','https://www.arnoldmagnetics.com/v2/sales/Product.aspx?id=%%PARTID%%'); INSERT INTO `suppliers` VALUES (26,'MAP','Maplin','http://www.maplin.co.uk','A UK highstreet and mail order parts supplier','http://www.maplin.co.uk/Search.aspx?criteria=%%PARTID%%'); -- -- Table structure for table `suppliers_to_countries` -- CREATE TABLE `suppliers_to_countries` ( `id` int(11) unsigned NOT NULL auto_increment, `supplier_id` int(11) NOT NULL, `country_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `supplier_id` (`supplier_id`,`country_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `suppliers_to_countries` -- -- -- Table structure for table `unique_parts` -- CREATE TABLE `unique_parts` ( `id` int(11) unsigned NOT NULL auto_increment, `type` varchar(32) NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `url` varchar(255) NOT NULL, `units` varchar(255) NOT NULL, `fudge_factor` double NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`,`name`) ) ENGINE=MyISAM AUTO_INCREMENT=356 DEFAULT CHARSET=utf8; -- -- Dumping data for table `unique_parts` -- INSERT INTO `unique_parts` VALUES (1,'belt','MXL','Material: Urethane/Kevlar Pitch: .08\" Width: 1/4\"','http://www.roymech.co.uk/Useful_Tables/Drive/Timing_belts.html','mm',0); INSERT INTO `unique_parts` VALUES (2,'component','A3977','an awesome microstepping driver. PLCC format','http://www.allegromicro.com/en/Products/Part_Numbers/3977/','',0); INSERT INTO `unique_parts` VALUES (3,'component','A3982','another cool stepper driver from allegro. SOIC format too!','http://www.allegromicro.com/en/Products/Part_Numbers/3982/','',0); INSERT INTO `unique_parts` VALUES (4,'component','78L05','a 5V voltage regulator','http://octopart.com/info/STMicroelectronics/L78L05ACZ','',0); INSERT INTO `unique_parts` VALUES (5,'component','7805DT','a 5V voltage regulator, SMT','','',0); INSERT INTO `unique_parts` VALUES (6,'component','L293D','a motor driver chip','http://octopart.com/info/Texas%20Instruments/L293DNE','',0); INSERT INTO `unique_parts` VALUES (7,'component','L297','a motor controller chip','','',0); INSERT INTO `unique_parts` VALUES (8,'component','L298N','a motor driver chip','http://octopart.com/info/STMicroelectronics/L298N','',0); INSERT INTO `unique_parts` VALUES (9,'component','1N4004','general purpose diode','http://octopart.com/info/Vishay/1N4004','',0); INSERT INTO `unique_parts` VALUES (10,'component','1N4005','general purpose diode','http://octopart.com/info/Vishay/1N4005','',0); INSERT INTO `unique_parts` VALUES (11,'component','1N4148','signal diode for various purposes','http://octopart.com/info/Fairchild/1N4148','',0); INSERT INTO `unique_parts` VALUES (12,'component','1N5817','schottky diode for blocking signals','','',0); INSERT INTO `unique_parts` VALUES (13,'component','TIP110','darlington power transistor','http://octopart.com/info/STMicroelectronics/TIP110','',0); INSERT INTO `unique_parts` VALUES (14,'component','TIP120','darlington power transistor','http://octopart.com/search?q=tip120','',0); INSERT INTO `unique_parts` VALUES (15,'component','PIC16F648A','the microcontroller','http://octopart.com/info/Microchip/PIC16F648A-I%2FP','',0); INSERT INTO `unique_parts` VALUES (16,'component','MAX232','a chip to help communicate with the serial port','http://octopart.com/info/Texas%20Instruments/MAX232N','',0); INSERT INTO `unique_parts` VALUES (17,'component','HCPL2631','a chip that provides optical isolation','http://octopart.com/info/Avago/HCPL-2631','',0); INSERT INTO `unique_parts` VALUES (18,'component','AS5040','a chip that provides magnetic rotary encoding (SMT)','http://octopart.com/info/Austriamicrosystems/AS5040','',0); INSERT INTO `unique_parts` VALUES (19,'component','Atmega168 tqfp','an awesome microcontroller that powers the arduino','','',0); INSERT INTO `unique_parts` VALUES (20,'component','Atmega644p tqfp','an awesome microcontroller that powers the sanguino','','',0); INSERT INTO `unique_parts` VALUES (21,'component','20 pin DIP socket','a DIP socket for mounting chips','http://octopart.com/info/3M/4820-3000-CP','',0); INSERT INTO `unique_parts` VALUES (22,'component','18 pin socket','a DIP socket for mounting the microcontroller','http://octopart.com/info/3M/4818-3000-CP','',0); INSERT INTO `unique_parts` VALUES (23,'component','16 pin DIP socket','a 16 pin socket to mount the RS232 chip in, just in case it gets fried.','http://octopart.com/info/3M/4816-3000-CP','',0); INSERT INTO `unique_parts` VALUES (24,'component','14 pin DIP socket','a socket to mount the chip in, just in case','http://octopart.com/info/3M/4814-3000-CP','',0); INSERT INTO `unique_parts` VALUES (25,'component','4700 uF electrolytic capacitor','power regulation capacitor. 25v or higher.','','',0); INSERT INTO `unique_parts` VALUES (26,'component','2200 uF electrolytic capacitor','power regulation capactor. 25v or higher.','','',0); INSERT INTO `unique_parts` VALUES (27,'component','1000 uF electrolytic capacitor','electrolytic capacitor','http://octopart.com/info/Nichicon/UVR1E102MPD','',0); INSERT INTO `unique_parts` VALUES (28,'component','470 uF electrolytic capacitor','electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (29,'component','100 uF electrolytic capacitor','electrolytic capacitor','http://octopart.com/info/Nichicon/UVR1E101MED','',0); INSERT INTO `unique_parts` VALUES (30,'component','10 uF electrolytic capacitor','electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (31,'component','1 uF electrolytic capacitor','electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (32,'component','.22 uF ceramic capacitor','ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (33,'component','100 nF ceramic capacitor','ceramic capacitor','http://octopart.com/info/AVX/5ZH104ZACJA','',0); INSERT INTO `unique_parts` VALUES (34,'component','10 nF ceramic capacitor','ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (35,'component','3.3 nF ceramic capacitor','ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (36,'component','1 nF ceramic capacitor','ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (37,'component','680 pF ceramic capacitor','ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (38,'component','180 ohm resistor','1/4 watt resistor','http://octopart.com/info/Arcol/291-180-RC','',0); INSERT INTO `unique_parts` VALUES (39,'component','220 ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (40,'component','330 ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (41,'component','560 ohm resistor','1/4 watt resistor','http://octopart.com/info/Arcol/291-560-RC','',0); INSERT INTO `unique_parts` VALUES (42,'component','680 ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (43,'component','0.5 ohm 2 watt resistor','2 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (44,'component','0.75 ohm 2 watt resistor','2 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (45,'component','1K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (46,'component','1.6K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (47,'component','1.8K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (48,'component','2K trimpot','a 2K ohm trimpot','','',0); INSERT INTO `unique_parts` VALUES (49,'component','10K trimpot','a 10K ohm trimpot','','',0); INSERT INTO `unique_parts` VALUES (50,'component','2.2K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (51,'component','2.7K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (52,'component','3.3K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (53,'component','4.7K ohm resistor','1/4 watt resistor','http://octopart.com/info/Arcol/291-4.7K-RC','',0); INSERT INTO `unique_parts` VALUES (54,'component','5.6K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (55,'component','10K ohm resistor','1/4 watt resistor','http://octopart.com/info/Arcol/291-10K-RC','',0); INSERT INTO `unique_parts` VALUES (56,'component','22K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (57,'component','100K ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (58,'component','1M ohm resistor','1/4 watt resistor','','',0); INSERT INTO `unique_parts` VALUES (59,'component','10K thermistor','10K ohm glass bead type, beta = 3480','http://octopart.com/info/Vishay/01T1002FP','',0); INSERT INTO `unique_parts` VALUES (60,'component','100K thermistor','100K ohm glass bead type, beta = 4066','','',0); INSERT INTO `unique_parts` VALUES (61,'component','4 pin molex connector','molex / disk drive style polarized power connector','http://octopart.com/info/Molex/15-24-4745','',0); INSERT INTO `unique_parts` VALUES (62,'component','9 pin DSUB','9-pin female PCB-mounting D connector','http://octopart.com/info/NorComp/182-009-213R531','',0); INSERT INTO `unique_parts` VALUES (63,'component','2 pin .200\" connector','eurostyle terminal blocks','http://octopart.com/info/Molex/880502','',0); INSERT INTO `unique_parts` VALUES (64,'component','4 pin .200\" terminal block','eurostyle terminal blocks','','',0); INSERT INTO `unique_parts` VALUES (65,'component','6 pin .200\" terminal block','eurostyle terminal blocks','','',0); INSERT INTO `unique_parts` VALUES (66,'component','8 pin .200\" terminal block','eurostyle terminal blocks','','',0); INSERT INTO `unique_parts` VALUES (67,'component','12 pin .200\" terminal block','eurostyle terminal blocks','','',0); INSERT INTO `unique_parts` VALUES (68,'component','.100 shunt','shunt connecter aka motherboard jumpers','http://octopart.com/info/3M/929952-10','',0); INSERT INTO `unique_parts` VALUES (69,'component','.100 breakaway header','male breakaway headers','','',0); INSERT INTO `unique_parts` VALUES (70,'component','.100 breakaway header (right-angle)','male breakaway headers (with a 90 degree bend)','','',0); INSERT INTO `unique_parts` VALUES (71,'component','2 pin header','signal connector','http://octopart.com/info/Molex/22-23-2021','',0); INSERT INTO `unique_parts` VALUES (72,'component','2 pin housing','connector housing','http://octopart.com/info/Molex/22-01-3027','',0); INSERT INTO `unique_parts` VALUES (73,'component','3 pin header','signal connector','http://octopart.com/info/Molex/22-23-2031','',0); INSERT INTO `unique_parts` VALUES (74,'component','3 pin housing','connector housing','http://octopart.com/info/Molex/22-01-3037','',0); INSERT INTO `unique_parts` VALUES (75,'component','4 pin header','motor connector','http://octopart.com/info/Molex/22-23-2041','',0); INSERT INTO `unique_parts` VALUES (76,'component','4 pin housing','connector housing','http://octopart.com/info/Molex/22-01-3047','',0); INSERT INTO `unique_parts` VALUES (77,'component','4 pin female header','.100\" make header plugs into this.','http://octopart.com/info/3M/929974-01-04','',0); INSERT INTO `unique_parts` VALUES (78,'component','6 pin female header','.100\" make header plugs into this.','','',0); INSERT INTO `unique_parts` VALUES (79,'component','8 pin female header','.100\" make header plugs into this.','','',0); INSERT INTO `unique_parts` VALUES (80,'component','10 pin female header','.100\" make header plugs into this.','','',0); INSERT INTO `unique_parts` VALUES (81,'component','20 pin female header','.100\" make header plugs into this.','','',0); INSERT INTO `unique_parts` VALUES (82,'component','22 pin female header','.100\" make header plugs into this.','','',0); INSERT INTO `unique_parts` VALUES (83,'component','12 pin header','power connector','http://octopart.com/info/Molex/22-23-2121','',0); INSERT INTO `unique_parts` VALUES (84,'component','12 pin housing','connector housing','http://octopart.com/info/Molex/22-01-3127','',0); INSERT INTO `unique_parts` VALUES (85,'component','crimp-on terminals','crimp-on terminals for connections','http://octopart.com/info/Molex/08-50-0114','',0); INSERT INTO `unique_parts` VALUES (86,'component','3mm green LED','a small green led','','',0); INSERT INTO `unique_parts` VALUES (87,'component','3mm red LED','a small red led','','',0); INSERT INTO `unique_parts` VALUES (88,'component','5mm green LED','a standard green led','','',0); INSERT INTO `unique_parts` VALUES (89,'component','5mm red LED','a standard red led','','',0); INSERT INTO `unique_parts` VALUES (90,'component','big heat sink','heatsink for motor driver','http://octopart.com/info/Aavid%20Thermalloy/566010B03400G','',0); INSERT INTO `unique_parts` VALUES (91,'component','small heat sink','heatsink for power transistor','http://octopart.com/info/Wakefield/290-1AB','',0); INSERT INTO `unique_parts` VALUES (92,'component','H21LOI','Optoswitch (inverting)','http://octopart.com/info/Fairchild/H21LOI','',0); INSERT INTO `unique_parts` VALUES (93,'component','H21LOB','Optoswitch (non-inverting)','http://octopart.com/info/Fairchild/H21LOB','',0); INSERT INTO `unique_parts` VALUES (94,'component','Bicolor LED','a two color LED that lights green for one polarity, and red for the opposite polarity','http://octopart.com/info/Kingbright/WP937EGW','',0); INSERT INTO `unique_parts` VALUES (95,'component','SB360','a schottky diode 3A / 60V','','',0); INSERT INTO `unique_parts` VALUES (96,'component','74HC00N','Quad NAND Gate','http://octopart.com/search?q=74HC00N','',0); INSERT INTO `unique_parts` VALUES (97,'component','74HC04N','Hex Inverter','http://octopart.com/search?q=74HC04N','',0); INSERT INTO `unique_parts` VALUES (98,'component','.156\" header','a high power header connector','','',0); INSERT INTO `unique_parts` VALUES (99,'component','.156\" 2 position housing','a high power header connector','','',0); INSERT INTO `unique_parts` VALUES (100,'component','.156\" 4 position housing','a high power header connector','','',0); INSERT INTO `unique_parts` VALUES (101,'component','.156\" crimp-on connector','crimp on connectors for the high power connector','','',0); INSERT INTO `unique_parts` VALUES (102,'component','Omron B3F-1000 Button','a simple pushbutton','http://octopart.com/search?q=b3f-1000','',0); INSERT INTO `unique_parts` VALUES (103,'component','AD595','thermocouple amplifier','http://octopart.com/search?q=ad595aq','',0); INSERT INTO `unique_parts` VALUES (104,'component','Type K Thermocouple','a thermocouple','','',0); INSERT INTO `unique_parts` VALUES (105,'component','6 pin IDC header','a 2 row, 6 pin, polarized IDC header','','',0); INSERT INTO `unique_parts` VALUES (106,'component','6 pin IDC connector','a 2 row, 6 pin, polarized IDC connector.','','',0); INSERT INTO `unique_parts` VALUES (107,'component','10 pin IDC header','a 2 row, 10 pin polarized IDC header.','','',0); INSERT INTO `unique_parts` VALUES (108,'component','10 pin IDC connector','a 2 row, 10 pin polarized IDC connector.','','',0); INSERT INTO `unique_parts` VALUES (109,'component','100uF electrolytic capacitor D55','a surface mount electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (110,'component','10uF electrolytic capacitor D55','a surface mount electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (111,'component','1uF electrolytic capacitor D55','a surface mount electrolytic capacitor','','',0); INSERT INTO `unique_parts` VALUES (112,'component','.22uF ceramic capacitor 1206','a surface mount ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (113,'component','100nF ceramic capacitor 1206','a surface mount ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (114,'component','10nF ceramic capacitor 1206','a surface mount ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (115,'component','1nF ceramic capacitor 1206','a surface mount ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (116,'component','15pF ceramic capacitor 1206','a surface mount ceramic capacitor','','',0); INSERT INTO `unique_parts` VALUES (117,'component','AS5040','a surface mount magnetic rotary encoder chip','','',0); INSERT INTO `unique_parts` VALUES (118,'component','Green LED 1206','a surface mount LED','','',0); INSERT INTO `unique_parts` VALUES (119,'component','Red LED 1206','a surface mount LED','','',0); INSERT INTO `unique_parts` VALUES (120,'component','180 ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (121,'component','220 ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (122,'component','560 ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (123,'component','1k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (124,'component','1.8k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (125,'component','2.2k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (126,'component','3.3k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (127,'component','4.7k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (128,'component','10k ohm resistor 1206','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (129,'component','0.25 ohm resistor 2512','a surface mount resistor','','',0); INSERT INTO `unique_parts` VALUES (130,'component','30 ohm resistor 5W','a 5W wirewound resistor','','',0); INSERT INTO `unique_parts` VALUES (131,'component','RJ45 Jack','a jack for RJ45 plugs','','',0); INSERT INTO `unique_parts` VALUES (132,'component','4 pos DIP switch','a 4 position dip switch','','',0); INSERT INTO `unique_parts` VALUES (133,'component','Ferrite Bead EMI Suppressor','a ferrite bead EMI/RFI suppression device','','',0); INSERT INTO `unique_parts` VALUES (134,'component','78L33Z','a 3.3v linear regulator, T0-92 format','','',0); INSERT INTO `unique_parts` VALUES (135,'component','3M sd card socket','a socket for SD cards','','',0); INSERT INTO `unique_parts` VALUES (136,'component','SN75176A','a line driver for RS485','','',0); INSERT INTO `unique_parts` VALUES (137,'component','10K ohm trimpot SMT 4mm','a SMD trimpot','','',0); INSERT INTO `unique_parts` VALUES (138,'component','NIF5002','a SMD n-channel MOSFET','','',0); INSERT INTO `unique_parts` VALUES (139,'component','NIF5003','a SMD n-channel MOSFET','','',0); INSERT INTO `unique_parts` VALUES (140,'component','16Mhz crystal SMD','a SMD crystal','','',0); INSERT INTO `unique_parts` VALUES (141,'component','16Mhz crystal','a quartz crystal for the arduino clock','','',0); INSERT INTO `unique_parts` VALUES (142,'component','SN75176A SOIC','a RS485 transciever','','',0); INSERT INTO `unique_parts` VALUES (143,'component','A3949 SOIC','a H bridge','','',0); INSERT INTO `unique_parts` VALUES (144,'component','MBRA140','an SMT diode','','',0); INSERT INTO `unique_parts` VALUES (145,'component','78L33 SOT89','an SMT linear voltage regulator.','','',0); INSERT INTO `unique_parts` VALUES (146,'component','ATX Motherboard Header','a header that accepts the 20-pin ATX motherboard connector','','',0); INSERT INTO `unique_parts` VALUES (147,'component','SPDT switch','a slide/toggle switch','','',0); INSERT INTO `unique_parts` VALUES (148,'fast','M3 nut','','','',0); INSERT INTO `unique_parts` VALUES (149,'fast','M3 washer','','','',0); INSERT INTO `unique_parts` VALUES (150,'fast','M3 x 10 cap','','','',0); INSERT INTO `unique_parts` VALUES (151,'fast','M3 x 15 cap','','','',0); INSERT INTO `unique_parts` VALUES (152,'fast','M3 x 25 cap','','','',0); INSERT INTO `unique_parts` VALUES (153,'fast','M3 x 30 cap','','','',0); INSERT INTO `unique_parts` VALUES (154,'fast','M3 x 35 cap','','','',0); INSERT INTO `unique_parts` VALUES (155,'fast','M3 x 40 cap','','','',0); INSERT INTO `unique_parts` VALUES (156,'fast','M3 x 50 cap','','','',0); INSERT INTO `unique_parts` VALUES (157,'fast','M5 nut','','','',0); INSERT INTO `unique_parts` VALUES (158,'fast','M5 washer','','','',0); INSERT INTO `unique_parts` VALUES (159,'fast','M5 x 15 cap','','','',0); INSERT INTO `unique_parts` VALUES (160,'fast','M5 x 20 cap','','','',0); INSERT INTO `unique_parts` VALUES (161,'fast','M5 x 25 cap','','','',0); INSERT INTO `unique_parts` VALUES (162,'fast','M5 x 30 cap','','','',0); INSERT INTO `unique_parts` VALUES (163,'fast','M5 x 40 cap','','','',0); INSERT INTO `unique_parts` VALUES (164,'fast','M5 x 50 cap','','','',0); INSERT INTO `unique_parts` VALUES (165,'fast','M5 x 8 grub','','','',0); INSERT INTO `unique_parts` VALUES (166,'fast','M8 nut','','','',0); INSERT INTO `unique_parts` VALUES (167,'fast','M8 washer','','','',0); INSERT INTO `unique_parts` VALUES (168,'fast','5/16\" x 3/4\" machine screw','','','',0); INSERT INTO `unique_parts` VALUES (169,'fast','5/16\" nut','','','',0); INSERT INTO `unique_parts` VALUES (170,'fast','5/16\" washer','','','',0); INSERT INTO `unique_parts` VALUES (171,'fast','1/2\" x 1.25\" machine screw','','','',0); INSERT INTO `unique_parts` VALUES (172,'fast','1/2\" nut','','','',0); INSERT INTO `unique_parts` VALUES (173,'fast','1/2\" washer','','','',0); INSERT INTO `unique_parts` VALUES (174,'fast','Coupling Nut 1/4-20','','','',0); INSERT INTO `unique_parts` VALUES (175,'fast','Self Tapping Screw 10-24 x 3/4\"','','','',0); INSERT INTO `unique_parts` VALUES (176,'fast','Small Nails','','','',0); INSERT INTO `unique_parts` VALUES (177,'lasercut','MCB v1.2 X Stage','the lasercut X stage for the McWire Cartesian Bot','','',0); INSERT INTO `unique_parts` VALUES (178,'lasercut','MCB v1.2 Y Stage','the lasercut Y stage for the McWire Cartesian Bot','','',0); INSERT INTO `unique_parts` VALUES (179,'lasercut','MCB v1.2 Z Stage','the lasercut Z stage for the McWire Cartesian Bot','','',0); INSERT INTO `unique_parts` VALUES (180,'lasercut','MCB v1.2 Vertical Base','the lasercut vertical base','','',0); INSERT INTO `unique_parts` VALUES (181,'lasercut','MCB v1.2 Bearing Arm','the lasercut bearing for the McWire Cartesian Bot','','',0); INSERT INTO `unique_parts` VALUES (182,'lasercut','MCB v1.2 Vertical Bearing Arm','the lasercut bearing for the McWire Cartesian Bot','','',0); INSERT INTO `unique_parts` VALUES (183,'lasercut','MCB v1.2 Endstop Mount','mount pad for opto endstop.','','',0); INSERT INTO `unique_parts` VALUES (184,'machined','PTFE Insulator','8mm PTFE Rod','http://reprap.org/bin/view/Main/ExtruderMechanicalParts#The_PTFE_holder','',0); INSERT INTO `unique_parts` VALUES (185,'machined','Heater Barrel','M6 brass/steel/aluminum studding','http://reprap.org/bin/view/Main/ExtruderMechanicalParts#The_brass_barrel','',0); INSERT INTO `unique_parts` VALUES (186,'machined','Extruder Nozzle','M6 dome nut (brass/steel/aluminum)','http://reprap.org/bin/view/Main/ExtruderMechanicalParts#The_dome_nut_nozzle','',0); INSERT INTO `unique_parts` VALUES (187,'machined','Flexible Drive Shaft','3mm / 1/8\" diameter steel wire / rope','http://reprap.org/bin/view/Main/ExtruderMechanicalParts#The_drive_screw','',0); INSERT INTO `unique_parts` VALUES (188,'machined','Half Bearing','a bearing for the extruder drive shaft','http://www.reprap.org/bin/view/Main/ExtruderMechanicalParts#The_half_bearings','',0); INSERT INTO `unique_parts` VALUES (189,'machined','Screw Drive','the studded rod that feeds the plastic filament','http://www.reprap.org/bin/view/Main/ExtruderMechanicalParts#The_drive_screw','',0); INSERT INTO `unique_parts` VALUES (190,'misc','CAPA','also known as Friendly Plastic, or Polymorph','http://reprap.org/bin/view/Main/Polymorph','g',0); INSERT INTO `unique_parts` VALUES (191,'misc','Serial Cable or USB -> Serial converter','this cable connects your computer to your RepRap','','',0); INSERT INTO `unique_parts` VALUES (192,'misc','Plastic Bag','pretty much any plastic bag will work. used as molding release','','',0); INSERT INTO `unique_parts` VALUES (193,'misc','High Temp Epoxy','JB Weld works great!','','g',0); INSERT INTO `unique_parts` VALUES (194,'misc','PTFE Tape','white Plumber\'s thread seal tape. very smooth.','','mm',0); INSERT INTO `unique_parts` VALUES (195,'misc','Thermoplastic','HDPE, or CAPA will work well. comes in 5 lb coils','http://reprap.org/bin/view/Main/PrintingMaterials','g',0); INSERT INTO `unique_parts` VALUES (196,'misc','3mm ID Silicon Tubing','used as a spring and/or motor coupling','','mm',0); INSERT INTO `unique_parts` VALUES (197,'misc','Fan','a standard computer fan','','',0); INSERT INTO `unique_parts` VALUES (198,'misc','Spring','generic steel spring','','',0); INSERT INTO `unique_parts` VALUES (199,'misc','Grease','general lubricating grease. oil probably works too.','','',0); INSERT INTO `unique_parts` VALUES (200,'misc','MDF / Wood Bed','a flat piece of wood for use as the build base','','',0); INSERT INTO `unique_parts` VALUES (201,'misc','zip tie','a little piece of plastic that loops around and locks into place to easily attach stuff.','','',0); INSERT INTO `unique_parts` VALUES (202,'misc','3/4\" x 3/4\" Aluminum Channel','','','inch',0); INSERT INTO `unique_parts` VALUES (203,'misc','1.5\" x 1.5\" Aluminum Angle','','','inch',0); INSERT INTO `unique_parts` VALUES (204,'misc','.5\" x .125\" PTFE strip','ptfe strip for linear bearings','','inch',0); INSERT INTO `unique_parts` VALUES (205,'misc','Skate Bearing','','','',0); INSERT INTO `unique_parts` VALUES (206,'misc','U Clamp','','','',0); INSERT INTO `unique_parts` VALUES (207,'misc','1.5\" angle iron','','','inch',0); INSERT INTO `unique_parts` VALUES (208,'misc','1/4\" ID Silicon Tubing','','','inch',0); INSERT INTO `unique_parts` VALUES (209,'misc','4\" Extension Spring','','','',0); INSERT INTO `unique_parts` VALUES (210,'misc','AS5040 magnet','Diametric Magnet, NdFeB, D6x2.5 mm, Supplier: Arnold Magnetics, RoHS/ Pb-free','http://www.austriamicrosystems.com/03products/products_detail/AS5040/download_AS5040.htm?#magnet_datasheet','',0); INSERT INTO `unique_parts` VALUES (211,'module','RepRap v1.0 \"Darwin\"','The entire RepRap machine, ready to print.','http://reprap.org/bin/view/Main/RepRapOneDarwin','',0); INSERT INTO `unique_parts` VALUES (212,'module','Cartesian Robot v1.0','The 3D positioning system, ready to position.','http://reprap.org/bin/view/Main/RepRapOneDarwin#Cartesian_robot','',0); INSERT INTO `unique_parts` VALUES (213,'module','Thermoplast Extruder v1.0','The thermoplastic extruder, ready to extrude.','http://reprap.org/bin/view/Main/RepRapOneDarwinThermoplastExtruder','',0); INSERT INTO `unique_parts` VALUES (214,'module','Thermoplast Extruder v1.1','The thermoplastic extruder, ready to extrude.','http://reprap.org/bin/view/Main/RepRapOneDarwinThermoplastExtruder','',0); INSERT INTO `unique_parts` VALUES (215,'module','Support Extruder v1.0','The support extruder, ready to extrude support material.','http://reprap.org/bin/view/Main/SupportExtruder_1_0','',0); INSERT INTO `unique_parts` VALUES (216,'module','Universal Controller v1.2','The universal controller, ready to be specialized.','http://reprap.org/bin/view/Main/UniversalControllerBoard_1_2','',0); INSERT INTO `unique_parts` VALUES (217,'module','Stepper Controller v1.2','The stepper controller, ready to control an axis.','http://reprap.org/bin/view/Main/DarwinStepperController_1_2','',0); INSERT INTO `unique_parts` VALUES (218,'module','Extruder Controller v1.2','The extruder controller, ready to control an extruder.','http://reprap.org/bin/view/Main/DarwinExtruderController_1_2','',0); INSERT INTO `unique_parts` VALUES (219,'module','Extruder Controller v2.0','The extruder controller, ready to control an extruder.','http://make.rrrf.org/ec-2.0','',0); INSERT INTO `unique_parts` VALUES (220,'module','Extruder Controller v2.1','The extruder controller, ready to control an extruder.','http://make.rrrf.org/ec-2.1','',0); INSERT INTO `unique_parts` VALUES (221,'module','PowerComms Board v1.2','The power/communications board, ready to provide power and communications.','http://reprap.org/bin/view/Main/DarwinPowerAndCommunicationsCard_1_2','',0); INSERT INTO `unique_parts` VALUES (222,'module','PowerComms Board v1.3','The power/communications board, ready to provide power and communications. Now with blinkenlights.','http://reprap.org/bin/view/Main/PowerCommsBoard_1_3','',0); INSERT INTO `unique_parts` VALUES (223,'module','Opto Endstop v1.0','The opto endstop board, ready to provide endstops.','http://reprap.org/bin/view/Main/DarwinOptoEndstop','',0); INSERT INTO `unique_parts` VALUES (224,'module','Opto Endstop v2.0','The opto endstop board, ready to provide endstops.','http://make.rrrf.org/oes-2.0','',0); INSERT INTO `unique_parts` VALUES (225,'module','Opto Endstop v2.1','The opto endstop board, ready to provide endstops.','http://make.rrrf.org/oes-2.1','',0); INSERT INTO `unique_parts` VALUES (226,'module','Opto Endstop v2.2','The opto endstop board, ready to provide endstops.','http://make.rrrf.org/oes-2.2','',0); INSERT INTO `unique_parts` VALUES (227,'module','Stepper Tester v1.0','The stepper tester, ready to test and blink.','http://reprap.org/bin/view/Main/StepperTester_1_0','',0); INSERT INTO `unique_parts` VALUES (228,'module','Extra Parts Kit','Extra parts, in case you dont trust yourself.','','',0); INSERT INTO `unique_parts` VALUES (229,'module','Pulley Molds Kit','Pulley molds, if you want to make your own pulleys.','http://reprap.org/bin/view/Main/AssemblingDarwinMachinery#Toothed_pulley_moulding','',0); INSERT INTO `unique_parts` VALUES (230,'module','Tools Kit','Tools you will need to build a RepRap.','','',0); INSERT INTO `unique_parts` VALUES (231,'module','RepStrap v1.0 \"Seedling\"','This is an easy to build repstrap machine to get you printing','http://make.rrrf.org/rss-1.0','',0); INSERT INTO `unique_parts` VALUES (232,'module','Arduino Based Electronics','These are the 2nd generation electronics','http://make.rrrf.org/electronics-2.0','',0); INSERT INTO `unique_parts` VALUES (233,'module','PWM Driver v1.0','This board allows you to drive 3 channels of up to 5A each','http://make.rrrf.org/pd-1.0','',0); INSERT INTO `unique_parts` VALUES (234,'module','PWM Driver v1.1','This board allows you to drive 3 channels of up to 5A each','http://make.rrrf.org/pwd-1.1','',0); INSERT INTO `unique_parts` VALUES (235,'module','DC Motor Driver v1.0','This board allows you to drive 2 small dc motors.','http://make.rrrf.org/dcmd-1.0','',0); INSERT INTO `unique_parts` VALUES (236,'module','DC Motor Driver v1.1','This board allows you to drive 2 small dc motors. now with leds!','http://make.rrrf.org/dcmd-1.1','',0); INSERT INTO `unique_parts` VALUES (237,'module','Stepper Motor Driver v1.0','This board allows you to control one stepper motor','http://make.rrrf.org/smd-1.0','',0); INSERT INTO `unique_parts` VALUES (238,'module','Stepper Motor Driver v1.1','This board allows you to control one stepper motor (with LED\'s now!)','http://make.rrrf.org/smd-1.1','',0); INSERT INTO `unique_parts` VALUES (239,'module','Stepper Motor Driver v1.2','This board allows you to control one stepper motor (with LED\'s now!)','http://make.rrrf.org/smd-1.2','',0); INSERT INTO `unique_parts` VALUES (240,'module','Stepper Motor Driver v2.0','New and improved stepper motor driver board based on A3977','http://make.rrrf.org/smd-2.0','',0); INSERT INTO `unique_parts` VALUES (241,'module','Stepper Motor Driver v2.1','New and improved stepper motor driver board based on A3979','http://make.rrrf.org/smd-2.1','',0); INSERT INTO `unique_parts` VALUES (242,'module','Stepper Motor Driver v2.2','New and improved stepper motor driver board based on A3982','http://make.rrrf.org/smd-2.2','',0); INSERT INTO `unique_parts` VALUES (243,'module','Stepper Motor Driver v2.3','New and improved stepper motor driver board based on A3982','http://make.rrrf.org/smd-2.3','',0); INSERT INTO `unique_parts` VALUES (244,'module','Temperature Sensor v1.0','this board does temperature monitoring','http://make.rrrf.org/ts-1.0','',0); INSERT INTO `unique_parts` VALUES (245,'module','Temperature Sensor v1.1','this board does temperature monitoring','http://make.rrrf.org/ts-1.1','',0); INSERT INTO `unique_parts` VALUES (246,'module','Temperature Sensor v2.0','this board does temperature monitoring','http://make.rrrf.org/ts-2.0','',0); INSERT INTO `unique_parts` VALUES (247,'module','McWire Cartesian Bot v1.2','this is a cartesian positioning system for printing','http://make.rrrf.org/mcb-1.2','',0); INSERT INTO `unique_parts` VALUES (248,'module','Arduino','this is an easy to program microcontroller board based around the atmega168','http://www.arduino.cc','',0); INSERT INTO `unique_parts` VALUES (249,'module','Arduino Breakout v1.0','a breakout board for the arduino for easier wiring - never released','http://make.rrrf.org/ab-1.0','',0); INSERT INTO `unique_parts` VALUES (250,'module','Arduino Breakout v1.1','a breakout board for the arduino for easier wiring','http://make.rrrf.org/ab-1.1','',0); INSERT INTO `unique_parts` VALUES (251,'module','Arduino Breakout v1.2','a breakout board for the arduino for easier wiring','http://make.rrrf.org/ab-1.2','',0); INSERT INTO `unique_parts` VALUES (252,'module','Arduino Breakout v1.3','a breakout board for the arduino for easier wiring','http://make.rrrf.org/ab-1.3','',0); INSERT INTO `unique_parts` VALUES (253,'module','Arduino Breakout v1.4','a breakout board for the arduino for easier wiring','http://make.rrrf.org/ab-1.4','',0); INSERT INTO `unique_parts` VALUES (254,'module','Thermocouple Sensor v1.0','an easy to use, high temperature sensor','http://make.rrrf.org/tcs-1.0','',0); INSERT INTO `unique_parts` VALUES (255,'module','Opto Isolator v1.0','an optical isolator','http://make.rrrf.org/oi-1.0','',0); INSERT INTO `unique_parts` VALUES (256,'module','Opto Isolator v1.1','an optical isolator','http://make.rrrf.org/oi-1.1','',0); INSERT INTO `unique_parts` VALUES (257,'module','Magnetic Rotary Encoder v1.0','a magnetic rotary encoder board','http://make.rrrf.org/mre-1.0','',0); INSERT INTO `unique_parts` VALUES (258,'module','GM3 Noise Suppressor v1.0','an electronic noise suppressor for the GM3 gearmotor','http://make.rrrf.org/gns-1.0','',0); INSERT INTO `unique_parts` VALUES (259,'module','RepRap Motherboard v1.1','a board to control the steppers and various extruders','http://make.sanguino.cc/rmb-1.1','',0); INSERT INTO `unique_parts` VALUES (260,'motor','Extruder Motor','Pololu GM3 (200:1 geared motor)','http://en.wikipedia.org/wiki/Electric_motor#DC_motors','',0); INSERT INTO `unique_parts` VALUES (261,'motor','Stepper Motor','bipolar, 0.9 step angle','http://en.wikipedia.org/wiki/Stepper_motor','',0); INSERT INTO `unique_parts` VALUES (262,'pcb','Universal Controller v1.2 PCB','controls an extruder or stepper motor','http://www.reprap.org/bin/view/Main/UniversalControllerBoard_1_2','',0); INSERT INTO `unique_parts` VALUES (263,'pcb','PowerComms v1.2 PCB','supplies power and communications between boards','http://reprap.org/bin/view/Main/DarwinPowerAndCommunicationsCard_1_2','',0); INSERT INTO `unique_parts` VALUES (264,'pcb','PowerComms v1.3 PCB','supplies power and communications between boards','http://reprap.org/bin/view/Main/PowerCommsBoard_1_3','',0); INSERT INTO `unique_parts` VALUES (265,'pcb','Opto Endstop v1.0 PCB','signals when the limit of an axes has been reached','http://reprap.org/bin/view/Main/DarwinOptoEndstop','',0); INSERT INTO `unique_parts` VALUES (266,'pcb','Opto Endstop v2.0 PCB','signals when the limit of an axes has been reached','http://make.rrrf.org/oes-2.0','',0); INSERT INTO `unique_parts` VALUES (267,'pcb','Opto Endstop v2.1 PCB','signals when the limit of an axes has been reached','http://make.rrrf.org/oes-2.1','',0); INSERT INTO `unique_parts` VALUES (268,'pcb','Opto Endstop v2.2 PCB','signals when the limit of an axes has been reached','http://make.rrrf.org/oes-2.2','',0); INSERT INTO `unique_parts` VALUES (269,'pcb','Stepper Tester v1.0 PCB','tests a universal controller board','http://reprap.org/bin/view/Main/StepperTester_1_0','',0); INSERT INTO `unique_parts` VALUES (270,'pcb','PWM Driver v1.0 PCB','drives 3 TIP120 power transistors','http://make.rrrf.org/pd-1.0','',0); INSERT INTO `unique_parts` VALUES (271,'pcb','PWM Driver v1.1 PCB','drives 3 TIP120 power transistors','http://make.rrrf.org/pwd-1.1','',0); INSERT INTO `unique_parts` VALUES (272,'pcb','DC Motor Driver v1.0 PCB','drives 2 small dc motors','http://make.rrrf.org/dcmd-1.0','',0); INSERT INTO `unique_parts` VALUES (273,'pcb','DC Motor Driver v1.1 PCB','drives 2 small dc motors (now with LEDs)','http://make.rrrf.org/dcmd-1.1','',0); INSERT INTO `unique_parts` VALUES (274,'pcb','Stepper Motor Driver v1.0 PCB','this board will drive a stepper motor','http://make.rrrf.org/smd-1.0','',0); INSERT INTO `unique_parts` VALUES (275,'pcb','Stepper Motor Driver v1.1 PCB','this board will drive a stepper motor (with blinky lights)','http://make.rrrf.org/smd-1.1','',0); INSERT INTO `unique_parts` VALUES (276,'pcb','Stepper Motor Driver v1.2 PCB','this board will drive a stepper motor (with blinky lights)','http://make.rrrf.org/smd-1.2','',0); INSERT INTO `unique_parts` VALUES (277,'pcb','Stepper Motor Driver v2.0 PCB','new and improved stepper motor driver board based on A3977','http://make.rrrf.org/smd-2.0','',0); INSERT INTO `unique_parts` VALUES (278,'pcb','Stepper Motor Driver v2.1 PCB','new and improved stepper motor driver board based on A3979','http://make.rrrf.org/smd-2.1','',0); INSERT INTO `unique_parts` VALUES (279,'pcb','Stepper Motor Driver v2.2 PCB','new and improved stepper motor driver board based on A3982','http://make.rrrf.org/smd-2.2','',0); INSERT INTO `unique_parts` VALUES (280,'pcb','Stepper Motor Driver v2.3 PCB','new and improved stepper motor driver board based on A3982','http://make.rrrf.org/smd-2.3','',0); INSERT INTO `unique_parts` VALUES (281,'pcb','Temperature Sensor v1.0 PCB','this board houses the temperature sensor','http://make.rrrf.org/ts-1.0','',0); INSERT INTO `unique_parts` VALUES (282,'pcb','Temperature Sensor v1.1 PCB','this board houses the temperature sensor','http://make.rrrf.org/ts-1.1','',0); INSERT INTO `unique_parts` VALUES (283,'pcb','Temperature Sensor v2.0 PCB','this board houses the temperature sensor','http://make.rrrf.org/ts-2.0','',0); INSERT INTO `unique_parts` VALUES (284,'pcb','Arduino Breakout v1.0 PCB','a breakout board for an Arduino - never publically released','http://make.rrrf.org/ab-1.0','',0); INSERT INTO `unique_parts` VALUES (285,'pcb','Arduino Breakout v1.1 PCB','a breakout board for an Arduino','http://make.rrrf.org/ab-1.1','',0); INSERT INTO `unique_parts` VALUES (286,'pcb','Arduino Breakout v1.2 PCB','a breakout board for an Arduino','http://make.rrrf.org/ab-1.2','',0); INSERT INTO `unique_parts` VALUES (287,'pcb','Arduino Breakout v1.3 PCB','a breakout board for an Arduino','http://make.rrrf.org/ab-1.3','',0); INSERT INTO `unique_parts` VALUES (288,'pcb','Arduino Breakout v1.4 PCB','a breakout board for an Arduino','http://make.rrrf.org/ab-1.4','',0); INSERT INTO `unique_parts` VALUES (289,'pcb','Thermocouple Sensor v1.0 PCB','a high temperature sensor','http://make.rrrf.org/tcs-1.0','',0); INSERT INTO `unique_parts` VALUES (290,'pcb','Opto Isolator v1.0 PCB','an optical isolator','http://make.rrrf.org/oi-1.0','',0); INSERT INTO `unique_parts` VALUES (291,'pcb','Opto Isolator v1.1 PCB','an optical isolator','http://make.rrrf.org/oi-1.1','',0); INSERT INTO `unique_parts` VALUES (292,'pcb','Magnetic Rotary Encoder v1.0 PCB','a magnetic rotary encoder','http://make.rrrf.org/mre-1.0','',0); INSERT INTO `unique_parts` VALUES (293,'pcb','GM3 Noise Suppressor v1.0 PCB','an electronic noise suppressor for the GM3 gearmotor','http://make.rrrf.org/gns-1.0','',0); INSERT INTO `unique_parts` VALUES (294,'pcb','Extruder Controller v2.0 PCB','a board for controlling an extruder','http://make.rrrf.org/ec-2.0','',0); INSERT INTO `unique_parts` VALUES (295,'pcb','Extruder Controller v2.1 PCB','a board for controlling an extruder','http://make.rrrf.org/ec-2.1','',0); INSERT INTO `unique_parts` VALUES (296,'pcb','RepRap Motherboard v1.1 PCB','a board to control the steppers and various extruders','http://make.sanguino.cc/rmb-1.1','',0); INSERT INTO `unique_parts` VALUES (297,'plumbing','Pipe Cap, Cast Iron','','','',0); INSERT INTO `unique_parts` VALUES (298,'plumbing','3\" Nipple, Galvanized Steel','','','',0); INSERT INTO `unique_parts` VALUES (299,'plumbing','6\" Nipple, Galvanized Steel','','','',0); INSERT INTO `unique_parts` VALUES (300,'plumbing','9\" Nipple, Galvanized Steel','','','',0); INSERT INTO `unique_parts` VALUES (301,'plumbing','12\" Nipple, Galvanized Steel','','','',0); INSERT INTO `unique_parts` VALUES (302,'plumbing','Black Steel 90deg Elbow','','','',0); INSERT INTO `unique_parts` VALUES (303,'plumbing','Flange, Cast Iron','','','',0); INSERT INTO `unique_parts` VALUES (304,'plumbing','Iron Tee','','','',0); INSERT INTO `unique_parts` VALUES (305,'pulley','X toothed pulley','a small pulley for the X axis','http://www.roymech.co.uk/Useful_Tables/Drive/Timing_belts.html','',0); INSERT INTO `unique_parts` VALUES (306,'pulley','Y toothed pulley','a small pulley for the Y axis','http://www.roymech.co.uk/Useful_Tables/Drive/Timing_belts.html','',0); INSERT INTO `unique_parts` VALUES (307,'pulley','Z toothed pulley','a medium sized pulley for the Z axis','http://www.roymech.co.uk/Useful_Tables/Drive/Timing_belts.html','',0); INSERT INTO `unique_parts` VALUES (308,'rp','Printing Service','Here are suppliers that will actually print the parts you need. It\'s a bit pricey though...','','',0); INSERT INTO `unique_parts` VALUES (309,'rod','8mm','8mm smooth rod. 5/16\" is a good equivalent.','','mm',0); INSERT INTO `unique_parts` VALUES (310,'stud','M3','3mm threaded rod. equivalent = ?','','mm',0); INSERT INTO `unique_parts` VALUES (311,'stud','M8','8mm threaded rod. 5/16\" is a good equivalent','','mm',0); INSERT INTO `unique_parts` VALUES (312,'stud','1/4\"-20','1/4\" threaded rod, 20 threads per inche','','in',0); INSERT INTO `unique_parts` VALUES (313,'tool','Drill Press','a drill press will help you get much more accurate drills','http://web.mit.edu/2.670/www/Tutorials/Machining/drill/Description.html','',0); INSERT INTO `unique_parts` VALUES (314,'tool','Power Drill','your normal everyday power drill','http://en.wikipedia.org/wiki/Drill','',0); INSERT INTO `unique_parts` VALUES (315,'tool','Multi Head Screw Driver','a screw driver with both philips and flathead ends','http://homerepair.about.com/od/termsst/g/gloss_scrw_mult.htm','',0); INSERT INTO `unique_parts` VALUES (316,'tool','Hack Saw','a sturdy 12\" hack saw','http://en.wikipedia.org/wiki/Hacksaw','',0); INSERT INTO `unique_parts` VALUES (317,'tool','Vice','make sure its sturdy and you can mount it to your bench','http://en.wikipedia.org/wiki/Vise_(tool)','',0); INSERT INTO `unique_parts` VALUES (318,'tool','Wire Strippers','you\'ll be using these a lot, so get a good pair','http://en.wikipedia.org/wiki/Wire_stripper','',0); INSERT INTO `unique_parts` VALUES (319,'tool','Soldering Iron','20-50 watts should be fine. small / pencil tip','http://en.wikipedia.org/wiki/Soldering_iron','',0); INSERT INTO `unique_parts` VALUES (320,'tool','Metric Allen Keys','you\'ll need 3, 5, and 8mm. they usually come in a set','http://en.wikipedia.org/wiki/Allen_wrench','',0); INSERT INTO `unique_parts` VALUES (321,'tool','Utility Knife','the sharper the better. be careful!','http://en.wikipedia.org/wiki/Utility_knife','',0); INSERT INTO `unique_parts` VALUES (322,'tool','PIC Programmer','you\'ll need this to program the PIC microcontroller','http://en.wikipedia.org/wiki/PIC_microcontroller','',0); INSERT INTO `unique_parts` VALUES (323,'tool','Hack Saw Blades','fine-toothed blades for cutting metal','http://www.centurydrill.com/hacksaw.html','',0); INSERT INTO `unique_parts` VALUES (324,'tool','Computer','a normal, modern computer with at least 512MB RAM','http://en.wikipedia.org/wiki/Computer','',0); INSERT INTO `unique_parts` VALUES (325,'tool','Multimeter','used to test voltages, resistance, continuity','http://en.wikipedia.org/wiki/Multimeter','',0); INSERT INTO `unique_parts` VALUES (326,'wire','Cat 6 cable','Category 6 ethernet cable. Solid core.','','feet',0); INSERT INTO `unique_parts` VALUES (327,'wire','22 AWG Black','general purpose hookup wire','http://en.wikipedia.org/wiki/Wire#Stranded','mm',0); INSERT INTO `unique_parts` VALUES (328,'wire','22 AWG Red','general purpose hookup wire','http://en.wikipedia.org/wiki/Wire#Stranded','mm',0); INSERT INTO `unique_parts` VALUES (329,'wire','22 AWG Green','general purpose hookup wire','http://en.wikipedia.org/wiki/Wire#Stranded','mm',0); INSERT INTO `unique_parts` VALUES (330,'wire','22 AWG White','general purpose hookup wire','http://en.wikipedia.org/wiki/Wire#Stranded','mm',0); INSERT INTO `unique_parts` VALUES (331,'wire','Nichrome 80','0.2mm nichrome (32 AWG NICHROME 80)','http://www.answers.com/topic/nichrome-2','mm',0); INSERT INTO `unique_parts` VALUES (332,'wire','Solder','use electronics solder, 1mm diameter. stay away from acid core solder.','http://en.wikipedia.org/wiki/Solder','g',0); INSERT INTO `unique_parts` VALUES (333,'wire','10 pin ribbon cable','.050\" pitch insulated ribbon cable','','inch',0); INSERT INTO `unique_parts` VALUES (334,'component','7 Segment LED, red, 0.3in','a 7 segment led display, common cathode','','',0); INSERT INTO `unique_parts` VALUES (335,'component','7 Segment LED, green, 0.3in','a 7 segment led display, common cathode','','',0); INSERT INTO `unique_parts` VALUES (336,'component','74HC595N','an 8-bit shift register','','',0); INSERT INTO `unique_parts` VALUES (337,'component','Bourns PTL60 Red','a slide potentiometer with integrated LED','','',0); INSERT INTO `unique_parts` VALUES (338,'component','Bourns PTL60 Green','a slide potentiometer with integrated LED','','',0); INSERT INTO `unique_parts` VALUES (339,'component','12mm Piezo Buzzer','a pizeo buzzer','','',0); INSERT INTO `unique_parts` VALUES (340,'component','LM35DZ','a temperature sensor','','',0); INSERT INTO `unique_parts` VALUES (341,'component','LDR','a light sensor','','',0); INSERT INTO `unique_parts` VALUES (342,'component','ATmega644P','a sick microprocessor','','',0); INSERT INTO `unique_parts` VALUES (343,'component','SPDT switch','a slide/toggle switch','','',0); INSERT INTO `unique_parts` VALUES (344,'component','22pf ceramic capacitor','some small capacitors for the clock','','',0); INSERT INTO `unique_parts` VALUES (345,'component','40 pin DIP socket','','','',0); INSERT INTO `unique_parts` VALUES (346,'component','7805','a 5v linear regulator, TO-220 format','','',0); INSERT INTO `unique_parts` VALUES (347,'component','2.1mm DC socket','a DC jack for power input','','',0); INSERT INTO `unique_parts` VALUES (348,'module','Danger Shield v1.0','the Danger Shield for arduino. rad inputs and outputs','http://make.nycresistor.com/ds-1.0','',0); INSERT INTO `unique_parts` VALUES (349,'module','Sanguino v1.0','an Arduino-compatible board based on the atmega644P','http://make.sanguino.cc/1.0','',0); INSERT INTO `unique_parts` VALUES (350,'module','Sanguino Breakout v1.0','a breakout shield for the Sanguino','http://make.sanguino.cc/sb-1.0','',0); INSERT INTO `unique_parts` VALUES (351,'module','RepRap Motherboard v1.0','a Sanguino powered motherboard for a RepRap','http://make.sanguino.cc/rmb-1.0','',0); INSERT INTO `unique_parts` VALUES (352,'pcb','Danger Shield v1.0 PCB','the PCB for a Danger Shield','http://make.nycresistor.com/ds-1.0','',0); INSERT INTO `unique_parts` VALUES (353,'pcb','Sanguino v1.0 PCB','an Arduino-compatible board based on the atmega644P','http://make.sanguino.com/1.0','',0); INSERT INTO `unique_parts` VALUES (354,'pcb','Sanguino Breakout v1.0 PCB','a breakout shield for the Sanguino','http://make.sanguino.com/sb-1.0','',0); INSERT INTO `unique_parts` VALUES (355,'pcb','RepRap Motherboard PCB v1.0','a Sanguino powered motherboard for a RepRap','http://make.sanguino.cc/rmb-1.0','',0);