023-drop-datastore-type.sql

-- https://github.com/scalableminds/webknossos/pull/3099


START TRANSACTION;

DROP VIEW webknossos.datastores_;
ALTER TABLE webknossos.datastores DROP COLUMN typ;
CREATE VIEW webknossos.dataStores_ AS SELECT * FROM webknossos.dataStores WHERE NOT isDeleted;

UPDATE webknossos.releaseInformation set schemaVersion = 23;

COMMIT TRANSACTION;