xref: /plugin/aichat/db/update0003.sql (revision e33a1d7adcbf36c57f516e2f829ec8ad59cdb47b)
1ALTER TABLE embeddings ADD COLUMN lang NOT NULL DEFAULT '';
2CREATE INDEX embeddings_lang_idx ON embeddings (lang);
3
4DROP TABLE clusters;
5CREATE TABLE clusters
6(
7    cluster   INTEGER   NOT NULL PRIMARY KEY AUTOINCREMENT,
8    lang      TEXT      NOT NULL DEFAULT '',
9    centroid  BLOB      NOT NULL,
10    created   TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
11);
12CREATE INDEX clusters_lang_idx ON clusters (lang);
13