13 lines
378 B
MySQL
13 lines
378 B
MySQL
|
CREATE TABLE IF NOT EXISTS habits
|
||
|
|
(
|
||
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
|
|
user_id INTEGER NOT NULL,
|
||
|
|
name TEXT NOT NULL,
|
||
|
|
note TEXT,
|
||
|
|
times INTEGER NOT NULL,
|
||
|
|
unit INTEGER,
|
||
|
|
list_index INTEGER NOT NULL,
|
||
|
|
created_at TEXT NOT NULL,
|
||
|
|
updated_at TEXT NOT NULL,
|
||
|
|
FOREIGN KEY (user_id) REFERENCES users(id)
|
||
|
|
);
|