All Downloads are FREE. Search and download functionalities are using the official Maven repository.

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

There is a newer version: 1.0.4
Show newest version

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);




© 2015 - 2024 Weber Informatics LLC | Privacy Policy