about summary refs log blame commit diff
path: root/src/libstore/schema.sql
blob: dc53f452c2d68ad5b7537a4951f9039e3a60b86c (plain) (tree)
1
2
3
4
5
6
7
8


                                       

                                                                
                                   

                                      


                                 

                               
                                      

                                                                        

  


                                                             



                                              
pragma foreign_keys = on;

create table if not exists ValidPaths (
    id               integer primary key autoincrement not null,
    path             text unique not null,
    hash             text not null,
    registrationTime integer not null,
    deriver          text
);

create table if not exists Refs (
    referrer  integer not null,
    reference integer not null,
    primary key (referrer, reference),
    foreign key (referrer) references ValidPaths(id) on delete cascade,
    foreign key (reference) references ValidPaths(id) on delete restrict
);

create index if not exists IndexReferrer on Refs(referrer);
create index if not exists IndexReference on Refs(reference);

create table if not exists FailedDerivations (
    path text primary key not null,
    time integer not null
);