Spaces:

KoRiF
/

MinCPionS

Running

MinCPionS / sql /create_endpoints.sql

KoRiF

implement MCP server search engine

4dc29ae over 1 year ago

272 Bytes

CREATE TABLE IF NOT EXISTS endpoints (
    space_id TEXT NOT NULL,
    endpoint_type TEXT NOT NULL,  -- 'sse' or 'schema'
    endpoint_url TEXT NOT NULL,
    FOREIGN KEY(space_id) REFERENCES spaces(space_id) ON DELETE CASCADE,
    PRIMARY KEY (space_id, endpoint_type)
);

	CREATE TABLE IF NOT EXISTS endpoints (
	space_id TEXT NOT NULL,
	endpoint_type TEXT NOT NULL, -- 'sse' or 'schema'
	endpoint_url TEXT NOT NULL,
	FOREIGN KEY(space_id) REFERENCES spaces(space_id) ON DELETE CASCADE,
	PRIMARY KEY (space_id, endpoint_type)
	);