2018122300.sql « postgres « SQL - github.com/roundcube/roundcubemail.git - Unnamed repository; edit this file 'description' to name the repository.

Welcome to mirror list, hosted at ThFree Co, Russian Federation.

2018122300.sql « postgres « SQL - github.com/roundcube/roundcubemail.git - Unnamed repository; edit this file 'description' to name the repository.

index : github.com/roundcube/roundcubemail.git

Unnamed repository; edit this file 'description' to name the repository.

www-data

summary refs log tree commit diff

path: root/SQL/postgres/2018122300.sql

blob: b7c1001567110122bb2ab394b9bdd02fa621c584 (plain)

ALTER TABLE "filestore" ADD COLUMN context varchar(32) NOT NULL;
UPDATE "filestore" SET context = 'enigma';
ALTER TABLE "filestore" DROP CONSTRAINT "filestore_user_id_filename";
ALTER TABLE "filestore" ADD CONSTRAINT "filestore_user_id_context_filename" UNIQUE (user_id, context, filename);