![]() Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory : /usr/local/cwpsrv/var/services/roundcube/SQL/postgres/ |
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);