... | ... | @@ -111,7 +111,15 @@ IMPORT DATABASE [CAMINHO_PARA_ARQUIVO] |
|
|
|
|
|
2. Crie o index necessário para a busca, utilizando o comando:
|
|
|
```bash
|
|
|
CREATE INDEX learningobject_search ON LearningObject (name, description, author) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
CREATE INDEX LearningObject.name ON LearningObject (name) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
|
|
|
CREATE INDEX LearningObject.description ON LearningObject (description) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
|
|
|
CREATE INDEX LearningObject.author ON LearningObject (author) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
|
|
|
CREATE INDEX Collection.name ON Collection (name) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
|
|
|
CREATE INDEX Collection.description ON Collection (description) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.br.BrazilianAnalyzer"}
|
|
|
```
|
|
|
|
|
|
---
|
... | ... | |