cadc-inventory-db.0.12.1.source-code.inventory.HarvestState.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of cadc-inventory-db Show documentation

OpenCADC Storage Inventory database library

There is a newer version: 1.0.4

create table .HarvestState (
    name varchar(64),
    resourceID varchar(128),
    curLastModified timestamp,
    curID uuid,

    lastModified timestamp not null,
    metaChecksum varchar(136) not null,
    id uuid not null primary key
);

create unique index hs_source_index 
    on .HarvestState(name, resourceID);