Project:Inventory system: Difference between revisions

Project:Inventory system (view source)

48 bytes added , 8 August 2010

1,143

edits

@@ Line 91: / Line 91: @@
 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
 );
 </pre>