1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 103: | Line 103: | ||
); | ); | ||
</pre> | </pre> | ||
=== Sample data === | |||
<pre> | <pre> | ||
| Line 127: | Line 129: | ||
INSERT INTO item SET title="74HC595 8-Bit Shift Register",category=3; | INSERT INTO item SET title="74HC595 8-Bit Shift Register",category=3; | ||
INSERT INTO item_properties SET item=1,property=2,value= | INSERT INTO item_properties SET item=1,property=2,value="1750218"; | ||
</pre> | |||
