[Phpgroupware-developers] proposal-branch; db-manipulation

[sigurdne]

I have added some database manipulation functions in property:
  CreateTable
  AddColumn
  DropColumn
  DropTable
  AlterColumn (don’t preserve data in column)

Might be something for the api?

Try it out in property->admin->Admin Location
(Each level in the hierarchy has it owns table - named as location<level> -
and is referencing its parent table by foreign keys. Each level is also
referencing a category-table - which is named fm_location<level>_category)

OR

property->admin->Admin entity

(Similar to the "location"  - entities has their own tables - but in this case
the entities are separated by type and category - as entity_<type>_<category>)

Location is a physical part of the property - it is common to organise the
locations in a hierachical structure with "part-of" relations
<example>
    Name                    Level
  -- Property                 1
     /-- Building             2
       /-- Entrance           3
         /-- Apartment        4
           /-- Room           5
</example>

Entities is a generic class of objects that all have in common that they can
be placed in a location and/or linked to other (only one) entities.