Database structure

Database structure

as of version 1.4.* (V14)

CREATE TABLE tracks(
  _id                      integer primary key autoincrement, 
  name                     text not null, 
  description              text not null, 
  icon                     text not null,                -- icon resource name
  enabled                  integer not null,             -- 0 = disabled or 1 = enabled
  multiple_entries_per_day integer DEFAULT 0,            -- 0 = single entry or 1 = multiple entries
  "order"                  integer DEFAULT -1,           -- 0?
  "color"                  integer DEFAULT 0             -- color code (since V14)
)

CREATE TABLE ticks(
  _id                       integer primary key autoincrement,
  _track_id                 integer,
  year                      integer,
  month                     integer,                     -- 0 .. 11 = Jan .. Dec
  day 	                    integer,
  hour                      integer,
  minute                    integer,
  second                    integer,
  has_time_info             integer DEFAULT 0            -- 0 = no or 1 = yes
)

CREATE TABLE groups(        -- since V13
  _id                       integer primary key autoincrement,
  name                      text not null,
  description               text not null,
  "order"                   integer DEFAULT -1            -- 0?
)

CREATE TABLE track2groups(  -- since V13
  _id                       integer primary key autoincrement,
  _track_id                 integer not null, 
  _group_id                 integer not null
)