CREATE TABLE banner_notifications (
  id SERIAL PRIMARY KEY,
  text TEXT NOT NULL,
  start_date TIMESTAMP WITH TIME ZONE NOT NULL,
  end_date TIMESTAMP WITH TIME ZONE NOT NULL,
  is_active BOOLEAN DEFAULT true,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- Create index for active banners
CREATE INDEX idx_banner_notifications_active ON banner_notifications(is_active);

-- Create index for date range queries
CREATE INDEX idx_banner_notifications_dates ON banner_notifications(start_date, end_date);
