Files
route-commerce/supabase/migrations/.archived/149_product_availability_dates.sql
Nora 0ac4beaaa8 fix: react-doctor errors → 0 errors, 1649 warnings (46/100)
- Add requireAuth() to admin-permissions.ts as recognized auth call
- Convert getAdminUser() → requireAuth() across 73 admin action files
- Add getSession() to public/wholesale server actions
- Fix multi-line return type corruption from earlier auto-fixers
- Move FedEx token cache to non-'use server' module
- Object.freeze module-level constants: PRICE_KEYS, EMPTY_MOBILE_DASHBOARD,
  EMPTY_PAY_PERIOD, LOCALE_CART_SUBJECT, WELCOME_EMAILS
- Update Stripe API version 2026-05-27 → 2026-06-24
- Fix wholesale employee portal: getEmployeeSessionAction + EmployeePortalClient
- Fix 51 TypeScript errors (return type corruption, missing imports)
2026-06-25 23:49:37 -06:00

9 lines
538 B
SQL

-- Add seasonal availability date fields to products table
-- Allows products to have start/end availability dates (e.g., "Available mid-July through mid-September")
ALTER TABLE products ADD COLUMN IF NOT EXISTS available_from TIMESTAMPTZ;
ALTER TABLE products ADD COLUMN IF NOT EXISTS available_until TIMESTAMPTZ;
-- Add comment for documentation
COMMENT ON COLUMN products.available_from IS 'Start date for product availability (seasonal)';
COMMENT ON COLUMN products.available_until IS 'End date for product availability (seasonal)';