-- Add regular_price column to deals table
ALTER TABLE "public"."deals" ADD COLUMN "regular_price" numeric(10,2);

-- Update RLS policies to include the new column
GRANT SELECT("regular_price") ON TABLE "public"."deals" TO "anon";
GRANT SELECT("regular_price") ON TABLE "public"."deals" TO "authenticated";
GRANT SELECT("regular_price"), UPDATE("regular_price") ON TABLE "public"."deals" TO "service_role";