cadc-inventory-db.0.12.1.source-code.inventory.ObsoleteStorageLocation.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
Show all versions of cadc-inventory-db Show documentation
OpenCADC Storage Inventory database library
create table .ObsoleteStorageLocation (
location_storageID varchar(512),
location_storageBucket varchar(8),
lastModified timestamp not null,
metaChecksum varchar(136) not null,
id uuid not null primary key
);
create unique index dsl_location_index
on .ObsoleteStorageLocation(location_storageBucket,location_storageID);
create index dsl_modified_index on .ObsoleteStorageLocation(lastModified);
© 2015 - 2024 Weber Informatics LLC | Privacy Policy