Old CalendarDatabaseSchema - Revision history

Martin Herfurth: /* Table prg_dates */

2008-02-27T12:40:53Z

Table prg_dates

← Older revision		Revision as of 12:40, 27 February 2008
Line 57:		Line 57:
	\|\| intfield06 \|\| Integer \|\| Not used anymore		\|\| intfield06 \|\| Integer \|\| Not used anymore
	\|-		\|-
	\|\| intfield07 \|\| Integer \|\| ~~Unused~~		\|\| intfield07 \|\| Integer \|\| Number of Attachments
	\|-		\|-
	\|\| field01 \|\| Text \|\| The subject of the appointment. This field must not be null.		\|\| field01 \|\| Text \|\| The subject of the appointment. This field must not be null.

Martin Herfurth: /* Table prg_dates */

2007-11-09T08:27:54Z

Table prg_dates

← Older revision		Revision as of 08:27, 9 November 2007
Line 94:		Line 94:
	\|\| field14 \|\| Text \|\| Completely unused		\|\| field14 \|\| Text \|\| Completely unused
	\|-		\|-
	\|\| field15 \|\| Text \|\| "1" if the appointment was stored in a ~~SP4~~ version. Null otherwise.		\|\| field15 \|\| Text \|\| "1" if the appointment was stored in a 0.8.8 version. Null otherwise.
	\|-		\|-
	\|\| confidential \|\| Text \|\| The private flag of the appointment. Possible values are yes or no		\|\| confidential \|\| Text \|\| The private flag of the appointment. Possible values are yes or no

Martin Herfurth: /* Table prg_dates */

2007-11-09T08:25:06Z

Table prg_dates

← Older revision		Revision as of 08:25, 9 November 2007
Line 94:		Line 94:
	\|\| field14 \|\| Text \|\| Completely unused		\|\| field14 \|\| Text \|\| Completely unused
	\|-		\|-
	\|\| field15 \|\| Text \|\| ~~Completely unused~~		\|\| field15 \|\| Text \|\| "1" if the appointment was stored in a SP4 version. Null otherwise.
	\|-		\|-
	\|\| confidential \|\| Text \|\| The private flag of the appointment. Possible values are yes or no		\|\| confidential \|\| Text \|\| The private flag of the appointment. Possible values are yes or no

Martin Herfurth: /* Table prg_dates */

2007-10-16T13:42:08Z

Table prg_dates

← Older revision		Revision as of 13:42, 16 October 2007
Line 53:		Line 53:
	\|\| intfield04 \|\| Integer \|\| The duration of the appointment in days. <BR> Is used if the appointment is a recurrence because in this case the field timestampfield02 stores end date of recurrence		\|\| intfield04 \|\| Integer \|\| The duration of the appointment in days. <BR> Is used if the appointment is a recurrence because in this case the field timestampfield02 stores end date of recurrence
	\|-		\|-
	\|\| intfield05 \|\| Integer \|\| The recurrence position of an exception from a recurrence appointment. <BR> Must be ~~> 1 or~~ NULL if it is a normal appointment.		\|\| intfield05 \|\| Integer \|\| The recurrence position of an exception from a recurrence appointment, 0 if it is the main sequence. <BR> Must be NULL if it is a normal appointment.
	\|-		\|-
	\|\| intfield06 \|\| Integer \|\| Not used anymore		\|\| intfield06 \|\| Integer \|\| Not used anymore
Line 84:		Line 84:
	\|\| field09 \|\| Text \|\| Categories		\|\| field09 \|\| Text \|\| Categories
	\|-		\|-
	\|\| field10 \|\| Text \|\| ~~Completely unused~~		\|\| field10 \|\| Text \|\| Comma-separated list of a sequence numbers. <BR> Every number is the position of a changed appointment of the recurrence appointment.
	\|-		\|-
	\|\| field11 \|\| Text \|\| Completely unused		\|\| field11 \|\| Text \|\| Completely unused

Sebastian.kauss: add categories

2007-10-15T13:43:04Z

add categories

← Older revision		Revision as of 13:43, 15 October 2007
Line 82:		Line 82:
	Every id is a reference of a modified exception of the recurrence appointment.		Every id is a reference of a modified exception of the recurrence appointment.
	\|-		\|-
	\|\| field09 \|\| Text \|\| ~~Unused~~		\|\| field09 \|\| Text \|\| Categories
	\|-		\|-
	\|\| field10 \|\| Text \|\| Completely unused		\|\| field10 \|\| Text \|\| Completely unused

Sebastian.kauss: add description for color label

2007-10-15T07:48:28Z

add description for color label

