Calendar database - Revision history

imported_>ashley: removed section edit links with NOEDITSECTION magic word to prettify the page a bit

2013-06-08T12:14:42Z

removed section edit links with __NOEDITSECTION__ magic word to prettify the page a bit

← Older revision		Revision as of 12:14, 8 June 2013
Line 2:		Line 2:

	If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian). The datatypes are those listed in the [http://www.sqlite.org/datatype3.html SQLite documentation].		If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian). The datatypes are those listed in the [http://www.sqlite.org/datatype3.html SQLite documentation].
			__NOEDITSECTION__<!-- removes section edit links as they look quite ugly on this page. -ashley on 8 June 2013 -->
	== [[#toc\|Structure]] ==		== [[#toc\|Structure]] ==
	=== [[#toc\|Tables & fields]] ===		=== [[#toc\|Tables & fields]] ===

imported_>krayon: /* Components */ Added flags

2012-10-29T16:19:44Z

Components: Added flags

← Older revision		Revision as of 16:19, 29 October 2012
Line 90:		Line 90:
	\| ComponentType \|\| integer \|\| 1 = event, 2 = task, 3 = note, 4 = birthday		\| ComponentType \|\| integer \|\| 1 = event, 2 = task, 3 = note, 4 = birthday
	\|-		\|-
	\| Flags \|\| \|\|		\| Flags \|\| integer \|\| 3 = has recursive entry, 4 = has alarm, 5 = has both
	\|-		\|-
	\| DateStart \|\| integer \|\| UTC start date in Unix Time Format (number of seconds since 01/01/1970)		\| DateStart \|\| integer \|\| UTC start date in Unix Time Format (number of seconds since 01/01/1970)

85.178.7.226: /* Birthdays */

2011-09-18T18:03:58Z

Birthdays

← Older revision		Revision as of 18:03, 18 September 2011
Line 18:		Line 18:
	==== [[#toc\|Birthdays]] ====		==== [[#toc\|Birthdays]] ====

	=~~====~~ Id ~~=====~~		{\| class="wikitable"
	~~=====~~ DayMonth ~~=====~~		\|+ Birthdays table
	~~=====~~ Year ~~=====~~		\|-
			! Field !! Type !! Description
			\|-
			\| Id \|\| integer \|\| primary key
			\|-
			\| DayMonth \|\| integer \|\| Day and month as a combined integer. Calculated as: month*100+day (day with a leading zero). 1102 means November 2
			\|-
			\| Year \|\| integer \|\| Year as a number.
			\|}

	==== [[#toc\|Calendars]] ====		==== [[#toc\|Calendars]] ====

imported_>amigadave: reformat page, condense information to one table per database table

2011-03-03T10:50:02Z

reformat page, condense information to one table per database table

Show changes

imported_>amigadave: Calendar Database moved to Calendar database: capitalisation

2011-01-26T11:21:53Z

Calendar Database moved to Calendar database: capitalisation

← Older revision	Revision as of 11:21, 26 January 2011
(No difference)

imported_>pir2: /* Calendars */

2010-09-21T22:55:45Z

Calendars

← Older revision		Revision as of 22:55, 21 September 2010
Line 30:		Line 30:
	----		----
	===== CalendarId =====		===== CalendarId =====
			:{\| class="wikitable"
			\|-
			\| <int> \|\| primary key
			\|-
			\|}
	===== Name =====		===== Name =====
			:{\| class="wikitable"
			\|-
			\| <txt> \|\| name of the calendar
			\|-
			\|}
	===== Colour =====		===== Colour =====
	:{\| class="wikitable"		:{\| class="wikitable"
Line 101:		Line 111:

	----		----

	==== [[#toc\|ComponentDetails]] ====		==== [[#toc\|ComponentDetails]] ====
	----		----

imported_>pir2 at 22:28, 21 September 2010

2010-09-21T22:28:18Z

← Older revision		Revision as of 22:28, 21 September 2010
Line 3:		Line 3:
	If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).		If you want to help editing this article and writing useful informations on fields or new scripts, feel free to copy your own database on your computer and analyze it with some tools like "SQLite Database Browser" (Linux/Debian).

	== Scripts ==		== [[#toc\|Scripts]] ==

	== Structure ==		== [[#toc\|Structure]] ==
	=== Tables & fields ===		=== [[#toc\|Tables & fields]] ===

	----		----
	==== ALARM ====		==== [[#toc\|ALARM]] ====
	----		----
	===== Id =====		===== Id =====
Line 20:		Line 20:

	----		----
	==== Birthdays ====		==== [[#toc\|Birthdays]] ====
	----		----
	===== Id =====		===== Id =====
Line 27:		Line 27:

	----		----
	==== Calendars ====		==== [[#toc\|Calendars]] ====
	----		----
	===== CalendarId =====		===== CalendarId =====
Line 101:		Line 101:

	----		----
	==== ComponentDetails ====		==== [[#toc\|ComponentDetails]] ====
	----		----
	===== Id =====		===== Id =====
Line 123:		Line 123:

	----		----
	==== Components ====		==== [[#toc\|Components]] ====
	----		----
	===== Id =====		===== Id =====
Line 256:		Line 256:
	----		----

	==== IDMAP ====		==== [[#toc\|IDMAP]] ====
	----		----
	===== LocalId =====		===== LocalId =====
Line 262:		Line 262:

	----		----
	==== Instances ====		==== [[#toc\|Instances]] ====
	----		----
	===== Id =====		===== Id =====
Line 269:		Line 269:

	----		----
	==== Parameters ====		==== [[#toc\|Parameters]] ====
	----		----
	===== ComponentId =====		===== ComponentId =====
Line 278:		Line 278:

	----		----
	==== RECURSIVE ====		==== [[#toc\|RECURSIVE]] ====
	----		----
	===== Id =====		===== Id =====
Line 289:		Line 289:

	----		----
	==== TIMEZONE ====		==== [[#toc\|TIMEZONE]] ====
	----		----
	===== Location =====		===== Location =====
Line 303:		Line 303:

	----		----
	==== Trash ====		==== [[#toc\|Trash]] ====
	----		----
	===== ComponentId =====		===== ComponentId =====
Line 312:		Line 312:

	----		----
	==== XProperties ====		==== [[#toc\|XProperties]] ====
	----		----
	===== ComponentId =====		===== ComponentId =====
Line 319:		Line 319:

	----		----
	==== sqlite_sequence ====		==== [[#toc\|sqlite_sequence]] ====
	----		----
	===== name =====		===== name =====
Line 325:		Line 325:


	=== Indices ===		=== [[#toc\|Indices]] ===
	==== IDX_ALARM ====		==== IDX_ALARM ====
	==== IDX_BIRTHDAYS_DATE ====		==== IDX_BIRTHDAYS_DATE ====

imported_>pir2: /* CalendarId */

2010-09-21T22:05:22Z

CalendarId

← Older revision		Revision as of 22:05, 21 September 2010
Line 134:		Line 134:
	:{\| class="wikitable"		:{\| class="wikitable"
	\|-		\|-
	\| <int> \|\| [[CalendarId\|calendar identifier]] associated to the component		\| <int> \|\| [[#CalendarId\|calendar identifier]] associated to the component
	\|-		\|-
	\|}		\|}

imported_>pir2: /* CalendarId */

2010-09-21T22:04:54Z

CalendarId

← Older revision		Revision as of 22:04, 21 September 2010
Line 134:		Line 134:
	:{\| class="wikitable"		:{\| class="wikitable"
	\|-		\|-
	\| <int> \|\| [[~~#Structure:Tables & fields:Calendars:~~CalendarId\|calendar]] ~~identifier~~ associated to the component		\| <int> \|\| [[CalendarId\|calendar identifier]] associated to the component
	\|-		\|-
	\|}		\|}

imported_>pir2: /* CalendarId */

2010-09-21T21:57:19Z

CalendarId

← Older revision		Revision as of 21:57, 21 September 2010
Line 134:		Line 134:
	:{\| class="wikitable"		:{\| class="wikitable"
	\|-		\|-
	\| <int> \|\| [[#~~Calendar database:~~Structure:Tables & fields:Calendars:CalendarId\|calendar]] identifier associated to the component		\| <int> \|\| [[#Structure:Tables & fields:Calendars:CalendarId\|calendar]] identifier associated to the component
	\|-		\|-
	\|}		\|}

Calendar database - Revision history

imported_>ashley: removed section edit links with __NOEDITSECTION__ magic word to prettify the page a bit

imported_>krayon: /* Components */ Added flags

85.178.7.226: /* Birthdays */

imported_>amigadave: reformat page, condense information to one table per database table

imported_>amigadave: Calendar Database moved to Calendar database: capitalisation

imported_>pir2: /* Calendars */

imported_>pir2 at 22:28, 21 September 2010

imported_>pir2: /* CalendarId */

imported_>pir2: /* CalendarId */

imported_>pir2: /* CalendarId */

imported_>ashley: removed section edit links with NOEDITSECTION magic word to prettify the page a bit