Project:Inventory system: Difference between revisions

Project:Inventory system (view source)

Revision as of 20:09, 23 November 2010

567 bytes added , 23 November 2010

→‎Sample data

Robert

1,143

edits

@@ Line 110: / Line 110: @@
 INSERT INTO category SET title="Components",parent=LAST_INSERT_ID();
 INSERT INTO category SET title="Resistors",parent=2;
+INSERT INTO category SET title="Light Emitting Diodes",parent=2;
 INSERT INTO category SET title="Integrated Circuits",parent=2;
 INSERT INTO category SET title="Mechanical";
@@ Line 129: / Line 130: @@
 INSERT INTO property_categories SET property=2,category=6;
-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 SET title="10Ω 0.25W 1% Resistor",category=3;
 INSERT INTO item SET title="12Ω 0.25W 1% Resistor",category=3;
@@ Line 203: / Line 202: @@
 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;
+INSERT INTO item SET title="5mm 20mA 2.1V Diffused Red LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Diffused Green LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Diffused Yellow LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Clear Red LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Clear Blue LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Clear Green LED",category=4;
+INSERT INTO item SET title="5mm 20mA 2.1V Clear White LED",category=4;
+INSERT INTO item SET title="74HC595 8-Bit Shift Register",category=5;
+INSERT INTO item_properties SET item=1,property=2,value="1750218";
 </pre>