HabitTracker/db/migrations/1706001378_create_habit_trackings.sql

7 lines
201 B
MySQL
Raw Permalink Normal View History

CREATE TABLE IF NOT EXISTS habit_trackings
(
id INTEGER PRIMARY KEY AUTOINCREMENT,
habit_id INTEGER,
created_at TEXT NOT NULL,
FOREIGN KEY (habit_id) REFERENCES habits(id)
);