mirror of
https://github.com/roundcube/roundcubemail.git
synced 2025-12-28 07:55:07 +00:00
6 lines
341 B
SQL
6 lines
341 B
SQL
ALTER TABLE "filestore" ADD COLUMN context varchar(32);
|
|
UPDATE "filestore" SET context = 'enigma';
|
|
ALTER TABLE "filestore" ALTER COLUMN context SET NOT NULL;
|
|
ALTER TABLE "filestore" DROP CONSTRAINT "filestore_user_id_filename";
|
|
ALTER TABLE "filestore" ADD CONSTRAINT "filestore_user_id_context_filename" UNIQUE (user_id, context, filename);
|