|
Server : Apache System : Linux server.lienzindia.com 4.18.0-348.7.1.el8_5.x86_64 #1 SMP Wed Dec 22 13:25:12 UTC 2021 x86_64 User : plutus ( 1007) PHP Version : 7.4.33 Disable Function : NONE Directory : /var/webuzo-data/roundcube/SQL/postgres/ |
Upload File : |
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);