mirror of
https://github.com/anomalyco/opencode.git
synced 2026-07-23 10:45:33 -04:00
Dax Raad
15 lines
414 B
SQL
15 lines
414 B
SQL
CREATE TABLE artifact (
|
|
channel TEXT NOT NULL,
|
|
name TEXT NOT NULL,
|
|
distribution TEXT NOT NULL,
|
|
version TEXT NOT NULL,
|
|
metadata TEXT NOT NULL,
|
|
active INTEGER NOT NULL DEFAULT 0 CHECK (active IN (0, 1)),
|
|
time_updated INTEGER NOT NULL,
|
|
PRIMARY KEY (channel, name, distribution, version)
|
|
) WITHOUT ROWID;
|
|
|
|
CREATE UNIQUE INDEX artifact_active
|
|
ON artifact (channel, name, distribution)
|
|
WHERE active = 1;
|