databasePG

const SQL_COLLECTIONS_LOADALL = "" +
	"SELECT " +
	"collectionid, " +
	"estateid, " +
	"name, " +
	"description, " +
	"signature_prefix, " +
	"storageid, " +
	"jwtkey, " +
	"secret, " +
	"public " +
	"FROM %s.collection"

const SQL_COLLECTION_NEWITEM = "" +
	"INSERT INTO %s.item (collectionid, signature, urn) " +
	"VALUES($1, $2, $3) returning itemid"

const SQL_LOADITEM = "" +
	"SELECT i.itemid, i.collectionid, i.signature, i.urn, i.type, i.subtype, i.objecttype, " +
	"i.parentid, i.mimetype, i.error, i.sha512, i.metadata, i.creation_date, i.last_modified, i.disabled, i.public, " +
	"i.public_actions, i.status " +
	"FROM %s.item i, %s.collection c " +
	"WHERE i.collectionid=c.collectionid AND c.name=$1 AND i.signature=$2"

const SQL_STORAGES_LOADALL = "" +
	"SELECT " +
	"storageid, " +
	"name, " +
	"filebase, " +
	"datadir, " +
	"subitemdir, " +
	"tempdir " +
	"FROM %s.storage"