HabitTracker/db/migrations/1705145041_create_habits_table.sql

10 lines
237 B
MySQL
Raw Permalink Normal View History

CREATE TABLE IF NOT EXISTS habits
(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
note TEXT NULL,
times INTEGER NOT NULL,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL
);