| -- Experimental table structure for MCP tracking | |
| CREATE TABLE IF NOT EXISTS spaces ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| space_id TEXT UNIQUE, | |
| title TEXT NOT NULL, | |
| author TEXT, | |
| description TEXT, | |
| likes INTEGER DEFAULT 0, | |
| url TEXT UNIQUE, | |
| --model_card TEXT, | |
| tags TEXT, | |
| last_modified TIMESTAMP, | |
| private BOOLEAN DEFAULT 0 | |
| ); | |
| CREATE INDEX IF NOT EXISTS idx_space_id ON spaces(space_id); | |