← Older revision		Revision as of 07:48, 15 October 2007
Line 49:		Line 49:
	Case three is an exception of a recurrence appointment. In this case is the value of intfield02 the value of intfield01 from the main recurrence appointment.		Case three is an exception of a recurrence appointment. In this case is the value of intfield02 the value of intfield01 from the main recurrence appointment.
	\|-		\|-
	\|\| intfield03 \|\| Integer \|\| ~~Unused~~		\|\| intfield03 \|\| Integer \|\| Color label
	\|-		\|-
	\|\| intfield04 \|\| Integer \|\| The duration of the appointment in days. <BR> Is used if the appointment is a recurrence because in this case the field timestampfield02 stores end date of recurrence		\|\| intfield04 \|\| Integer \|\| The duration of the appointment in days. <BR> Is used if the appointment is a recurrence because in this case the field timestampfield02 stores end date of recurrence

Sebastian.kauss: add missing value for attributes ds

2007-10-10T14:47:38Z

add missing value for attributes ds

← Older revision		Revision as of 14:47, 10 October 2007
Line 105:		Line 105:
	! Attribute !! Type !! Description		! Attribute !! Type !! Description
	\|-		\|-
	\| ds \|\| Text \|\| Possible values no, daily, weekly, monthly or ~~yearly~~		\| ds \|\| Text \|\| Possible values no, daily, weekly, monthly, monthly2, yearly or yearly2
	\|-		\|-
	\| ds_ends \|\| Long \|\| Milliseconds from 01.01.1970 in UTC. <BR> The long descripes the end date of the recurrence appointment.		\| ds_ends \|\| Long \|\| Milliseconds from 01.01.1970 in UTC. <BR> The long descripes the end date of the recurrence appointment.

Sebastian.kauss: add description for field confidential and confirmnotification

2007-08-13T08:51:13Z

add description for field confidential and confirmnotification

← Older revision		Revision as of 08:51, 13 August 2007
Line 95:		Line 95:
	\|-		\|-
	\|\| field15 \|\| Text \|\| Completely unused		\|\| field15 \|\| Text \|\| Completely unused
			\|-
			\|\| confidential \|\| Text \|\| The private flag of the appointment. Possible values are yes or no
			\|-
			\|\| confirmnotification \|\| Text \|\| Enables the confirm notification for the user. Possible values are yes or no
	\|}		\|}

Line 181:		Line 185:
	3 = Tuesday<BR>		3 = Tuesday<BR>
	4 = Wednesday<BR>		4 = Wednesday<BR>
	5 = ~~Thurday~~<BR>		5 = Thursday<BR>
	6 = Friday<BR>		6 = Friday<BR>
	7 = Saturday<BR>		7 = Saturday<BR>

Sebastian.kauss: add description for timestampfield01 and timestampfield02

2007-08-13T08:36:11Z

add description for timestampfield01 and timestampfield02

← Older revision		Revision as of 08:36, 13 August 2007
Line 31:		Line 31:
	\|\| order_crit \|\|Text \|\| Unused		\|\| order_crit \|\|Text \|\| Unused
	\|-		\|-
	\|\| timestampfield01 \|\| Timestamp with time zone \|\| starting time		\|\| timestampfield01 \|\| Timestamp with time zone \|\| The starting time of the appointment.
			If field05 doesn't contain the value 'gtz' the normal starting time is saved.
			e.g. Start date is "10.08.2007 10:00:00+02" the value is saved in this way in the database "2007-08-10 10:00:00+02".
			Otherwiese if field05 contains the value 'gtz' is only the date without time but with server offset saved.
			e.g. Start date is "10.08.2007" the value is saved in this way in the database "2007-08-10 00:00:00+02".
			If the server timezone is "Europe/Berlin"
	\|-		\|-
	\|\| timestampfield02\|\|~~timestamp~~ with time zone\|\| ending time		\|\| timestampfield02 \|\| Timestamp with time zone \|\| The ending time of the appointment. <BR> If non recurring appointments are stored this field stores the values of the end time like the start time see information for timestampfield01.
			The only exception is if a recurring appointment is saved. In this case if the value of timestampfield02 the until date of the recurrence appointment plus the appointment end time.
			This means in the case we have a start date = 10.08.2007 10:00, an end date = 10.08.2007 11:00 and an until = 16.08.2007 the stored value in the database is "2007-08-16 11:00:00+02".
	\|-		\|-
	\| intfield01 \|\| Integer \|\| The unique id of the appointment		\| intfield01 \|\| Integer \|\| The unique id of the appointment

Sebastian.kauss: Fix some format problems

2007-08-10T14:37:35Z

Fix some format problems

Show changes