Re: Restructuring

Martin Schulze wrote:
> Through the next days (or weeks, depends on my time) I will update the
> structure of LTP and rework the database. Please don't commit during
> this. I'm done with the programming part, but will carefully split
> out patches into logical parts, rather than one large patch for everything.

New Fields

    * person.id (type serial): This will eventually permit to
      manage two or more people with the same name (c.f. Arne
      Wichmann, Jochen Kunz and others)

    * person.mobile (type text): explicit attribute for the
      mobile phone number

    * person.phone (type text): explicit attribute for the
      terrestrial phone number

    * project.subproject (type text): Pointer to the project
      that will host this one as sub-project

    * workshop.person (type int4): Pointer to the person
      giving the workshop. This will help letting the speaker edit
      their own workshop data, even with double names.

    * workshop.speaker (type text): Removed. Old textual
      name of the speaker(s).

New Attributes

    * person.project with foreign key to project.name

    * junction.person with foreign key to person.id

    * nili.person with foreign key to person.id

    * workshop.person with foreign key to person.id

    * availability.person with foreign key to person.id

    * assignment.person with foreign key to person.id

Regards,

        Joey

-- 
If nothing changes, everything will remain the same.  -- Barne's Law