[cvs] [Wiki] changed: Groo/Tables

[Luciano Ramalho]

luciano  Mon, 21 Aug 2006 06:56:14 -0700

Modified page: http://wiki.horde.org/Groo/Tables
New Revision:  1.2
Change log:  fix typo

@@ -64,9 +64,9 @@
  ++ groo_items
  
  This table structured was borrowed from Mnemo (the mnemo_memos table). The only change, besides the fieldnames, was the addition of the item_book_id field, which is a foreign key linking to the groo_books table.
  
-Both item_id and item_uid are randomly generated unique strings. In a recent discussion on the //dev// list concluded with Chuck saying that id fields (such as item_id) in Horde tables should be converted back to integers. Item_uid will continue as is, because it is used for syncing to external devices. I don't know wether Groo items could be usefully synced to a cell phone or PDA, but for the time being the field stays.
+Both item_id and item_uid are randomly generated unique strings. A recent discussion on the //dev// list concluded with Chuck saying that id fields (such as item_id) in Horde apps should be converted back to integers. Item_uid will continue as is, because it is used for syncing to external devices. I don't know wether Groo items could be usefully synced to a cell phone or PDA, but for the time being the field stays.
  
  <code type="sql">CREATE TABLE groo_items (
      item_owner      VARCHAR(255) NOT NULL, -- id of the Horde share which owns this item
      item_id         VARCHAR(32) NOT NULL,  -- id of the item (a random string)