OpenShell/crates/openshell-server/migrations/sqlite/001_create_objects.sql

CREATE TABLE IF NOT EXISTS objects (
    object_type TEXT NOT NULL,
    id TEXT NOT NULL,
    name TEXT NOT NULL,
    payload BLOB NOT NULL,
    created_at_ms INTEGER NOT NULL,
    updated_at_ms INTEGER NOT NULL,
    PRIMARY KEY (id),
    UNIQUE (object_type, name)
);