Create the tracking database schema

Creates the SQLite or PostgreSQL tables required by the tracking layer. The function is idempotent: calling it several times on the same connection keeps existing data and only creates missing tables.

Usage

create_schema(con)

Arguments

con

A DBI connection.

Value

The input connection, invisibly.

Examples

db_path <- tempfile(fileext = ".sqlite")
con <- init_tracking_db(db_path, overwrite = TRUE)
create_schema(con)
DBI::dbDisconnect(con)