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

                                 
                               
                                      
                                                                        
  

                                                             
                                        

                                   
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 FailedPaths (
    path text primary key not null,
    time integer not null
);