Spaces:
Sleeping
Sleeping
File size: 4,082 Bytes
ea9ca44 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 | -- Check current bucket settings
SELECT id, name, public, file_size_limit, allowed_mime_types, created_at
FROM storage.buckets
WHERE name IN ('avatars', 'resume')
ORDER BY name;
-- Update avatars bucket to be public and set proper limits
UPDATE storage.buckets
SET
public = true,
file_size_limit = 1048576, -- 1MB
allowed_mime_types = ARRAY['image/jpeg', 'image/png', 'image/jpg']
WHERE name = 'avatars';
-- Update resume bucket to be public and set proper limits
UPDATE storage.buckets
SET
public = true,
file_size_limit = 5242880, -- 5MB
allowed_mime_types = ARRAY['application/pdf', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document']
WHERE name = 'resume';
-- Check if RLS policies exist for avatars bucket
SELECT schemaname, tablename, policyname, permissive, roles, cmd, qual
FROM pg_policies
WHERE tablename = 'objects' AND policyname LIKE '%avatar%';
-- Create RLS policies for avatars bucket if they don't exist
DO $$
BEGIN
-- Check if policy exists, if not create it
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can upload their own avatar'
) THEN
CREATE POLICY "Users can upload their own avatar" ON storage.objects
FOR INSERT WITH CHECK (bucket_id = 'avatars' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can update their own avatar'
) THEN
CREATE POLICY "Users can update their own avatar" ON storage.objects
FOR UPDATE USING (bucket_id = 'avatars' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can delete their own avatar'
) THEN
CREATE POLICY "Users can delete their own avatar" ON storage.objects
FOR DELETE USING (bucket_id = 'avatars' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Avatar images are publicly accessible'
) THEN
CREATE POLICY "Avatar images are publicly accessible" ON storage.objects
FOR SELECT USING (bucket_id = 'avatars');
END IF;
END $$;
-- Create RLS policies for resume bucket if they don't exist
DO $$
BEGIN
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can upload their own resume'
) THEN
CREATE POLICY "Users can upload their own resume" ON storage.objects
FOR INSERT WITH CHECK (bucket_id = 'resume' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can update their own resume'
) THEN
CREATE POLICY "Users can update their own resume" ON storage.objects
FOR UPDATE USING (bucket_id = 'resume' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Users can delete their own resume'
) THEN
CREATE POLICY "Users can delete their own resume" ON storage.objects
FOR DELETE USING (bucket_id = 'resume' AND auth.uid()::text = (storage.foldername(name))[1]);
END IF;
IF NOT EXISTS (
SELECT 1 FROM pg_policies
WHERE tablename = 'objects'
AND policyname = 'Resume files are publicly accessible'
) THEN
CREATE POLICY "Resume files are publicly accessible" ON storage.objects
FOR SELECT USING (bucket_id = 'resume');
END IF;
END $$;
-- Final check of bucket settings
SELECT id, name, public, file_size_limit, allowed_mime_types
FROM storage.buckets
WHERE name IN ('avatars', 'resume')
ORDER BY name;
|