SQL
CREATE VIRTUAL TABLE memory_items_fts
USING fts5 (
namespace UNINDEXED,
id UNINDEXED,
kind,
tags,
text
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
namespace |
|
✓ | Rename | Drop | |
id |
|
✓ | Rename | Drop | |
kind |
|
✓ | Rename | Drop | |
tags |
|
✓ | Rename | Drop | |
text |
|
✓ | Rename | Drop |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|