Workouts

schema.sql 14 lines

Files · 8

emits.js14 lines
index.jsx228 lines
listens.js8 lines
manifest.json254 lines
schema.js2 lines
schema.sql14 lines
store.js11 lines
style.css60 lines

1234567891011121314CREATE TABLE activities (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  sport_type TEXT NOT NULL,
  start_date TEXT,
  start_date_local TEXT NOT NULL,
  timezone TEXT,
  distance REAL NOT NULL DEFAULT 0 CHECK (distance >= 0),
  elapsed_time INTEGER NOT NULL CHECK (elapsed_time >= 0),
  moving_time INTEGER CHECK (moving_time >= 0),
  total_elevation_gain REAL CHECK (total_elevation_gain >= 0),
  description TEXT,
  commute INTEGER NOT NULL DEFAULT 0 CHECK (commute IN (0, 1))
);