CREATE TABLE IF NOT EXISTS repository_metadata ( repository TEXT NOT NULL, name TEXT NOT NULL, value TEXT NOT NULL ); CREATE UNIQUE INDEX unique_per_repository_metadata ON repository_metadata (repository, name);