13 lines
375 B
SQL
13 lines
375 B
SQL
CREATE TABLE lifeos_states (
|
|
user_id TEXT PRIMARY KEY,
|
|
profile_json TEXT NOT NULL DEFAULT '{}',
|
|
memories_json TEXT NOT NULL DEFAULT '[]',
|
|
museum_json TEXT NOT NULL DEFAULT '[]',
|
|
settings_json TEXT NOT NULL DEFAULT '{}',
|
|
system_json TEXT NOT NULL DEFAULT '{}',
|
|
updated_at TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_lifeos_states_updated_at
|
|
ON lifeos_states(updated_at);
|