[cvs] [Wiki] changed: Groo/Tables

[Luciano Ramalho]

luciano  Mon, 21 Aug 2006 07:05:31 -0700

Modified page: http://wiki.horde.org/Groo/Tables
New Revision:  1.3
Change log:  added leases table

@@ -106,8 +106,24 @@
      UNIQUE (metadata_source, param_name, param_value)
  );
  </code>
  
+----
+++ groo_item_leases
  
+This is intended to control the lease of items between users. No code dealing with this has been implemented yet. The plan is to try to leverage the Nag (tasks) functionality do implement this, so some of the fields below may turn out to be redundant.
  
-
-
+<code type="sql">CREATE TABLE groo_item_leases (
+    lease_id INT UNSIGNED NOT NULL,
+    item_id INT UNSIGNED NOT NULL,  -- leased item id
+    requester_uid VARCHAR(255),     -- who asked to borrow
+    lease_status CHAR(32),          -- internal status string, eg: PENDING, OVERDUE
+    return_condition TEXT,          -- optional owner comment on the state of the returned item
+    start_dt DATETIME,              -- start of the lease period
+    end_dt DATETIME,                -- end of the lease period
+    returned_dt DATETIME,           -- date when the item was returned to the owner
+    record_modified_dt TIMESTAMP,
+    created_dt DATETIME NOT NULL,
+--
+    PRIMARY KEY (lease_id)
+);
+</code>