Re: Create Standard Set of Folders for a new project / With or without Access Permissions....

On Jan 15, 2004, at 10:48 AM, Jagdeep S. Anand (Kuro Soft Thailand) 
wrote:
> Well, I have this this requirement of creating a standard set of 
> folders
> every time a new project is created. And if possible with permission /
> access list.
> One could also see this like a template project.

Yes, this is what
   http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=121

it also contains some suggestions on workarounds.

> Helge, I would like your advise on this. If this is at present is not
> supported and possible. I plan to do this using database triggers. 
> What I am
> going to do is that I am going to, "CAREFULLY",  create an after insert
> database trigger on the projects table and create corresponding 
> required
> records in other thread tables.  All my projects are now fixed for
> "DATABASE" as project base.

Hm, that sounds pretty dangerous ...

> Do you suggest any precautions or issues against this. I know I am 
> kinda
> tinkering with the arteries here.... But I need a workaround...

I would suggest not to use database triggers, but anyway. Document 
structure is managed with the "doc" (a view), "document_editing" and 
"document_version" files.
Notes are also stored as documents ("note" view).
Document/Folder permissions are stored in the object_acl table. 
Document attributes in "obj_property".

The meaning of the tables should be pretty obvious ;-) 
"document_editing" is a "checked out" document.

> I am an all-all oracle guy, but I kinda like this database (Postgres) 
> for
> the loads of features it bundles.

If you buy a SKYRiX 5 maintenance contract, you also get an Oracle 
adaptor ;-)

best regards,
   Helge
-- 
OpenGroupware.org => http://www.opengroupware.org/

-- 
OpenGroupware.org Discussion [email protected]
http://mail.opengroupware.org/mailman/listinfo/discuss