Database schema

Shortcut

You can quickly create this database structure by importing the provided template file.

Database schema

Laika requires a database with tables set up in the following manner:

Table: data

Column	Type
id	int, auto-increment
data	date
site	smallint
data_id	smallint
value	float

Table: goals

Column	Type
id	int, auto-increment
report_item	smallint
site	smallint
gan_profile	tinytext
gan_goal_id	tinyint

Table: menu_groups

Column	Type
id	int, auto-increment
group_name	tinytext

Table: menu_items

Column	Type
id	int, auto-increment
group_id	tinyint
hidden	tinyint
menu_item_title	tinytext
report_layout	tinytext
report_header	tinytext
report_description	text

Table: metrics

Column	Type
id	int, auto-increment
name	tinytext
is_global	tinyint
operation	text

Table: sites

Column	Type
id	int, auto-increment
name	tinytext
alt_name	tinytext
showData	tinyint
fetchData	tinyint
gan_view_id	tinytext
additional_metrics	text