ANNOUNCE: New ctags table

Adam Tauno Williams <[email protected]> Wed, 10 Jun 2009 14:22:15 -0400
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <1244658135.9852.23.camel@linux-m3mt>
For those building from trunk, or currently pulling packages from OBS,
there is a new table required as of r2256.

CREATE TABLE ctags (
  entity VARCHAR NOT NULL,
  ctag  INTEGER NOT NULL DEFAULT 0
);

INSERT INTO ctags (entity) VALUES ('Person');
INSERT INTO ctags (entity) VALUES ('Enterprise');
INSERT INTO ctags (entity) VALUES ('Date');
INSERT INTO ctags (entity) VALUES ('Job');
INSERT INTO ctags (entity) VALUES ('Team');

This is part of adding ctag support to OGo (specifically ZideStore).
ctags allow a client to *very* quickly detect if the contents of a
collection have changed;  such as the /public/Contacts folder.  Thus
avoiding doing a PROPFIND on the entire folder to determine if a re-sync
is needing.  ctag support is not complete or working yet,  but without
this table a server post-r2256 will fails some operations with a
database error.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users