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