1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 91: | Line 91: | ||
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, | ||
queue TINYINT UNSIGNED NOT NULL, -- queue.id | queue TINYINT UNSIGNED NOT NULL, -- queue.id | ||
item MEDIUMINT UNSIGNED NOT NULL, -- item.id | item MEDIUMINT UNSIGNED NOT NULL, -- item.id | ||
resolved BOOLEAN DEFAULT NULL -- 0 = Ignored, 1 = Done, NULL = Pending | resolved BOOLEAN DEFAULT NULL -- 0 = Ignored, 1 = Done, NULL = Pending | ||
resolved_date TIMESTAMP | resolved_date TIMESTAMP DEFAULT NULL | ||
); | ); | ||
</pre> | </pre> | ||
