guix/scripts/schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

create table if not exists Packages (
    id integer primary key autoincrement not null,
    name        text not null,
    output      text default "out",
    system      text not null,
    path        text not null, -- store path, e.g. /gnu/store/abcd...-foo
    -- path        text unique not null, -- TODO: Make unique?  Maybe to slow.
    version     text not null,
    guix        text not null
);

create virtual table if not exists Files using fts5(
    subpath,
    package
);