xref: /plugin/aichat/db/update0003.sql (revision e7611489c85f333e5e56d206ee2182115fd03f58)
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