File size: 392 Bytes
4dc29ae
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE IF NOT EXISTS tools (
    space_id TEXT NOT NULL,
    tool_name TEXT NOT NULL,
    description TEXT,
    input_schema TEXT,  -- JSON schema
    output_type TEXT,
    endpoint_type TEXT DEFAULT 'schema',
    FOREIGN KEY(space_id) REFERENCES spaces(space_id) ON DELETE CASCADE,
    PRIMARY KEY (space_id, tool_name)
);

CREATE INDEX IF NOT EXISTS idx_tool_name ON tools(tool_name);