-- Manual migration SQL commands
-- Run these through cPanel PostgreSQL interface or phpPgAdmin as the database owner

-- Add deleted_at column to products table (for soft deletes)
ALTER TABLE products ADD COLUMN deleted_at TIMESTAMP(0) WITHOUT TIME ZONE NULL;

-- Add shipping_city column to orders table
ALTER TABLE orders ADD COLUMN shipping_city VARCHAR(100) NULL;

-- Optional: Grant ALTER permission to TheRoasters_Auto user for future migrations
-- GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "TheRoasters_Auto";
-- ALTER TABLE products OWNER TO "TheRoasters_Auto";
-- ALTER TABLE orders OWNER TO "TheRoasters_Auto";
