cadc-inventory-db.0.12.1.source-code.inventory.StorageSite.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 .StorageSite (
    resourceID varchar(512) not null,
    name varchar(32) not null,
    allowRead boolean not null,
    allowWrite boolean not null,
    
    id uuid not null primary key,
    lastModified timestamp not null,
    metaChecksum varchar(136) not null
);

create unique index resourceid_index on .StorageSite(resourceID);

create index ss_modified_index on .StorageSite(lastModified);