Query
CREATE TABLE user_settings (
user_id TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (user_id, key),
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)
CREATE TABLE user_settings (
user_id TEXT NOT NULL,
key TEXT NOT NULL,
value TEXT,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (user_id, key),
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)