f89e074dd1
Governed substrate for autonomous agents: scoped identity (passports), audited actions, MCP workspace. Infra IPs and secrets redacted for public release.
14 lines
520 B
SQL
14 lines
520 B
SQL
-- Migration: Add schema_layouts table for storing node positions
|
|
-- Date: 2024-12-19
|
|
|
|
CREATE TABLE IF NOT EXISTS schema_layouts (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
space_id INTEGER NOT NULL UNIQUE,
|
|
layout TEXT NOT NULL, -- JSON array of { tableId, x, y }
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
FOREIGN KEY (space_id) REFERENCES spaces(id) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_schema_layouts_space ON schema_layouts(space_id);
|