Anonymous

Project:Inventory system: Difference between revisions

From London Hackspace Wiki
Line 71: Line 71:
);
);


-- Values which a given property may have.
CREATE TABLE property_values (
CREATE TABLE property_values (
     id                INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     id                INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
Line 89: Line 90:
);
);


-- items in a queue.
CREATE TABLE queue_items (
CREATE TABLE queue_items (
     id            INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     id            INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
1,143

edits