Workouts

schema.js 2 lines

Files · 8
12// Kept byte-for-byte equivalent to schema.sql; bundled without a runtime fetch.
export default "CREATE TABLE activities (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  name TEXT NOT NULL,\n  sport_type TEXT NOT NULL,\n  start_date TEXT,\n  start_date_local TEXT NOT NULL,\n  timezone TEXT,\n  distance REAL NOT NULL DEFAULT 0 CHECK (distance >= 0),\n  elapsed_time INTEGER NOT NULL CHECK (elapsed_time >= 0),\n  moving_time INTEGER CHECK (moving_time >= 0),\n  total_elevation_gain REAL CHECK (total_elevation_gain >= 0),\n  description TEXT,\n  commute INTEGER NOT NULL DEFAULT 0 CHECK (commute IN (0, 1))\n);\n";