Anonymous

Project:Inventory system: Difference between revisions

From London Hackspace Wiki

Project:Inventory system (view source)

Revision as of 19:47, 23 November 2010

4,742 bytes added ,  23 November 2010
→‎Sample data
Line 109: Line 109:
INSERT INTO category SET title="Electronics";
INSERT INTO category SET title="Electronics";
INSERT INTO category SET title="Components",parent=LAST_INSERT_ID();
INSERT INTO category SET title="Components",parent=LAST_INSERT_ID();
INSERT INTO category SET title="Integrated Circuits",parent=LAST_INSERT_ID();
INSERT INTO category SET title="Resistors",parent=2;
INSERT INTO category SET title="Integrated Circuits",parent=2;
INSERT INTO category SET title="Mechanical";
INSERT INTO category SET title="Mechanical";
INSERT INTO category SET title="Components",parent=LAST_INSERT_ID();
INSERT INTO category SET title="Components",parent=LAST_INSERT_ID();
Line 128: Line 129:
INSERT INTO property_categories SET property=2,category=6;
INSERT INTO property_categories SET property=2,category=6;


INSERT INTO item SET title="74HC595 8-Bit Shift Register",category=3;
INSERT INTO item SET title="74HC595 8-Bit Shift Register",category=4;
INSERT INTO item_properties SET item=1,property=2,value="1750218";
INSERT INTO item_properties SET item=1,property=2,value="1750218";
INSERT INTO item SET title="10Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="12Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="15Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="18Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="22Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="27Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="33Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="39Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="47Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="56Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="68Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="82Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="100Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="120Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="150Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="180Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="220Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="270Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="330Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="390Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="470Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="560Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="680Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="820Ω 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.0kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.2kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.5kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.8kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="2.2kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="2.7kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="3.3kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="3.9kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="4.7kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="5.6kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="6.8kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="8.2kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="10kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="12kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="15kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="18kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="22kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="27kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="33kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="39kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="47kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="56kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="68kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="82kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="100kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="120kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="150kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="180kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="220kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="270kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="330kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="390kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="470kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="560kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="680kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="820kΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.0MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.2MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.5MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="1.8MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="2.2MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="2.7MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="3.3MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="3.9MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="4.7MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="5.6MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="6.8MΩ 0.25W 1% Resistor",category=3;
INSERT INTO item SET title="8.2MΩ 0.25W 1% Resistor",category=3;
</pre>
</pre>
Robert
1,143

edits

Retrieved from ‘https://wiki.london.hackspace.org.uk/view/Special:MobileDiff/6533’